RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local

← cluster olap objects holding_values_raw_ft explain
Overview Objects Graph History
table · olap.holding_values_raw_ft profiled over 5s
seconds (1–30)

Job is idle — throughput ~0; structure shown.

15 operators
Materialize · olap.holding_values_raw_ft
0% idle 2 actors
WatermarkFilter
0% idle 2 actors
Union
0% idle 2 actors
UpstreamSinkUnion
1% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Dml
0% idle 2 actors
Source
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamCdcScan · olap
0% idle 1 actor
Merge
— — 1 actor
Exchange
0% idle 0 actors
CdcFilter
0% idle 1 actor
Merge
— — 1 actor
Heat = the operator's output-buffer backpressure over the sampling window. Click a node to fold its subtree.
Materialize · olap.holding_values_raw_ft Materialize olap.holding_values_raw… idle · 2 actors WatermarkFilter WatermarkFilter idle · 2 actors Union Union idle · 2 actors UpstreamSinkUnion UpstreamSinkUnion idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Dml Dml idle · 2 actors Source Source idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamCdcScan · olap StreamCdcScan olap idle · 1 actor Merge Merge — · 1 actor Exchange Exchange idle · 0 actors CdcFilter CdcFilter idle · 1 actor Merge Merge — · 1 actor
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand 
Fragment 32893 (Actor 736117,736118)
StreamMaterialize { columns: [account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance], stream_key: [account_id, asset_id, dim_value_date, type], pk_columns: [account_id, asset_id, dim_value_date, type], pk_conflict: Overwrite, watermark_columns: [dim_value_date] }
├── output:
│   ┌── olap.holding_values_raw_ft.account_id
│   ├── olap.holding_values_raw_ft.asset_id
│   ├── olap.holding_values_raw_ft.dim_value_date
│   ├── olap.holding_values_raw_ft.currency_code
│   ├── olap.holding_values_raw_ft.market_value
│   ├── olap.holding_values_raw_ft.average_cost_per_unit
│   ├── olap.holding_values_raw_ft.purchased_quantity
│   ├── olap.holding_values_raw_ft.type
│   ├── olap.holding_values_raw_ft.m_is_stub
│   ├── olap.holding_values_raw_ft.disabled_at
│   ├── olap.holding_values_raw_ft.average_cost_per_unit_system_currency
│   ├── olap.holding_values_raw_ft.total_cost_system_currency
│   └── olap.holding_values_raw_ft.cost_fx_provenance
├── stream key: [ olap.holding_values_raw_ft.account_id, olap.holding_values_raw_ft.asset_id, olap.holding_values_raw_ft.dim_value_date, olap.holding_values_raw_ft.type ]
└── StreamWatermarkFilter [upsert] { watermark_descs: [Desc { column: olap.holding_values_raw_ft.dim_value_date, expr: (olap.holding_values_raw_ft.dim_value_date - '5 years':Interval)::Date }], output_watermarks: [[olap.holding_values_raw_ft.dim_value_date]] }
    ├── output:
    │   ┌── olap.holding_values_raw_ft.account_id
    │   ├── olap.holding_values_raw_ft.asset_id
    │   ├── olap.holding_values_raw_ft.dim_value_date
    │   ├── olap.holding_values_raw_ft.currency_code
    │   ├── olap.holding_values_raw_ft.market_value
    │   ├── olap.holding_values_raw_ft.average_cost_per_unit
    │   ├── olap.holding_values_raw_ft.purchased_quantity
    │   ├── olap.holding_values_raw_ft.type
    │   ├── olap.holding_values_raw_ft.m_is_stub
    │   ├── olap.holding_values_raw_ft.disabled_at
    │   ├── olap.holding_values_raw_ft.average_cost_per_unit_system_currency
    │   ├── olap.holding_values_raw_ft.total_cost_system_currency
    │   └── olap.holding_values_raw_ft.cost_fx_provenance
    ├── stream key: []
    └── StreamUnion { all: true }
        ├── output:
        │   ┌── olap.holding_values_raw_ft.account_id
        │   ├── olap.holding_values_raw_ft.asset_id
        │   ├── olap.holding_values_raw_ft.dim_value_date
        │   ├── olap.holding_values_raw_ft.currency_code
        │   ├── olap.holding_values_raw_ft.market_value
        │   ├── olap.holding_values_raw_ft.average_cost_per_unit
        │   ├── olap.holding_values_raw_ft.purchased_quantity
        │   ├── olap.holding_values_raw_ft.type
        │   ├── olap.holding_values_raw_ft.m_is_stub
        │   ├── olap.holding_values_raw_ft.disabled_at
        │   ├── olap.holding_values_raw_ft.average_cost_per_unit_system_currency
        │   ├── olap.holding_values_raw_ft.total_cost_system_currency
        │   └── olap.holding_values_raw_ft.cost_fx_provenance
        ├── stream key: []
        ├── MergeExecutor
        │   ├── output:
        │   │   ┌── olap.holding_values_raw_ft.account_id
        │   │   ├── olap.holding_values_raw_ft.asset_id
        │   │   ├── olap.holding_values_raw_ft.dim_value_date
        │   │   ├── olap.holding_values_raw_ft.currency_code
        │   │   ├── olap.holding_values_raw_ft.market_value
        │   │   ├── olap.holding_values_raw_ft.average_cost_per_unit
        │   │   ├── olap.holding_values_raw_ft.purchased_quantity
        │   │   ├── olap.holding_values_raw_ft.type
        │   │   ├── olap.holding_values_raw_ft.m_is_stub
        │   │   ├── olap.holding_values_raw_ft.disabled_at
        │   │   ├── olap.holding_values_raw_ft.average_cost_per_unit_system_currency
        │   │   ├── olap.holding_values_raw_ft.total_cost_system_currency
        │   │   └── olap.holding_values_raw_ft.cost_fx_provenance
        │   └── stream key: [ olap.holding_values_raw_ft.account_id, olap.holding_values_raw_ft.asset_id, olap.holding_values_raw_ft.dim_value_date, olap.holding_values_raw_ft.type ]
        ├── MergeExecutor { output: [ account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance ], stream key: [] }
        └── StreamUpstreamSinkUnion { output: [ account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance ], stream key: [] }

Fragment 32894 (Actor 736119)
StreamCdcTableScan { table: olap.holding_values_raw_ft, columns: [account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance] }
├── output:
│   ┌── olap.holding_values_raw_ft.account_id
│   ├── olap.holding_values_raw_ft.asset_id
│   ├── olap.holding_values_raw_ft.dim_value_date
│   ├── olap.holding_values_raw_ft.currency_code
│   ├── olap.holding_values_raw_ft.market_value
│   ├── olap.holding_values_raw_ft.average_cost_per_unit
│   ├── olap.holding_values_raw_ft.purchased_quantity
│   ├── olap.holding_values_raw_ft.type
│   ├── olap.holding_values_raw_ft.m_is_stub
│   ├── olap.holding_values_raw_ft.disabled_at
│   ├── olap.holding_values_raw_ft.average_cost_per_unit_system_currency
│   ├── olap.holding_values_raw_ft.total_cost_system_currency
│   └── olap.holding_values_raw_ft.cost_fx_provenance
├── stream key: [ olap.holding_values_raw_ft.account_id, olap.holding_values_raw_ft.asset_id, olap.holding_values_raw_ft.dim_value_date, olap.holding_values_raw_ft.type ]
└── MergeExecutor { output: [ payload, _rw_offset, _rw_table_name ], stream key: [] }

Fragment 32895 (Actor 736943)
StreamCdcFilter { output: [ payload, _rw_offset, _rw_table_name ], stream key: [] }
└── Upstream { output: [ payload, _rw_offset, _rw_table_name ], stream key: [] }

Fragment 32896 (Actor 736205,736206)
StreamDml { columns: [account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance] }
├── output: [ account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance ]
├── stream key: []
└── StreamSource { output: [ account_id, asset_id, dim_value_date, currency_code, market_value, average_cost_per_unit, purchased_quantity, type, m_is_stub, disabled_at, average_cost_per_unit_system_currency, total_cost_system_currency, cost_fx_provenance ], stream key: [] }