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.