Skip to content

Remove duplicated index from boards_epic_board_recent_visits

Leonardo da Rosa requested to merge remove-duplicated-indexes-boards_epic_board_recent_visits into master

What does this MR do and why?

Remove duplicated index from boards_epic_board_recent_visits table.

It removes:

Drop index_boards_epic_board_recent_visits_on_user_id as it's already covered by:

Index Columns
index_epic_board_recent_visits_on_user_group_and_board user_id asc, group_id asc, epic_board_id asc

It is possible that this MR will still need some changes to drop the index from the database. Currently, the gitlab-housekeeper is not always capable of removing all references, so you must check the diff and pipeline failures to confirm if there are any issues. Ensure that the index exists in the production database by checking Joe Bot trough https://console.postgres.ai/gitlab. If the index was already removed or if the index it's being removed in another merge request, consider closing this merge request.

This change was generated by gitlab-housekeeper using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with gitlab-housekeeper please comment in #442003.

Merge request reports