Run #4
trips · submitted 11 Oct 2026, 18:57
SQL
successSELECT region, COUNT(*) AS n, AVG(distance) AS avg_distance FROM trips GROUP BY region ORDER BY n DESC
Dataset trips · ./data/trips
| Row | region | n | avg_distance |
|---|---|---|---|
| 1 | EU | 100,000 | 20.0795 |
| 2 | APAC | 100,000 | 20.1004 |
| 3 | US | 100,000 | 20.1498 |
The plan after optimization, which is what actually executed — projection and predicate pushdown have already been applied, so the Scan node shows the columns and filters it really used.
Text plan
Sort n desc
Aggregate group=[region] aggs=[count(*),avg(distance)]
Scan trips cols=[distance]
Where the bytes went
The middle bars are bytes a scan-everything engine would have read and this one did not. They add up to the full scan exactly — it is one number decomposed, not four separate measurements.
Row-group map (120 of 120 read)
Scan metrics as recorded by the engine
- total_files
- 15
- files_scanned
- 15
- files_pruned
- 0
- total_row_groups
- 120
- row_groups_scanned
- 120
- row_groups_pruned
- 0
- rows_scanned
- 300000
- columns_projected
- 1
- columns_total
- 7
- bytes_scanned
- 1438507
- bytes_total
- 6190367
- bytes_pruned_files
- 0
- bytes_pruned_row_groups
- 0
- bytes_unprojected
- 4751860
Byte counts are compressed on-disk bytes on both sides of the ratio.
bytes_total covers every row-group including the pruned ones, plus the
file size of files that were never opened.
- Only 1 of 7 columns came off disk — the other 6 were never referenced, and Parquet is columnar.
The middle bars are bytes a scan-everything engine would have read and this one did not. They add up to the full scan exactly — it is one number decomposed, not four separate measurements.