RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

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

Job is idle — throughput ~0; structure shown.

Aggregation state — unbounded unless keyed or temporally filtered
9 operators
Materialize · alpheya_experience_bff.party_task_counts_mv
0% idle 2 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
StreamScan · party_task_unique_mv_next
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Heat = the operator's output-buffer backpressure over the sampling window. Click a node to fold its subtree.
Materialize · alpheya_experience_bff.party_task_counts_mv Materialize alpheya_experience_bff.… idle · 2 actors Project Project — · 2 actors HashAgg HashAgg idle · 2 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamScan · party_task_unique_mv_next StreamScan party_task_unique_mv_ne… idle · 2 actors BatchPlan BatchPlan — · 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 18096 (Actor 158817,158818)
StreamMaterialize { columns: [party_id, active_count, high_priority_count], stream_key: [party_id], pk_columns: [party_id], pk_conflict: NoCheck } { output: [ party_task_unique_mv_next.party_id, $expr1, $expr2 ], stream key: [ party_task_unique_mv_next.party_id ] }
└── StreamProject { exprs: [party_task_unique_mv_next.party_id, count filter(In(party_task_unique_mv_next.status, 'TO_DO':Varchar, 'IN_PROGRESS':Varchar))::Int32 as $expr1, count filter(In(party_task_unique_mv_next.status, 'TO_DO':Varchar, 'IN_PROGRESS':Varchar) AND (party_task_unique_mv_next.priority = 'HIGH':Varchar))::Int32 as $expr2] }
    ├── output: [ party_task_unique_mv_next.party_id, $expr1, $expr2 ]
    ├── stream key: [ party_task_unique_mv_next.party_id ]
    └── StreamHashAgg { group_key: [party_task_unique_mv_next.party_id], aggs: [count filter(In(party_task_unique_mv_next.status, 'TO_DO':Varchar, 'IN_PROGRESS':Varchar)), count filter(In(party_task_unique_mv_next.status, 'TO_DO':Varchar, 'IN_PROGRESS':Varchar) AND (party_task_unique_mv_next.priority = 'HIGH':Varchar)), count] }
        ├── output: [ party_task_unique_mv_next.party_id, count filter(In(party_task_unique_mv_next.status, 'TO_DO':Varchar, 'IN_PROGRESS':Varchar)), count filter(In(party_task_unique_mv_next.status, 'TO_DO':Varchar, 'IN_PROGRESS':Varchar) AND (party_task_unique_mv_next.priority = 'HIGH':Varchar)), count ]
        ├── stream key: [ party_task_unique_mv_next.party_id ]
        └── StreamLocalityProvider { locality_columns: [party_task_unique_mv_next.party_id] } { output: [ party_task_unique_mv_next.party_id, party_task_unique_mv_next.status, party_task_unique_mv_next.priority, party_task_unique_mv_next.task_id ], stream key: [ party_task_unique_mv_next.party_id, party_task_unique_mv_next.task_id ] }
            └── MergeExecutor { output: [ party_task_unique_mv_next.party_id, party_task_unique_mv_next.status, party_task_unique_mv_next.priority, party_task_unique_mv_next.task_id ], stream key: [ party_task_unique_mv_next.party_id, party_task_unique_mv_next.task_id ] }

Fragment 18097 (Actor 158820,158819)
StreamTableScan { table: party_task_unique_mv_next, columns: [party_id, status, priority, task_id] }
├── output: [ party_task_unique_mv_next.party_id, party_task_unique_mv_next.status, party_task_unique_mv_next.priority, party_task_unique_mv_next.task_id ]
├── stream key: [ party_task_unique_mv_next.party_id, party_task_unique_mv_next.task_id ]
├── Upstream { output: [ party_id, status, priority, task_id ], stream key: [] }
└── BatchPlanNode { output: [ party_id, status, priority, task_id ], stream key: [] }