Drop unused ci builds index

Ref: #271620 (closed)

What does this MR do and why?

This MR drops our index_ci_builds_on_project_id_for_successfull_pages_deploy which does not seem to be used according to Thanos.

Screenshots or screen recordings

Database

List of relations  
 Schema |                            Name                            | Type  |  Owner  |   Table   |  Size  | Description   
--------+------------------------------------------------------------+-------+---------+-----------+--------+-------------  
 public | index_ci_builds_on_project_id_for_successfull_pages_deploy | index | joe_292 | ci_builds | 827 MB |   
(1 row)  

Migrations up

➜  gitlab git:(master) ✗ rails db:migrate:main
ci: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: migrating
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- indexes(:ci_builds)
ci:    -> 0.0091s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0001s
ci: -- remove_index(:ci_builds, {:algorithm=>:concurrently, :name=>"index_ci_builds_on_project_id_for_successfull_pages_deploy"})
ci:    -> 0.0021s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0002s
ci: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: migrated (0.0159s)

➜  gitlab git:(master) ✗ rails db:migrate:main
main: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: migrating
main: -- transaction_open?()
main:    -> 0.0000s
main: -- indexes(:ci_builds)
main:    -> 0.0094s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0002s
main: -- remove_index(:ci_builds, {:algorithm=>:concurrently, :name=>"index_ci_builds_on_project_id_for_successfull_pages_deploy"})
main:    -> 0.0042s
main: -- execute("RESET statement_timeout")
main:    -> 0.0003s
main: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: migrated (0.0200s)

Migrations down

➜  gitlab git:(master) ✗ rails db:rollback:ci
ci: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: reverting
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- index_exists?(:ci_builds, :project_id, {:where=>"(((type)::text = 'GenericCommitStatus'::text) AND ((stage)::text = 'deploy'::text) AND ((name)::text = 'pages:deploy'::text) AND ((status)::text = 'success'::text))", :name=>"index_ci_builds_on_project_id_for_successfull_pages_deploy", :algorithm=>:concurrently})
ci:    -> 0.0084s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0002s
ci: -- add_index(:ci_builds, :project_id, {:where=>"(((type)::text = 'GenericCommitStatus'::text) AND ((stage)::text = 'deploy'::text) AND ((name)::text = 'pages:deploy'::text) AND ((status)::text = 'success'::text))", :name=>"index_ci_builds_on_project_id_for_successfull_pages_deploy", :algorithm=>:concurrently})
ci:    -> 0.0033s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0002s
ci: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: reverted (0.0163s)

➜  gitlab git:(master) ✗ rails db:rollback:main
main: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: reverting
main: -- transaction_open?()
main:    -> 0.0000s
main: -- index_exists?(:ci_builds, :project_id, {:where=>"(((type)::text = 'GenericCommitStatus'::text) AND ((stage)::text = 'deploy'::text) AND ((name)::text = 'pages:deploy'::text) AND ((status)::text = 'success'::text))", :name=>"index_ci_builds_on_project_id_for_successfull_pages_deploy", :algorithm=>:concurrently})
main:    -> 0.0083s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0001s
main: -- add_index(:ci_builds, :project_id, {:where=>"(((type)::text = 'GenericCommitStatus'::text) AND ((stage)::text = 'deploy'::text) AND ((name)::text = 'pages:deploy'::text) AND ((status)::text = 'success'::text))", :name=>"index_ci_builds_on_project_id_for_successfull_pages_deploy", :algorithm=>:concurrently})
main:    -> 0.0028s
main: -- execute("RESET statement_timeout")
main:    -> 0.0001s
main: == 20220630085003 DropProjectSuccessfullPagesDeployIndexFromCiBuilds: reverted (0.0151s)

Impact

Reduced ci_builds size by 0.8GB

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.