You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Postgres EXPLAIN parsing incorrect and missing new flags #1416
Hello! Just filing this to let you know of the current issues with the EXPLAIN statement parsing since it looks like it was implemented slightly wrong (brackets missing for all options exception analyze and verbose, parses boolean options when not using brackets) and a few features missing(using 0 and 1 for false and true, new Postgres options, text format)
Queries that should parse and work as expected:
EXPLAIN SELECT 1
EXPLAIN ANALYZE SELECT 1
EXPLAIN VERBOSE SELECT 1
EXPLAIN ANALYZE VERBOSE SELECT 1
Queries that should not parse (that currently do not parse as expected):
EXPLAIN () SELECT 1
Queries that should not parse (that currently parse):
EXPLAIN ANALYZE TRUE SELECT 1
EXPLAIN VERBOSE TRUE SELECT 1
EXPLAIN BUFFERS SELECT 1
EXPLAIN COSTS SELECT 1
EXPLAIN FORMAT XML SELECT 1
EXPLAIN FORMAT JSON SELECT 1
EXPLAIN FORMAT YAML SELECT 1
Queries that should parse and do not currently work (bugs):
Activity
wumpz commentedon Nov 19, 2021
@SerialVelocity Wow. This was included over a year ago. Strange that til now nobody complained. You are right, the implementation is wrong.
SuperPat45 commentedon Feb 4, 2026
EXPLAIN ANALYZE would be very useful.