Remove `index_vulnerability_occurrences_for_issue_links_migration`
Context
This index was added in 13.3
for Add migration helper index for Vulnerabilities:... (!38898 - merged) • Tiger Watson • 13.3
Verification that index is unused
The "Finding unused indexes" docs say that you can check if an index is still used in production using the following thanos query:
sum by (type)(rate(pg_stat_user_indexes_idx_scan{env="gprd", indexrelname="index_vulnerability_occurrences_for_issue_links_migration"}[180d]))
doing so results in no usage:
thanos results
thanos results |
---|
thanos deprecation
There is a warning about thanos being deprecated, so perhaps I need to check grafana instead
I ran a similar query in grafana and also see no usages
sum by(type) (rate(pg_stat_user_indexes_idx_scan{indexrelname="index_vulnerability_occurrences_for_issue_links_migration"}[30d]))
Implementation Plan
-
drop the index
Edited by Michael Becker