Create index for project vulnerability_reads on common filters
requested to merge minac_413697_create_index_for_project_vulnerability_reads_on_common_filters into master
What does this MR do and why?
This MR commits an asynchronously created index by Prepare async index for project vulnerability_r... (!124083 - merged).
rake command outputs
rake db:migrate:up
main: == 20230626101519 CreateIndexForVulnerabilityReadsOnCommonProjectFilters: migrating
main: -- transaction_open?()
main: -> 0.0001s
main: -- view_exists?(:postgres_partitions)
main: -> 0.1130s
main: -- index_exists?(:vulnerability_reads, [:project_id, :state, :report_type, :severity, :vulnerability_id], {:order=>{:severity=>:desc, :vulnerability_id=>:desc}, :name=>"index_project_vulnerability_reads_common_finder_query_desc", :algorithm=>:concurrently})
main: -> 0.0100s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0003s
main: -- add_index(:vulnerability_reads, [:project_id, :state, :report_type, :severity, :vulnerability_id], {:order=>{:severity=>:desc, :vulnerability_id=>:desc}, :name=>"index_project_vulnerability_reads_common_finder_query_desc", :algorithm=>:concurrently})
main: -> 0.0122s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: == 20230626101519 CreateIndexForVulnerabilityReadsOnCommonProjectFilters: migrated (0.1610s)
rake db:migrate:down
main: == [advisory_lock_connection] object_id: 223140, pg_backend_pid: 60579
main: == 20230626101519 CreateIndexForVulnerabilityReadsOnCommonProjectFilters: reverting
main: -- transaction_open?()
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.1128s
main: -- indexes(:vulnerability_reads)
main: -> 0.0069s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0001s
main: -- remove_index(:vulnerability_reads, {:algorithm=>:concurrently, :name=>"index_project_vulnerability_reads_common_finder_query_desc"})
main: -> 0.0025s
main: -- execute("RESET statement_timeout")
main: -> 0.0002s
main: == 20230626101519 CreateIndexForVulnerabilityReadsOnCommonProjectFilters: reverted (0.1356s)
Related to Unable to load the Vulnerability Report filtere... (#413697 - closed)
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.
Edited by Mehmet Emin INAC