Skip to main content

EXPLAIN FRAGMENTS

Shows the distributed execution plan of an SQL statement.

This command transforms the execution plan of an SQL statement into plan fragments where you can see the process of retrieving the data you need from Databend.

Syntax

EXPLAIN FRAGMENTS <statement>

Examples

EXPLAIN FRAGMENTS select COUNT() from numbers(10) GROUP BY number % 3;

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| explain |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Fragment 0: |
| DataExchange: Shuffle |
| AggregatorPartial: groupBy=[[(number % 3)]], aggr=[[COUNT()]] |
| Expression: (number % 3):UInt8 (Before GroupBy) |
| ReadDataSource: scan schema: [number:UInt64], statistics: [read_rows: 10, read_bytes: 80, partitions_scanned: 1, partitions_total: 1], push_downs: [projections: [0]] |
| |
| Fragment 2: |
| DataExchange: Merge |
| Projection: COUNT():UInt64 |
| AggregatorFinal: groupBy=[[(number % 3)]], aggr=[[COUNT()]] |
| Remote[receive fragment: 0] |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
11 rows in set (0.02 sec)
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today