Webinar: How to Compare Postgres Plans & Tune Slow Queries with pganalyze
Comparing EXPLAIN plans manually is a painstaking process of pattern-matching and query trial-and-error. We’ll show you how to compare Postgres plans in pganalyze where the analysis is done automatically to easily uncover common problems causing slow queries.
Lukas Fittl
Founder & CEO, pganalyze
Founder & CEO, pganalyze
In detail, we walk through
- How to identify slow queries using data gathered by pganalyze & its Automated EXPLAIN feature
- How to compare query plans against variants to test for performance with the new Query Tuning features
- How to debug common scenarios like inefficient joins and nested loops and missing or inefficient indexes
- How to fix queries by rewriting them, changing statistics settings, or forcing a better plan
Watch the Webinar Recording
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
