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 scenarios, even 1 ms might seem to be too…
How to find query examples for problematic pg_stat_statements records
In a few hours, I'm presenting my "Seamless Postgres query optimization" tutorial at DjangoCon US, so it's a good time to talk about transitioning from…
How to use lib_pgquery in shell to normalize and match queries from various sources
How to work with pg_stat_statements, part 1
There are two big branches of query optimization: