Enable auto_explain

sql

LOAD 'auto_explain';
SET auto_explain.log_min_duration = '200ms';
SET auto_explain.log_analyze = on;

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

Return the plan as machine-readable JSON.

Open In sheetsqlsame section

Prefer keyset pagination over deep OFFSET scans for large result sets.

Open In sheetsql1 tag match

Avoid fetching unnecessary columns, especially wide rows.

Open In sheetsql1 tag match