The p95 for POST /checkout went from 410 ms to 1.9 s after Tuesday's deploy. Two changes landed together:
customer_id.| Step | Before | After |
|---|---|---|
| Tax lookup | 12 ms | 640 ms |
| Cart query | 35 ms | 880 ms |
| Everything else | 363 ms | 380 ms |
Restore the index first. It is one statement and needs no deploy:
create index concurrently cart_items_customer_id_idx
on cart_items (customer_id);The tax lookup is slower by design. Cache it per region and it stops showing up.
The full trace is in the Acme runbook.