RWM Console cluster: risingwave-adib.adib-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
42 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
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
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
Project · Inner · parties.id = customer_relationships.party_id
— — 2 actors
HashAgg · Inner · parties.id = customer_relationships.party_id Aggregation state — unbounded unless keyed or temporally filtered
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 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 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 Project · Inner · parties.id = customer_relationships.party_id Project Inner · parties.id = cu… — · 2 actors HashAgg · Inner · parties.id = customer_relationships.party_id HashAgg Inner · parties.id = cu… 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 23607 (Actor 104437,104438)
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 23608 (Actor 104450,104449)
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 23609 (Actor 104445,104446)
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 23610 (Actor 104447,104448)
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 ] }
    └── 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 ] }
            └── MergeExecutor { output: [ customer_relationships.party_id, customer_relationships.id ], stream key: [ customer_relationships.id ] }

Fragment 23611 (Actor 104440,104439)
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 23612 (Actor 104441,104442)
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 23613 (Actor 104452,104451)
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 23614 (Actor 104443,104444)
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 23615 (Actor 104454,104453)
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: [] }