Details for Query 5

Show the Stage ID and Task ID that corresponds to the max metric
WholeStageCodegen (5) duration: 4 msWholeStageCodegen (4) duration: total (min, med, max )434 ms (1 ms, 1 ms, 10 ms )WholeStageCodegen (3) duration: total (min, med, max )1.5 m (643 ms, 2.1 s, 2.5 s )WholeStageCodegen (1) duration: total (min, med, max )44.3 s (0 ms, 662 ms, 2.4 s )WholeStageCodegen (2) duration: total (min, med, max )43.8 s (0 ms, 638 ms, 2.5 s )
HashAggregate

time in aggregation build: 4 ms
number of output rows: 1
Exchange

shuffle records written: 200
shuffle write time total (min, med, max )
54 ms (0 ms, 0 ms, 2 ms )
records read: 200
local bytes read: 5.6 KiB
fetch wait time: 0 ms
remote bytes read: 5.6 KiB
local blocks read: 100
remote blocks read: 100
data size total (min, med, max )
3.1 KiB (16.0 B, 16.0 B, 16.0 B )
shuffle bytes written total (min, med, max )
11.1 KiB (56.0 B, 56.0 B, 59.0 B )
HashAggregate

time in aggregation build total (min, med, max )
380 ms (0 ms, 1 ms, 10 ms )
number of output rows: 200
HashAggregate

time in aggregation build total (min, med, max )
169 ms (0 ms, 0 ms, 9 ms )
peak memory total (min, med, max )
4.0 GiB (256.0 KiB, 256.0 KiB, 64.3 MiB )
number of output rows: 78
avg hash probe bucket list iters (min, med, max ):
(1, 1, 1 )
Exchange

shuffle records written: 3,432
shuffle write time total (min, med, max )
271 ms (4 ms, 6 ms, 11 ms )
records read: 3,432
local bytes read total (min, med, max )
95.5 KiB (0.0 B, 0.0 B, 1896.0 B )
fetch wait time total (min, med, max )
17 ms (0 ms, 0 ms, 4 ms )
remote bytes read total (min, med, max )
96.1 KiB (0.0 B, 0.0 B, 2.0 KiB )
local blocks read: 1,404
remote blocks read: 1,412
data size total (min, med, max )
80.1 KiB (1864.0 B, 1864.0 B, 1864.0 B )
shuffle bytes written total (min, med, max )
191.6 KiB (4.4 KiB, 4.4 KiB, 4.4 KiB )
HashAggregate

time in aggregation build total (min, med, max )
1.5 m (635 ms, 2.1 s, 2.5 s )
peak memory total (min, med, max )
2.8 GiB (64.3 MiB, 64.3 MiB, 64.3 MiB )
number of output rows: 3,432
avg hash probe bucket list iters (min, med, max ):
(1, 1, 1 )

Union


Project

Scan csv

number of files read: 1
metadata time: 0 ms
size of files read: 2.7 GiB
number of output rows: 6,905,288

Project

Scan csv

number of files read: 1
metadata time: 0 ms
size of files read: 2.7 GiB
number of output rows: 6,905,288
Details