report_twrr_daily_mv · explain

materialized view · alinma_bff.report_twrr_daily_mv profiled over 5s
Job is idle — throughput ~0; structure shown.
Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
Heat tree Operator graph
37 operators
Materialize · alinma_bff.report_twrr_daily_mv
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · twrr_mv_next.account_group_id = position_summary_mv_next.ac…
— — 2 actors
HashJoin · Inner · twrr_mv_next.account_group_id = position_summary_mv_next.ac… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
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
Filter · position_summary_mv_next
0% idle 2 actors
StreamScan · position_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
SyncLogStore · Inner · portfolio_to_account_groups_mv.account_group_id = twrr_mv_n…
— — 2 actors
HashJoin · Inner · portfolio_to_account_groups_mv.account_group_id = twrr_mv_n… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
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 · twrr_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
StreamScan · portfolio_to_account_groups_mv
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 64497 (Actor 747423,747424)
StreamMaterialize { columns: [portfolio_id, account_group_type, dim_balance_date, currency_code, market_value, fair_value, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, twrr_mv_next.account_group_id(hidden), portfolio_to_account_groups_mv.account_group_id(hidden), portfolio_to_account_groups_mv.$src(hidden), twrr_mv_next.position_type(hidden), twrr_mv_next.position_summary_mv_next.source_entity_type(hidden), position_summary_mv_next.account_group_id(hidden), position_summary_mv_next.dim_balance_date(hidden), position_summary_mv_next.currency_code(hidden), position_summary_mv_next.source_entity_type(hidden), position_summary_mv_next.position_type(hidden)], stream_key: [twrr_mv_next.account_group_id, dim_balance_date, currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type], pk_columns: [twrr_mv_next.account_group_id, dim_balance_date, currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type], pk_conflict: NoCheck }
├── output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.account_group_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ]
├── stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ]
└── MergeExecutor { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.account_group_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ] }

Fragment 64498 (Actor 747422,747421)
StreamSyncLogStore { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.account_group_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ] }
└── StreamHashJoin { type: Inner, predicate: twrr_mv_next.account_group_id = position_summary_mv_next.account_group_id AND twrr_mv_next.dim_balance_date = position_summary_mv_next.dim_balance_date AND twrr_mv_next.currency_code = position_summary_mv_next.currency_code }
    ├── output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.account_group_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ]
    ├── stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ]
    ├── MergeExecutor { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ] }
    └── MergeExecutor { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ] }

Fragment 64499 (Actor 744821,744820)
StreamLocalityProvider { locality_columns: [twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code] } { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ] }
└── MergeExecutor { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }

Fragment 64500 (Actor 744822,744823)
StreamSyncLogStore { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }
└── StreamHashJoin { type: Inner, predicate: portfolio_to_account_groups_mv.account_group_id = twrr_mv_next.account_group_id } { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.type, twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }
    ├── MergeExecutor { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.type, portfolio_to_account_groups_mv.$src ], stream key: [ portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src ] }
    └── MergeExecutor { output: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }

Fragment 64501 (Actor 744825,744824)
StreamLocalityProvider { locality_columns: [portfolio_to_account_groups_mv.account_group_id] } { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.type, portfolio_to_account_groups_mv.$src ], stream key: [ portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src ] }
└── MergeExecutor { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.type, portfolio_to_account_groups_mv.$src ], stream key: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src ] }

Fragment 64502 (Actor 747716,747717)
StreamTableScan { table: portfolio_to_account_groups_mv, columns: [portfolio_id, account_group_id, type, $src] } { output: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.type, portfolio_to_account_groups_mv.$src ], stream key: [ portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src ] }
├── Upstream { output: [ portfolio_id, account_group_id, type, $src ], stream key: [] }
└── BatchPlanNode { output: [ portfolio_id, account_group_id, type, $src ], stream key: [] }

Fragment 64503 (Actor 747527,747526)
StreamLocalityProvider { locality_columns: [twrr_mv_next.account_group_id] } { output: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }
└── MergeExecutor { output: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }

Fragment 64504 (Actor 747719,747718)
StreamTableScan { table: twrr_mv_next, columns: [account_group_id, dim_balance_date, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, position_type, position_summary_mv_next.source_entity_type] } { output: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.currency_code, twrr_mv_next.daily_subperiod_return, twrr_mv_next.daily_subperiod_fair_value_return, twrr_mv_next.daily_subperiod_return_system_currency, twrr_mv_next.daily_subperiod_fair_value_return_system_currency, twrr_mv_next.position_type, twrr_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ twrr_mv_next.account_group_id, twrr_mv_next.dim_balance_date, twrr_mv_next.position_type, twrr_mv_next.currency_code, twrr_mv_next.position_summary_mv_next.source_entity_type ] }
├── Upstream { output: [ account_group_id, dim_balance_date, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, position_type, position_summary_mv_next.source_entity_type ], stream key: [] }
└── BatchPlanNode { output: [ account_group_id, dim_balance_date, currency_code, daily_subperiod_return, daily_subperiod_fair_value_return, daily_subperiod_return_system_currency, daily_subperiod_fair_value_return_system_currency, position_type, position_summary_mv_next.source_entity_type ], stream key: [] }

Fragment 64505 (Actor 744966,744967)
StreamLocalityProvider { locality_columns: [position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, 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.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ], stream key: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_type ] }
└── MergeExecutor { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_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 64506 (Actor 747744,747745)
StreamFilter { predicate: (position_summary_mv_next.position_type = 'POSITION':Varchar) AND (position_summary_mv_next.source_entity_type = 'portfolio':Varchar) } { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_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, currency_code, market_value, fair_value, source_entity_type, position_type] } { output: [ position_summary_mv_next.account_group_id, position_summary_mv_next.dim_balance_date, position_summary_mv_next.currency_code, position_summary_mv_next.market_value, position_summary_mv_next.fair_value, position_summary_mv_next.source_entity_type, position_summary_mv_next.position_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, currency_code, market_value, fair_value, source_entity_type, position_type ], stream key: [] }
    └── BatchPlanNode { output: [ account_group_id, dim_balance_date, currency_code, market_value, fair_value, source_entity_type, position_type ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
