holding_values_latest_mv · explain

← cluster insights objects holding_values_latest_mv explain
Overview Objects Graph History
materialized view · insights.holding_values_latest_mv profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
9 operators
Materialize · insights.holding_values_latest_mv
0% idle 2 actors
Project
— — 2 actors
GroupTopN
0% idle 2 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · holding_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 58914 (Actor 739296,739297)
StreamMaterialize { columns: [account_id, asset_id, type, dim_value_date, currency_code, purchased_quantity, average_cost_per_unit, market_value, fair_value, accrued_value, market_value_system_currency, average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency], stream_key: [account_id, asset_id, type], pk_columns: [account_id, asset_id, type], pk_conflict: NoCheck }
├── output: [ holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type, holding_values_mv_next.dim_value_date, holding_values_mv_next.currency_code, holding_values_mv_next.purchased_quantity, holding_values_mv_next.average_cost_per_unit, holding_values_mv_next.market_value, holding_values_mv_next.fair_value, holding_values_mv_next.accrued_value, holding_values_mv_next.market_value_system_currency, holding_values_mv_next.average_cost_system_currency, holding_values_mv_next.fair_value_system_currency, holding_values_mv_next.accrued_value_system_currency ]
├── stream key: [ holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type ]
└── StreamProject { exprs: [holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type, holding_values_mv_next.dim_value_date, holding_values_mv_next.currency_code, holding_values_mv_next.purchased_quantity, holding_values_mv_next.average_cost_per_unit, holding_values_mv_next.market_value, holding_values_mv_next.fair_value, holding_values_mv_next.accrued_value, holding_values_mv_next.market_value_system_currency, holding_values_mv_next.average_cost_system_currency, holding_values_mv_next.fair_value_system_currency, holding_values_mv_next.accrued_value_system_currency] }
    ├── output: [ holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type, holding_values_mv_next.dim_value_date, holding_values_mv_next.currency_code, holding_values_mv_next.purchased_quantity, holding_values_mv_next.average_cost_per_unit, holding_values_mv_next.market_value, holding_values_mv_next.fair_value, holding_values_mv_next.accrued_value, holding_values_mv_next.market_value_system_currency, holding_values_mv_next.average_cost_system_currency, holding_values_mv_next.fair_value_system_currency, holding_values_mv_next.accrued_value_system_currency ]
    ├── stream key: [ holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type ]
    └── StreamGroupTopN { order: [holding_values_mv_next.dim_value_date DESC], limit: 1, offset: 0, group_key: [holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type] }
        ├── output:
        │   ┌── holding_values_mv_next.account_id
        │   ├── holding_values_mv_next.asset_id
        │   ├── holding_values_mv_next.dim_value_date
        │   ├── holding_values_mv_next.type
        │   ├── holding_values_mv_next.currency_code
        │   ├── holding_values_mv_next.market_value
        │   ├── holding_values_mv_next.average_cost_per_unit
        │   ├── holding_values_mv_next.purchased_quantity
        │   ├── holding_values_mv_next.fair_value
        │   ├── holding_values_mv_next.accrued_value
        │   ├── holding_values_mv_next.accrued_value_system_currency
        │   ├── holding_values_mv_next.market_value_system_currency
        │   ├── holding_values_mv_next.average_cost_system_currency
        │   ├── holding_values_mv_next.fair_value_system_currency
        │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code
        │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date
        │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.account_id
        │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id
        │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.type
        │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code
        │   └── holding_values_mv_next.$src
        ├── stream key: [ holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type ]
        └── StreamLocalityProvider { locality_columns: [holding_values_mv_next.account_id, holding_values_mv_next.asset_id, holding_values_mv_next.type] }
            ├── output:
            │   ┌── holding_values_mv_next.account_id
            │   ├── holding_values_mv_next.asset_id
            │   ├── holding_values_mv_next.dim_value_date
            │   ├── holding_values_mv_next.type
            │   ├── holding_values_mv_next.currency_code
            │   ├── holding_values_mv_next.market_value
            │   ├── holding_values_mv_next.average_cost_per_unit
            │   ├── holding_values_mv_next.purchased_quantity
            │   ├── holding_values_mv_next.fair_value
            │   ├── holding_values_mv_next.accrued_value
            │   ├── holding_values_mv_next.accrued_value_system_currency
            │   ├── holding_values_mv_next.market_value_system_currency
            │   ├── holding_values_mv_next.average_cost_system_currency
            │   ├── holding_values_mv_next.fair_value_system_currency
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.account_id
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.type
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code
            │   └── holding_values_mv_next.$src
            ├── stream key:
            │   ┌── holding_values_mv_next.account_id
            │   ├── holding_values_mv_next.asset_id
            │   ├── holding_values_mv_next.type
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.account_id
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.type
            │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code
            │   └── holding_values_mv_next.$src
            └── MergeExecutor
                ├── output:
                │   ┌── holding_values_mv_next.account_id
                │   ├── holding_values_mv_next.asset_id
                │   ├── holding_values_mv_next.dim_value_date
                │   ├── holding_values_mv_next.type
                │   ├── holding_values_mv_next.currency_code
                │   ├── holding_values_mv_next.market_value
                │   ├── holding_values_mv_next.average_cost_per_unit
                │   ├── holding_values_mv_next.purchased_quantity
                │   ├── holding_values_mv_next.fair_value
                │   ├── holding_values_mv_next.accrued_value
                │   ├── holding_values_mv_next.accrued_value_system_currency
                │   ├── holding_values_mv_next.market_value_system_currency
                │   ├── holding_values_mv_next.average_cost_system_currency
                │   ├── holding_values_mv_next.fair_value_system_currency
                │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code
                │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date
                │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.account_id
                │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id
                │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.type
                │   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code
                │   └── holding_values_mv_next.$src
                └── stream key: [ holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code, holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date, holding_values_mv_next.holding_values_with_accruals_mv_next.account_id, holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id, holding_values_mv_next.holding_values_with_accruals_mv_next.type, holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code, holding_values_mv_next.$src ]

Fragment 58915 (Actor 739753,739752)
StreamTableScan { table: holding_values_mv_next, columns: [account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, fair_value, accrued_value, accrued_value_system_currency, market_value_system_currency, average_cost_system_currency, fair_value_system_currency, holding_values_with_accruals_mv_next.currency_code, holding_values_with_accruals_mv_next.dim_value_date, holding_values_with_accruals_mv_next.account_id, holding_values_with_accruals_mv_next.asset_id, holding_values_with_accruals_mv_next.type, holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code, $src] }
├── output:
│   ┌── holding_values_mv_next.account_id
│   ├── holding_values_mv_next.asset_id
│   ├── holding_values_mv_next.dim_value_date
│   ├── holding_values_mv_next.type
│   ├── holding_values_mv_next.currency_code
│   ├── holding_values_mv_next.market_value
│   ├── holding_values_mv_next.average_cost_per_unit
│   ├── holding_values_mv_next.purchased_quantity
│   ├── holding_values_mv_next.fair_value
│   ├── holding_values_mv_next.accrued_value
│   ├── holding_values_mv_next.accrued_value_system_currency
│   ├── holding_values_mv_next.market_value_system_currency
│   ├── holding_values_mv_next.average_cost_system_currency
│   ├── holding_values_mv_next.fair_value_system_currency
│   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code
│   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date
│   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.account_id
│   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id
│   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.type
│   ├── holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code
│   └── holding_values_mv_next.$src
├── stream key: [ holding_values_mv_next.holding_values_with_accruals_mv_next.currency_code, holding_values_mv_next.holding_values_with_accruals_mv_next.dim_value_date, holding_values_mv_next.holding_values_with_accruals_mv_next.account_id, holding_values_mv_next.holding_values_with_accruals_mv_next.asset_id, holding_values_mv_next.holding_values_with_accruals_mv_next.type, holding_values_mv_next.holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code, holding_values_mv_next.$src ]
├── Upstream { output: [ account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, fair_value, accrued_value, accrued_value_system_currency, market_value_system_currency, average_cost_system_currency, fair_value_system_currency, holding_values_with_accruals_mv_next.currency_code, holding_values_with_accruals_mv_next.dim_value_date, holding_values_with_accruals_mv_next.account_id, holding_values_with_accruals_mv_next.asset_id, holding_values_with_accruals_mv_next.type, holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code, $src ], stream key: [] }
└── BatchPlanNode { output: [ account_id, asset_id, dim_value_date, type, currency_code, market_value, average_cost_per_unit, purchased_quantity, fair_value, accrued_value, accrued_value_system_currency, market_value_system_currency, average_cost_system_currency, fair_value_system_currency, holding_values_with_accruals_mv_next.currency_code, holding_values_with_accruals_mv_next.dim_value_date, holding_values_with_accruals_mv_next.account_id, holding_values_with_accruals_mv_next.asset_id, holding_values_with_accruals_mv_next.type, holding_values_with_accruals_mv_next.foreign_exchange_rates_eod_ft.target_currency_code, $src ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
