Webinar: How to Optimize Slow Queries with EXPLAIN to Fix Bad Query Plans

Learn the essential skills of optimizing slow queries with EXPLAIN ANALYZE and get practical advice on how to address common problems.

Lukas Fittl
Founder & CEO, pganalyze

How to go from a slow query to a query plan that shows which exact part was slows
Why BUFFERS is important, and how to interpret the hits counter
How to rewrite queries based on plans to speed up performance
The different planner settings and how they influence plan choices
How to identify when plans "fall over" to a bad query plan and why this can happen
Identifying bad row estimates in a query, and how to correct them with better statistics
Using statistics on expressions to help queries that use JSONB
Identifying alternate plans using planner hints with pg_hint_plan
Other ways of overriding the Postgres planner choices
Parameterized Index Scans, and how they are influenced by the join order and join type
Existing and upcoming pganalyze functionality for optimizing slow queries and working with EXPLAIN plans