In https://gitlab.com/gitlab-org/gitlab/-/merge_requests/74800, 2
indexes were added to `merge_request_assignees` and
`merge_request_reviewers` tables to improve the performance of the
finder query for attention requests.

In https://gitlab.com/gitlab-org/gitlab/-/merge_requests/80732, the
finder query was used to show the count of attention requests.

While investigating a bug related to the count, found out that the
count query isn't performant enough. Based on this query plan
(https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/9497/commands/33700),
it takes around 447ms.

It's noticeable that the query plan isn't using the index added on
the first MR when querying the `merge_request_assignees` and
`merge_request_reviewers` tables.

To fix this, narrower indexes are added on both tables for `user_id`
and `state` columns. This also deletes the `state` indexes that
were added before. The query timing dropped to 14ms from 447ms.

Query plan: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/9497/commands/33717

Changelog: performance

Replace static, weak password

See merge request gitlab-org/gitlab!84126

Refactor pipeline index page

See merge request gitlab-org/gitlab!83357

Update Conan troubleshooting steps

See merge request gitlab-org/gitlab!83888

Allow auditor to view group VSA analytics

See merge request gitlab-org/gitlab!84058

Remove link to content editor feedback issue

See merge request gitlab-org/gitlab!83529

Clarified postgres configuration in praefect docs

See merge request gitlab-org/gitlab!84028

Update asciidoctor-include-ext to 0.4.0

See merge request gitlab-org/gitlab!83955

Correct project access token documentation

See merge request gitlab-org/gitlab!83986

Geo: Implement state machine on a state model (Refactoring)

See merge request gitlab-org/gitlab!83553

Implement state machine on a state model instead
of the main model.

Changelog: other

Revert 'add-optional-needs-for-setup-test-env' into 'master'

See merge request gitlab-org/gitlab!84102

Changelog: changed

Ensure unconfirmed users can’t access Secure Files

See merge request gitlab-org/gitlab!83896

Remove user_email_lookup_limit column

See merge request gitlab-org/gitlab!83358

Changelog: changed

Clarify deployed filters requirement

See merge request gitlab-org/gitlab!84081

Cross-link the search page and the fast-forward merge strategy
pages. Links like these keep them in sync with each other.

[ci skip]

Implement generic CRM form and add "edit crm organization" UI

See merge request gitlab-org/gitlab!76949

Merge Security master into Canonical master

See merge request gitlab-org/gitlab!84094

Handle underscores in user quick actions

See merge request gitlab-org/gitlab!83987

Update Documentation MR template

See merge request gitlab-org/gitlab!84045

The auditor role should be able to view VSA analytics
of a group they are not a member of, as per our docs.

Changelog: fixed
EE: true

Merge branch '357318-markdown-automatic-lists-should-not-add-additional-completed-tasks' into 'master'

[markdown] Automatic lists should not add additional completed tasks

See merge request gitlab-org/gitlab!84022

Allow auditor to read group contribution analytics

See merge request gitlab-org/gitlab!83722

Hide state and configure Button for Sast_Iac on Security Config Page

See merge request gitlab-org/gitlab!83757

feat: Add CI_GITLAB_FIPS_MODE to predefined CI variables

See merge request gitlab-org/gitlab!83891

This reverts merge request !83934

The auditor role should be able to view contribution analytics
of a group they are not a member of, as per our docs.

Changelog: fixed
EE: true

Disallow import of non-deprecated name

See merge request gitlab-org/gitlab!83982

Move BBM prometheus metrics into separate class

See merge request gitlab-org/gitlab!83644