EXPLAIN ANALYZE

sql

EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM orders WHERE customer_id = 42;

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

Include more detail about output columns and active settings.

Open In sheetsqlsame section

Return the plan as machine-readable JSON.

Open In sheetsqlsame section

Log slow query plans automatically in the server logs.

Open In sheetsqlsame section

Vacuum and refresh planner stats in one command.

Open In sheetsql1 tag match

Show extra detail while updating planner statistics.

Open In sheetsql1 tag match