Skip to content

Remove duplicated index from board_group_recent_visits

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

What does this MR do and why?

Remove duplicated index from board_group_recent_visits table.

It removes:

Drop index_board_group_recent_visits_on_user_id as it's already covered by:

Index Columns
index_board_group_recent_visits_on_user_group_and_board user_id asc, group_id asc, 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 gitlab-org/gitlab#442003.

Merge request reports