Webinar Recording: How to use the Postgres query planner to debug bad plans and speed up queries
Follow-up resources
Links referenced in the webinar
- The Basics of Postgres Query Planning
- Hacking the Query Planner (PDF) - Tom Lane’s presentation from PGCon 2011
- How Postgres Chooses Which Index To Use For A Query
- CREATE STATISTICS postgresql.org docs
- 5mins of Postgres E15: Tuning Postgres' Deterministic Query Planner, Extended Statistics and Join Collapse Limits
- Query Planning Gone Wrong (video) - Robert Haas' presentation from Postgres Open 2013
- auto_explain postgresql.org docs
- “Sampling-based timing for EXPLAIN ANALYZE” on the pgsql-hackers list
- Recording of our previous webinar “Optimizing Postgres I/O Performance and Costs”
- EXPLAIN (ANALYZE) needs BUFFERS to improve the Postgres query optimization
- pg_hint_plan GitHub repository
- 5mins of Postgres E1: Using Postgres statistics to improve bad query plans, pg_hint_plan extension
- “How to influence query planning in Postgresql” - by Chris Kiehl
- 5mins of Postgres E51: Using Memoize to speed up joins between two Postgres tables
Get in touch with us to learn more or request a demo
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
