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

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

Job is idle — throughput ~0; structure shown.

14 operators
Materialize · olap.transactions_intraday_dm
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.transactions_intraday_dm Materialize olap.transactions_intra… 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 36921 (Actor 742171,742170)
StreamMaterialize { columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason], stream_key: [transaction_id], pk_columns: [transaction_id], pk_conflict: Overwrite }
├── output:
│   ┌── olap.transactions_intraday_dm.transaction_id
│   ├── olap.transactions_intraday_dm.account_id
│   ├── olap.transactions_intraday_dm.asset_id
│   ├── olap.transactions_intraday_dm.transaction_valuation_date
│   ├── olap.transactions_intraday_dm.transaction_valuation_timestamp
│   ├── olap.transactions_intraday_dm.transaction_settlement_date
│   ├── olap.transactions_intraday_dm.transaction_type_id
│   ├── olap.transactions_intraday_dm.currency_code
│   ├── olap.transactions_intraday_dm.gross_value
│   ├── olap.transactions_intraday_dm.net_value
│   ├── olap.transactions_intraday_dm.quantity
│   ├── olap.transactions_intraday_dm.order_id
│   ├── olap.transactions_intraday_dm.order_side_label_id
│   ├── olap.transactions_intraday_dm.status_label_id
│   ├── olap.transactions_intraday_dm.disabled_at
│   └── olap.transactions_intraday_dm.retire_reason
├── stream key: [ olap.transactions_intraday_dm.transaction_id ]
└── StreamUnion { all: true }
    ├── output:
    │   ┌── olap.transactions_intraday_dm.transaction_id
    │   ├── olap.transactions_intraday_dm.account_id
    │   ├── olap.transactions_intraday_dm.asset_id
    │   ├── olap.transactions_intraday_dm.transaction_valuation_date
    │   ├── olap.transactions_intraday_dm.transaction_valuation_timestamp
    │   ├── olap.transactions_intraday_dm.transaction_settlement_date
    │   ├── olap.transactions_intraday_dm.transaction_type_id
    │   ├── olap.transactions_intraday_dm.currency_code
    │   ├── olap.transactions_intraday_dm.gross_value
    │   ├── olap.transactions_intraday_dm.net_value
    │   ├── olap.transactions_intraday_dm.quantity
    │   ├── olap.transactions_intraday_dm.order_id
    │   ├── olap.transactions_intraday_dm.order_side_label_id
    │   ├── olap.transactions_intraday_dm.status_label_id
    │   ├── olap.transactions_intraday_dm.disabled_at
    │   └── olap.transactions_intraday_dm.retire_reason
    ├── stream key: []
    ├── MergeExecutor
    │   ├── output:
    │   │   ┌── olap.transactions_intraday_dm.transaction_id
    │   │   ├── olap.transactions_intraday_dm.account_id
    │   │   ├── olap.transactions_intraday_dm.asset_id
    │   │   ├── olap.transactions_intraday_dm.transaction_valuation_date
    │   │   ├── olap.transactions_intraday_dm.transaction_valuation_timestamp
    │   │   ├── olap.transactions_intraday_dm.transaction_settlement_date
    │   │   ├── olap.transactions_intraday_dm.transaction_type_id
    │   │   ├── olap.transactions_intraday_dm.currency_code
    │   │   ├── olap.transactions_intraday_dm.gross_value
    │   │   ├── olap.transactions_intraday_dm.net_value
    │   │   ├── olap.transactions_intraday_dm.quantity
    │   │   ├── olap.transactions_intraday_dm.order_id
    │   │   ├── olap.transactions_intraday_dm.order_side_label_id
    │   │   ├── olap.transactions_intraday_dm.status_label_id
    │   │   ├── olap.transactions_intraday_dm.disabled_at
    │   │   └── olap.transactions_intraday_dm.retire_reason
    │   └── stream key: [ olap.transactions_intraday_dm.transaction_id ]
    ├── MergeExecutor { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason ], stream key: [] }
    └── StreamUpstreamSinkUnion { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason ], stream key: [] }

Fragment 36922 (Actor 742172)
StreamCdcTableScan { table: olap.transactions_intraday_dm, columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason] }
├── output:
│   ┌── olap.transactions_intraday_dm.transaction_id
│   ├── olap.transactions_intraday_dm.account_id
│   ├── olap.transactions_intraday_dm.asset_id
│   ├── olap.transactions_intraday_dm.transaction_valuation_date
│   ├── olap.transactions_intraday_dm.transaction_valuation_timestamp
│   ├── olap.transactions_intraday_dm.transaction_settlement_date
│   ├── olap.transactions_intraday_dm.transaction_type_id
│   ├── olap.transactions_intraday_dm.currency_code
│   ├── olap.transactions_intraday_dm.gross_value
│   ├── olap.transactions_intraday_dm.net_value
│   ├── olap.transactions_intraday_dm.quantity
│   ├── olap.transactions_intraday_dm.order_id
│   ├── olap.transactions_intraday_dm.order_side_label_id
│   ├── olap.transactions_intraday_dm.status_label_id
│   ├── olap.transactions_intraday_dm.disabled_at
│   └── olap.transactions_intraday_dm.retire_reason
├── stream key: [ olap.transactions_intraday_dm.transaction_id ]
└── MergeExecutor { output: [ payload, _rw_offset, _rw_table_name ], stream key: [] }

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

Fragment 36924 (Actor 742173,742174)
StreamDml { columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason] }
├── output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason ]
├── stream key: []
└── StreamSource { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, gross_value, net_value, quantity, order_id, order_side_label_id, status_label_id, disabled_at, retire_reason ], stream key: [] }