v.22.3Improvement

EXPLAIN AST Query Outputs Graphviz Format Graph

Official CH changelog text
EXPLAIN AST query can output AST in form of a graph in Graphviz format: EXPLAIN AST graph = 1 SELECT * FROM system.parts. #35173 (李扬).
EXPLAIN AST query now supports outputting the Abstract Syntax Tree (AST) as a graph in Graphviz format.

Why it matters

This feature allows users to visualize the AST of a query, making it easier to understand query parsing and optimization by representing the query structure graphically.

How to use it

Use the command EXPLAIN AST graph = 1 <query> to get the AST output in Graphviz graph format. For example: EXPLAIN AST graph = 1 SELECT * FROM system.parts.

Related resources

PreviousNext