Postgres Performance Basics: Reading EXPLAIN Output and Fixing Slow Queries

A slow query is a guess until you see its plan. Postgres will tell you exactly how it intends to run a query and, with one extra keyword, how the run actually went. Learning to read that output is one