party_aum_mv · explain

← cluster alinma_bff objects party_aum_mv explain
materialized view · alinma_bff.party_aum_mv profiled over 5s
Job is idle — throughput ~0; structure shown.
Stateful hash join (4 state tables) — consider a temporal join for dimension lookupsAggregation state — unbounded unless keyed or temporally filtered
Heat tree Operator graph
45 operators
Materialize · alinma_bff.party_aum_mv
0% idle 2 actors
Project
— — 2 actors
HashAgg Aggregation state — unbounded unless keyed or temporally filtered
0% idle 2 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Project
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftOuter · investment_holdings_latest_mv_next.currency_code = fx_rates…
— — 2 actors
HashJoin · LeftOuter · investment_holdings_latest_mv_next.currency_code = fx_rates… 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
StreamScan · fx_rates_snapshot_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
Project
— — 2 actors
HashAgg Aggregation state — unbounded unless keyed or temporally filtered
0% idle 2 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · party_current_account_membership_mv.account_id = investment…
— — 2 actors
HashJoin · Inner · party_current_account_membership_mv.account_id = investment… 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 · investment_holdings_latest_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 · party_current_account_membership_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 59151 (Actor 740375,740376)
StreamMaterialize { columns: [party_id, account_group_type, aum_market_value, fair_aum_market_value, aum_market_value_system_currency, fair_aum_market_value_system_currency], stream_key: [party_id, account_group_type], pk_columns: [party_id, account_group_type], pk_conflict: NoCheck }
├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, sum($expr2), sum($expr3), sum(sum(investment_holdings_latest_mv_next.market_value_system_currency)), sum(sum(investment_holdings_latest_mv_next.fair_value_system_currency)) ]
├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
└── StreamProject { exprs: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, sum($expr2), sum($expr3), sum(sum(investment_holdings_latest_mv_next.market_value_system_currency)), sum(sum(investment_holdings_latest_mv_next.fair_value_system_currency))] }
    ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, sum($expr2), sum($expr3), sum(sum(investment_holdings_latest_mv_next.market_value_system_currency)), sum(sum(investment_holdings_latest_mv_next.fair_value_system_currency)) ]
    ├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
    └── StreamHashAgg { group_key: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type], aggs: [sum($expr2), sum($expr3), sum(sum(investment_holdings_latest_mv_next.market_value_system_currency)), sum(sum(investment_holdings_latest_mv_next.fair_value_system_currency)), count] }
        ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, sum($expr2), sum($expr3), sum(sum(investment_holdings_latest_mv_next.market_value_system_currency)), sum(sum(investment_holdings_latest_mv_next.fair_value_system_currency)), count ]
        ├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
        └── StreamLocalityProvider { locality_columns: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type] }
            ├── output:
            │   ┌── party_current_account_membership_mv.party_id
            │   ├── party_current_account_membership_mv.account_group_type
            │   ├── $expr2
            │   ├── $expr3
            │   ├── sum(investment_holdings_latest_mv_next.market_value_system_currency)
            │   ├── sum(investment_holdings_latest_mv_next.fair_value_system_currency)
            │   ├── investment_holdings_latest_mv_next.currency_code
            │   └── party_current_account_membership_mv.party_currency
            ├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency ]
            └── MergeExecutor
                ├── output:
                │   ┌── party_current_account_membership_mv.party_id
                │   ├── party_current_account_membership_mv.account_group_type
                │   ├── $expr2
                │   ├── $expr3
                │   ├── sum(investment_holdings_latest_mv_next.market_value_system_currency)
                │   ├── sum(investment_holdings_latest_mv_next.fair_value_system_currency)
                │   ├── investment_holdings_latest_mv_next.currency_code
                │   └── party_current_account_membership_mv.party_currency
                └── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]

Fragment 59152 (Actor 740380,740379)
StreamProject { exprs: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, (sum(investment_holdings_latest_mv_next.market_value) * $expr1) as $expr2, (sum(investment_holdings_latest_mv_next.fair_value) * $expr1) as $expr3, sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency] }
├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, $expr2, $expr3, sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency ]
├── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
└── StreamProject { exprs: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), fx_rates_snapshot_mv_next.rate, Coalesce(fx_rates_snapshot_mv_next.rate, Case((investment_holdings_latest_mv_next.currency_code = party_current_account_membership_mv.party_currency), 1:Int32)::Decimal) as $expr1] }
    ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), fx_rates_snapshot_mv_next.rate, $expr1 ]
    ├── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
    └── MergeExecutor
        ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), fx_rates_snapshot_mv_next.rate, fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code ]
        └── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]

Fragment 59153 (Actor 740377,740378)
StreamSyncLogStore
├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), fx_rates_snapshot_mv_next.rate, fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code ]
├── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
└── StreamHashJoin { type: LeftOuter, predicate: investment_holdings_latest_mv_next.currency_code = fx_rates_snapshot_mv_next.source_currency_code AND party_current_account_membership_mv.party_currency = fx_rates_snapshot_mv_next.target_currency_code }
    ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), fx_rates_snapshot_mv_next.rate, fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code ]
    ├── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
    ├── MergeExecutor
    │   ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency) ]
    │   └── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
    └── MergeExecutor { output: [ fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code, fx_rates_snapshot_mv_next.rate ], stream key: [ fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code ] }

Fragment 59154 (Actor 740382,740381)
StreamLocalityProvider { locality_columns: [investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency] }
├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency) ]
├── stream key: [ investment_holdings_latest_mv_next.currency_code, party_current_account_membership_mv.party_currency, party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type ]
└── MergeExecutor
    ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency) ]
    └── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code ]

Fragment 59155 (Actor 740384,740383)
StreamProject { exprs: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency)] }
├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency) ]
├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code ]
└── StreamHashAgg { group_key: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code], aggs: [sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), count] }
    ├── output: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code, sum(investment_holdings_latest_mv_next.market_value), sum(investment_holdings_latest_mv_next.fair_value), sum(investment_holdings_latest_mv_next.market_value_system_currency), sum(investment_holdings_latest_mv_next.fair_value_system_currency), count ]
    ├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code ]
    └── StreamLocalityProvider { locality_columns: [party_current_account_membership_mv.party_id, party_current_account_membership_mv.account_group_type, party_current_account_membership_mv.party_currency, investment_holdings_latest_mv_next.currency_code] }
        ├── output:
        │   ┌── party_current_account_membership_mv.party_id
        │   ├── party_current_account_membership_mv.account_group_type
        │   ├── party_current_account_membership_mv.party_currency
        │   ├── investment_holdings_latest_mv_next.currency_code
        │   ├── investment_holdings_latest_mv_next.market_value
        │   ├── investment_holdings_latest_mv_next.fair_value
        │   ├── investment_holdings_latest_mv_next.market_value_system_currency
        │   ├── investment_holdings_latest_mv_next.fair_value_system_currency
        │   ├── party_current_account_membership_mv.account_id
        │   ├── party_current_account_membership_mv.customer_relationship_id
        │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
        │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
        │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
        │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
        │   ├── party_current_account_membership_mv.$src
        │   ├── party_current_account_membership_mv.lifecycle_profiles.id
        │   ├── investment_holdings_latest_mv_next.account_id
        │   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
        │   ├── investment_holdings_latest_mv_next.asset_id
        │   └── investment_holdings_latest_mv_next.type
        ├── stream key:
        │   ┌── party_current_account_membership_mv.party_id
        │   ├── party_current_account_membership_mv.account_group_type
        │   ├── party_current_account_membership_mv.party_currency
        │   ├── investment_holdings_latest_mv_next.currency_code
        │   ├── party_current_account_membership_mv.account_id
        │   ├── party_current_account_membership_mv.customer_relationship_id
        │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
        │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
        │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
        │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
        │   ├── party_current_account_membership_mv.$src
        │   ├── party_current_account_membership_mv.lifecycle_profiles.id
        │   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
        │   ├── investment_holdings_latest_mv_next.asset_id
        │   └── investment_holdings_latest_mv_next.type
        └── MergeExecutor
            ├── output:
            │   ┌── party_current_account_membership_mv.party_id
            │   ├── party_current_account_membership_mv.account_group_type
            │   ├── party_current_account_membership_mv.party_currency
            │   ├── investment_holdings_latest_mv_next.currency_code
            │   ├── investment_holdings_latest_mv_next.market_value
            │   ├── investment_holdings_latest_mv_next.fair_value
            │   ├── investment_holdings_latest_mv_next.market_value_system_currency
            │   ├── investment_holdings_latest_mv_next.fair_value_system_currency
            │   ├── party_current_account_membership_mv.account_id
            │   ├── party_current_account_membership_mv.customer_relationship_id
            │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
            │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
            │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
            │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
            │   ├── party_current_account_membership_mv.$src
            │   ├── party_current_account_membership_mv.lifecycle_profiles.id
            │   ├── investment_holdings_latest_mv_next.account_id
            │   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
            │   ├── investment_holdings_latest_mv_next.asset_id
            │   └── investment_holdings_latest_mv_next.type
            └── stream key:
                ┌── party_current_account_membership_mv.account_id
                ├── party_current_account_membership_mv.party_id
                ├── party_current_account_membership_mv.customer_relationship_id
                ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
                ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
                ├── party_current_account_membership_mv.party_involvements_dm.entity_id
                ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
                ├── party_current_account_membership_mv.$src
                ├── party_current_account_membership_mv.lifecycle_profiles.id
                ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
                ├── investment_holdings_latest_mv_next.asset_id
                └── investment_holdings_latest_mv_next.type

Fragment 59156 (Actor 740386,740385)
StreamSyncLogStore
├── output:
│   ┌── party_current_account_membership_mv.party_id
│   ├── party_current_account_membership_mv.account_group_type
│   ├── party_current_account_membership_mv.party_currency
│   ├── investment_holdings_latest_mv_next.currency_code
│   ├── investment_holdings_latest_mv_next.market_value
│   ├── investment_holdings_latest_mv_next.fair_value
│   ├── investment_holdings_latest_mv_next.market_value_system_currency
│   ├── investment_holdings_latest_mv_next.fair_value_system_currency
│   ├── party_current_account_membership_mv.account_id
│   ├── party_current_account_membership_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
│   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
│   ├── party_current_account_membership_mv.$src
│   ├── party_current_account_membership_mv.lifecycle_profiles.id
│   ├── investment_holdings_latest_mv_next.account_id
│   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
│   ├── investment_holdings_latest_mv_next.asset_id
│   └── investment_holdings_latest_mv_next.type
├── stream key:
│   ┌── party_current_account_membership_mv.account_id
│   ├── party_current_account_membership_mv.party_id
│   ├── party_current_account_membership_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
│   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
│   ├── party_current_account_membership_mv.$src
│   ├── party_current_account_membership_mv.lifecycle_profiles.id
│   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
│   ├── investment_holdings_latest_mv_next.asset_id
│   └── investment_holdings_latest_mv_next.type
└── StreamHashJoin { type: Inner, predicate: party_current_account_membership_mv.account_id = investment_holdings_latest_mv_next.account_id }
    ├── output:
    │   ┌── party_current_account_membership_mv.party_id
    │   ├── party_current_account_membership_mv.account_group_type
    │   ├── party_current_account_membership_mv.party_currency
    │   ├── investment_holdings_latest_mv_next.currency_code
    │   ├── investment_holdings_latest_mv_next.market_value
    │   ├── investment_holdings_latest_mv_next.fair_value
    │   ├── investment_holdings_latest_mv_next.market_value_system_currency
    │   ├── investment_holdings_latest_mv_next.fair_value_system_currency
    │   ├── party_current_account_membership_mv.account_id
    │   ├── party_current_account_membership_mv.customer_relationship_id
    │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
    │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
    │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
    │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
    │   ├── party_current_account_membership_mv.$src
    │   ├── party_current_account_membership_mv.lifecycle_profiles.id
    │   ├── investment_holdings_latest_mv_next.account_id
    │   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
    │   ├── investment_holdings_latest_mv_next.asset_id
    │   └── investment_holdings_latest_mv_next.type
    ├── stream key:
    │   ┌── party_current_account_membership_mv.account_id
    │   ├── party_current_account_membership_mv.party_id
    │   ├── party_current_account_membership_mv.customer_relationship_id
    │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
    │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
    │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
    │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
    │   ├── party_current_account_membership_mv.$src
    │   ├── party_current_account_membership_mv.lifecycle_profiles.id
    │   ├── investment_holdings_latest_mv_next.accounts_dm.product_type_id
    │   ├── investment_holdings_latest_mv_next.asset_id
    │   └── investment_holdings_latest_mv_next.type
    ├── MergeExecutor
    │   ├── output:
    │   │   ┌── party_current_account_membership_mv.party_id
    │   │   ├── party_current_account_membership_mv.account_id
    │   │   ├── party_current_account_membership_mv.account_group_type
    │   │   ├── party_current_account_membership_mv.party_currency
    │   │   ├── party_current_account_membership_mv.customer_relationship_id
    │   │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
    │   │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
    │   │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
    │   │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
    │   │   ├── party_current_account_membership_mv.$src
    │   │   └── party_current_account_membership_mv.lifecycle_profiles.id
    │   └── stream key: [ party_current_account_membership_mv.account_id, party_current_account_membership_mv.party_id, party_current_account_membership_mv.customer_relationship_id, party_current_account_membership_mv.party_active_customer_relationships_mv.party_id, party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id, party_current_account_membership_mv.party_involvements_dm.entity_id, party_current_account_membership_mv.open_accounts_mv.is_restricted, party_current_account_membership_mv.$src, party_current_account_membership_mv.lifecycle_profiles.id ]
    └── MergeExecutor
        ├── output: [ investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.currency_code, investment_holdings_latest_mv_next.market_value, investment_holdings_latest_mv_next.fair_value, investment_holdings_latest_mv_next.market_value_system_currency, investment_holdings_latest_mv_next.fair_value_system_currency, investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]
        └── stream key: [ investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]

Fragment 59157 (Actor 741036,741037)
StreamLocalityProvider { locality_columns: [party_current_account_membership_mv.account_id] }
├── output:
│   ┌── party_current_account_membership_mv.party_id
│   ├── party_current_account_membership_mv.account_id
│   ├── party_current_account_membership_mv.account_group_type
│   ├── party_current_account_membership_mv.party_currency
│   ├── party_current_account_membership_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
│   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
│   ├── party_current_account_membership_mv.$src
│   └── party_current_account_membership_mv.lifecycle_profiles.id
├── stream key: [ party_current_account_membership_mv.account_id, party_current_account_membership_mv.party_id, party_current_account_membership_mv.customer_relationship_id, party_current_account_membership_mv.party_active_customer_relationships_mv.party_id, party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id, party_current_account_membership_mv.party_involvements_dm.entity_id, party_current_account_membership_mv.open_accounts_mv.is_restricted, party_current_account_membership_mv.$src, party_current_account_membership_mv.lifecycle_profiles.id ]
└── MergeExecutor
    ├── output:
    │   ┌── party_current_account_membership_mv.party_id
    │   ├── party_current_account_membership_mv.account_id
    │   ├── party_current_account_membership_mv.account_group_type
    │   ├── party_current_account_membership_mv.party_currency
    │   ├── party_current_account_membership_mv.customer_relationship_id
    │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
    │   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
    │   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
    │   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
    │   ├── party_current_account_membership_mv.$src
    │   └── party_current_account_membership_mv.lifecycle_profiles.id
    └── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.customer_relationship_id, party_current_account_membership_mv.party_active_customer_relationships_mv.party_id, party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id, party_current_account_membership_mv.party_involvements_dm.entity_id, party_current_account_membership_mv.open_accounts_mv.is_restricted, party_current_account_membership_mv.$src, party_current_account_membership_mv.lifecycle_profiles.id ]

Fragment 59158 (Actor 741051,741052)
StreamTableScan { table: party_current_account_membership_mv, columns: [party_id, account_id, account_group_type, party_currency, customer_relationship_id, party_active_customer_relationships_mv.party_id, party_active_customer_relationships_mv.customer_relationship_id, party_involvements_dm.entity_id, open_accounts_mv.is_restricted, $src, lifecycle_profiles.id] }
├── output:
│   ┌── party_current_account_membership_mv.party_id
│   ├── party_current_account_membership_mv.account_id
│   ├── party_current_account_membership_mv.account_group_type
│   ├── party_current_account_membership_mv.party_currency
│   ├── party_current_account_membership_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.party_id
│   ├── party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id
│   ├── party_current_account_membership_mv.party_involvements_dm.entity_id
│   ├── party_current_account_membership_mv.open_accounts_mv.is_restricted
│   ├── party_current_account_membership_mv.$src
│   └── party_current_account_membership_mv.lifecycle_profiles.id
├── stream key: [ party_current_account_membership_mv.party_id, party_current_account_membership_mv.customer_relationship_id, party_current_account_membership_mv.party_active_customer_relationships_mv.party_id, party_current_account_membership_mv.party_active_customer_relationships_mv.customer_relationship_id, party_current_account_membership_mv.party_involvements_dm.entity_id, party_current_account_membership_mv.open_accounts_mv.is_restricted, party_current_account_membership_mv.$src, party_current_account_membership_mv.lifecycle_profiles.id ]
├── Upstream { output: [ party_id, account_id, account_group_type, party_currency, customer_relationship_id, party_active_customer_relationships_mv.party_id, party_active_customer_relationships_mv.customer_relationship_id, party_involvements_dm.entity_id, open_accounts_mv.is_restricted, $src, lifecycle_profiles.id ], stream key: [] }
└── BatchPlanNode { output: [ party_id, account_id, account_group_type, party_currency, customer_relationship_id, party_active_customer_relationships_mv.party_id, party_active_customer_relationships_mv.customer_relationship_id, party_involvements_dm.entity_id, open_accounts_mv.is_restricted, $src, lifecycle_profiles.id ], stream key: [] }

Fragment 59159 (Actor 741038,741039)
StreamLocalityProvider { locality_columns: [investment_holdings_latest_mv_next.account_id] }
├── output: [ investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.currency_code, investment_holdings_latest_mv_next.market_value, investment_holdings_latest_mv_next.fair_value, investment_holdings_latest_mv_next.market_value_system_currency, investment_holdings_latest_mv_next.fair_value_system_currency, investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]
├── stream key: [ investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]
└── MergeExecutor
    ├── output: [ investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.currency_code, investment_holdings_latest_mv_next.market_value, investment_holdings_latest_mv_next.fair_value, investment_holdings_latest_mv_next.market_value_system_currency, investment_holdings_latest_mv_next.fair_value_system_currency, investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]
    └── stream key: [ investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]

Fragment 59160 (Actor 741054,741053)
StreamTableScan { table: investment_holdings_latest_mv_next, columns: [account_id, currency_code, market_value, fair_value, market_value_system_currency, fair_value_system_currency, accounts_dm.product_type_id, asset_id, type] }
├── output: [ investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.currency_code, investment_holdings_latest_mv_next.market_value, investment_holdings_latest_mv_next.fair_value, investment_holdings_latest_mv_next.market_value_system_currency, investment_holdings_latest_mv_next.fair_value_system_currency, investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]
├── stream key: [ investment_holdings_latest_mv_next.accounts_dm.product_type_id, investment_holdings_latest_mv_next.account_id, investment_holdings_latest_mv_next.asset_id, investment_holdings_latest_mv_next.type ]
├── Upstream { output: [ account_id, currency_code, market_value, fair_value, market_value_system_currency, fair_value_system_currency, accounts_dm.product_type_id, asset_id, type ], stream key: [] }
└── BatchPlanNode { output: [ account_id, currency_code, market_value, fair_value, market_value_system_currency, fair_value_system_currency, accounts_dm.product_type_id, asset_id, type ], stream key: [] }

Fragment 59161 (Actor 741055,741056)
StreamTableScan { table: fx_rates_snapshot_mv_next, columns: [source_currency_code, target_currency_code, rate] } { output: [ fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code, fx_rates_snapshot_mv_next.rate ], stream key: [ fx_rates_snapshot_mv_next.source_currency_code, fx_rates_snapshot_mv_next.target_currency_code ] }
├── Upstream { output: [ source_currency_code, target_currency_code, rate ], stream key: [] }
└── BatchPlanNode { output: [ source_currency_code, target_currency_code, rate ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
