Skip to content

Add index for environments on project_id and id

Furkan Ayhan requested to merge 385767-fa-add-index-for-environments-on-project_id-id into master

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.

Merge request reports