Operations / 8 min read / 4 views
Debugging production latency without panic
A calm workflow for tracing slow requests from browser waterfall to database query plan.
Trace the user path first
Start at the edge and keep a timeline. Latency work gets easier when every measurement has a place in the same story.
latency-check.sql
EXPLAIN ANALYZE
SELECT id, status, created_at
FROM jobs
WHERE account_id = $1
ORDER BY created_at DESC
LIMIT 50;