orders · explain — RWM Console

table · order_service.orders profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
15 operators
Materialize · order_service.orders
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 · oms
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 32743 (Actor 740315,740314)
StreamMaterialize { columns: [id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail], stream_key: [id, created_at], pk_columns: [id], pk_conflict: Overwrite, watermark_columns: [created_at] }
├── output:
│   ┌── oms.orders.id
│   ├── oms.orders.client_order_id
│   ├── oms.orders.portfolio_id
│   ├── oms.orders.security_account_id
│   ├── oms.orders.initiator
│   ├── oms.orders.asset_id
│   ├── oms.orders.side
│   ├── oms.orders.workflow_state
│   ├── oms.orders.execution_state
│   ├── oms.orders.etag
│   ├── oms.orders.customer_relationship_id
│   ├── oms.orders.instruction
│   ├── oms.orders.execution_spec
│   ├── oms.orders.cost_estimate
│   ├── oms.orders.filled_quantity
│   ├── oms.orders.created_at
│   ├── oms.orders.deleted_at
│   ├── oms.orders.termination_reason
│   ├── oms.orders.executed_at
│   └── oms.orders.termination_detail
├── stream key: [ oms.orders.id, oms.orders.created_at ]
└── StreamWatermarkFilter [upsert] { watermark_descs: [Desc { column: oms.orders.created_at, expr: SubtractWithTimeZone(oms.orders.created_at, '5 years':Interval, 'UTC':Varchar) }], output_watermarks: [[oms.orders.created_at]] }
    ├── output:
    │   ┌── oms.orders.id
    │   ├── oms.orders.client_order_id
    │   ├── oms.orders.portfolio_id
    │   ├── oms.orders.security_account_id
    │   ├── oms.orders.initiator
    │   ├── oms.orders.asset_id
    │   ├── oms.orders.side
    │   ├── oms.orders.workflow_state
    │   ├── oms.orders.execution_state
    │   ├── oms.orders.etag
    │   ├── oms.orders.customer_relationship_id
    │   ├── oms.orders.instruction
    │   ├── oms.orders.execution_spec
    │   ├── oms.orders.cost_estimate
    │   ├── oms.orders.filled_quantity
    │   ├── oms.orders.created_at
    │   ├── oms.orders.deleted_at
    │   ├── oms.orders.termination_reason
    │   ├── oms.orders.executed_at
    │   └── oms.orders.termination_detail
    ├── stream key: []
    └── StreamUnion { all: true }
        ├── output:
        │   ┌── oms.orders.id
        │   ├── oms.orders.client_order_id
        │   ├── oms.orders.portfolio_id
        │   ├── oms.orders.security_account_id
        │   ├── oms.orders.initiator
        │   ├── oms.orders.asset_id
        │   ├── oms.orders.side
        │   ├── oms.orders.workflow_state
        │   ├── oms.orders.execution_state
        │   ├── oms.orders.etag
        │   ├── oms.orders.customer_relationship_id
        │   ├── oms.orders.instruction
        │   ├── oms.orders.execution_spec
        │   ├── oms.orders.cost_estimate
        │   ├── oms.orders.filled_quantity
        │   ├── oms.orders.created_at
        │   ├── oms.orders.deleted_at
        │   ├── oms.orders.termination_reason
        │   ├── oms.orders.executed_at
        │   └── oms.orders.termination_detail
        ├── stream key: []
        ├── MergeExecutor
        │   ├── output:
        │   │   ┌── oms.orders.id
        │   │   ├── oms.orders.client_order_id
        │   │   ├── oms.orders.portfolio_id
        │   │   ├── oms.orders.security_account_id
        │   │   ├── oms.orders.initiator
        │   │   ├── oms.orders.asset_id
        │   │   ├── oms.orders.side
        │   │   ├── oms.orders.workflow_state
        │   │   ├── oms.orders.execution_state
        │   │   ├── oms.orders.etag
        │   │   ├── oms.orders.customer_relationship_id
        │   │   ├── oms.orders.instruction
        │   │   ├── oms.orders.execution_spec
        │   │   ├── oms.orders.cost_estimate
        │   │   ├── oms.orders.filled_quantity
        │   │   ├── oms.orders.created_at
        │   │   ├── oms.orders.deleted_at
        │   │   ├── oms.orders.termination_reason
        │   │   ├── oms.orders.executed_at
        │   │   └── oms.orders.termination_detail
        │   └── stream key: [ oms.orders.id ]
        ├── MergeExecutor { output: [ id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail ], stream key: [] }
        └── StreamUpstreamSinkUnion { output: [ id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail ], stream key: [] }

Fragment 32744 (Actor 740316)
StreamCdcTableScan { table: oms.orders, columns: [id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail] }
├── output:
│   ┌── oms.orders.id
│   ├── oms.orders.client_order_id
│   ├── oms.orders.portfolio_id
│   ├── oms.orders.security_account_id
│   ├── oms.orders.initiator
│   ├── oms.orders.asset_id
│   ├── oms.orders.side
│   ├── oms.orders.workflow_state
│   ├── oms.orders.execution_state
│   ├── oms.orders.etag
│   ├── oms.orders.customer_relationship_id
│   ├── oms.orders.instruction
│   ├── oms.orders.execution_spec
│   ├── oms.orders.cost_estimate
│   ├── oms.orders.filled_quantity
│   ├── oms.orders.created_at
│   ├── oms.orders.deleted_at
│   ├── oms.orders.termination_reason
│   ├── oms.orders.executed_at
│   └── oms.orders.termination_detail
├── stream key: [ oms.orders.id ]
└── MergeExecutor { output: [ payload, _rw_offset, _rw_table_name ], stream key: [] }

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

Fragment 32746 (Actor 740317,740318)
StreamDml { columns: [id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail] }
├── output: [ id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail ]
├── stream key: []
└── StreamSource { output: [ id, client_order_id, portfolio_id, security_account_id, initiator, asset_id, side, workflow_state, execution_state, etag, customer_relationship_id, instruction, execution_spec, cost_estimate, filled_quantity, created_at, deleted_at, termination_reason, executed_at, termination_detail ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
