PostgreSQL · Command
EXPLAIN
EXPLAIN shows PostgreSQL's chosen execution plan for a statement. It can report estimated costs and, with ANALYZE, actual execution statistics.
Last updated
Syntax
EXPLAIN [ ( option [, ...] ) ] statement
EXPLAIN [ ANALYZE ] [ VERBOSE ] statementIn-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.
SubscribeRelated
ANALYZEEXECUTEPREPAREANALYZE