Remove ci_builds security job values index
requested to merge 212654-can-we-remove-the-index-index_ci_builds_on_name_for_security_reports_values into master
What does this MR do?
Remove the redundant index index_ci_builds_on_name_for_security_reports_values
Discussion and issue #212654 (closed)
Migration output
$ VERBOSE=true bundle exec rake db:migrate:up VERSION=20200330123739
]== 20200330123739 RemoveIndexCiBuildsOnNameForSecurityReportsValues: migrating
-- transaction_open?()
-> 0.0000s
-- indexes(:ci_builds)
-> 0.0075s
-- execute("SET statement_timeout TO 0")
-> 0.0001s
-- remove_index(:ci_builds, {:algorithm=>:concurrently, :name=>"index_ci_builds_on_name_for_security_reports_values"})
-> 0.0060s
-- execute("RESET ALL")
-> 0.0005s
== 20200330123739 RemoveIndexCiBuildsOnNameForSecurityReportsValues: migrated (0.0143s)
$ VERBOSE=true bundle exec rake db:migrate:down VERSION=20200330123739
== 20200330123739 RemoveIndexCiBuildsOnNameForSecurityReportsValues: reverting
-- transaction_open?()
-> 0.0000s
-- index_exists?(:ci_builds, [:name], {:name=>"index_ci_builds_on_name_for_security_reports_values", :where=>"((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, ('dast'::character varying)::text, ('dependency_scanning'::character varying)::text, ('license_management'::character varying)::text, ('sast'::character varying)::text, ('license_scanning'::character varying)::text]))", :algorithm=>:concurrently})
-> 0.0079s
-- execute("SET statement_timeout TO 0")
-> 0.0001s
-- add_index(:ci_builds, [:name], {:name=>"index_ci_builds_on_name_for_security_reports_values", :where=>"((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, ('dast'::character varying)::text, ('dependency_scanning'::character varying)::text, ('license_management'::character varying)::text, ('sast'::character varying)::text, ('license_scanning'::character varying)::text]))", :algorithm=>:concurrently})
-> 0.0211s
-- execute("RESET ALL")
-> 0.0002s
== 20200330123739 RemoveIndexCiBuildsOnNameForSecurityReportsValues: reverted
Timing
exec drop index concurrently index_ci_builds_on_name_for_security_reports_values
The query has been executed. Duration: 605.000 ms
Does this MR meet the acceptance criteria?
Conformity
Edited by Alper Akgun