Drop duplicate index from `vulnerability_occurrences` table
What does this MR do and why?
The index named index_vulnerability_occurrences_on_uuid_1 is a duplicate of index_vuln_findings_on_uuid_including_vuln_id_1, therefore, can be removed.
Note that the index being removed is still used, but the queries utilizing that index will utilize the other once it's removed(https://thanos-query.ops.gitlab.net/graph?g0.expr=rate(pg_stat_user_indexes_idx_scan%7Benv%3D%22gprd%22%2C%20type%3D%22patroni%22%2C%20indexrelname%3D%22index_vulnerability_occurrences_on_uuid_1%22%7D%5B3h%5D)&g0.tab=0&g0.stacked=0&g0.range_input=4w&g0.max_source_resolution=0s&g0.deduplicate=1&g0.partial_response=0&g0.store_matches=%5B%5D).
Edited by Michael Becker