Skip to content

Replace index on ci_triggers

Andreas Brandl requested to merge ab/replace-index into master

What does this MR do?

This makes an existing index wider to allow ORDER BY id DESC LIMIT type of queries. See #34188 (closed).

Resulting index:

    "index_ci_trigger_requests_on_trigger_id_and_id" btree (trigger_id, id DESC)

Down

== 20191016072826 ReplaceCiTriggerRequestsIndex: reverting ====================
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:ci_trigger_requests, [:trigger_id], {:algorithm=>:concurrently})
   -> 0.0040s
-- execute("SET statement_timeout TO 0")
   -> 0.0004s
-- add_index(:ci_trigger_requests, [:trigger_id], {:algorithm=>:concurrently})
   -> 0.0096s
-- execute("RESET ALL")
   -> 0.0017s
-- transaction_open?()
   -> 0.0000s
-- select_one("SELECT current_setting('server_version_num') AS v")
   -> 0.0013s
-- index_exists?(:ci_trigger_requests, [:trigger_id, :id], {:order=>{:id=>:desc}, :algorithm=>:concurrently})
   -> 0.0038s
-- execute("SET statement_timeout TO 0")
   -> 0.0013s
-- remove_index(:ci_trigger_requests, {:order=>{:id=>:desc}, :algorithm=>:concurrently, :column=>[:trigger_id, :id]})
   -> 0.0070s
-- execute("RESET ALL")
   -> 0.0006s
== 20191016072826 ReplaceCiTriggerRequestsIndex: reverted (0.0317s) ===========

Up

== 20191016072826 ReplaceCiTriggerRequestsIndex: migrating ====================
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:ci_trigger_requests, [:trigger_id, :id], {:order=>{:id=>:desc}, :algorithm=>:concurrently})
   -> 0.0032s
-- execute("SET statement_timeout TO 0")
   -> 0.0004s
-- add_index(:ci_trigger_requests, [:trigger_id, :id], {:order=>{:id=>:desc}, :algorithm=>:concurrently})
   -> 0.0109s
-- execute("RESET ALL")
   -> 0.0016s
-- transaction_open?()
   -> 0.0000s
-- select_one("SELECT current_setting('server_version_num') AS v")
   -> 0.0058s
-- index_exists?(:ci_trigger_requests, [:trigger_id], {:algorithm=>:concurrently})
   -> 0.0052s
-- execute("SET statement_timeout TO 0")
   -> 0.0005s
-- remove_index(:ci_trigger_requests, {:algorithm=>:concurrently, :column=>[:trigger_id]})
   -> 0.0116s
-- execute("RESET ALL")
   -> 0.0041s
== 20191016072826 ReplaceCiTriggerRequestsIndex: migrated (0.0442s) ===========

Conformity

Edited by 🤖 GitLab Bot 🤖

Merge request reports