Skip to content

masterclass Buddy

Sign in Start learning

PostgreSQL · Command

EXPLAIN ANALYZE

EXPLAIN shows the execution plan PostgreSQL chooses for a statement. EXPLAIN ANALYZE runs it and adds actual timing and row data.

Last updated 2 November 2026

Syntax

EXPLAIN [ ( option [, ...] ) ] statement

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

ANALYZE
PREPARE
EXPLAIN EXECUTE
FORMAT JSON
FORMAT YAML

Source: PostgreSQL: Documentation: 18: EXPLAIN. Checked 2026-11-03.