settled_position_valuations_sink · explain

sink · insights.settled_position_valuations_sink profiled over 5s

Job is idle — throughput ~0; structure shown.

Heat tree Operator graph

4 operators

Sink · insights.settled_position_valuations_sink

0% idle 2 actors

StreamScan · settled_position_valuations_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 59924 (Actor 739352,739353)
StreamSink { type: upsert, columns: [account_id, asset_id, currency_code, last_settlement_date, settled_quantity, settled_value, price, price_date, market_value, market_value_system_currency, average_cost_per_unit, average_cost_per_unit_system_currency, baseline_purchased_quantity, cost_basis_date, cost_basis_is_stub, total_cost, total_cost_system_currency, cost_fx_provenance, settled_position_valuations_mv_next.fx_rates_snapshot_mv_next.target_currency_code(hidden)], downstream_pk: [settled_position_valuations_mv_next.account_id, settled_position_valuations_mv_next.asset_id, settled_position_valuations_mv_next.currency_code] }
├── output:
│   ┌── settled_position_valuations_mv_next.account_id
│   ├── settled_position_valuations_mv_next.asset_id
│   ├── settled_position_valuations_mv_next.currency_code
│   ├── settled_position_valuations_mv_next.last_settlement_date
│   ├── settled_position_valuations_mv_next.settled_quantity
│   ├── settled_position_valuations_mv_next.settled_value
│   ├── settled_position_valuations_mv_next.price
│   ├── settled_position_valuations_mv_next.price_date
│   ├── settled_position_valuations_mv_next.market_value
│   ├── settled_position_valuations_mv_next.market_value_system_currency
│   ├── settled_position_valuations_mv_next.average_cost_per_unit
│   ├── settled_position_valuations_mv_next.average_cost_per_unit_system_currency
│   ├── settled_position_valuations_mv_next.baseline_purchased_quantity
│   ├── settled_position_valuations_mv_next.cost_basis_date
│   ├── settled_position_valuations_mv_next.cost_basis_is_stub
│   ├── settled_position_valuations_mv_next.total_cost
│   ├── settled_position_valuations_mv_next.total_cost_system_currency
│   ├── settled_position_valuations_mv_next.cost_fx_provenance
│   └── settled_position_valuations_mv_next.fx_rates_snapshot_mv_next.target_currency_code
├── stream key: [ settled_position_valuations_mv_next.currency_code, settled_position_valuations_mv_next.asset_id, settled_position_valuations_mv_next.account_id, settled_position_valuations_mv_next.fx_rates_snapshot_mv_next.target_currency_code ]
└── StreamTableScan { table: settled_position_valuations_mv_next, columns: [account_id, asset_id, currency_code, last_settlement_date, settled_quantity, settled_value, price, price_date, market_value, market_value_system_currency, average_cost_per_unit, average_cost_per_unit_system_currency, baseline_purchased_quantity, cost_basis_date, cost_basis_is_stub, total_cost, total_cost_system_currency, cost_fx_provenance, fx_rates_snapshot_mv_next.target_currency_code] }
    ├── output:
    │   ┌── settled_position_valuations_mv_next.account_id
    │   ├── settled_position_valuations_mv_next.asset_id
    │   ├── settled_position_valuations_mv_next.currency_code
    │   ├── settled_position_valuations_mv_next.last_settlement_date
    │   ├── settled_position_valuations_mv_next.settled_quantity
    │   ├── settled_position_valuations_mv_next.settled_value
    │   ├── settled_position_valuations_mv_next.price
    │   ├── settled_position_valuations_mv_next.price_date
    │   ├── settled_position_valuations_mv_next.market_value
    │   ├── settled_position_valuations_mv_next.market_value_system_currency
    │   ├── settled_position_valuations_mv_next.average_cost_per_unit
    │   ├── settled_position_valuations_mv_next.average_cost_per_unit_system_currency
    │   ├── settled_position_valuations_mv_next.baseline_purchased_quantity
    │   ├── settled_position_valuations_mv_next.cost_basis_date
    │   ├── settled_position_valuations_mv_next.cost_basis_is_stub
    │   ├── settled_position_valuations_mv_next.total_cost
    │   ├── settled_position_valuations_mv_next.total_cost_system_currency
    │   ├── settled_position_valuations_mv_next.cost_fx_provenance
    │   └── settled_position_valuations_mv_next.fx_rates_snapshot_mv_next.target_currency_code
    ├── stream key: [ settled_position_valuations_mv_next.currency_code, settled_position_valuations_mv_next.asset_id, settled_position_valuations_mv_next.account_id, settled_position_valuations_mv_next.fx_rates_snapshot_mv_next.target_currency_code ]
    ├── Upstream { output: [ account_id, asset_id, currency_code, last_settlement_date, settled_quantity, settled_value, price, price_date, market_value, market_value_system_currency, average_cost_per_unit, average_cost_per_unit_system_currency, baseline_purchased_quantity, cost_basis_date, cost_basis_is_stub, total_cost, total_cost_system_currency, cost_fx_provenance, fx_rates_snapshot_mv_next.target_currency_code ], stream key: [] }
    └── BatchPlanNode { output: [ account_id, asset_id, currency_code, last_settlement_date, settled_quantity, settled_value, price, price_date, market_value, market_value_system_currency, average_cost_per_unit, average_cost_per_unit_system_currency, baseline_purchased_quantity, cost_basis_date, cost_basis_is_stub, total_cost, total_cost_system_currency, cost_fx_provenance, fx_rates_snapshot_mv_next.target_currency_code ], stream key: [] }

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