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

← cluster alinma_bff objects report_allocation_twrr_daily_sink explain
Overview Objects Graph History
sink · alinma_bff.report_allocation_twrr_daily_sink profiled over 5s
seconds (1–30)

Job is idle — throughput ~0; structure shown.

6 operators
Sink · alinma_bff.report_allocation_twrr_daily_sink
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · report_allocation_twrr_daily_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.
Sink · alinma_bff.report_allocation_twrr_daily_sink Sink alinma_bff.report_alloc… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamScan · report_allocation_twrr_daily_mv_next StreamScan report_allocation_twrr_… 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 62385 (Actor 741573,741572)
StreamSink { type: upsert, columns: [portfolio_id, account_group_type, dim_balance_date, distribution_type, item_id, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id(hidden), report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code(hidden), report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code(hidden)], downstream_pk: [report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.account_group_type, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.currency_code] }
├── output: [ report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.account_group_type, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.currency_code, report_allocation_twrr_daily_mv_next.daily_subperiod_return, report_allocation_twrr_daily_mv_next.daily_subperiod_fair_value_return, report_allocation_twrr_daily_mv_next.daily_subperiod_return_system_currency, report_allocation_twrr_daily_mv_next.daily_subperiod_fair_value_return_system_currency, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ]
├── stream key: [ report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ]
└── MergeExecutor
    ├── output: [ report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.account_group_type, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.currency_code, report_allocation_twrr_daily_mv_next.daily_subperiod_return, report_allocation_twrr_daily_mv_next.daily_subperiod_fair_value_return, report_allocation_twrr_daily_mv_next.daily_subperiod_return_system_currency, report_allocation_twrr_daily_mv_next.daily_subperiod_fair_value_return_system_currency, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ]
    └── stream key: [ report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ]

Fragment 62386 (Actor 741002,741003)
StreamTableScan { table: report_allocation_twrr_daily_mv_next, columns: [portfolio_id, account_group_type, dim_balance_date, distribution_type, item_id, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, twrr_by_distribution_mv_next.taxonomy_code, twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code] }
├── output: [ report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.account_group_type, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.currency_code, report_allocation_twrr_daily_mv_next.daily_subperiod_return, report_allocation_twrr_daily_mv_next.daily_subperiod_fair_value_return, report_allocation_twrr_daily_mv_next.daily_subperiod_return_system_currency, report_allocation_twrr_daily_mv_next.daily_subperiod_fair_value_return_system_currency, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ]
├── stream key: [ report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_allocation_twrr_daily_mv_next.portfolio_id, report_allocation_twrr_daily_mv_next.portfolio_to_account_groups_mv.$src, report_allocation_twrr_daily_mv_next.dim_balance_date, report_allocation_twrr_daily_mv_next.distribution_type, report_allocation_twrr_daily_mv_next.item_id, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.taxonomy_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, report_allocation_twrr_daily_mv_next.twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ]
├── Upstream { output: [ portfolio_id, account_group_type, dim_balance_date, distribution_type, item_id, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, twrr_by_distribution_mv_next.taxonomy_code, twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ], stream key: [] }
└── BatchPlanNode { output: [ portfolio_id, account_group_type, dim_balance_date, distribution_type, item_id, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_type, twrr_by_distribution_mv_next.position_by_distribution_mv_next.source_entity_type, twrr_by_distribution_mv_next.taxonomy_code, twrr_by_distribution_mv_next.position_by_distribution_mv_next.position_summary_mv_next.source_entity_type, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.position_type, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.currency_code, twrr_by_distribution_mv_next.flow_by_distribution_mv_next.taxonomy_code ], stream key: [] }