← recall

query plan term

DB's chosen execution strategy for a query

Use EXPLAIN ANALYZE to see actual time per node. Look for high cost nodes, mismatches between estimated and actual rows, sequential scans on large tables.

aliases: explain plan, execution plan

topics: databases, postgres

references:

• Postgres — EXPLAIN
• explain.depesz.com (visualizer)