Webinar Recording: How to Compare Postgres Plans & Tune Slow Queries
Additional resources
- Presentation slides
- pganalyze newsletter
- Webinar: How to optimize slow queries with EXPLAIN
- Amazon Aurora documentation: aurora_stat_plans
5mins of Postgres episodes
- Improved EXPLAIN for SubPlan nodes
- Tuning random_page_cost and how index correlation affects query plans
- EXPLAIN (ANALYZE, BUFFERS) and interpreting shared buffers hit in Nested Loops
- How to optimize correlated subqueries in Postgres
- Faster query plans with Postgres 16: Incremental Sorts, Anti-JOINs and more
Get in touch with us to learn more or request a demo
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
