pnl_by_asset_mv · explain

← cluster insights objects pnl_by_asset_mv explain
Overview Objects Graph History
materialized view · insights.pnl_by_asset_mv profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
22 operators
Materialize · insights.pnl_by_asset_mv
0% idle 2 actors
Project · AsofLeftOuter · position_by_asset_mv_next.account_group_id = flow_by_asset_…
— — 2 actors
Project · AsofLeftOuter · position_by_asset_mv_next.account_group_id = flow_by_asset_…
— — 2 actors
Project · AsofLeftOuter · position_by_asset_mv_next.account_group_id = flow_by_asset_…
— — 2 actors
AsOfJoin · AsofLeftOuter · position_by_asset_mv_next.account_group_id = flow_by_asset_…
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 · flow_by_asset_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
Filter · position_by_asset_mv_next
0% idle 2 actors
StreamScan · position_by_asset_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 64402 (Actor 747415,747416)
StreamMaterialize
├─columns: [account_group_id, dim_balance_date, position_type, asset_id, asset_currency, 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, cumulative_adjusted_netflow_asset_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, total_gain_loss_asset_currency, unrealized_gain_loss_asset_currency, realized_gain_loss_asset_currency, fair_value_total_gain_loss, fair_value_unrealized_gain_loss, fair_value_realized_gain_loss, fair_value_total_gain_loss_system_currency, fair_value_unrealized_gain_loss_system_currency, fair_value_realized_gain_loss_system_currency, fair_value_total_gain_loss_asset_currency, fair_value_unrealized_gain_loss_asset_currency, fair_value_realized_gain_loss_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded(hidden), position_by_asset_mv_next.source_entity_type(hidden), position_by_asset_mv_next.position_values_mv_next.position_type_expanded(hidden), position_by_asset_mv_next.flag(hidden), position_by_asset_mv_next.position_summary_mv_next.source_entity_type(hidden), flow_by_asset_mv_next.dim_transaction_date(hidden), flow_by_asset_mv_next.asset_currency(hidden), flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded(hidden), flow_by_asset_mv_next.flag(hidden)]
├─stream_key: [account_group_id, asset_id, position_type, currency_code, dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag]
├─pk_columns: [account_group_id, asset_id, position_type, currency_code, dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag]
└─pk_conflict: NoCheck
├── output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, $expr1, $expr2, $expr3, $expr4, $expr5, $expr16, $expr6, $expr7, $expr17, $expr8, $expr9, $expr18, $expr10, $expr11, $expr19, $expr12, $expr13, $expr20, $expr14, $expr15, $expr21, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
├── stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
└── StreamProject { exprs: [position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, $expr1, $expr2, $expr3, $expr4, $expr5, ($expr4 - $expr5) as $expr16, $expr6, $expr7, ($expr6 - $expr7) as $expr17, $expr8, $expr9, ($expr8 - $expr9) as $expr18, $expr10, $expr11, ($expr10 - $expr11) as $expr19, $expr12, $expr13, ($expr12 - $expr13) as $expr20, $expr14, $expr15, ($expr14 - $expr15) as $expr21, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag] }
    ├── output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, $expr1, $expr2, $expr3, $expr4, $expr5, $expr16, $expr6, $expr7, $expr17, $expr8, $expr9, $expr18, $expr10, $expr11, $expr19, $expr12, $expr13, $expr20, $expr14, $expr15, $expr21, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
    ├── stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
    └── StreamProject
└─exprs:
  ┌─position_by_asset_mv_next.account_group_id
  ├─position_by_asset_mv_next.dim_balance_date
  ├─position_by_asset_mv_next.position_type
  ├─position_by_asset_mv_next.asset_id
  ├─position_by_asset_mv_next.asset_currency
  ├─position_by_asset_mv_next.currency_code
  ├─position_by_asset_mv_next.market_value
  ├─position_by_asset_mv_next.total_average_cost
  ├─position_by_asset_mv_next.fair_value
  ├─position_by_asset_mv_next.market_value_system_currency
  ├─position_by_asset_mv_next.total_average_cost_system_currency
  ├─position_by_asset_mv_next.fair_value_system_currency
  ├─position_by_asset_mv_next.market_value_asset_currency
  ├─position_by_asset_mv_next.total_average_cost_asset_currency
  ├─position_by_asset_mv_next.fair_value_asset_currency
  ├─flow_by_asset_mv_next.cumulative_adjusted_netflow
  ├─flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency
  ├─flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency
  ├─$expr1
  ├─$expr2
  ├─$expr3
  ├─(position_by_asset_mv_next.market_value - $expr1) as $expr4
  ├─(position_by_asset_mv_next.market_value - position_by_asset_mv_next.total_average_cost) as $expr5
  ├─(position_by_asset_mv_next.market_value_system_currency - $expr2) as $expr6
  ├─(position_by_asset_mv_next.market_value_system_currency - position_by_asset_mv_next.total_average_cost_system_currency) as $expr7
  ├─(position_by_asset_mv_next.market_value_asset_currency - $expr3) as $expr8
  ├─(position_by_asset_mv_next.market_value_asset_currency - position_by_asset_mv_next.total_average_cost_asset_currency) as $expr9
  ├─(position_by_asset_mv_next.fair_value - $expr1) as $expr10
  ├─(position_by_asset_mv_next.fair_value - position_by_asset_mv_next.total_average_cost) as $expr11
  ├─(position_by_asset_mv_next.fair_value_system_currency - $expr2) as $expr12
  ├─(position_by_asset_mv_next.fair_value_system_currency - position_by_asset_mv_next.total_average_cost_system_currency) as $expr13
  ├─(position_by_asset_mv_next.fair_value_asset_currency - $expr3) as $expr14
  ├─(position_by_asset_mv_next.fair_value_asset_currency - position_by_asset_mv_next.total_average_cost_asset_currency) as $expr15
  ├─position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded
  ├─position_by_asset_mv_next.source_entity_type
  ├─position_by_asset_mv_next.position_values_mv_next.position_type_expanded
  ├─position_by_asset_mv_next.flag
  ├─position_by_asset_mv_next.position_summary_mv_next.source_entity_type
  ├─flow_by_asset_mv_next.dim_transaction_date
  ├─flow_by_asset_mv_next.asset_currency
  ├─flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded
  └─flow_by_asset_mv_next.flag
        ├── output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, $expr1, $expr2, $expr3, $expr4, $expr5, $expr6, $expr7, $expr8, $expr9, $expr10, $expr11, $expr12, $expr13, $expr14, $expr15, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
        ├── stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
        └── StreamProject { exprs: [position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, Coalesce(flow_by_asset_mv_next.cumulative_adjusted_netflow, 0:Decimal) as $expr1, Coalesce(flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, 0:Decimal) as $expr2, Coalesce(flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, 0:Decimal) as $expr3, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag] }
            ├── output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, $expr1, $expr2, $expr3, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
            ├── stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
            └── StreamAsOfJoin { type: AsofLeftOuter, predicate: position_by_asset_mv_next.account_group_id = flow_by_asset_mv_next.account_group_id AND position_by_asset_mv_next.asset_id = flow_by_asset_mv_next.asset_id AND position_by_asset_mv_next.position_type = flow_by_asset_mv_next.position_type AND position_by_asset_mv_next.currency_code = flow_by_asset_mv_next.currency_code AND (flow_by_asset_mv_next.dim_transaction_date <= position_by_asset_mv_next.dim_balance_date) }
                ├── output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
                ├── stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ]
                ├── MergeExecutor { output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ] }
                └── MergeExecutor { output: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ], stream key: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ] }

Fragment 64403 (Actor 747418,747417)
StreamLocalityProvider { locality_columns: [position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code] } { output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ] }
└── MergeExecutor { output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ] }

Fragment 64404 (Actor 747419,747420)
StreamFilter { predicate: (position_by_asset_mv_next.source_entity_type <> 'user':Varchar) } { output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ] }
└── StreamTableScan { table: position_by_asset_mv_next, columns: [account_group_id, dim_balance_date, position_type, asset_id, asset_currency, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, position_values_mv_next.holding_currency_expanded, source_entity_type, position_values_mv_next.position_type_expanded, flag, position_summary_mv_next.source_entity_type] } { output: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.market_value, position_by_asset_mv_next.total_average_cost, position_by_asset_mv_next.fair_value, position_by_asset_mv_next.market_value_system_currency, position_by_asset_mv_next.total_average_cost_system_currency, position_by_asset_mv_next.fair_value_system_currency, position_by_asset_mv_next.market_value_asset_currency, position_by_asset_mv_next.total_average_cost_asset_currency, position_by_asset_mv_next.fair_value_asset_currency, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ], stream key: [ position_by_asset_mv_next.account_group_id, position_by_asset_mv_next.dim_balance_date, position_by_asset_mv_next.position_type, position_by_asset_mv_next.currency_code, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, position_by_asset_mv_next.asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.asset_id, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type ] }
    ├── Upstream { output: [ account_group_id, dim_balance_date, position_type, asset_id, asset_currency, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, position_values_mv_next.holding_currency_expanded, 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, asset_id, asset_currency, currency_code, market_value, total_average_cost, fair_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, position_values_mv_next.holding_currency_expanded, source_entity_type, position_values_mv_next.position_type_expanded, flag, position_summary_mv_next.source_entity_type ], stream key: [] }

Fragment 64405 (Actor 743775,743776)
StreamLocalityProvider { locality_columns: [flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code] } { output: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ], stream key: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ] }
└── MergeExecutor { output: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ], stream key: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.flag ] }

Fragment 64406 (Actor 747619,747620)
StreamTableScan { table: flow_by_asset_mv_next, columns: [account_group_id, dim_transaction_date, asset_id, position_type, currency_code, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency, cumulative_adjusted_netflow_asset_currency, asset_currency, flow_values_mv_next.position_type_expanded, flag] } { output: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.cumulative_adjusted_netflow, flow_by_asset_mv_next.cumulative_adjusted_netflow_system_currency, flow_by_asset_mv_next.cumulative_adjusted_netflow_asset_currency, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.flag ], stream key: [ flow_by_asset_mv_next.account_group_id, flow_by_asset_mv_next.asset_id, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.dim_transaction_date, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.flag ] }
├── Upstream { output: [ account_group_id, dim_transaction_date, asset_id, position_type, currency_code, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency, cumulative_adjusted_netflow_asset_currency, asset_currency, flow_values_mv_next.position_type_expanded, flag ], stream key: [] }
└── BatchPlanNode { output: [ account_group_id, dim_transaction_date, asset_id, position_type, currency_code, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency, cumulative_adjusted_netflow_asset_currency, asset_currency, flow_values_mv_next.position_type_expanded, flag ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
