Finding the root cause of slow Postgres queries using EXPLAIN
Learn how to use EXPLAIN to understand problematic query plans, and how to enable auto_explain to automatically collect EXPLAIN plans for slow queries.
In this book you will learn:
- How you can use EXPLAIN to find common patterns of problematic plans
- How you then can improve these query plans that match these patterns
- How you can use auto_explain to automatically start collecting EXPLAIN plans so you don't have to