Trino version: 484
Queued: 157.38us, Analysis: 2.48ms, Planning: 28.19ms, Execution: 311.48ms, Finishing: 0.00ns
Fragment 1 [SINGLE]
    CPU: 888.00us, Scheduled: 897.04us, Blocked 132.94ms (Input: 132.94ms, Output: 0.00ns), Input: 5 rows (115B); per task: avg.: 5.00 std.dev.: 0.00, Output: 5 rows (115B)
    Peak Memory: 352B, Tasks count: 1; per task: max: 352B
    Output layout: [mktsegment, count]
    Output partitioning: SINGLE []
    RemoteMerge[sourceFragmentIds = [2]]
        Layout: [mktsegment:varchar(10), count:bigint]
        CPU: 1.00ms (2.86%), Scheduled: 1.00ms (1.82%), Blocked: 133.00ms (1.19%), Output: 5 rows (115B)
        Input avg.: 5.00 rows, Input std.dev.: 0.00%

Fragment 2 [ROUND_ROBIN]
    CPU: 8.56ms, Scheduled: 42.37ms, Blocked 3.51s (Input: 3.30s, Output: 0.00ns), Input: 5 rows (115B); per task: avg.: 2.50 std.dev.: 1.50, Output: 5 rows (115B)
    Peak Memory: 512B, Tasks count: 2; per task: max: 296B
    Amount of input data processed by the workers for this stage might be skewed
    Output layout: [mktsegment, count]
    Output partitioning: SINGLE []
    LocalMerge[orderBy = [mktsegment ASC NULLS LAST]]
    │   Layout: [mktsegment:varchar(10), count:bigint]
    │   Estimates: {rows: 5 (70B), cpu: 0, memory: 0B, network: 0B}
    │   CPU: 0.00ns (0.00%), Scheduled: 0.00ns (0.00%), Blocked: 210.00ms (1.89%), Output: 5 rows (115B)
    │   Input avg.: 0.16 rows, Input std.dev.: 282.13%
    └─ PartialSort[orderBy = [mktsegment ASC NULLS LAST]]
       │   Layout: [mktsegment:varchar(10), count:bigint]
       │   Estimates: {rows: 5 (70B), cpu: ?, memory: ?, network: ?}
       │   CPU: 4.00ms (11.43%), Scheduled: 5.00ms (9.09%), Blocked: 0.00ns (0.00%), Output: 5 rows (115B)
       │   Input avg.: 0.16 rows, Input std.dev.: 282.13%
       └─ RemoteSource[sourceFragmentIds = [3]]
              Layout: [mktsegment:varchar(10), count:bigint]
              CPU: 0.00ns (0.00%), Scheduled: 1.00ms (1.82%), Blocked: 3.30s (29.63%), Output: 5 rows (115B)
              Input avg.: 0.16 rows, Input std.dev.: 282.13%

Fragment 3 [HASH]
    CPU: 16.88ms, Scheduled: 36.40ms, Blocked 5.55s (Input: 2.81s, Output: 0.00ns), Input: 32 rows (737B); per task: avg.: 16.00 std.dev.: 10.00, Output: 5 rows (115B)
    Peak Memory: 832B, Tasks count: 2; per task: max: 632B
    Amount of input data processed by the workers for this stage might be skewed
    Output layout: [mktsegment, count]
    Output partitioning: ROUND_ROBIN []
    Aggregate[type = FINAL, keys = [mktsegment]]
    │   Layout: [mktsegment:varchar(10), count:bigint]
    │   Estimates: {rows: 5 (70B), cpu: 842, memory: 70B, network: 0B}
    │   CPU: 4.00ms (11.43%), Scheduled: 14.00ms (25.45%), Blocked: 0.00ns (0.00%), Output: 5 rows (115B)
    │   Input avg.: 1.00 rows, Input std.dev.: 233.18%
    │   count := count(count_4)
    └─ LocalExchange[partitioning = HASH, arguments = [mktsegment::varchar(10)]]
       │   Layout: [mktsegment:varchar(10), count_4:bigint]
       │   Estimates: {rows: 60 (842B), cpu: 842, memory: 0B, network: 0B}
       │   CPU: 2.00ms (5.71%), Scheduled: 2.00ms (3.64%), Blocked: 2.73s (24.51%), Output: 32 rows (737B)
       │   Input avg.: 1.00 rows, Input std.dev.: 289.40%
       └─ RemoteSource[sourceFragmentIds = [4]]
              Layout: [mktsegment:varchar(10), count_4:bigint]
              CPU: 2.00ms (5.71%), Scheduled: 2.00ms (3.64%), Blocked: 2.81s (25.23%), Output: 32 rows (737B)
              Input avg.: 1.00 rows, Input std.dev.: 289.40%

Fragment 4 [SOURCE]
    CPU: 25.71ms, Scheduled: 33.72ms, Blocked 1.95s (Input: 1.51s, Output: 0.00ns), Input: 1502 rows (33.67kB); per task: avg.: 751.00 std.dev.: 2.00, Output: 32 rows (737B)
    Peak Memory: 132.94kB, Tasks count: 2; per task: max: 131kB
    Output layout: [mktsegment, count_4]
    Output partitioning: HASH [mktsegment]
    Aggregate[type = PARTIAL, keys = [mktsegment]]
    │   Layout: [mktsegment:varchar(10), count_4:bigint]
    │   Estimates: {rows: 60 (842B), cpu: ?, memory: ?, network: ?}
    │   CPU: 4.00ms (11.43%), Scheduled: 6.00ms (10.91%), Blocked: 0.00ns (0.00%), Output: 32 rows (737B)
    │   Input avg.: 8.63 rows, Input std.dev.: 35.23%
    │   count_4 := count(*)
    └─ InnerJoin[criteria = (nationkey = nationkey_1), distribution = REPLICATED]
       │   Layout: [mktsegment:varchar(10)]
       │   Estimates: {rows: 60 (302B), cpu: 20.87k, memory: 18B, network: 0B}
       │   CPU: 2.00ms (5.71%), Scheduled: 2.00ms (3.64%), Blocked: 348.00ms (3.12%), Output: 69 rows (1.21kB)
       │   Left (probe) Input avg.: 187.50 rows, Input std.dev.: 0.71%
       │   Right (build) Input avg.: 1.00 rows, Input std.dev.: 0.00%
       │   Distribution: REPLICATED
       │   dynamicFilterAssignments = {nationkey_1 -> #df_443}
       ├─ ScanFilter[table = tpch:tiny:customer, dynamicFilters = {nationkey = #df_443}]
       │      Layout: [nationkey:bigint, mktsegment:varchar(10)]
       │      Estimates: {rows: 1500 (20.55kB), cpu: 20.55k, memory: 0B, network: 0B}/{rows: 1500 (20.55kB), cpu: 20.55k, memory: 0B, network: 0B}
       │      CPU: 11.00ms (31.43%), Scheduled: 11.00ms (20.00%), Blocked: 0.00ns (0.00%), Output: 1500 rows (33.66kB)
       │      Input avg.: 187.50 rows, Input std.dev.: 0.71%
       │      nationkey := tpch:nationkey
       │      mktsegment := tpch:mktsegment
       │      Input: 1500 rows (33.66kB), Filtered: 0.00%, Splits: 8, Splits generation wait time: 0.00ms
       │      Dynamic filters: 
       │          - df_443, [ SortedRangeSet[type=bigint, ranges=1, {[3]}] ], collection time=125.04ms
       └─ LocalExchange[partitioning = SINGLE]
          │   Layout: [nationkey_1:bigint]
          │   Estimates: {rows: 1 (9B), cpu: 0, memory: 0B, network: 0B}
          │   CPU: 2.00ms (5.71%), Scheduled: 3.00ms (5.45%), Blocked: 96.00ms (0.86%), Output: 2 rows (18B)
          │   Input avg.: 0.06 rows, Input std.dev.: 387.30%
          └─ RemoteSource[sourceFragmentIds = [5]]
                 Layout: [nationkey_1:bigint]
                 CPU: 1.00ms (2.86%), Scheduled: 1.00ms (1.82%), Blocked: 1.51s (13.57%), Output: 2 rows (18B)
                 Input avg.: 0.06 rows, Input std.dev.: 387.30%

Fragment 5 [SOURCE]
    CPU: 2.79ms, Scheduled: 6.60ms, Blocked 0.00ns (Input: 0.00ns, Output: 0.00ns), Input: 25 rows (527B); per task: avg.: 12.50 std.dev.: 12.50, Output: 1 row (9B)
    Peak Memory: 96B, Tasks count: 2; per task: max: 96B
    Amount of input data processed by the workers for this stage might be skewed
    Output layout: [nationkey_1]
    Output partitioning: BROADCAST []
    ScanFilterProject[table = tpch:tiny:nation, filterPredicate = (name_2 = varchar(25) 'CANADA')]
        Layout: [nationkey_1:bigint]
        Estimates: {rows: 25 (225B), cpu: 527, memory: 0B, network: 0B}/{rows: 1 (9B), cpu: 527, memory: 0B, network: 0B}/{rows: 1 (9B), cpu: 9, memory: 0B, network: 0B}
        CPU: 2.00ms (5.71%), Scheduled: 7.00ms (12.73%), Blocked: 0.00ns (0.00%), Output: 1 row (9B)
        Input avg.: 3.13 rows, Input std.dev.: 264.58%
        nationkey_1 := tpch:nationkey
        name_2 := tpch:name
        Input: 25 rows (527B), Filtered: 96.00%, Splits: 8, Splits generation wait time: 0.01ms

