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

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

Job is idle — throughput ~0; structure shown.

6 operators
Materialize · adib_rm.pnl_snapshot_mv
0% idle 2 actors
Project · pnl_summary_mv_next
— — 2 actors
GroupTopN · pnl_summary_mv_next
0% idle 2 actors
StreamScan · pnl_summary_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 · adib_rm.pnl_snapshot_mv Materialize adib_rm.pnl_snapshot_mv idle · 2 actors Project · pnl_summary_mv_next Project pnl_summary_mv_next — · 2 actors GroupTopN · pnl_summary_mv_next GroupTopN pnl_summary_mv_next idle · 2 actors StreamScan · pnl_summary_mv_next StreamScan pnl_summary_mv_next 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 26022 (Actor 131944,131945)
StreamMaterialize { columns: [account_group_id, dim_balance_date, position_type, currency_code, unrealized_gain_loss, total_average_cost, unrealized_gain_loss_system_currency, total_average_cost_system_currency], stream_key: [account_group_id, position_type, currency_code], pk_columns: [account_group_id, position_type, currency_code], pk_conflict: NoCheck }
├── output: [ pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.dim_balance_date, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code, pnl_summary_mv_next.unrealized_gain_loss, pnl_summary_mv_next.total_average_cost, pnl_summary_mv_next.unrealized_gain_loss_system_currency, pnl_summary_mv_next.total_average_cost_system_currency ]
├── stream key: [ pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code ]
└── StreamProject { exprs: [pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.dim_balance_date, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code, pnl_summary_mv_next.unrealized_gain_loss, pnl_summary_mv_next.total_average_cost, pnl_summary_mv_next.unrealized_gain_loss_system_currency, pnl_summary_mv_next.total_average_cost_system_currency] }
    ├── output: [ pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.dim_balance_date, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code, pnl_summary_mv_next.unrealized_gain_loss, pnl_summary_mv_next.total_average_cost, pnl_summary_mv_next.unrealized_gain_loss_system_currency, pnl_summary_mv_next.total_average_cost_system_currency ]
    ├── stream key: [ pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code ]
    └── StreamGroupTopN { order: [pnl_summary_mv_next.dim_balance_date DESC], limit: 1, offset: 0, group_key: [pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code] }
        ├── output:
        │   ┌── pnl_summary_mv_next.account_group_id
        │   ├── pnl_summary_mv_next.dim_balance_date
        │   ├── pnl_summary_mv_next.position_type
        │   ├── pnl_summary_mv_next.currency_code
        │   ├── pnl_summary_mv_next.total_average_cost
        │   ├── pnl_summary_mv_next.total_average_cost_system_currency
        │   ├── pnl_summary_mv_next.unrealized_gain_loss
        │   ├── pnl_summary_mv_next.unrealized_gain_loss_system_currency
        │   ├── pnl_summary_mv_next.position_summary_mv_next.source_entity_type
        │   └── pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date
        ├── stream key: [ pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.position_type, pnl_summary_mv_next.currency_code ]
        └── StreamTableScan { table: pnl_summary_mv_next, columns: [account_group_id, dim_balance_date, position_type, currency_code, total_average_cost, total_average_cost_system_currency, unrealized_gain_loss, unrealized_gain_loss_system_currency, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date] }
            ├── output:
            │   ┌── pnl_summary_mv_next.account_group_id
            │   ├── pnl_summary_mv_next.dim_balance_date
            │   ├── pnl_summary_mv_next.position_type
            │   ├── pnl_summary_mv_next.currency_code
            │   ├── pnl_summary_mv_next.total_average_cost
            │   ├── pnl_summary_mv_next.total_average_cost_system_currency
            │   ├── pnl_summary_mv_next.unrealized_gain_loss
            │   ├── pnl_summary_mv_next.unrealized_gain_loss_system_currency
            │   ├── pnl_summary_mv_next.position_summary_mv_next.source_entity_type
            │   └── pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date
            ├── stream key: [ pnl_summary_mv_next.account_group_id, pnl_summary_mv_next.position_summary_mv_next.source_entity_type, pnl_summary_mv_next.dim_balance_date, pnl_summary_mv_next.currency_code, pnl_summary_mv_next.position_type, pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date ]
            ├── Upstream { output: [ account_group_id, dim_balance_date, position_type, currency_code, total_average_cost, total_average_cost_system_currency, unrealized_gain_loss, unrealized_gain_loss_system_currency, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date ], stream key: [] }
            └── BatchPlanNode { output: [ account_group_id, dim_balance_date, position_type, currency_code, total_average_cost, total_average_cost_system_currency, unrealized_gain_loss, unrealized_gain_loss_system_currency, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date ], stream key: [] }