Return the plan as machine-readable JSON.

Section: EXPLAIN and Plan Analysis

EXPLAIN JSON format

sql
sql
EXPLAIN (ANALYZE, FORMAT JSON) SELECT * FROM orders;
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing EXPLAIN and Plan Analysis
EXPLAIN query
Show the planner's chosen execution plan.
OpenIn sheetsqlsame section
EXPLAIN ANALYZE
Run the query and show actual timing and buffer usage.
OpenIn sheetsqlsame section
EXPLAIN VERBOSE
Include more detail about output columns and active settings.
OpenIn sheetsqlsame section
Enable auto_explain
Log slow query plans automatically in the server logs.
OpenIn sheetsqlsame section
Vacuum one table
Reclaim dead tuples and maintain visibility data.
Show work_mem
Inspect a setting that affects sort and hash memory usage.