EXPLAIN

Also written: EXPLAIN ANALYZE, query plan

A command that shows the plan Postgres chooses for a query, as a tree of nodes. Plain EXPLAIN shows only estimates, and EXPLAIN ANALYZE runs the query and adds the actual results.