holding_values_raw_mv · explain

materialized view · insights.holding_values_raw_mv profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
14 operators
Materialize · insights.holding_values_raw_mv
0% idle 2 actors
Union
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · cash_values_journal_density_mv_next
— — 2 actors
StreamScan · cash_values_journal_density_mv_next
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · holding_values_journal_density_mv_next
— — 2 actors
StreamScan · holding_values_journal_density_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 23584 (Actor 104043,104044)
StreamMaterialize { columns: [account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, average_cost_per_unit_system_currency, total_cost_system_currency, deposit_profit_accrued, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date(hidden), holding_values_journal_density_mv_next.$expr2(hidden), holding_values_journal_density_mv_next.dim_value_date(hidden), holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from(hidden), holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum(hidden), holding_values_journal_density_mv_next.account_id(hidden), holding_values_journal_density_mv_next.asset_id(hidden), holding_values_journal_density_mv_next.currency_code(hidden), $src(hidden)], stream_key: [holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, $src], pk_columns: [holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, $src], pk_conflict: NoCheck }
├── output: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.type, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.market_value, holding_values_journal_density_mv_next.average_cost_per_unit, holding_values_journal_density_mv_next.purchased_quantity, holding_values_journal_density_mv_next.average_cost_per_unit_system_currency, holding_values_journal_density_mv_next.total_cost_system_currency, null:Decimal, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, $src ]
├── stream key: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, $src ]
└── StreamUnion { all: true } { output: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.type, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.market_value, holding_values_journal_density_mv_next.average_cost_per_unit, holding_values_journal_density_mv_next.purchased_quantity, holding_values_journal_density_mv_next.average_cost_per_unit_system_currency, holding_values_journal_density_mv_next.total_cost_system_currency, null:Decimal, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, $src ], stream key: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, $src ] }
    ├── MergeExecutor { output: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.type, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.market_value, holding_values_journal_density_mv_next.average_cost_per_unit, holding_values_journal_density_mv_next.purchased_quantity, holding_values_journal_density_mv_next.average_cost_per_unit_system_currency, holding_values_journal_density_mv_next.total_cost_system_currency, null:Decimal, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, 0:Int32 ], stream key: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum ] }
    └── MergeExecutor { output: [ cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.dim_value_date, cash_values_journal_density_mv_next.type, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.market_value, cash_values_journal_density_mv_next.average_cost_per_unit, cash_values_journal_density_mv_next.purchased_quantity, null:Decimal, null:Decimal, null:Decimal, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2, cash_values_journal_density_mv_next.dim_value_date, null:Date, null:Int64, cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.currency_code, 1:Int32 ], stream key: [ cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2, cash_values_journal_density_mv_next.dim_value_date ] }

Fragment 23585 (Actor 104047,104048)
StreamProject { exprs: [holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.type, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.market_value, holding_values_journal_density_mv_next.average_cost_per_unit, holding_values_journal_density_mv_next.purchased_quantity, holding_values_journal_density_mv_next.average_cost_per_unit_system_currency, holding_values_journal_density_mv_next.total_cost_system_currency, null:Decimal, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, 0:Int32] }
├── output: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.type, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.market_value, holding_values_journal_density_mv_next.average_cost_per_unit, holding_values_journal_density_mv_next.purchased_quantity, holding_values_journal_density_mv_next.average_cost_per_unit_system_currency, holding_values_journal_density_mv_next.total_cost_system_currency, null:Decimal, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum, holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, 0:Int32 ]
├── stream key: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum ]
└── StreamTableScan { table: holding_values_journal_density_mv_next, columns: [account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, average_cost_per_unit_system_currency, total_cost_system_currency, purchased_quantity, settled_position_series_mv_next.dim_settlement_date, $expr2, settled_cost_basis_series_mv.effective_from, settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum] } { output: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.type, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.market_value, holding_values_journal_density_mv_next.average_cost_per_unit, holding_values_journal_density_mv_next.average_cost_per_unit_system_currency, holding_values_journal_density_mv_next.total_cost_system_currency, holding_values_journal_density_mv_next.purchased_quantity, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum ], stream key: [ holding_values_journal_density_mv_next.account_id, holding_values_journal_density_mv_next.asset_id, holding_values_journal_density_mv_next.currency_code, holding_values_journal_density_mv_next.settled_position_series_mv_next.dim_settlement_date, holding_values_journal_density_mv_next.$expr2, holding_values_journal_density_mv_next.dim_value_date, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.effective_from, holding_values_journal_density_mv_next.settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum ] }
    ├── Upstream { output: [ account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, average_cost_per_unit_system_currency, total_cost_system_currency, purchased_quantity, settled_position_series_mv_next.dim_settlement_date, $expr2, settled_cost_basis_series_mv.effective_from, settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum ], stream key: [] }
    └── BatchPlanNode { output: [ account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, average_cost_per_unit_system_currency, total_cost_system_currency, purchased_quantity, settled_position_series_mv_next.dim_settlement_date, $expr2, settled_cost_basis_series_mv.effective_from, settled_cost_basis_series_mv.settled_cost_basis_carried_mv_next.sum ], stream key: [] }

Fragment 23586 (Actor 104046,104045)
StreamProject { exprs: [cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.dim_value_date, cash_values_journal_density_mv_next.type, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.market_value, cash_values_journal_density_mv_next.average_cost_per_unit, cash_values_journal_density_mv_next.purchased_quantity, null:Decimal, null:Decimal, null:Decimal, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2, cash_values_journal_density_mv_next.dim_value_date, null:Date, null:Int64, cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.currency_code, 1:Int32] } { output: [ cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.dim_value_date, cash_values_journal_density_mv_next.type, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.market_value, cash_values_journal_density_mv_next.average_cost_per_unit, cash_values_journal_density_mv_next.purchased_quantity, null:Decimal, null:Decimal, null:Decimal, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2, cash_values_journal_density_mv_next.dim_value_date, null:Date, null:Int64, cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.currency_code, 1:Int32 ], stream key: [ cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2, cash_values_journal_density_mv_next.dim_value_date ] }
└── StreamTableScan { table: cash_values_journal_density_mv_next, columns: [account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, settled_cash_series_mv_next.dim_settlement_date, $expr2] } { output: [ cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.dim_value_date, cash_values_journal_density_mv_next.type, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.market_value, cash_values_journal_density_mv_next.average_cost_per_unit, cash_values_journal_density_mv_next.purchased_quantity, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2 ], stream key: [ cash_values_journal_density_mv_next.account_id, cash_values_journal_density_mv_next.asset_id, cash_values_journal_density_mv_next.currency_code, cash_values_journal_density_mv_next.settled_cash_series_mv_next.dim_settlement_date, cash_values_journal_density_mv_next.$expr2, cash_values_journal_density_mv_next.dim_value_date ] }
    ├── Upstream { output: [ account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, settled_cash_series_mv_next.dim_settlement_date, $expr2 ], stream key: [] }
    └── BatchPlanNode { output: [ account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, settled_cash_series_mv_next.dim_settlement_date, $expr2 ], stream key: [] }
RWM Console cluster: risingwave-adib.adib-rw.svc.cluster.local
