EXPLAIN JSON format

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.

Same sheet · prioritizing EXPLAIN and Plan Analysis

Show the planner's chosen execution plan.

Open In sheetsqlsame section

Run the query and show actual timing and buffer usage.

Open In sheetsqlsame section

Include more detail about output columns and active settings.

Open In sheetsqlsame section

Log slow query plans automatically in the server logs.

Open In sheetsqlsame section

Reclaim dead tuples and maintain visibility data.

Inspect a setting that affects sort and hash memory usage.