Performance / Guide
Finding and Fixing Slow Queries with pg_stat_statements | pginsights
The guide ranks pg_stat_statements entries by total time, mean time, calls, I/O and temp spill, shows reset and snapshot-delta approaches, and summarizes column changes from PostgreSQL 13 through 18. It finishes with EXPLAIN (ANALYZE, BUFFERS) interpretation and an ordered troubleshooting checklist tested on PostgreSQL 17.11.
Read the guideWhy it’s in the collection
Provides runnable monitoring queries and a practical triage sequence for diagnosing slow statements with a contrib extension.
THE CONVERSATION
Found on Hacker News 1
Links lead to the original story or comment where this resource appeared. Titles identify the surrounding discussion.