flow_by_distribution_mv · explain

materialized view · insights.flow_by_distribution_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 filteredWindow state — add a WHERE rank <= N to bound it
Heat tree Operator graph
32 operators
Materialize · insights.flow_by_distribution_mv
0% idle 2 actors
OverWindow Window state — add a WHERE rank <= N to bound it
0% idle 2 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
Project · (flow_asset_values_mv_next.dim_transaction_date >= asset_di…
— — 2 actors
Filter · (flow_asset_values_mv_next.dim_transaction_date >= asset_di…
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · Inner · flow_asset_values_mv_next.asset_id = asset_distributions_fo…
— — 2 actors
HashJoin · Inner · flow_asset_values_mv_next.asset_id = asset_distributions_fo… 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 · asset_distributions_for_consumers_mv
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 · flow_asset_values_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 18844 (Actor 160518,160517)
StreamMaterialize { columns: [account_group_id, dim_transaction_date, distribution_type, taxonomy_node_id, taxonomy_code, position_type, currency_code, adjusted_net_flow, adjusted_net_flow_system_currency, cumulative_adjusted_netflow, cumulative_adjusted_netflow_system_currency], stream_key: [account_group_id, distribution_type, taxonomy_node_id, position_type, currency_code, dim_transaction_date, taxonomy_code], pk_columns: [account_group_id, distribution_type, taxonomy_node_id, position_type, currency_code, dim_transaction_date, taxonomy_code], pk_conflict: NoCheck }
├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2), sum, sum ]
├── stream key: [ flow_asset_values_mv_next.account_group_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.taxonomy_code ]
└── StreamOverWindow { window_functions: [sum(sum($expr1)) OVER(PARTITION BY flow_asset_values_mv_next.account_group_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency ORDER BY flow_asset_values_mv_next.dim_transaction_date ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), sum(sum($expr2)) OVER(PARTITION BY flow_asset_values_mv_next.account_group_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency ORDER BY flow_asset_values_mv_next.dim_transaction_date ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)] }
    ├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2), sum, sum ]
    ├── stream key: [ flow_asset_values_mv_next.account_group_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.taxonomy_code ]
    └── StreamLocalityProvider { locality_columns: [flow_asset_values_mv_next.account_group_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency] }
        ├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2) ]
        ├── stream key: [ flow_asset_values_mv_next.account_group_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.taxonomy_code ]
        └── MergeExecutor { output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2) ], stream key: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency ] }

Fragment 18845 (Actor 160519,160520)
StreamProject { exprs: [flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2)] }
├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2) ]
├── stream key: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency ]
└── StreamHashAgg { group_key: [flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency], aggs: [sum($expr1), sum($expr2), count] }
    ├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, sum($expr1), sum($expr2), count ]
    ├── stream key: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency ]
    └── StreamLocalityProvider { locality_columns: [flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency] }
        ├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, $expr1, $expr2, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
        ├── stream key: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
        └── MergeExecutor
            ├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, $expr1, $expr2, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
            └── stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]

Fragment 18846 (Actor 160522,160521)
StreamProject { exprs: [flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, (flow_asset_values_mv_next.net_value_group * asset_distributions_for_consumers_mv.share) as $expr1, (flow_asset_values_mv_next.net_value_system * asset_distributions_for_consumers_mv.share) as $expr2, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date] }
├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, $expr1, $expr2, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
├── stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
└── StreamFilter { predicate: (flow_asset_values_mv_next.dim_transaction_date >= asset_distributions_for_consumers_mv.effective_start_date) AND (flow_asset_values_mv_next.dim_transaction_date < asset_distributions_for_consumers_mv.effective_end_date) }
    ├── output:
    │   ┌── flow_asset_values_mv_next.account_group_id
    │   ├── flow_asset_values_mv_next.dim_transaction_date
    │   ├── flow_asset_values_mv_next.asset_id
    │   ├── flow_asset_values_mv_next.position_type
    │   ├── flow_asset_values_mv_next.group_currency
    │   ├── flow_asset_values_mv_next.net_value_group
    │   ├── flow_asset_values_mv_next.net_value_system
    │   ├── flow_asset_values_mv_next.asset_type
    │   ├── flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded
    │   ├── flow_asset_values_mv_next.flag
    │   ├── asset_distributions_for_consumers_mv.asset_id
    │   ├── asset_distributions_for_consumers_mv.distribution_type
    │   ├── asset_distributions_for_consumers_mv.effective_start_date
    │   ├── asset_distributions_for_consumers_mv.effective_end_date
    │   ├── asset_distributions_for_consumers_mv.taxonomy_node_id
    │   ├── asset_distributions_for_consumers_mv.taxonomy_code
    │   ├── asset_distributions_for_consumers_mv.share
    │   ├── asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id
    │   └── asset_distributions_for_consumers_mv.asset_distributions_dm.dimension
    ├── stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
    └── MergeExecutor
        ├── output:
        │   ┌── flow_asset_values_mv_next.account_group_id
        │   ├── flow_asset_values_mv_next.dim_transaction_date
        │   ├── flow_asset_values_mv_next.asset_id
        │   ├── flow_asset_values_mv_next.position_type
        │   ├── flow_asset_values_mv_next.group_currency
        │   ├── flow_asset_values_mv_next.net_value_group
        │   ├── flow_asset_values_mv_next.net_value_system
        │   ├── flow_asset_values_mv_next.asset_type
        │   ├── flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded
        │   ├── flow_asset_values_mv_next.flag
        │   ├── asset_distributions_for_consumers_mv.asset_id
        │   ├── asset_distributions_for_consumers_mv.distribution_type
        │   ├── asset_distributions_for_consumers_mv.effective_start_date
        │   ├── asset_distributions_for_consumers_mv.effective_end_date
        │   ├── asset_distributions_for_consumers_mv.taxonomy_node_id
        │   ├── asset_distributions_for_consumers_mv.taxonomy_code
        │   ├── asset_distributions_for_consumers_mv.share
        │   ├── asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id
        │   └── asset_distributions_for_consumers_mv.asset_distributions_dm.dimension
        └── stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]

Fragment 18847 (Actor 160524,160523)
StreamSyncLogStore
├── output:
│   ┌── flow_asset_values_mv_next.account_group_id
│   ├── flow_asset_values_mv_next.dim_transaction_date
│   ├── flow_asset_values_mv_next.asset_id
│   ├── flow_asset_values_mv_next.position_type
│   ├── flow_asset_values_mv_next.group_currency
│   ├── flow_asset_values_mv_next.net_value_group
│   ├── flow_asset_values_mv_next.net_value_system
│   ├── flow_asset_values_mv_next.asset_type
│   ├── flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded
│   ├── flow_asset_values_mv_next.flag
│   ├── asset_distributions_for_consumers_mv.asset_id
│   ├── asset_distributions_for_consumers_mv.distribution_type
│   ├── asset_distributions_for_consumers_mv.effective_start_date
│   ├── asset_distributions_for_consumers_mv.effective_end_date
│   ├── asset_distributions_for_consumers_mv.taxonomy_node_id
│   ├── asset_distributions_for_consumers_mv.taxonomy_code
│   ├── asset_distributions_for_consumers_mv.share
│   ├── asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id
│   └── asset_distributions_for_consumers_mv.asset_distributions_dm.dimension
├── stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
└── StreamHashJoin { type: Inner, predicate: flow_asset_values_mv_next.asset_id = asset_distributions_for_consumers_mv.asset_id }
    ├── output:
    │   ┌── flow_asset_values_mv_next.account_group_id
    │   ├── flow_asset_values_mv_next.dim_transaction_date
    │   ├── flow_asset_values_mv_next.asset_id
    │   ├── flow_asset_values_mv_next.position_type
    │   ├── flow_asset_values_mv_next.group_currency
    │   ├── flow_asset_values_mv_next.net_value_group
    │   ├── flow_asset_values_mv_next.net_value_system
    │   ├── flow_asset_values_mv_next.asset_type
    │   ├── flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded
    │   ├── flow_asset_values_mv_next.flag
    │   ├── asset_distributions_for_consumers_mv.asset_id
    │   ├── asset_distributions_for_consumers_mv.distribution_type
    │   ├── asset_distributions_for_consumers_mv.effective_start_date
    │   ├── asset_distributions_for_consumers_mv.effective_end_date
    │   ├── asset_distributions_for_consumers_mv.taxonomy_node_id
    │   ├── asset_distributions_for_consumers_mv.taxonomy_code
    │   ├── asset_distributions_for_consumers_mv.share
    │   ├── asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id
    │   └── asset_distributions_for_consumers_mv.asset_distributions_dm.dimension
    ├── stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
    ├── MergeExecutor { output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.net_value_group, flow_asset_values_mv_next.net_value_system, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag ], stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag ] }
    └── MergeExecutor { output: [ asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.effective_start_date, asset_distributions_for_consumers_mv.effective_end_date, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, asset_distributions_for_consumers_mv.share, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension ], stream key: [ asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ] }

Fragment 18848 (Actor 160526,160525)
StreamLocalityProvider { locality_columns: [flow_asset_values_mv_next.asset_id] } { output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.net_value_group, flow_asset_values_mv_next.net_value_system, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag ], stream key: [ flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag ] }
└── MergeExecutor { output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.net_value_group, flow_asset_values_mv_next.net_value_system, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag ], stream key: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag ] }

Fragment 18849 (Actor 160529,160530)
StreamTableScan { table: flow_asset_values_mv_next, columns: [account_group_id, dim_transaction_date, asset_id, position_type, group_currency, net_value_group, net_value_system, asset_type, flow_values_mv_next.position_type_expanded, flag] }
├── output: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.position_type, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.net_value_group, flow_asset_values_mv_next.net_value_system, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.flag ]
├── stream key: [ flow_asset_values_mv_next.account_group_id, flow_asset_values_mv_next.dim_transaction_date, flow_asset_values_mv_next.asset_id, flow_asset_values_mv_next.asset_type, flow_asset_values_mv_next.flow_values_mv_next.position_type_expanded, flow_asset_values_mv_next.group_currency, flow_asset_values_mv_next.flag ]
├── Upstream { output: [ account_group_id, dim_transaction_date, asset_id, position_type, group_currency, net_value_group, net_value_system, asset_type, flow_values_mv_next.position_type_expanded, flag ], stream key: [] }
└── BatchPlanNode { output: [ account_group_id, dim_transaction_date, asset_id, position_type, group_currency, net_value_group, net_value_system, asset_type, flow_values_mv_next.position_type_expanded, flag ], stream key: [] }

Fragment 18850 (Actor 160527,160528)
StreamLocalityProvider { locality_columns: [asset_distributions_for_consumers_mv.asset_id] } { output: [ asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.effective_start_date, asset_distributions_for_consumers_mv.effective_end_date, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, asset_distributions_for_consumers_mv.share, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension ], stream key: [ asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ] }
└── MergeExecutor { output: [ asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.effective_start_date, asset_distributions_for_consumers_mv.effective_end_date, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, asset_distributions_for_consumers_mv.share, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension ], stream key: [ asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ] }

Fragment 18851 (Actor 160532,160531)
StreamTableScan { table: asset_distributions_for_consumers_mv, columns: [asset_id, distribution_type, effective_start_date, effective_end_date, taxonomy_node_id, taxonomy_code, share, taxonomy_nodes_dm.dimension_id, asset_distributions_dm.dimension] }
├── output: [ asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.distribution_type, asset_distributions_for_consumers_mv.effective_start_date, asset_distributions_for_consumers_mv.effective_end_date, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.taxonomy_code, asset_distributions_for_consumers_mv.share, asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension ]
├── stream key: [ asset_distributions_for_consumers_mv.taxonomy_nodes_dm.dimension_id, asset_distributions_for_consumers_mv.taxonomy_node_id, asset_distributions_for_consumers_mv.asset_id, asset_distributions_for_consumers_mv.asset_distributions_dm.dimension, asset_distributions_for_consumers_mv.effective_start_date ]
├── Upstream { output: [ asset_id, distribution_type, effective_start_date, effective_end_date, taxonomy_node_id, taxonomy_code, share, taxonomy_nodes_dm.dimension_id, asset_distributions_dm.dimension ], stream key: [] }
└── BatchPlanNode { output: [ asset_id, distribution_type, effective_start_date, effective_end_date, taxonomy_node_id, taxonomy_code, share, taxonomy_nodes_dm.dimension_id, asset_distributions_dm.dimension ], stream key: [] }
RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local
