Query tuning
Optimize query performance with EXPLAIN ANALYZE, execution plans, and performance tuning techniques
How-to guides​
EXPLAIN ANALYZE or EXPLAIN (ANALYZE, BUFFERS)?​
Difficulty: intermediate • Time: 5 min
How to find query examples for problematic pg_stat_statements records​
Difficulty: beginner • Time: 6 min
How to decide when a query is too slow and needs optimization​
Difficulty: intermediate • Time: 5 min
How to make the non-production Postgres planner behave like in production​
Difficulty: intermediate • Time: 5 min