Query Plan Surprises in PostgreSQL
A slow reporting query, eleven seconds on three million rows, and three weeks of actually reading EXPLAIN ANALYZE output.
A slow reporting query, eleven seconds on three million rows, and three weeks of actually reading EXPLAIN ANALYZE output.
Before you reach for Datadog or htop, there's a whole set of built-in utilities that tell you exactly what your system is doing.