From Dev.to

How to read PostgreSQL EXPLAIN output

TL;DR Read the plan tree from leaves to root; cost, rows, and width are estimates, not measurements. Start with plain EXPLAIN when execution consequences are unknown. EXPLAIN ANALYZE executes the...

Read the full report at Dev.to ↗