report_pnl_daily_sink · explain

← cluster alinma_bff objects report_pnl_daily_sink explain
Overview Objects Graph History
sink · alinma_bff.report_pnl_daily_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
6 operators
Sink · alinma_bff.report_pnl_daily_sink
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · report_pnl_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.
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand
Fragment 62382 (Actor 741577,741576)
StreamSink { type: upsert, columns: [portfolio_id, account_group_type, dim_balance_date, 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, report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id(hidden), report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src(hidden), report_pnl_daily_mv_next.pnl_summary_mv_next.position_type(hidden), report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type(hidden), report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date(hidden)], downstream_pk: [report_pnl_daily_mv_next.portfolio_id, report_pnl_daily_mv_next.account_group_type, report_pnl_daily_mv_next.dim_balance_date, report_pnl_daily_mv_next.currency_code] }
├── output:
│   ┌── report_pnl_daily_mv_next.portfolio_id
│   ├── report_pnl_daily_mv_next.account_group_type
│   ├── report_pnl_daily_mv_next.dim_balance_date
│   ├── report_pnl_daily_mv_next.currency_code
│   ├── report_pnl_daily_mv_next.market_value
│   ├── report_pnl_daily_mv_next.total_average_cost
│   ├── report_pnl_daily_mv_next.fair_value
│   ├── report_pnl_daily_mv_next.market_value_system_currency
│   ├── report_pnl_daily_mv_next.total_average_cost_system_currency
│   ├── report_pnl_daily_mv_next.fair_value_system_currency
│   ├── report_pnl_daily_mv_next.cumulative_adjusted_netflow
│   ├── report_pnl_daily_mv_next.cumulative_adjusted_netflow_system_currency
│   ├── report_pnl_daily_mv_next.total_gain_loss
│   ├── report_pnl_daily_mv_next.unrealized_gain_loss
│   ├── report_pnl_daily_mv_next.realized_gain_loss
│   ├── report_pnl_daily_mv_next.total_gain_loss_system_currency
│   ├── report_pnl_daily_mv_next.unrealized_gain_loss_system_currency
│   ├── report_pnl_daily_mv_next.realized_gain_loss_system_currency
│   ├── report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id
│   ├── report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src
│   ├── report_pnl_daily_mv_next.pnl_summary_mv_next.position_type
│   ├── report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type
│   └── report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date
├── stream key: [ report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_pnl_daily_mv_next.portfolio_id, report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src, report_pnl_daily_mv_next.pnl_summary_mv_next.position_type, report_pnl_daily_mv_next.currency_code, report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type, report_pnl_daily_mv_next.dim_balance_date, report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date ]
└── MergeExecutor
    ├── output:
    │   ┌── report_pnl_daily_mv_next.portfolio_id
    │   ├── report_pnl_daily_mv_next.account_group_type
    │   ├── report_pnl_daily_mv_next.dim_balance_date
    │   ├── report_pnl_daily_mv_next.currency_code
    │   ├── report_pnl_daily_mv_next.market_value
    │   ├── report_pnl_daily_mv_next.total_average_cost
    │   ├── report_pnl_daily_mv_next.fair_value
    │   ├── report_pnl_daily_mv_next.market_value_system_currency
    │   ├── report_pnl_daily_mv_next.total_average_cost_system_currency
    │   ├── report_pnl_daily_mv_next.fair_value_system_currency
    │   ├── report_pnl_daily_mv_next.cumulative_adjusted_netflow
    │   ├── report_pnl_daily_mv_next.cumulative_adjusted_netflow_system_currency
    │   ├── report_pnl_daily_mv_next.total_gain_loss
    │   ├── report_pnl_daily_mv_next.unrealized_gain_loss
    │   ├── report_pnl_daily_mv_next.realized_gain_loss
    │   ├── report_pnl_daily_mv_next.total_gain_loss_system_currency
    │   ├── report_pnl_daily_mv_next.unrealized_gain_loss_system_currency
    │   ├── report_pnl_daily_mv_next.realized_gain_loss_system_currency
    │   ├── report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id
    │   ├── report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src
    │   ├── report_pnl_daily_mv_next.pnl_summary_mv_next.position_type
    │   ├── report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type
    │   └── report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date
    └── stream key: [ report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_pnl_daily_mv_next.portfolio_id, report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src, report_pnl_daily_mv_next.pnl_summary_mv_next.position_type, report_pnl_daily_mv_next.currency_code, report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type, report_pnl_daily_mv_next.dim_balance_date, report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date ]

Fragment 62383 (Actor 740948,740947)
StreamTableScan { table: report_pnl_daily_mv_next, columns: [portfolio_id, account_group_type, dim_balance_date, 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, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, pnl_summary_mv_next.position_type, pnl_summary_mv_next.position_summary_mv_next.source_entity_type, pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date] }
├── output:
│   ┌── report_pnl_daily_mv_next.portfolio_id
│   ├── report_pnl_daily_mv_next.account_group_type
│   ├── report_pnl_daily_mv_next.dim_balance_date
│   ├── report_pnl_daily_mv_next.currency_code
│   ├── report_pnl_daily_mv_next.market_value
│   ├── report_pnl_daily_mv_next.total_average_cost
│   ├── report_pnl_daily_mv_next.fair_value
│   ├── report_pnl_daily_mv_next.market_value_system_currency
│   ├── report_pnl_daily_mv_next.total_average_cost_system_currency
│   ├── report_pnl_daily_mv_next.fair_value_system_currency
│   ├── report_pnl_daily_mv_next.cumulative_adjusted_netflow
│   ├── report_pnl_daily_mv_next.cumulative_adjusted_netflow_system_currency
│   ├── report_pnl_daily_mv_next.total_gain_loss
│   ├── report_pnl_daily_mv_next.unrealized_gain_loss
│   ├── report_pnl_daily_mv_next.realized_gain_loss
│   ├── report_pnl_daily_mv_next.total_gain_loss_system_currency
│   ├── report_pnl_daily_mv_next.unrealized_gain_loss_system_currency
│   ├── report_pnl_daily_mv_next.realized_gain_loss_system_currency
│   ├── report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id
│   ├── report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src
│   ├── report_pnl_daily_mv_next.pnl_summary_mv_next.position_type
│   ├── report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type
│   └── report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date
├── stream key: [ report_pnl_daily_mv_next.portfolio_to_account_groups_mv.account_group_id, report_pnl_daily_mv_next.portfolio_id, report_pnl_daily_mv_next.portfolio_to_account_groups_mv.$src, report_pnl_daily_mv_next.pnl_summary_mv_next.position_type, report_pnl_daily_mv_next.currency_code, report_pnl_daily_mv_next.pnl_summary_mv_next.position_summary_mv_next.source_entity_type, report_pnl_daily_mv_next.dim_balance_date, report_pnl_daily_mv_next.pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date ]
├── Upstream { output: [ portfolio_id, account_group_type, dim_balance_date, 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, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, pnl_summary_mv_next.position_type, pnl_summary_mv_next.position_summary_mv_next.source_entity_type, pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date ], stream key: [] }
└── BatchPlanNode { output: [ portfolio_id, account_group_type, dim_balance_date, 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, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, pnl_summary_mv_next.position_type, pnl_summary_mv_next.position_summary_mv_next.source_entity_type, pnl_summary_mv_next.flow_summary_mv_next.dim_transaction_date ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
