Async removal of project statistics indexes
Summary
We have identified indexes on the project statistics table that are unused on GitLab.com.
This issue is for tracking the work involved in asynchronously removing those indexes (async due to the high traffic nature of the project statistics table)
Proposal
Remove the following indexes:
| # | index | info | added in |
|---|---|---|---|
| 1 | index_project_statistics_on_repository_size_and_project_id |
Thanos indicates unused on .com, can be removed? | !32879 (merged) |
| 2 | index_project_statistics_on_storage_size_and_project_id |
Thanos indicates unused on .com, can be removed? | !32879 (merged) |
| 3 | tmp_index_project_statistics_updated_at |
MR to remove: !154410 (merged) | !128730 (merged) |
| 4 | index_project_statistics_on_packages_size_and_project_id |
Thanos indicates unused on .com, can be removed? | !47156 (merged) |
| 5 | index_project_statistics_on_wiki_size_and_project_id |
Thanos indicates unused on .com, can be removed? | !32879 (merged) |
Edited by Vijay Hawoldar