RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.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
54 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 · 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
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 · 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
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand 
Fragment 18083 (Actor 158298,158299)
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 ] }

Fragment 18084 (Actor 158304,158305)
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 18085 (Actor 158306,158307)
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 18086 (Actor 158303,158302)
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 18087 (Actor 158749,158750)
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 18088 (Actor 158799,158800)
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 18089 (Actor 158812,158811)
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 18090 (Actor 158801,158802)
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 18091 (Actor 158803,158804)
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 18092 (Actor 158300,158301)
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 18093 (Actor 158309,158308)
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 18094 (Actor 158805,158806)
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 18095 (Actor 158814,158813)
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: [] }