Cheat Sheet logoCheat Sheet Today
PostgreSQL Performance Cheat Sheet/EXPLAIN VERBOSE

Include more detail about output columns and active settings.

Back to sheetBrowse commands
Sign in to save
Section: EXPLAIN and Plan Analysis

EXPLAIN VERBOSE

sql
sql
EXPLAIN (ANALYZE, VERBOSE, BUFFERS, SETTINGS) SELECT * FROM orders WHERE customer_id = 42;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

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 JSON format
Return the plan as machine-readable JSON.
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.
OpenIn sheetsql
Show work_mem
Inspect a setting that affects sort and hash memory usage.
OpenIn sheetsql