1951. How to Tell Whether Your Slow Query Is a Planning or an Execution Problem (www.tigerdata.com)
How to tell if your slow Postgres query is a planning or execution problem: read EXPLAIN ANALYZE's Planning Time and Execution Time to diagnose the bottleneck.