EXPLAIN query

sql

EXPLAIN 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

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

Return the plan as machine-readable JSON.

Open In sheetsqlsame section

Log slow query plans automatically in the server logs.

Open In sheetsqlsame section

Inspect a planner estimate of OS cache availability.

Open In sheetsql1 tag match

Inspect a cost parameter that influences index-vs-seqscan decisions.

Open In sheetsql1 tag match