Skip to content

Prepare index for environments on project_id and id

What does this MR do and why?

This MR prepares an index for the environments table on the project_id and id columns (index_environments_on_project_id_and_id). In the next step, we'll use add_concurrent_index to complete it. (https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#create-indexes-asynchronously)

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.

Edited by Furkan Ayhan

Merge request reports