holding_values_intraday_ft · explain

table · olap.holding_values_intraday_ft profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
15 operators
Materialize · olap.holding_values_intraday_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.
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand
Fragment 16907 (Actor 99537,99538)
StreamMaterialize { columns: [id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance], stream_key: [id, holding_timestamp], pk_columns: [id], pk_conflict: Overwrite, watermark_columns: [holding_timestamp] }
├── output:
│   ┌── olap.holding_values_intraday_ft.id
│   ├── olap.holding_values_intraday_ft.account_id
│   ├── olap.holding_values_intraday_ft.asset_id
│   ├── olap.holding_values_intraday_ft.currency_code
│   ├── olap.holding_values_intraday_ft.holding_timestamp
│   ├── olap.holding_values_intraday_ft.purchased_quantity
│   ├── olap.holding_values_intraday_ft.market_value
│   ├── olap.holding_values_intraday_ft.average_cost
│   ├── olap.holding_values_intraday_ft.average_cost_per_unit
│   ├── olap.holding_values_intraday_ft.average_cost_per_unit_system_currency
│   ├── olap.holding_values_intraday_ft.market_value_system_currency
│   ├── olap.holding_values_intraday_ft.disabled_at
│   ├── olap.holding_values_intraday_ft.total_cost_system_currency
│   └── olap.holding_values_intraday_ft.cost_fx_provenance
├── stream key: [ olap.holding_values_intraday_ft.id, olap.holding_values_intraday_ft.holding_timestamp ]
└── StreamWatermarkFilter [upsert] { watermark_descs: [Desc { column: olap.holding_values_intraday_ft.holding_timestamp, expr: SubtractWithTimeZone(olap.holding_values_intraday_ft.holding_timestamp, '5 years':Interval, 'UTC':Varchar) }], output_watermarks: [[olap.holding_values_intraday_ft.holding_timestamp]] }
    ├── output:
    │   ┌── olap.holding_values_intraday_ft.id
    │   ├── olap.holding_values_intraday_ft.account_id
    │   ├── olap.holding_values_intraday_ft.asset_id
    │   ├── olap.holding_values_intraday_ft.currency_code
    │   ├── olap.holding_values_intraday_ft.holding_timestamp
    │   ├── olap.holding_values_intraday_ft.purchased_quantity
    │   ├── olap.holding_values_intraday_ft.market_value
    │   ├── olap.holding_values_intraday_ft.average_cost
    │   ├── olap.holding_values_intraday_ft.average_cost_per_unit
    │   ├── olap.holding_values_intraday_ft.average_cost_per_unit_system_currency
    │   ├── olap.holding_values_intraday_ft.market_value_system_currency
    │   ├── olap.holding_values_intraday_ft.disabled_at
    │   ├── olap.holding_values_intraday_ft.total_cost_system_currency
    │   └── olap.holding_values_intraday_ft.cost_fx_provenance
    ├── stream key: []
    └── StreamUnion { all: true }
        ├── output:
        │   ┌── olap.holding_values_intraday_ft.id
        │   ├── olap.holding_values_intraday_ft.account_id
        │   ├── olap.holding_values_intraday_ft.asset_id
        │   ├── olap.holding_values_intraday_ft.currency_code
        │   ├── olap.holding_values_intraday_ft.holding_timestamp
        │   ├── olap.holding_values_intraday_ft.purchased_quantity
        │   ├── olap.holding_values_intraday_ft.market_value
        │   ├── olap.holding_values_intraday_ft.average_cost
        │   ├── olap.holding_values_intraday_ft.average_cost_per_unit
        │   ├── olap.holding_values_intraday_ft.average_cost_per_unit_system_currency
        │   ├── olap.holding_values_intraday_ft.market_value_system_currency
        │   ├── olap.holding_values_intraday_ft.disabled_at
        │   ├── olap.holding_values_intraday_ft.total_cost_system_currency
        │   └── olap.holding_values_intraday_ft.cost_fx_provenance
        ├── stream key: []
        ├── MergeExecutor
        │   ├── output:
        │   │   ┌── olap.holding_values_intraday_ft.id
        │   │   ├── olap.holding_values_intraday_ft.account_id
        │   │   ├── olap.holding_values_intraday_ft.asset_id
        │   │   ├── olap.holding_values_intraday_ft.currency_code
        │   │   ├── olap.holding_values_intraday_ft.holding_timestamp
        │   │   ├── olap.holding_values_intraday_ft.purchased_quantity
        │   │   ├── olap.holding_values_intraday_ft.market_value
        │   │   ├── olap.holding_values_intraday_ft.average_cost
        │   │   ├── olap.holding_values_intraday_ft.average_cost_per_unit
        │   │   ├── olap.holding_values_intraday_ft.average_cost_per_unit_system_currency
        │   │   ├── olap.holding_values_intraday_ft.market_value_system_currency
        │   │   ├── olap.holding_values_intraday_ft.disabled_at
        │   │   ├── olap.holding_values_intraday_ft.total_cost_system_currency
        │   │   └── olap.holding_values_intraday_ft.cost_fx_provenance
        │   └── stream key: [ olap.holding_values_intraday_ft.id ]
        ├── MergeExecutor { output: [ id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance ], stream key: [] }
        └── StreamUpstreamSinkUnion { output: [ id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance ], stream key: [] }

Fragment 16908 (Actor 99542)
StreamCdcTableScan { table: olap.holding_values_intraday_ft, columns: [id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance] }
├── output:
│   ┌── olap.holding_values_intraday_ft.id
│   ├── olap.holding_values_intraday_ft.account_id
│   ├── olap.holding_values_intraday_ft.asset_id
│   ├── olap.holding_values_intraday_ft.currency_code
│   ├── olap.holding_values_intraday_ft.holding_timestamp
│   ├── olap.holding_values_intraday_ft.purchased_quantity
│   ├── olap.holding_values_intraday_ft.market_value
│   ├── olap.holding_values_intraday_ft.average_cost
│   ├── olap.holding_values_intraday_ft.average_cost_per_unit
│   ├── olap.holding_values_intraday_ft.average_cost_per_unit_system_currency
│   ├── olap.holding_values_intraday_ft.market_value_system_currency
│   ├── olap.holding_values_intraday_ft.disabled_at
│   ├── olap.holding_values_intraday_ft.total_cost_system_currency
│   └── olap.holding_values_intraday_ft.cost_fx_provenance
├── stream key: [ olap.holding_values_intraday_ft.id ]
└── MergeExecutor { output: [ payload, _rw_offset, _rw_table_name ], stream key: [] }

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

Fragment 16910 (Actor 99558,99557)
StreamDml { columns: [id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance] }
├── output: [ id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance ]
├── stream key: []
└── StreamSource { output: [ id, account_id, asset_id, currency_code, holding_timestamp, purchased_quantity, market_value, average_cost, average_cost_per_unit, average_cost_per_unit_system_currency, market_value_system_currency, disabled_at, total_cost_system_currency, cost_fx_provenance ], stream key: [] }
RWM Console cluster: risingwave-adib.adib-rw.svc.cluster.local
