Remove legacy indices from ci_builds
Overview
Migrating data, removing legacy columns and removing / moving indices should be done together, we should not remove indices until we add them in the second table.
Current Schema
Index | Legacy? | Notes |
---|---|---|
ci_builds_pkey |
Used | |
index_ci_builds_on_token |
Does not exist anymore | |
index_ci_builds_on_token_encrypted |
Used | |
ci_builds_gitlab_monitor_metrics |
Used | |
index_ci_builds_on_artifacts_expire_at |
Does not exist anymore | |
index_ci_builds_on_auto_canceled_by_id |
Used | |
index_ci_builds_on_commit_id_and_stage_idx_and_created_at |
Used | |
index_ci_builds_on_commit_id_and_status_and_type |
Used | |
index_ci_builds_on_commit_id_and_type_and_name_and_ref |
Used | |
index_ci_builds_on_commit_id_and_type_and_ref |
Used | |
index_ci_builds_on_commit_id_artifacts_expired_at_and_id |
Used | |
index_ci_builds_on_project_id_and_id |
Used | |
index_ci_builds_on_project_id_and_name_and_ref |
Used | |
index_ci_builds_on_project_id_for_successfull_pages_deploy |
Not used | |
index_ci_builds_on_protected |
Does not exist anymore | |
index_ci_builds_on_queued_at |
Not Used | |
index_ci_builds_on_runner_id |
Does not exist anymore | |
index_ci_builds_on_stage_id |
Used | |
index_ci_builds_on_status_and_type_and_runner_id |
Used | |
index_ci_builds_on_updated_at |
Used | |
index_ci_builds_on_upstream_pipeline_id |
Used | |
index_ci_builds_on_user_id |
Used | |
index_ci_builds_on_user_id_and_created_at_and_type_eq_ci_build |
Used | |
index_ci_builds_project_id_and_status_for_live_jobs_partial2 |
Used | |
index_for_resource_group |
Removed in !74018 (merged) | |
index_partial_ci_builds_on_user_id_name_parser_features |
Used | |
index_secure_ci_builds_on_user_id_created_at_parser_features |
Does not exist anymore | |
index_security_ci_builds_on_name_and_id_parser_features |
Used | |
partial_index_ci_builds_on_scheduled_at_with_scheduled_jobs |
Used | |
tmp_build_stage_position_index |
Does not exist anymore |
Edited by Max Orefice