Supporting https://gitlab.com/groups/gitlab-org/-/epics/13616+, this epic tracks identification and removal of indices on From https://gitlab.com/gitlab-com/gitlab-OKRs/-/work_items/7863#note_1929192435, these are the indices that have been identified: Other indices have been identified as being possibly redundant in https://gitlab.com/gitlab-org/gitlab/-/issues/456959#note_1945703212, we may consider double checking for further redundancy reported in there. | Index | Issue | Status | |-------|-------|--------| | `index_vuln_findings_on_uuid_including_vuln_id_1` | https://gitlab.com/gitlab-org/gitlab/-/issues/471148+s | ~blocked Pending Rails 7.1 upgrade https://gitlab.com/gitlab-org/gitlab/-/merge_requests/155287 | | `index_vulnerability_occurrences_on_uuid_1` | https://gitlab.com/gitlab-org/gitlab/-/issues/471147+s | ~blocked Pending Rails 7.1 upgrade https://gitlab.com/gitlab-org/gitlab/-/merge_requests/155287 | | `tmp_index_vulnerability_occurrences_id_and_latest_pipeline_id` | https://gitlab.com/gitlab-org/gitlab/-/issues/471149+s | :white_check_mark: | | `security_findings_confidence_idx` | https://gitlab.com/gitlab-org/gitlab/-/issues/471150+s | :white_check_mark: | | `index_vulnerability_occurrences_on_project_fingerprint` | https://gitlab.com/gitlab-org/gitlab/-/issues/471151+s | :white_check_mark: | | `index_sbom_occurrences_on_component_version_id` | https://gitlab.com/gitlab-org/gitlab/-/issues/471152+s | :white_check_mark: | | `index_vulnerability_occurrences_for_issue_links_migration` | https://gitlab.com/gitlab-org/gitlab/-/issues/471153+s | :white_check_mark: | | `index_vulnerability_occurrences_deduplication` | https://gitlab.com/gitlab-org/gitlab/-/issues/471154+s | :white_check_mark: | | `index_vulnerability_reads_on_namespace_type_severity_id` | https://gitlab.com/gitlab-org/gitlab/-/issues/470937+s | :white_check_mark: | | `index_vulnerability_reads_common_finder_query_w_namespace_id` | https://gitlab.com/gitlab-org/gitlab/-/issues/470937+s | :white_check_mark: | | `index_vuln_reads_on_namespace_id_state_severity_and_vuln_id` | https://gitlab.com/gitlab-org/gitlab/-/issues/470937+s | :white_check_mark: | | `idx_vulnerability_reads_for_traversal_ids_queries_srt_severity` | https://gitlab.com/gitlab-org/gitlab/-/issues/473153+s | :x: Can't be removed | | `index_sbom_component_versions_on_component_id` | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162621 | :white_check_mark: | | `index_vulnerabilities_on_project_id_and_state_and_severity` | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162626 | :white_check_mark: | | `index_vulnerability_external_issue_links_on_vulnerability_id` | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162626 | :white_check_mark: | | `finding_links_on_vulnerability_occurrence_id` | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162626 | :white_check_mark: | | `index_vulnerability_finding_signatures_on_finding_id` | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162626 | :white_check_mark: | | `index_vulnerability_flags_on_vulnerability_occurrence_id` | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162626 | :white_check_mark: |