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.

Ebook Cover Image

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

Download this eBook


Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze

Atlassian
DoorDash
Moody's
fuboTv
Salsify
CounterPath
Ipsy