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

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

Job is idle — throughput ~0; structure shown.

6 operators
Materialize · insights.portfolio_to_account_groups_mv
0% idle 2 actors
Project · portfolios_dm
— — 2 actors
Filter · portfolios_dm
0% idle 2 actors
StreamScan · portfolios_dm
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 · insights.portfolio_to_account_groups_mv Materialize insights.portfolio_to_a… idle · 2 actors Project · portfolios_dm Project portfolios_dm — · 2 actors Filter · portfolios_dm Filter portfolios_dm idle · 2 actors StreamScan · portfolios_dm StreamScan portfolios_dm 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 12439 (Actor 156618,156619)
StreamMaterialize { columns: [portfolio_id, account_group_id, type], stream_key: [portfolio_id], pk_columns: [portfolio_id], pk_conflict: NoCheck }
├── output: [ portfolios_dm.portfolio_id, $expr1, 'all':Varchar ]
├── stream key: [ portfolios_dm.portfolio_id ]
└── StreamProject { exprs: [portfolios_dm.portfolio_id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(portfolios_dm.portfolio_id, 'all':Varchar)::Bytea)) as $expr1, 'all':Varchar] }
    ├── output: [ portfolios_dm.portfolio_id, $expr1, 'all':Varchar ]
    ├── stream key: [ portfolios_dm.portfolio_id ]
    └── StreamFilter { predicate: IsNull(portfolios_dm.disabled_at) AND Not(IsTrue(portfolios_dm.m_is_stub)) }
        ├── output: [ portfolios_dm.portfolio_id, portfolios_dm.disabled_at, portfolios_dm.m_is_stub ]
        ├── stream key: [ portfolios_dm.portfolio_id ]
        └── StreamTableScan { table: portfolios_dm, columns: [portfolio_id, disabled_at, m_is_stub] }
            ├── output: [ portfolios_dm.portfolio_id, portfolios_dm.disabled_at, portfolios_dm.m_is_stub ]
            ├── stream key: [ portfolios_dm.portfolio_id ]
            ├── Upstream { output: [ portfolio_id, disabled_at, m_is_stub ], stream key: [] }
            └── BatchPlanNode { output: [ portfolio_id, disabled_at, m_is_stub ], stream key: [] }