position_by_currency_sink · explain

sink · insights.position_by_currency_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
7 operators
Sink · insights.position_by_currency_sink
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · position_by_currency_mv_next
— — 2 actors
StreamScan · position_by_currency_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 64883 (Actor 748190,748191)
StreamSink { type: upsert, columns: [account_group_id, type, dim_balance_date, holding_currency_code, currency_code, market_value, total_average_cost, fair_value, fair_value_system_currency, accrued_value, accrued_value_system_currency, market_value_system_currency, total_average_cost_system_currency, weight, fair_value_weight, position_by_currency_mv_next.source_entity_type(hidden), position_by_currency_mv_next.position_values_mv_next.position_type_expanded(hidden), position_by_currency_mv_next.flag(hidden), position_by_currency_mv_next.position_summary_mv_next.source_entity_type(hidden)], downstream_pk: [position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.item_id, position_by_currency_mv_next.position_type] }
├── output:
│   ┌── position_by_currency_mv_next.account_group_id
│   ├── position_by_currency_mv_next.position_type
│   ├── position_by_currency_mv_next.dim_balance_date
│   ├── position_by_currency_mv_next.item_id
│   ├── position_by_currency_mv_next.currency_code
│   ├── position_by_currency_mv_next.market_value
│   ├── position_by_currency_mv_next.total_average_cost
│   ├── position_by_currency_mv_next.fair_value
│   ├── position_by_currency_mv_next.fair_value_system_currency
│   ├── position_by_currency_mv_next.accrued_value
│   ├── position_by_currency_mv_next.accrued_value_system_currency
│   ├── position_by_currency_mv_next.market_value_system_currency
│   ├── position_by_currency_mv_next.total_average_cost_system_currency
│   ├── position_by_currency_mv_next.weight
│   ├── position_by_currency_mv_next.fair_value_weight
│   ├── position_by_currency_mv_next.source_entity_type
│   ├── position_by_currency_mv_next.position_values_mv_next.position_type_expanded
│   ├── position_by_currency_mv_next.flag
│   └── position_by_currency_mv_next.position_summary_mv_next.source_entity_type
├── stream key: [ position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.position_type, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.item_id, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type ]
└── MergeExecutor
    ├── output:
    │   ┌── position_by_currency_mv_next.account_group_id
    │   ├── position_by_currency_mv_next.position_type
    │   ├── position_by_currency_mv_next.dim_balance_date
    │   ├── position_by_currency_mv_next.item_id
    │   ├── position_by_currency_mv_next.currency_code
    │   ├── position_by_currency_mv_next.market_value
    │   ├── position_by_currency_mv_next.total_average_cost
    │   ├── position_by_currency_mv_next.fair_value
    │   ├── position_by_currency_mv_next.fair_value_system_currency
    │   ├── position_by_currency_mv_next.accrued_value
    │   ├── position_by_currency_mv_next.accrued_value_system_currency
    │   ├── position_by_currency_mv_next.market_value_system_currency
    │   ├── position_by_currency_mv_next.total_average_cost_system_currency
    │   ├── position_by_currency_mv_next.weight
    │   ├── position_by_currency_mv_next.fair_value_weight
    │   ├── position_by_currency_mv_next.source_entity_type
    │   ├── position_by_currency_mv_next.position_values_mv_next.position_type_expanded
    │   ├── position_by_currency_mv_next.flag
    │   └── position_by_currency_mv_next.position_summary_mv_next.source_entity_type
    └── stream key: [ position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.position_type, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.item_id, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type ]

Fragment 64884 (Actor 747231,747230)
StreamProject { exprs: [position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.position_type, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.item_id, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.market_value, position_by_currency_mv_next.total_average_cost, position_by_currency_mv_next.fair_value, position_by_currency_mv_next.fair_value_system_currency, position_by_currency_mv_next.accrued_value, position_by_currency_mv_next.accrued_value_system_currency, position_by_currency_mv_next.market_value_system_currency, position_by_currency_mv_next.total_average_cost_system_currency, position_by_currency_mv_next.weight, position_by_currency_mv_next.fair_value_weight, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type] }
├── output: [ position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.position_type, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.item_id, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.market_value, position_by_currency_mv_next.total_average_cost, position_by_currency_mv_next.fair_value, position_by_currency_mv_next.fair_value_system_currency, position_by_currency_mv_next.accrued_value, position_by_currency_mv_next.accrued_value_system_currency, position_by_currency_mv_next.market_value_system_currency, position_by_currency_mv_next.total_average_cost_system_currency, position_by_currency_mv_next.weight, position_by_currency_mv_next.fair_value_weight, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type ]
├── stream key: [ position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.position_type, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.item_id, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type ]
└── StreamTableScan { table: position_by_currency_mv_next, columns: [account_group_id, dim_balance_date, position_type, item_id, currency_code, market_value, total_average_cost, fair_value, accrued_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency, weight, fair_value_weight, source_entity_type, position_values_mv_next.position_type_expanded, flag, position_summary_mv_next.source_entity_type] }
    ├── output: [ position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.position_type, position_by_currency_mv_next.item_id, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.market_value, position_by_currency_mv_next.total_average_cost, position_by_currency_mv_next.fair_value, position_by_currency_mv_next.accrued_value, position_by_currency_mv_next.market_value_system_currency, position_by_currency_mv_next.total_average_cost_system_currency, position_by_currency_mv_next.fair_value_system_currency, position_by_currency_mv_next.accrued_value_system_currency, position_by_currency_mv_next.weight, position_by_currency_mv_next.fair_value_weight, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type ]
    ├── stream key: [ position_by_currency_mv_next.account_group_id, position_by_currency_mv_next.dim_balance_date, position_by_currency_mv_next.position_type, position_by_currency_mv_next.currency_code, position_by_currency_mv_next.source_entity_type, position_by_currency_mv_next.position_values_mv_next.position_type_expanded, position_by_currency_mv_next.item_id, position_by_currency_mv_next.flag, position_by_currency_mv_next.position_summary_mv_next.source_entity_type ]
    ├── Upstream { output: [ account_group_id, dim_balance_date, position_type, item_id, currency_code, market_value, total_average_cost, fair_value, accrued_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency, weight, fair_value_weight, source_entity_type, position_values_mv_next.position_type_expanded, flag, position_summary_mv_next.source_entity_type ], stream key: [] }
    └── BatchPlanNode { output: [ account_group_id, dim_balance_date, position_type, item_id, currency_code, market_value, total_average_cost, fair_value, accrued_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency, weight, fair_value_weight, source_entity_type, position_values_mv_next.position_type_expanded, flag, position_summary_mv_next.source_entity_type ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
