PostgreSQL execution plans
See how PostgreSQL plans or actually executes your query.
Paste JSON produced by PostgreSQL. QueryGraph parses and analyzes it entirely in this browser; it does not execute SQL, connect to a database, or send the plan elsewhere.
Estimated plan
Plans without executing the statement. Cost values are planner units, not milliseconds.
EXPLAIN (FORMAT JSON) SELECT ...;
Actual runtime + buffers
Executes the statement and records observed timing, rows, loops, and buffers.
EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) SELECT ...;
EXPLAIN ANALYZE executes the statement. INSERT, UPDATE, DELETE, and functions with side effects can modify data.
Supported: PostgreSQL EXPLAIN JSON, including JSON copied from common SQL clients, ANALYZE, BUFFERS, workers, JIT, and triggers. Not supported: text, YAML, XML, MySQL EXPLAIN, or SQL-only input. Limits: 2 MB, 1000 nodes, depth 100.