Slow queries· last 24h Critical regressionQ-491 · orders-db SELECT * FROM line_items WHERE order_id = $1
Regression introduced in web-api@7d3f2c1. Rolled back at 14:34. N+1 pattern. Recommend single JOIN preload or composite index on (order_id, item_id).
CREATE INDEX CONCURRENTLY idx_line_items_order ON line_items(order_id);
Projected speedup: ≈14× projected p99 latency · last hour
14:0014:1514:3014:4515:00