EXPLAIN

Also written: EXPLAIN ANALYZE

Shows the plan Postgres chose for a query. Plain EXPLAIN only estimates, while EXPLAIN ANALYZE actually runs the query and reports real times.