Add index for environments on project_id and id
What does this MR do and why?
This MR creates an index for the environments
table on the project_id
and id
columns (index_environments_on_project_id_and_id
). As we discussed in the previous MR, we can directly create the index instead of using the "Async index" workflow. It took 1.248 min to create this index in the db lab.
The main reason for this index is to increase the performance of the environments list endpoint. More info: #385767 (comment 1230613048)
Related to #385767 (closed)
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.