📄️ EXPLAIN ANALYZE
EXPLAIN ANALYZE used to display a query execution plan along with actual run-time performance statistics.
📄️ EXPLAIN AST
Returns the abstract syntax tree (AST) of an SQL statement. The command breaks an SQL statement into syntactic parts and represents them in a hierarchical structure.
📄️ EXPLAIN FRAGMENTS
Shows the distributed execution plan of an SQL statement.
📄️ EXPLAIN MEMO
Returns the internal structure Memo of the query.
📄️ EXPLAIN RAW
Shows the logical execution plan of an SQL statement that you can use to analyze, troubleshoot, and improve the efficiency of your queries.
📄️ EXPLAIN SYNTAX
Outputs formatted SQL code. This command works as an SQL formatter that makes your code easy to read.
Shows the execution plan of a SQL statement. An execution plan is shown as a tree consisting of different operators where you can see how Databend will execute the SQL statement. An operator usually includes one or more fields describing the actions Databend will perform or the objects related to the query.