Check size of Requirements database table to ensure efficiency
A follow-up from !31857 (comment 346369944):
Here are some plans using the gitlab-org/gitlab project:
- by author - https://explain.dalibo.com/plan/XxD
- by title search - https://explain.dalibo.com/plan/SaH
- by author and title search - https://explain.dalibo.com/plan/MXN
In all three cases it's using index_requirements_on_project_id_and_iid
. I think all other indexes on requirements
are not used much. You may want to create a follow up issue to check table size and index usage in few months time.
Edited by Jan Provaznik