Trino version: 484
Fragment 0 [SINGLE]
    Output layout: [mktsegment, count]
    Output partitioning: SINGLE []
    Output[columnNames = [mktsegment, customers]]
    │   Layout: [mktsegment:varchar(10), count:bigint]
    │   Estimates: {rows: 5 (70B), cpu: 0, memory: 0B, network: 0B}
    │   customers := count
    └─ RemoteMerge[sourceFragmentIds = [1]]
           Layout: [mktsegment:varchar(10), count:bigint]

Fragment 1 [ROUND_ROBIN]
    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}
    └─ PartialSort[orderBy = [mktsegment ASC NULLS LAST]]
       │   Layout: [mktsegment:varchar(10), count:bigint]
       │   Estimates: {rows: 5 (70B), cpu: ?, memory: ?, network: ?}
       └─ RemoteSource[sourceFragmentIds = [2]]
              Layout: [mktsegment:varchar(10), count:bigint]

Fragment 2 [HASH]
    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}
    │   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}
       └─ RemoteSource[sourceFragmentIds = [3]]
              Layout: [mktsegment:varchar(10), count_4:bigint]

Fragment 3 [SOURCE]
    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: ?}
    │   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}
       │   Distribution: REPLICATED
       │   dynamicFilterAssignments = {nationkey_1 -> #df_401}
       ├─ ScanFilter[table = tpch:tiny:customer, dynamicFilters = {nationkey = #df_401}]
       │      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}
       │      nationkey := tpch:nationkey
       │      mktsegment := tpch:mktsegment
       └─ LocalExchange[partitioning = SINGLE]
          │   Layout: [nationkey_1:bigint]
          │   Estimates: {rows: 1 (9B), cpu: 0, memory: 0B, network: 0B}
          └─ RemoteSource[sourceFragmentIds = [4]]
                 Layout: [nationkey_1:bigint]

Fragment 4 [SOURCE]
    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}
        nationkey_1 := tpch:nationkey
        name_2 := tpch:name

