Replace index on ci_triggers
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 🤖