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