Trino version: 484
Queued: 140.33us, Analysis: 2.11ms, Planning: 18.33ms, Execution: 253.78ms, Finishing: 0.00ns
Fragment 1 [SINGLE]
    CPU: 834.00us, Scheduled: 846.96us, Blocked 61.17ms (Input: 61.17ms, 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: 0.00ns (0.00%), Scheduled: 0.00ns (0.00%), Blocked: 61.00ms (0.91%), Output: 5 rows (115B)
        Input avg.: 5.00 rows, Input std.dev.: 0.00%

Fragment 2 [ROUND_ROBIN]
    CPU: 5.95ms, Scheduled: 9.05ms, Blocked 2.64s (Input: 2.49s, 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: 149.00ms (2.22%), 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: 2.00ms (10.00%), Scheduled: 4.00ms (11.43%), 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: 0.00ns (0.00%), Blocked: 2.49s (37.07%), Output: 5 rows (115B)
              Input avg.: 0.16 rows, Input std.dev.: 282.13%

Fragment 3 [HASH]
    CPU: 14.42ms, Scheduled: 32.78ms, Blocked 3.40s (Input: 1.67s, Output: 0.00ns), Input: 32 rows (737B); per task: avg.: 16.00 std.dev.: 10.00, Output: 5 rows (115B)
    Peak Memory: 1.02kB, Tasks count: 2; per task: max: 840B
    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 (20.00%), Scheduled: 5.00ms (14.29%), 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: 1.00ms (5.00%), Scheduled: 3.00ms (8.57%), Blocked: 1.74s (25.93%), Output: 32 rows (737B)
       │   Input avg.: 1.00 rows, Input std.dev.: 176.78%
       └─ RemoteSource[sourceFragmentIds = [4]]
              Layout: [mktsegment:varchar(10), count_4:bigint]
              CPU: 2.00ms (10.00%), Scheduled: 3.00ms (8.57%), Blocked: 1.67s (24.80%), Output: 32 rows (737B)
              Input avg.: 1.00 rows, Input std.dev.: 176.78%

Fragment 4 [SOURCE]
    CPU: 15.19ms, Scheduled: 24.78ms, Blocked 608.91ms (Input: 474.37ms, Output: 0.00ns), Input: 1502 rows (33.67kB); per task: avg.: 751.00 std.dev.: 2.00, Output: 32 rows (737B)
    Peak Memory: 3.16kB, Tasks count: 2; per task: max: 1.94kB
    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 (20.00%), Scheduled: 11.00ms (31.43%), 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 (10.00%), Scheduled: 2.00ms (5.71%), Blocked: 111.00ms (1.65%), 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
       ├─ TableScan[table = tpch:tiny:customer]
       │      Layout: [nationkey:bigint, mktsegment:varchar(10)]
       │      Estimates: {rows: 1500 (20.55kB), cpu: 20.55k, memory: 0B, network: 0B}
       │      CPU: 4.00ms (20.00%), Scheduled: 4.00ms (11.43%), 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), Splits: 8, Splits generation wait time: 0.01ms
       └─ LocalExchange[partitioning = SINGLE]
          │   Layout: [nationkey_1:bigint]
          │   Estimates: {rows: 1 (9B), cpu: 0, memory: 0B, network: 0B}
          │   CPU: 0.00ns (0.00%), Scheduled: 0.00ns (0.00%), Blocked: 24.00ms (0.36%), Output: 2 rows (18B)
          │   Input avg.: 0.06 rows, Input std.dev.: 387.30%
          └─ RemoteSource[sourceFragmentIds = [5]]
                 Layout: [nationkey_1:bigint]
                 CPU: 0.00ns (0.00%), Scheduled: 1.00ms (2.86%), Blocked: 474.00ms (7.06%), Output: 2 rows (18B)
                 Input avg.: 0.06 rows, Input std.dev.: 387.30%

Fragment 5 [SOURCE]
    CPU: 1.97ms, Scheduled: 3.00ms, 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: 1.00ms (5.00%), Scheduled: 2.00ms (5.71%), 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

