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

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

Job is idle — throughput ~0; structure shown.

6 operators
Materialize · insights.asset_latest_price_mv
0% idle 2 actors
Project · asset_price_with_lag_mv
— — 2 actors
GroupTopN · asset_price_with_lag_mv
0% idle 2 actors
StreamScan · asset_price_with_lag_mv
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.asset_latest_price_mv Materialize insights.asset_latest_p… idle · 2 actors Project · asset_price_with_lag_mv Project asset_price_with_lag_mv — · 2 actors GroupTopN · asset_price_with_lag_mv GroupTopN asset_price_with_lag_mv idle · 2 actors StreamScan · asset_price_with_lag_mv StreamScan asset_price_with_lag_mv 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 62512 (Actor 742936,742935)
StreamMaterialize { columns: [asset_id, price, price_date, price_change_pct_1d], stream_key: [asset_id], pk_columns: [asset_id], pk_conflict: NoCheck } { output: [ asset_price_with_lag_mv.asset_id, asset_price_with_lag_mv.adjusted_last_close_price, asset_price_with_lag_mv.fact_date, $expr1 ], stream key: [ asset_price_with_lag_mv.asset_id ] }
└── StreamProject { exprs: [asset_price_with_lag_mv.asset_id, asset_price_with_lag_mv.adjusted_last_close_price, asset_price_with_lag_mv.fact_date, Case((IsNull(asset_price_with_lag_mv.prev_price) OR (asset_price_with_lag_mv.prev_price = 0:Decimal)), null:Decimal, ((asset_price_with_lag_mv.adjusted_last_close_price - asset_price_with_lag_mv.prev_price) / asset_price_with_lag_mv.prev_price)) as $expr1] }
    ├── output: [ asset_price_with_lag_mv.asset_id, asset_price_with_lag_mv.adjusted_last_close_price, asset_price_with_lag_mv.fact_date, $expr1 ]
    ├── stream key: [ asset_price_with_lag_mv.asset_id ]
    └── StreamGroupTopN { order: [asset_price_with_lag_mv.fact_date DESC], limit: 1, offset: 0, group_key: [asset_price_with_lag_mv.asset_id] } { output: [ asset_price_with_lag_mv.asset_id, asset_price_with_lag_mv.fact_date, asset_price_with_lag_mv.adjusted_last_close_price, asset_price_with_lag_mv.prev_price ], stream key: [ asset_price_with_lag_mv.asset_id ] }
        └── StreamTableScan { table: asset_price_with_lag_mv, columns: [asset_id, fact_date, adjusted_last_close_price, prev_price] } { output: [ asset_price_with_lag_mv.asset_id, asset_price_with_lag_mv.fact_date, asset_price_with_lag_mv.adjusted_last_close_price, asset_price_with_lag_mv.prev_price ], stream key: [ asset_price_with_lag_mv.asset_id, asset_price_with_lag_mv.fact_date ] }
            ├── Upstream { output: [ asset_id, fact_date, adjusted_last_close_price, prev_price ], stream key: [] }
            └── BatchPlanNode { output: [ asset_id, fact_date, adjusted_last_close_price, prev_price ], stream key: [] }