Loading
Swap workflow_id index for a composite index on checkpoint blobs
What does this MR do and why?
This MR swaps the index on p_duo_workflows_checkpoint_blobs from a
single column, workflow_id, to a composite index on
(workflow_id, channel, id). Reads that filter by workflow and channel
currently sort in memory; the new index lets them use an index scan
instead. Measured on Database Lab, Ai::DuoWorkflows::Workflow#latest_channel_message
drops from 205 buffers and a top-N heapsort (49.6 ms) to 8 buffers and no
sort (0.1 ms). The old index becomes redundant and is dropped in the same
migration.
Database
The migration 20260831181732_swap_workflow_id_index_on_p_duo_workflows_checkpoint_blobs.rb
runs on the partitioned table p_duo_workflows_checkpoint_blobs:
add_concurrent_partitioned_indexcreatesidx_duo_wf_checkpoint_blobs_on_workflow_channel_idon(workflow_id, channel, id).remove_concurrent_partitioned_index_by_namedropsindex_duo_wf_checkpoint_blobs_on_workflow_idon(workflow_id).
!251705 (merged) queued the
per-partition indexes for asynchronous creation on GitLab.com. Where a
partition's index already exists, add_concurrent_partitioned_index only
attaches it to the new parent index, which is cheap. On any instance
without the async build (including self-managed), it builds each partition
index concurrently, which is more expensive.
The old (workflow_id) index is safe to drop: workflow_id is the
leading column of the new index, so it covers the same lookups. The
foreign key cascade delete for fk_duo_wf_checkpoint_blobs_workflow_id
still gets an index scan against the new index (see the delete plan
below).
This is an index-only change. It does not need a feature flag.
This MR must not merge until the async per-partition indexes exist and
are valid on every partition on GitLab.com production. As of 2026-08-31,
the postgres_async_indexes queue on a Database Lab clone had no entries
for this index yet, because the MR that queued them merged the same day
and had not deployed. I will re-check
\d idx_duo_wf_checkpoint_blobs_on_workflow_channel_id on Database Lab
before marking this MR ready.
Query plans below are from a Database Lab clone of production (workflow 6405842, the same session as the async-index MR), with the new index built on that session's partition and the old index dropped.
#latest_channel_message — 8 buffers, no sort (before: 205 buffers, top-N heapsort)
SELECT * FROM p_duo_workflows_checkpoint_blobs
WHERE workflow_id = 6405842
AND workflow_created_at >= '2026-08-17 09:04:38+00'
AND workflow_created_at < '2026-08-17 09:04:39+00'
AND project_id = 39903947
AND thread_ts IN (...172 values...)
AND channel = 'ui_chat_log'
ORDER BY id DESC LIMIT 1Plan (EXPLAIN ANALYZE, Database Lab)
Limit (cost=0.98..100.92 rows=1 width=405) (actual time=0.364..0.364 rows=1 loops=1)
Buffers: shared hit=3 read=5
I/O Timings: read=0.274 write=0.000
-> Index Scan Backward using tmp_blobs_wf_channel_id on gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817 p_duo_workflows_checkpoint_blobs (cost=0.98..100.92 rows=1 width=405) (actual time=0.362..0.362 rows=1 loops=1)
Index Cond: ((p_duo_workflows_checkpoint_blobs.workflow_id = 6405842) AND (p_duo_workflows_checkpoint_blobs.channel = 'ui_chat_log'::text))
Filter: ((p_duo_workflows_checkpoint_blobs.workflow_created_at >= '2026-08-17 09:04:38+00'::timestamp with time zone) AND (p_duo_workflows_checkpoint_blobs.workflow_created_at < '2026-08-17 09:04:39+00'::timestamp with time zone) AND (p_duo_workflows_checkpoint_blobs.project_id = 39903947) AND (p_duo_workflows_checkpoint_blobs.thread_ts = ANY ('{...172 values...}'::text[])))
Buffers: shared hit=3 read=5
I/O Timings: read=0.274 write=0.000
Settings: seq_page_cost = '4', effective_cache_size = '472585MB', jit = 'off', random_page_cost = '1.5', work_mem = '230MB'
Query ID: -9220619165215932930
stats:
Time: 9.911 ms
- planning: 9.476 ms
- execution: 0.435 ms
- I/O read: 0.274 ms
- I/O write: 0.000 ms
Shared buffers:
- hits: 3 (~24.00 KiB) from the buffer pool
- reads: 5 (~40.00 KiB) from the OS file cache, including disk I/O
- dirtied: 0
- writes: 0
#history_blobs_for — 129 buffers, no sort (before: 208 buffers + quicksort)
SELECT * FROM p_duo_workflows_checkpoint_blobs
WHERE workflow_id = 6405842
AND workflow_created_at >= '2026-08-17 09:04:38+00'
AND workflow_created_at < '2026-08-17 09:04:39+00'
AND project_id = 39903947
AND thread_ts IN (...172 values...)
AND channel = 'ui_chat_log'
ORDER BY idPlan (EXPLAIN ANALYZE, Database Lab)
Index Scan using tmp_blobs_wf_channel_id on gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817 p_duo_workflows_checkpoint_blobs (cost=0.98..100.92 rows=1 width=405) (actual time=0.426..2.477 rows=122 loops=1)
Index Cond: ((p_duo_workflows_checkpoint_blobs.workflow_id = 6405842) AND (p_duo_workflows_checkpoint_blobs.channel = 'ui_chat_log'::text))
Filter: ((p_duo_workflows_checkpoint_blobs.workflow_created_at >= '2026-08-17 09:04:38+00'::timestamp with time zone) AND (p_duo_workflows_checkpoint_blobs.workflow_created_at < '2026-08-17 09:04:39+00'::timestamp with time zone) AND (p_duo_workflows_checkpoint_blobs.project_id = 39903947) AND (p_duo_workflows_checkpoint_blobs.thread_ts = ANY ('{...172 values...}'::text[])))
Buffers: shared hit=7 read=122
I/O Timings: read=2.053 write=0.000
Settings: work_mem = '230MB', seq_page_cost = '4', effective_cache_size = '472585MB', jit = 'off', random_page_cost = '1.5'
Query ID: 5035386583924710344
stats:
Time: 9.550 ms
- planning: 7.011 ms
- execution: 2.539 ms
- I/O read: 2.053 ms
- I/O write: 0.000 ms
Shared buffers:
- hits: 7 (~56.00 KiB) from the buffer pool
- reads: 122 (~976.00 KiB) from the OS file cache, including disk I/O
- dirtied: 0
- writes: 0
#accumulated_blobs_for — unchanged, still served by idx_duo_wf_checkpoint_blobs_dedup
SELECT * FROM p_duo_workflows_checkpoint_blobs
WHERE workflow_id = 6405842
AND workflow_created_at >= '2026-08-17 09:04:38+00'
AND workflow_created_at < '2026-08-17 09:04:39+00'
AND project_id = 39903947
AND thread_ts IN (...172 values...)
ORDER BY idPlan (EXPLAIN ANALYZE, Database Lab)
Sort (cost=357.56..357.56 rows=1 width=405) (actual time=18.282..18.340 rows=556 loops=1)
Sort Key: p_duo_workflows_checkpoint_blobs.id
Sort Method: quicksort Memory: 292kB
Buffers: shared hit=150 read=101
I/O Timings: read=17.225 write=0.000
-> Index Scan using p_duo_workflows_checkpoint_b_project_id_workflow_id_threa_idx64 on gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817 p_duo_workflows_checkpoint_blobs (cost=0.55..357.55 rows=1 width=405) (actual time=4.478..17.978 rows=556 loops=1)
Index Cond: ((p_duo_workflows_checkpoint_blobs.project_id = 39903947) AND (p_duo_workflows_checkpoint_blobs.workflow_id = 6405842) AND (p_duo_workflows_checkpoint_blobs.thread_ts = ANY ('{...172 values...}'::text[])) AND (p_duo_workflows_checkpoint_blobs.workflow_created_at >= '2026-08-17 09:04:38+00'::timestamp with time zone) AND (p_duo_workflows_checkpoint_blobs.workflow_created_at < '2026-08-17 09:04:39+00'::timestamp with time zone))
Buffers: shared hit=147 read=101
I/O Timings: read=17.225 write=0.000
Settings: seq_page_cost = '4', effective_cache_size = '472585MB', jit = 'off', random_page_cost = '1.5', work_mem = '230MB'
Query ID: 783898794643307706
stats:
Time: 24.005 ms
- planning: 5.598 ms
- execution: 18.407 ms
- I/O read: 17.225 ms
- I/O write: 0.000 ms
Shared buffers:
- hits: 150 (~1.20 MiB) from the buffer pool
- reads: 101 (~808.00 KiB) from the OS file cache, including disk I/O
- dirtied: 0
- writes: 0
#chat_log_thread_ts — unchanged, index-only scan on idx_duo_wf_checkpoint_blobs_dedup, Heap Fetches 0
SELECT DISTINCT thread_ts FROM p_duo_workflows_checkpoint_blobs
WHERE workflow_id = 6405842
AND workflow_created_at >= '2026-08-17 09:04:38+00'
AND workflow_created_at < '2026-08-17 09:04:39+00'
AND project_id = 39903947
AND channel = 'ui_chat_log'Plan (EXPLAIN ANALYZE, Database Lab)
Unique (cost=0.55..3.60 rows=1 width=37) (actual time=8.519..21.238 rows=122 loops=1)
Buffers: shared hit=4 read=19
I/O Timings: read=20.857 write=0.000
-> Index Only Scan using p_duo_workflows_checkpoint_b_project_id_workflow_id_threa_idx64 on gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817 p_duo_workflows_checkpoint_blobs (cost=0.55..3.60 rows=1 width=37) (actual time=8.517..21.181 rows=122 loops=1)
Index Cond: ((p_duo_workflows_checkpoint_blobs.project_id = 39903947) AND (p_duo_workflows_checkpoint_blobs.workflow_id = 6405842) AND (p_duo_workflows_checkpoint_blobs.channel = 'ui_chat_log'::text) AND (p_duo_workflows_checkpoint_blobs.workflow_created_at >= '2026-08-17 09:04:38+00'::timestamp with time zone) AND (p_duo_workflows_checkpoint_blobs.workflow_created_at < '2026-08-17 09:04:39+00'::timestamp with time zone))
Heap Fetches: 0
Buffers: shared hit=4 read=19
I/O Timings: read=20.857 write=0.000
Settings: work_mem = '230MB', seq_page_cost = '4', effective_cache_size = '472585MB', jit = 'off', random_page_cost = '1.5'
Query ID: -5858565530979595089
stats:
Time: 23.572 ms
- planning: 2.272 ms
- execution: 21.300 ms
- I/O read: 20.857 ms
- I/O write: 0.000 ms
Shared buffers:
- hits: 4 (~32.00 KiB) from the buffer pool
- reads: 19 (~152.00 KiB) from the OS file cache, including disk I/O
- dirtied: 0
- writes: 0
Cascade delete by workflow_id — index scan on the new index
-- what the fk_duo_wf_checkpoint_blobs_workflow_id cascade runs per partition
DELETE FROM gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817
WHERE workflow_id = 6405842Plan (EXPLAIN ANALYZE, Database Lab)
Delete on gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817 (cost=0.55..570.93 rows=0 width=0) (actual time=15.699..15.700 rows=0 loops=1)
Buffers: shared hit=1376 read=17 dirtied=208
WAL: records=573 fpi=206 bytes=1695280
I/O Timings: read=12.771 write=0.000
-> Index Scan using tmp_blobs_wf_channel_id on gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817 (cost=0.55..570.93 rows=583 width=6) (actual time=0.210..1.020 rows=556 loops=1)
Index Cond: (p_duo_workflows_checkpoint_blobs_20260817.workflow_id = 6405842)
Buffers: shared hit=555 read=3
I/O Timings: read=0.207 write=0.000
Settings: random_page_cost = '1.5', work_mem = '230MB', seq_page_cost = '4', effective_cache_size = '472585MB', jit = 'off'
Query ID: -2994577790392507499
stats:
Time: 16.616 ms
- planning: 0.714 ms
- execution: 15.902 ms
- I/O read: 12.771 ms
- I/O write: 0.000 ms
Shared buffers:
- hits: 1376 (~10.80 MiB) from the buffer pool
- reads: 17 (~136.00 KiB) from the OS file cache, including disk I/O
- dirtied: 208 (~1.60 MiB)
- writes: 0
Migration up
Output (local, RAILS_ENV=test)
main: == [advisory_lock_connection] object_id: 161020, pg_backend_pid: 42458
main: == 20260831181732 SwapWorkflowIdIndexOnPDuoWorkflowsCheckpointBlobs: migrating
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_name_exists?(:p_duo_workflows_checkpoint_blobs, "idx_duo_wf_checkpoint_blobs_on_workflow_channel_id")
main: -> 0.0338s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260801", [:workflow_id, :channel, :id], {:name=>"index_addb1d64a3", :algorithm=>:concurrently})
main: -> 0.0030s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260801", [:workflow_id, :channel, :id], {:name=>"index_addb1d64a3", :algorithm=>:concurrently})
main: -> 0.0034s
main: -- execute("RESET statement_timeout")
main: -> 0.0005s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260802", [:workflow_id, :channel, :id], {:name=>"index_7a798ee2a1", :algorithm=>:concurrently})
main: -> 0.1103s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260802", [:workflow_id, :channel, :id], {:name=>"index_7a798ee2a1", :algorithm=>:concurrently})
main: -> 0.0020s
main: -- transaction_open?(nil)
main: -> 0.0004s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260803", [:workflow_id, :channel, :id], {:name=>"index_6a3026758d", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260803", [:workflow_id, :channel, :id], {:name=>"index_6a3026758d", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260804", [:workflow_id, :channel, :id], {:name=>"index_db4d5b2575", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260804", [:workflow_id, :channel, :id], {:name=>"index_db4d5b2575", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260805", [:workflow_id, :channel, :id], {:name=>"index_9f4563c23c", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260805", [:workflow_id, :channel, :id], {:name=>"index_9f4563c23c", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260806", [:workflow_id, :channel, :id], {:name=>"index_37856dcbf2", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260806", [:workflow_id, :channel, :id], {:name=>"index_37856dcbf2", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260807", [:workflow_id, :channel, :id], {:name=>"index_84d8fdc2ce", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260807", [:workflow_id, :channel, :id], {:name=>"index_84d8fdc2ce", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260808", [:workflow_id, :channel, :id], {:name=>"index_5999563c73", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260808", [:workflow_id, :channel, :id], {:name=>"index_5999563c73", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260809", [:workflow_id, :channel, :id], {:name=>"index_e3119b6fd8", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260809", [:workflow_id, :channel, :id], {:name=>"index_e3119b6fd8", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260810", [:workflow_id, :channel, :id], {:name=>"index_58f7c1fb9b", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260810", [:workflow_id, :channel, :id], {:name=>"index_58f7c1fb9b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260811", [:workflow_id, :channel, :id], {:name=>"index_8c57ad31a8", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260811", [:workflow_id, :channel, :id], {:name=>"index_8c57ad31a8", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260812", [:workflow_id, :channel, :id], {:name=>"index_603aa7535a", :algorithm=>:concurrently})
main: -> 0.0015s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260812", [:workflow_id, :channel, :id], {:name=>"index_603aa7535a", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260813", [:workflow_id, :channel, :id], {:name=>"index_ef539c158b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260813", [:workflow_id, :channel, :id], {:name=>"index_ef539c158b", :algorithm=>:concurrently})
main: -> 0.0017s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260814", [:workflow_id, :channel, :id], {:name=>"index_6d55ce7133", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260814", [:workflow_id, :channel, :id], {:name=>"index_6d55ce7133", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260815", [:workflow_id, :channel, :id], {:name=>"index_82ecaa7f05", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260815", [:workflow_id, :channel, :id], {:name=>"index_82ecaa7f05", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260816", [:workflow_id, :channel, :id], {:name=>"index_982c0ada3c", :algorithm=>:concurrently})
main: -> 0.0018s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260816", [:workflow_id, :channel, :id], {:name=>"index_982c0ada3c", :algorithm=>:concurrently})
main: -> 0.0028s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817", [:workflow_id, :channel, :id], {:name=>"index_4d306a0370", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817", [:workflow_id, :channel, :id], {:name=>"index_4d306a0370", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260818", [:workflow_id, :channel, :id], {:name=>"index_985f1f3ecc", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260818", [:workflow_id, :channel, :id], {:name=>"index_985f1f3ecc", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260819", [:workflow_id, :channel, :id], {:name=>"index_488b75a04c", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260819", [:workflow_id, :channel, :id], {:name=>"index_488b75a04c", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260820", [:workflow_id, :channel, :id], {:name=>"index_e18e6eec5b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260820", [:workflow_id, :channel, :id], {:name=>"index_e18e6eec5b", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260821", [:workflow_id, :channel, :id], {:name=>"index_b25448490b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260821", [:workflow_id, :channel, :id], {:name=>"index_b25448490b", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260822", [:workflow_id, :channel, :id], {:name=>"index_982e252a8c", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260822", [:workflow_id, :channel, :id], {:name=>"index_982e252a8c", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260823", [:workflow_id, :channel, :id], {:name=>"index_103849d3f7", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260823", [:workflow_id, :channel, :id], {:name=>"index_103849d3f7", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260824", [:workflow_id, :channel, :id], {:name=>"index_1cbba5c1d7", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260824", [:workflow_id, :channel, :id], {:name=>"index_1cbba5c1d7", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260825", [:workflow_id, :channel, :id], {:name=>"index_bc857e0001", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260825", [:workflow_id, :channel, :id], {:name=>"index_bc857e0001", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260826", [:workflow_id, :channel, :id], {:name=>"index_ec0b79d8f4", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260826", [:workflow_id, :channel, :id], {:name=>"index_ec0b79d8f4", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260827", [:workflow_id, :channel, :id], {:name=>"index_0cd9257ffb", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260827", [:workflow_id, :channel, :id], {:name=>"index_0cd9257ffb", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260828", [:workflow_id, :channel, :id], {:name=>"index_279b7b9841", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260828", [:workflow_id, :channel, :id], {:name=>"index_279b7b9841", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260829", [:workflow_id, :channel, :id], {:name=>"index_406280d2c5", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260829", [:workflow_id, :channel, :id], {:name=>"index_406280d2c5", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260830", [:workflow_id, :channel, :id], {:name=>"index_5440000f12", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260830", [:workflow_id, :channel, :id], {:name=>"index_5440000f12", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260831", [:workflow_id, :channel, :id], {:name=>"index_79f522acb4", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260831", [:workflow_id, :channel, :id], {:name=>"index_79f522acb4", :algorithm=>:concurrently})
main: -> 0.0022s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260901", [:workflow_id, :channel, :id], {:name=>"index_c1a491749b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260901", [:workflow_id, :channel, :id], {:name=>"index_c1a491749b", :algorithm=>:concurrently})
main: -> 0.0017s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260902", [:workflow_id, :channel, :id], {:name=>"index_0c8ebd72a8", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260902", [:workflow_id, :channel, :id], {:name=>"index_0c8ebd72a8", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260903", [:workflow_id, :channel, :id], {:name=>"index_d64bb50f8e", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260903", [:workflow_id, :channel, :id], {:name=>"index_d64bb50f8e", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260904", [:workflow_id, :channel, :id], {:name=>"index_5b3d60a7d6", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260904", [:workflow_id, :channel, :id], {:name=>"index_5b3d60a7d6", :algorithm=>:concurrently})
main: -> 0.0016s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260905", [:workflow_id, :channel, :id], {:name=>"index_e6a5194868", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260905", [:workflow_id, :channel, :id], {:name=>"index_e6a5194868", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260906", [:workflow_id, :channel, :id], {:name=>"index_0fa8421c6a", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260906", [:workflow_id, :channel, :id], {:name=>"index_0fa8421c6a", :algorithm=>:concurrently})
main: -> 0.0019s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260907", [:workflow_id, :channel, :id], {:name=>"index_25508589c6", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260907", [:workflow_id, :channel, :id], {:name=>"index_25508589c6", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260908", [:workflow_id, :channel, :id], {:name=>"index_38519c138b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260908", [:workflow_id, :channel, :id], {:name=>"index_38519c138b", :algorithm=>:concurrently})
main: -> 0.0020s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260909", [:workflow_id, :channel, :id], {:name=>"index_69f9377737", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260909", [:workflow_id, :channel, :id], {:name=>"index_69f9377737", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260910", [:workflow_id, :channel, :id], {:name=>"index_be2a8fc5f3", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260910", [:workflow_id, :channel, :id], {:name=>"index_be2a8fc5f3", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260911", [:workflow_id, :channel, :id], {:name=>"index_8349a853a5", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260911", [:workflow_id, :channel, :id], {:name=>"index_8349a853a5", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260912", [:workflow_id, :channel, :id], {:name=>"index_8d0428df86", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260912", [:workflow_id, :channel, :id], {:name=>"index_8d0428df86", :algorithm=>:concurrently})
main: -> 0.0020s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260913", [:workflow_id, :channel, :id], {:name=>"index_c6ffaeafc0", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260913", [:workflow_id, :channel, :id], {:name=>"index_c6ffaeafc0", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260914", [:workflow_id, :channel, :id], {:name=>"index_4ec493f8b2", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260914", [:workflow_id, :channel, :id], {:name=>"index_4ec493f8b2", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260915", [:workflow_id, :channel, :id], {:name=>"index_f1ac1ad2b5", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260915", [:workflow_id, :channel, :id], {:name=>"index_f1ac1ad2b5", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260916", [:workflow_id, :channel, :id], {:name=>"index_6392891c8b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260916", [:workflow_id, :channel, :id], {:name=>"index_6392891c8b", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260917", [:workflow_id, :channel, :id], {:name=>"index_d98acb5adf", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260917", [:workflow_id, :channel, :id], {:name=>"index_d98acb5adf", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260918", [:workflow_id, :channel, :id], {:name=>"index_a565898333", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260918", [:workflow_id, :channel, :id], {:name=>"index_a565898333", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260919", [:workflow_id, :channel, :id], {:name=>"index_3d7958ddb6", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260919", [:workflow_id, :channel, :id], {:name=>"index_3d7958ddb6", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260920", [:workflow_id, :channel, :id], {:name=>"index_68a06b08fd", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260920", [:workflow_id, :channel, :id], {:name=>"index_68a06b08fd", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260921", [:workflow_id, :channel, :id], {:name=>"index_6e3d5c773b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260921", [:workflow_id, :channel, :id], {:name=>"index_6e3d5c773b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260922", [:workflow_id, :channel, :id], {:name=>"index_df447bdf0b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260922", [:workflow_id, :channel, :id], {:name=>"index_df447bdf0b", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260923", [:workflow_id, :channel, :id], {:name=>"index_2bb82dcb5f", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260923", [:workflow_id, :channel, :id], {:name=>"index_2bb82dcb5f", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260924", [:workflow_id, :channel, :id], {:name=>"index_04261db1aa", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260924", [:workflow_id, :channel, :id], {:name=>"index_04261db1aa", :algorithm=>:concurrently})
main: -> 0.0007s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260925", [:workflow_id, :channel, :id], {:name=>"index_2968797885", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260925", [:workflow_id, :channel, :id], {:name=>"index_2968797885", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260926", [:workflow_id, :channel, :id], {:name=>"index_7ec2a286ac", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260926", [:workflow_id, :channel, :id], {:name=>"index_7ec2a286ac", :algorithm=>:concurrently})
main: -> 0.0018s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260927", [:workflow_id, :channel, :id], {:name=>"index_22d319300b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260927", [:workflow_id, :channel, :id], {:name=>"index_22d319300b", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- add_index(:p_duo_workflows_checkpoint_blobs, [:workflow_id, :channel, :id], {:name=>"idx_duo_wf_checkpoint_blobs_on_workflow_channel_id"})
main: -> 0.0041s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_name_exists?(:p_duo_workflows_checkpoint_blobs, "index_duo_wf_checkpoint_blobs_on_workflow_id")
main: -> 0.0004s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- remove_index(:p_duo_workflows_checkpoint_blobs, {:name=>"index_duo_wf_checkpoint_blobs_on_workflow_id"})
main: -> 0.0015s
main: == 20260831181732 SwapWorkflowIdIndexOnPDuoWorkflowsCheckpointBlobs: migrated (0.4143s)
main: == [advisory_lock_connection] object_id: 161020, pg_backend_pid: 42458Migration down
Output (local, RAILS_ENV=test)
main: == [advisory_lock_connection] object_id: 160740, pg_backend_pid: 42231
main: == 20260831181732 SwapWorkflowIdIndexOnPDuoWorkflowsCheckpointBlobs: reverting
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_name_exists?(:p_duo_workflows_checkpoint_blobs, "index_duo_wf_checkpoint_blobs_on_workflow_id")
main: -> 0.0260s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260801", [:workflow_id], {:name=>"index_89019f9417", :algorithm=>:concurrently})
main: -> 0.0020s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0003s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260801", [:workflow_id], {:name=>"index_89019f9417", :algorithm=>:concurrently})
main: -> 0.0019s
main: -- execute("RESET statement_timeout")
main: -> 0.0002s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260802", [:workflow_id], {:name=>"index_686a204f39", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260802", [:workflow_id], {:name=>"index_686a204f39", :algorithm=>:concurrently})
main: -> 0.0015s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260803", [:workflow_id], {:name=>"index_9aa741d28a", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260803", [:workflow_id], {:name=>"index_9aa741d28a", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260804", [:workflow_id], {:name=>"index_14252da8f5", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260804", [:workflow_id], {:name=>"index_14252da8f5", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260805", [:workflow_id], {:name=>"index_8d68945f5a", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260805", [:workflow_id], {:name=>"index_8d68945f5a", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260806", [:workflow_id], {:name=>"index_65f965247c", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260806", [:workflow_id], {:name=>"index_65f965247c", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260807", [:workflow_id], {:name=>"index_830b3c40ec", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260807", [:workflow_id], {:name=>"index_830b3c40ec", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260808", [:workflow_id], {:name=>"index_e02174542a", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260808", [:workflow_id], {:name=>"index_e02174542a", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260809", [:workflow_id], {:name=>"index_0fb0ae2908", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260809", [:workflow_id], {:name=>"index_0fb0ae2908", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260810", [:workflow_id], {:name=>"index_6dd63f55f1", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260810", [:workflow_id], {:name=>"index_6dd63f55f1", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260811", [:workflow_id], {:name=>"index_fa2f9e1805", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260811", [:workflow_id], {:name=>"index_fa2f9e1805", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260812", [:workflow_id], {:name=>"index_13fb698e81", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260812", [:workflow_id], {:name=>"index_13fb698e81", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260813", [:workflow_id], {:name=>"index_714e66b72b", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260813", [:workflow_id], {:name=>"index_714e66b72b", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260814", [:workflow_id], {:name=>"index_ecf6955b32", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260814", [:workflow_id], {:name=>"index_ecf6955b32", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260815", [:workflow_id], {:name=>"index_f187904e38", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260815", [:workflow_id], {:name=>"index_f187904e38", :algorithm=>:concurrently})
main: -> 0.0007s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260816", [:workflow_id], {:name=>"index_c70831d8c1", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260816", [:workflow_id], {:name=>"index_c70831d8c1", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817", [:workflow_id], {:name=>"index_8cdb8c53cc", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260817", [:workflow_id], {:name=>"index_8cdb8c53cc", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260818", [:workflow_id], {:name=>"index_c2b54f57d8", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260818", [:workflow_id], {:name=>"index_c2b54f57d8", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260819", [:workflow_id], {:name=>"index_5bc837b119", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260819", [:workflow_id], {:name=>"index_5bc837b119", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260820", [:workflow_id], {:name=>"index_e7db040886", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260820", [:workflow_id], {:name=>"index_e7db040886", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260821", [:workflow_id], {:name=>"index_a9386fcea3", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260821", [:workflow_id], {:name=>"index_a9386fcea3", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260822", [:workflow_id], {:name=>"index_58a35c44eb", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260822", [:workflow_id], {:name=>"index_58a35c44eb", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260823", [:workflow_id], {:name=>"index_3216db44d8", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260823", [:workflow_id], {:name=>"index_3216db44d8", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260824", [:workflow_id], {:name=>"index_8a84a0cc2d", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260824", [:workflow_id], {:name=>"index_8a84a0cc2d", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260825", [:workflow_id], {:name=>"index_cf6ea37aef", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260825", [:workflow_id], {:name=>"index_cf6ea37aef", :algorithm=>:concurrently})
main: -> 0.0021s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260826", [:workflow_id], {:name=>"index_3e958277b1", :algorithm=>:concurrently})
main: -> 0.0018s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260826", [:workflow_id], {:name=>"index_3e958277b1", :algorithm=>:concurrently})
main: -> 0.0029s
main: -- transaction_open?(nil)
main: -> 0.0004s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260827", [:workflow_id], {:name=>"index_37dc7fe77f", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260827", [:workflow_id], {:name=>"index_37dc7fe77f", :algorithm=>:concurrently})
main: -> 0.0031s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260828", [:workflow_id], {:name=>"index_3ee9f5b77b", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260828", [:workflow_id], {:name=>"index_3ee9f5b77b", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260829", [:workflow_id], {:name=>"index_9c2801b6f9", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260829", [:workflow_id], {:name=>"index_9c2801b6f9", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260830", [:workflow_id], {:name=>"index_e833fa0f96", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260830", [:workflow_id], {:name=>"index_e833fa0f96", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260831", [:workflow_id], {:name=>"index_529d8a827c", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260831", [:workflow_id], {:name=>"index_529d8a827c", :algorithm=>:concurrently})
main: -> 0.0016s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260901", [:workflow_id], {:name=>"index_e106d62306", :algorithm=>:concurrently})
main: -> 0.0016s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260901", [:workflow_id], {:name=>"index_e106d62306", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260902", [:workflow_id], {:name=>"index_7028fef1a1", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260902", [:workflow_id], {:name=>"index_7028fef1a1", :algorithm=>:concurrently})
main: -> 0.0016s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260903", [:workflow_id], {:name=>"index_1d22abc384", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260903", [:workflow_id], {:name=>"index_1d22abc384", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260904", [:workflow_id], {:name=>"index_f5cf9304a7", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260904", [:workflow_id], {:name=>"index_f5cf9304a7", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260905", [:workflow_id], {:name=>"index_e96ee0ba63", :algorithm=>:concurrently})
main: -> 0.0023s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260905", [:workflow_id], {:name=>"index_e96ee0ba63", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260906", [:workflow_id], {:name=>"index_5f217007aa", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260906", [:workflow_id], {:name=>"index_5f217007aa", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260907", [:workflow_id], {:name=>"index_0ff73fee05", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260907", [:workflow_id], {:name=>"index_0ff73fee05", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260908", [:workflow_id], {:name=>"index_c26516226c", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260908", [:workflow_id], {:name=>"index_c26516226c", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260909", [:workflow_id], {:name=>"index_1d15846712", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260909", [:workflow_id], {:name=>"index_1d15846712", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260910", [:workflow_id], {:name=>"index_9ae70a6029", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260910", [:workflow_id], {:name=>"index_9ae70a6029", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260911", [:workflow_id], {:name=>"index_bc0183894d", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260911", [:workflow_id], {:name=>"index_bc0183894d", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260912", [:workflow_id], {:name=>"index_c7ddac86df", :algorithm=>:concurrently})
main: -> 0.0016s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260912", [:workflow_id], {:name=>"index_c7ddac86df", :algorithm=>:concurrently})
main: -> 0.0018s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260913", [:workflow_id], {:name=>"index_c0e9a329cd", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260913", [:workflow_id], {:name=>"index_c0e9a329cd", :algorithm=>:concurrently})
main: -> 0.0030s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260914", [:workflow_id], {:name=>"index_3c6829fcd5", :algorithm=>:concurrently})
main: -> 0.0013s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260914", [:workflow_id], {:name=>"index_3c6829fcd5", :algorithm=>:concurrently})
main: -> 0.0009s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260915", [:workflow_id], {:name=>"index_e586774d80", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260915", [:workflow_id], {:name=>"index_e586774d80", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260916", [:workflow_id], {:name=>"index_a930ad9b75", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260916", [:workflow_id], {:name=>"index_a930ad9b75", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260917", [:workflow_id], {:name=>"index_66fa27b526", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260917", [:workflow_id], {:name=>"index_66fa27b526", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260918", [:workflow_id], {:name=>"index_dbfb99576b", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260918", [:workflow_id], {:name=>"index_dbfb99576b", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260919", [:workflow_id], {:name=>"index_67753527b0", :algorithm=>:concurrently})
main: -> 0.0020s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260919", [:workflow_id], {:name=>"index_67753527b0", :algorithm=>:concurrently})
main: -> 0.0008s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260920", [:workflow_id], {:name=>"index_4446aae474", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260920", [:workflow_id], {:name=>"index_4446aae474", :algorithm=>:concurrently})
main: -> 0.0022s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260921", [:workflow_id], {:name=>"index_9d97cfffc4", :algorithm=>:concurrently})
main: -> 0.0017s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260921", [:workflow_id], {:name=>"index_9d97cfffc4", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260922", [:workflow_id], {:name=>"index_1d6f82619a", :algorithm=>:concurrently})
main: -> 0.0012s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260922", [:workflow_id], {:name=>"index_1d6f82619a", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260923", [:workflow_id], {:name=>"index_566fbe3b90", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260923", [:workflow_id], {:name=>"index_566fbe3b90", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260924", [:workflow_id], {:name=>"index_8aec41b35c", :algorithm=>:concurrently})
main: -> 0.0030s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260924", [:workflow_id], {:name=>"index_8aec41b35c", :algorithm=>:concurrently})
main: -> 0.0010s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260925", [:workflow_id], {:name=>"index_cf473ca758", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260925", [:workflow_id], {:name=>"index_cf473ca758", :algorithm=>:concurrently})
main: -> 0.0007s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260926", [:workflow_id], {:name=>"index_6e7457d450", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260926", [:workflow_id], {:name=>"index_6e7457d450", :algorithm=>:concurrently})
main: -> 0.0019s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_exists?("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260927", [:workflow_id], {:name=>"index_65ec27c83b", :algorithm=>:concurrently})
main: -> 0.0011s
main: -- add_index("gitlab_partitions_dynamic.p_duo_workflows_checkpoint_blobs_20260927", [:workflow_id], {:name=>"index_65ec27c83b", :algorithm=>:concurrently})
main: -> 0.0017s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- add_index(:p_duo_workflows_checkpoint_blobs, [:workflow_id], {:name=>"index_duo_wf_checkpoint_blobs_on_workflow_id"})
main: -> 0.0039s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- index_name_exists?(:p_duo_workflows_checkpoint_blobs, "idx_duo_wf_checkpoint_blobs_on_workflow_channel_id")
main: -> 0.0004s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- remove_index(:p_duo_workflows_checkpoint_blobs, {:name=>"idx_duo_wf_checkpoint_blobs_on_workflow_channel_id"})
main: -> 0.0021s
main: == 20260831181732 SwapWorkflowIdIndexOnPDuoWorkflowsCheckpointBlobs: reverted (0.3292s)
main: == [advisory_lock_connection] object_id: 160740, pg_backend_pid: 42231References
- Closes #626571 (closed)
- Related: #621934 (closed) (the original index proposal with full before/after analysis)
- Related: !251705 (merged) (async index preparation)
Edited by Eduardo Bonet