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

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

Job is idle — throughput ~0; structure shown.

22 operators
Materialize · insights.pnl_summary_mv
0% idle 2 actors
Project · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv…
— — 2 actors
Project · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv…
— — 2 actors
Project · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv…
— — 2 actors
AsOfJoin · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv…
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · flow_summary_mv_next
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · position_summary_mv_next
0% idle 2 actors
StreamScan · position_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 · insights.pnl_summary_mv Materialize insights.pnl_summary_mv idle · 2 actors Project · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv… Project AsofLeftOuter · positio… — · 2 actors Project · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv… Project AsofLeftOuter · positio… — · 2 actors Project · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv… Project AsofLeftOuter · positio… — · 2 actors AsOfJoin · AsofLeftOuter · position_summary_mv_next.account_group_id = flow_summary_mv… AsOfJoin AsofLeftOuter · positio… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamScan · flow_summary_mv_next StreamScan flow_summary_mv_next idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · position_summary_mv_next Filter position_summary_mv_next idle · 2 actors StreamScan · position_summary_mv_next StreamScan position_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 61820 (Actor 740193,740192)
StreamMaterialize { columns: [account_group_id, dim_balance_date, position_type, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency, total_gain_loss, unrealized_gain_loss, realized_gain_loss, total_gain_loss_system_currency, unrealized_gain_loss_system_currency, realized_gain_loss_system_currency, fair_value_total_gain_loss, fair_value_unrealized_gain_loss, fair_value_realized_gain_loss, fair_value_total_gain_loss_system_currency, fair_value_unrealized_gain_loss_system_currency, fair_value_realized_gain_loss_system_currency, position_summary_mv_next.source_entity_type(hidden), flow_summary_mv_next.dim_transaction_date(hidden)], stream_key: [account_group_id, position_type, currency_code, position_summary_mv_next.source_entity_type, dim_balance_date, flow_summary_mv_next.dim_transaction_date], pk_columns: [account_group_id, position_type, currency_code, position_summary_mv_next.source_entity_type, dim_balance_date, flow_summary_mv_next.dim_transaction_date], pk_conflict: NoCheck }
├── output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, $expr1, $expr2, $expr3, $expr4, $expr11, $expr5, $expr6, $expr12, $expr7, $expr8, $expr13, $expr9, $expr10, $expr14, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date ]
├── stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, flow_summary_mv_next.dim_transaction_date ]
└── StreamProject { exprs: [position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, $expr1, $expr2, $expr3, $expr4, ($expr3 - $expr4) as $expr11, $expr5, $expr6, ($expr5 - $expr6) as $expr12, $expr7, $expr8, ($expr7 - $expr8) as $expr13, $expr9, $expr10, ($expr9 - $expr10) as $expr14, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date] }
    ├── output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, $expr1, $expr2, $expr3, $expr4, $expr11, $expr5, $expr6, $expr12, $expr7, $expr8, $expr13, $expr9, $expr10, $expr14, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date ]
    ├── stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, flow_summary_mv_next.dim_transaction_date ]
    └── StreamProject { exprs: [position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency, $expr1, $expr2, (position_summary_mv_next.market_value - $expr1) as $expr3, (position_summary_mv_next.market_value - position_summary_mv_next.total_average_cost) as $expr4, (position_summary_mv_next.market_value_system_currency - $expr2) as $expr5, (position_summary_mv_next.market_value_system_currency - position_summary_mv_next.total_average_cost_system_currency) as $expr6, (position_summary_mv_next.fair_value - $expr1) as $expr7, (position_summary_mv_next.fair_value - position_summary_mv_next.total_average_cost) as $expr8, (position_summary_mv_next.fair_value_system_currency - $expr2) as $expr9, (position_summary_mv_next.fair_value_system_currency - position_summary_mv_next.total_average_cost_system_currency) as $expr10, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date] }
        ├── output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency, $expr1, $expr2, $expr3, $expr4, $expr5, $expr6, $expr7, $expr8, $expr9, $expr10, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date ]
        ├── stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, flow_summary_mv_next.dim_transaction_date ]
        └── StreamProject { exprs: [position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency, Coalesce(flow_summary_mv_next.cumulative_adjusted_netflow, 0:Decimal) as $expr1, Coalesce(flow_summary_mv_next.cumulative_adjusted_netflow_system_currency, 0:Decimal) as $expr2, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date] }
            ├── output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency, $expr1, $expr2, position_summary_mv_next.source_entity_type, flow_summary_mv_next.dim_transaction_date ]
            ├── stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, flow_summary_mv_next.dim_transaction_date ]
            └── StreamAsOfJoin { type: AsofLeftOuter, predicate: position_summary_mv_next.account_group_id = flow_summary_mv_next.account_group_id AND position_summary_mv_next.position_type = flow_summary_mv_next.position_type AND position_summary_mv_next.currency_code = flow_summary_mv_next.currency_code AND (flow_summary_mv_next.dim_transaction_date <= position_summary_mv_next.dim_balance_date) }
                ├── output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency, position_summary_mv_next.source_entity_type, flow_summary_mv_next.account_group_id, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.dim_transaction_date ]
                ├── stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, flow_summary_mv_next.dim_transaction_date ]
                ├── MergeExecutor { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, position_summary_mv_next.source_entity_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date ] }
                └── MergeExecutor { output: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.dim_transaction_date, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency ], stream key: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.dim_transaction_date ] }

Fragment 61821 (Actor 740196,740197)
StreamLocalityProvider { locality_columns: [position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code] } { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, position_summary_mv_next.source_entity_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date ] }
└── MergeExecutor { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, position_summary_mv_next.source_entity_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.position_type ] }

Fragment 61822 (Actor 739923,739924)
StreamFilter { predicate: (position_summary_mv_next.source_entity_type <> 'user':Varchar) } { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, position_summary_mv_next.source_entity_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.position_type ] }
└── StreamTableScan { table: position_summary_mv_next, columns: [account_group_id, dim_balance_date, position_type, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, source_entity_type] } { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.position_type, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.total_average_cost, position_summary_mv_next.fair_value, position_summary_mv_next.market_value_system_currency, position_summary_mv_next.total_average_cost_system_currency, position_summary_mv_next.fair_value_system_currency, position_summary_mv_next.source_entity_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.source_entity_type, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.position_type ] }
    ├── Upstream { output: [ account_group_id, dim_balance_date, position_type, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, source_entity_type ], stream key: [] }
    └── BatchPlanNode { output: [ account_group_id, dim_balance_date, position_type, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, source_entity_type ], stream key: [] }

Fragment 61823 (Actor 740223,740222)
StreamLocalityProvider { locality_columns: [flow_summary_mv_next.account_group_id, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code] } { output: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.dim_transaction_date, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency ], stream key: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.dim_transaction_date ] }
└── MergeExecutor { output: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.dim_transaction_date, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency ], stream key: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.currency_code, flow_summary_mv_next.position_type, flow_summary_mv_next.dim_transaction_date ] }

Fragment 61824 (Actor 740220,740221)
StreamTableScan { table: flow_summary_mv_next, columns: [account_group_id, dim_transaction_date, position_type, currency_code, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency] } { output: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.dim_transaction_date, flow_summary_mv_next.position_type, flow_summary_mv_next.currency_code, flow_summary_mv_next.cumulative_adjusted_netflow, flow_summary_mv_next.cumulative_adjusted_netflow_system_currency ], stream key: [ flow_summary_mv_next.account_group_id, flow_summary_mv_next.currency_code, flow_summary_mv_next.position_type, flow_summary_mv_next.dim_transaction_date ] }
├── Upstream { output: [ account_group_id, dim_transaction_date, position_type, currency_code, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency ], stream key: [] }
└── BatchPlanNode { output: [ account_group_id, dim_transaction_date, position_type, currency_code, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency ], stream key: [] }