Skip to content

Remove ci_builds security job values index

Alper Akgun 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

Merge request reports