EXPLAIN ANALYZE or EXPLAIN (ANALYZE, BUFFERS)?
UPDATE 2025: Starting with Postgres 18, the `BUFFERS` option becomes default in `EXPLAIN ANALYZE`, which is great news.
5 docs tagged with "query-analysis"
View All TagsHow to decide when a query is too slow and needs optimization
"Slow" is a relative concept. In some cases, we might be happy with query latency 1 minute (or no?), while in other
How to find query examples for problematic pg_stat_statements records
// I post a new PostgreSQL "howto" article every day. Join me in this journey – subscribe, provide feedback, share!
How to use lib_pgquery in shell to normalize and match queries from various sources
How to work with pg_stat_statements, part 1
Two branches of query optimization