RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local

← cluster insights objects party_to_account_groups_mv explain
Overview Objects Graph History
materialized view · insights.party_to_account_groups_mv profiled over 5s
seconds (1–30)

Job is idle — throughput ~0; structure shown.

Stateful hash join (4 state tables) — consider a temporal join for dimension lookupsAggregation state — unbounded unless keyed or temporally filtered
106 operators
Materialize · insights.party_to_account_groups_mv
0% idle 2 actors
Union
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · parties.id = party_account_group_types_mv_next.party_id
— — 2 actors
HashJoin · Inner · parties.id = party_account_group_types_mv_next.party_id Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · party_account_group_types_mv_next
0% idle 2 actors
StreamScan · party_account_group_types_mv_next
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
NoOp
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · parties.id = customer_relationships.party_id
— — 2 actors
HashJoin · Inner · parties.id = customer_relationships.party_id Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
HashAgg Aggregation state — unbounded unless keyed or temporally filtered
0% idle 2 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · customer_relationships
— — 2 actors
Filter · customer_relationships
0% idle 2 actors
StreamScan · customer_relationships
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · parties
— — 2 actors
Filter · parties
0% idle 2 actors
StreamScan · parties
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · parties.id = party_account_group_types_mv_next.party_id
— — 2 actors
HashJoin · Inner · parties.id = party_account_group_types_mv_next.party_id Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · party_account_group_types_mv_next
0% idle 2 actors
StreamScan · party_account_group_types_mv_next
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
NoOp
0% idle 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · parties.id = party_account_group_types_mv_next.party_id
— — 2 actors
HashJoin · Inner · parties.id = party_account_group_types_mv_next.party_id Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · party_account_group_types_mv_next
0% idle 2 actors
StreamScan · party_account_group_types_mv_next
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
NoOp
0% idle 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Heat = the operator's output-buffer backpressure over the sampling window. Click a node to fold its subtree.
Materialize · insights.party_to_account_groups_mv Materialize insights.party_to_accou… idle · 2 actors Union Union idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · Inner · parties.id = party_account_group_types_mv_next.party_id SyncLogStore Inner · parties.id = pa… — · 2 actors HashJoin · Inner · parties.id = party_account_group_types_mv_next.party_id HashJoin Inner · parties.id = pa… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · party_account_group_types_mv_next Filter party_account_group_typ… idle · 2 actors StreamScan · party_account_group_types_mv_next StreamScan party_account_group_typ… idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors NoOp NoOp idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore SyncLogStore — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore SyncLogStore — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore SyncLogStore — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · Inner · parties.id = customer_relationships.party_id SyncLogStore Inner · parties.id = cu… — · 2 actors HashJoin · Inner · parties.id = customer_relationships.party_id HashJoin Inner · parties.id = cu… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors HashAgg HashAgg idle · 2 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · customer_relationships Project customer_relationships — · 2 actors Filter · customer_relationships Filter customer_relationships idle · 2 actors StreamScan · customer_relationships StreamScan customer_relationships idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · parties Project parties — · 2 actors Filter · parties Filter parties idle · 2 actors StreamScan · parties StreamScan parties idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · Inner · parties.id = party_account_group_types_mv_next.party_id SyncLogStore Inner · parties.id = pa… — · 2 actors HashJoin · Inner · parties.id = party_account_group_types_mv_next.party_id HashJoin Inner · parties.id = pa… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · party_account_group_types_mv_next Filter party_account_group_typ… idle · 2 actors StreamScan · party_account_group_types_mv_next StreamScan party_account_group_typ… idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors NoOp NoOp idle · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · Inner · parties.id = party_account_group_types_mv_next.party_id SyncLogStore Inner · parties.id = pa… — · 2 actors HashJoin · Inner · parties.id = party_account_group_types_mv_next.party_id HashJoin Inner · parties.id = pa… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · party_account_group_types_mv_next Filter party_account_group_typ… idle · 2 actors StreamScan · party_account_group_types_mv_next StreamScan party_account_group_typ… idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors NoOp NoOp idle · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand 
Fragment 61187 (Actor 738521,738520)
StreamMaterialize { columns: [party_id, account_group_id, type, parties.id(hidden), null:Varchar(hidden), $src(hidden)], stream_key: [parties.id, null:Varchar, $src], pk_columns: [parties.id, null:Varchar, $src], pk_conflict: NoCheck }
├── output: [ parties.id, $expr1, 'none':Varchar, parties.id, null:Varchar, $src ]
├── stream key: [ parties.id, null:Varchar, $src ]
└── StreamUnion { all: true } { output: [ parties.id, $expr1, 'none':Varchar, parties.id, null:Varchar, $src ], stream key: [ parties.id, null:Varchar, $src ] }
    ├── MergeExecutor { output: [ parties.id, $expr1, 'none':Varchar, parties.id, null:Varchar, 0:Int32 ], stream key: [ parties.id ] }
    ├── MergeExecutor { output: [ parties.id, $expr2, 'all':Varchar, parties.id, party_account_group_types_mv_next.type, 1:Int32 ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }
    ├── MergeExecutor { output: [ parties.id, $expr3, 'restricted':Varchar, parties.id, party_account_group_types_mv_next.type, 2:Int32 ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }
    └── MergeExecutor { output: [ parties.id, $expr4, 'un_restricted':Varchar, parties.id, party_account_group_types_mv_next.type, 3:Int32 ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }

Fragment 61188 (Actor 738541,738540)
StreamProject { exprs: [parties.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(parties.id, 'none':Varchar)::Bytea)) as $expr1, 'none':Varchar, parties.id, null:Varchar, 0:Int32] }
├── output: [ parties.id, $expr1, 'none':Varchar, parties.id, null:Varchar, 0:Int32 ]
├── stream key: [ parties.id ]
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61189 (Actor 738544,738545)
StreamSyncLogStore { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61190 (Actor 738539,738538)
StreamSyncLogStore { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61191 (Actor 738524,738525)
StreamSyncLogStore { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61192 (Actor 738535,738534)
StreamSyncLogStore { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── StreamHashJoin { type: Inner, predicate: parties.id = customer_relationships.party_id } { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
    ├── MergeExecutor { output: [ parties.id ], stream key: [ parties.id ] }
    └── MergeExecutor { output: [ customer_relationships.party_id ], stream key: [ customer_relationships.party_id ] }

Fragment 61193 (Actor 738519,738518)
StreamProject { exprs: [parties.id] } { output: [ parties.id ], stream key: [ parties.id ] }
└── StreamFilter { predicate: IsNull(parties.disabled_at) } { output: [ parties.id, parties.disabled_at ], stream key: [ parties.id ] }
    └── StreamTableScan { table: parties, columns: [id, disabled_at] } { output: [ parties.id, parties.disabled_at ], stream key: [ parties.id ] }
        ├── Upstream { output: [ id, disabled_at ], stream key: [] }
        └── BatchPlanNode { output: [ id, disabled_at ], stream key: [] }

Fragment 61194 (Actor 738547,738546)
StreamProject { exprs: [customer_relationships.party_id] } { output: [ customer_relationships.party_id ], stream key: [ customer_relationships.party_id ] }
└── StreamHashAgg { group_key: [customer_relationships.party_id], aggs: [count] } { output: [ customer_relationships.party_id, count ], stream key: [ customer_relationships.party_id ] }
    └── StreamLocalityProvider { locality_columns: [customer_relationships.party_id] }
        ├── output: [ customer_relationships.party_id, customer_relationships.id ]
        ├── stream key: [ customer_relationships.party_id, customer_relationships.id ]
        └── MergeExecutor { output: [ customer_relationships.party_id, customer_relationships.id ], stream key: [ customer_relationships.id ] }

Fragment 61195 (Actor 738585,738584)
StreamProject { exprs: [customer_relationships.party_id, customer_relationships.id] } { output: [ customer_relationships.party_id, customer_relationships.id ], stream key: [ customer_relationships.id ] }
└── StreamFilter { predicate: (customer_relationships.type = 'CUSTOMER':Varchar) AND (customer_relationships.status = 'ACTIVE':Varchar) AND IsNull(customer_relationships.disabled_at) }
    ├── output: [ customer_relationships.party_id, customer_relationships.id, customer_relationships.type, customer_relationships.status, customer_relationships.disabled_at ]
    ├── stream key: [ customer_relationships.id ]
    └── StreamTableScan { table: customer_relationships, columns: [party_id, id, type, status, disabled_at] }
        ├── output: [ customer_relationships.party_id, customer_relationships.id, customer_relationships.type, customer_relationships.status, customer_relationships.disabled_at ]
        ├── stream key: [ customer_relationships.id ]
        ├── Upstream { output: [ party_id, id, type, status, disabled_at ], stream key: [] }
        └── BatchPlanNode { output: [ party_id, id, type, status, disabled_at ], stream key: [] }

Fragment 61196 (Actor 738548,738549)
StreamProject { exprs: [parties.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(parties.id, 'all':Varchar)::Bytea)) as $expr2, 'all':Varchar, parties.id, party_account_group_types_mv_next.type, 1:Int32] }
├── output: [ parties.id, $expr2, 'all':Varchar, parties.id, party_account_group_types_mv_next.type, 1:Int32 ]
├── stream key: [ parties.id, party_account_group_types_mv_next.type ]
└── MergeExecutor { output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }

Fragment 61197 (Actor 738550,738551)
StreamSyncLogStore { output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }
└── StreamHashJoin { type: Inner, predicate: parties.id = party_account_group_types_mv_next.party_id }
    ├── output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── stream key: [ parties.id, party_account_group_types_mv_next.type ]
    ├── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
    └── MergeExecutor { output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ] }

Fragment 61198 (Actor 738536,738537)
StreamLocalityProvider { locality_columns: [parties.id] } { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61199 (Actor 738532,738533)
StreamNoOp { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61200 (Actor 738552,738553)
StreamLocalityProvider { locality_columns: [party_account_group_types_mv_next.party_id] }
├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
└── MergeExecutor { output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ] }

Fragment 61201 (Actor 738587,738586)
StreamFilter { predicate: (party_account_group_types_mv_next.type = 'all':Varchar) }
├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
└── StreamTableScan { table: party_account_group_types_mv_next, columns: [party_id, type] }
    ├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── Upstream { output: [ party_id, type ], stream key: [] }
    └── BatchPlanNode { output: [ party_id, type ], stream key: [] }

Fragment 61202 (Actor 738556,738557)
StreamProject { exprs: [parties.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(parties.id, 'restricted':Varchar)::Bytea)) as $expr3, 'restricted':Varchar, parties.id, party_account_group_types_mv_next.type, 2:Int32] }
├── output: [ parties.id, $expr3, 'restricted':Varchar, parties.id, party_account_group_types_mv_next.type, 2:Int32 ]
├── stream key: [ parties.id, party_account_group_types_mv_next.type ]
└── MergeExecutor { output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }

Fragment 61203 (Actor 738554,738555)
StreamSyncLogStore { output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }
└── StreamHashJoin { type: Inner, predicate: parties.id = party_account_group_types_mv_next.party_id }
    ├── output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── stream key: [ parties.id, party_account_group_types_mv_next.type ]
    ├── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
    └── MergeExecutor { output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ] }

Fragment 61204 (Actor 738530,738531)
StreamLocalityProvider { locality_columns: [parties.id] } { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61205 (Actor 738527,738526)
StreamNoOp { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61206 (Actor 738558,738559)
StreamLocalityProvider { locality_columns: [party_account_group_types_mv_next.party_id] }
├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
└── MergeExecutor { output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ] }

Fragment 61207 (Actor 738589,738588)
StreamFilter { predicate: (party_account_group_types_mv_next.type = 'restricted':Varchar) }
├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
└── StreamTableScan { table: party_account_group_types_mv_next, columns: [party_id, type] }
    ├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── Upstream { output: [ party_id, type ], stream key: [] }
    └── BatchPlanNode { output: [ party_id, type ], stream key: [] }

Fragment 61208 (Actor 738560,738561)
StreamProject { exprs: [parties.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(parties.id, 'un_restricted':Varchar)::Bytea)) as $expr4, 'un_restricted':Varchar, parties.id, party_account_group_types_mv_next.type, 3:Int32] }
├── output: [ parties.id, $expr4, 'un_restricted':Varchar, parties.id, party_account_group_types_mv_next.type, 3:Int32 ]
├── stream key: [ parties.id, party_account_group_types_mv_next.type ]
└── MergeExecutor { output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }

Fragment 61209 (Actor 738563,738562)
StreamSyncLogStore { output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ parties.id, party_account_group_types_mv_next.type ] }
└── StreamHashJoin { type: Inner, predicate: parties.id = party_account_group_types_mv_next.party_id }
    ├── output: [ parties.id, party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── stream key: [ parties.id, party_account_group_types_mv_next.type ]
    ├── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
    └── MergeExecutor { output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ] }

Fragment 61210 (Actor 738543,738542)
StreamLocalityProvider { locality_columns: [parties.id] } { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61211 (Actor 738529,738528)
StreamNoOp { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }
└── MergeExecutor { output: [ parties.id, customer_relationships.party_id ], stream key: [ parties.id ] }

Fragment 61212 (Actor 738564,738565)
StreamLocalityProvider { locality_columns: [party_account_group_types_mv_next.party_id] }
├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
└── MergeExecutor { output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ], stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ] }

Fragment 61213 (Actor 738567,738566)
StreamFilter { predicate: (party_account_group_types_mv_next.type = 'un_restricted':Varchar) }
├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
└── StreamTableScan { table: party_account_group_types_mv_next, columns: [party_id, type] }
    ├── output: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── stream key: [ party_account_group_types_mv_next.party_id, party_account_group_types_mv_next.type ]
    ├── Upstream { output: [ party_id, type ], stream key: [] }
    └── BatchPlanNode { output: [ party_id, type ], stream key: [] }