intraday_position_by_asset_sink · explain

← cluster insights objects intraday_position_by_asset_sink explain
Overview Objects Graph History
sink · insights.intraday_position_by_asset_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
6 operators
Sink · insights.intraday_position_by_asset_sink
0% idle 2 actors
Project · intraday_position_by_asset_mv_next
— — 2 actors
Filter · intraday_position_by_asset_mv_next
0% idle 2 actors
StreamScan · intraday_position_by_asset_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 26256 (Actor 134033,134032)
StreamSink { type: upsert, columns: [account_group_id, type, balance_timestamp, asset_id, currency_code, market_value, total_average_cost, fair_value, fair_value_system_currency, accrued_value, accrued_value_system_currency, market_value_system_currency, total_average_cost_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, asset_quantity, weight, fair_value_weight, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code(hidden)], downstream_pk: [intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.change_time, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.position_type] }
├── output: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.change_time, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.market_value, intraday_position_by_asset_mv_next.total_average_cost, intraday_position_by_asset_mv_next.fair_value, intraday_position_by_asset_mv_next.fair_value_system_currency, intraday_position_by_asset_mv_next.accrued_value, intraday_position_by_asset_mv_next.accrued_value_system_currency, intraday_position_by_asset_mv_next.market_value_system_currency, intraday_position_by_asset_mv_next.total_average_cost_system_currency, intraday_position_by_asset_mv_next.market_value_asset_currency, intraday_position_by_asset_mv_next.total_average_cost_asset_currency, intraday_position_by_asset_mv_next.fair_value_asset_currency, intraday_position_by_asset_mv_next.quantity, intraday_position_by_asset_mv_next.weight, intraday_position_by_asset_mv_next.fair_value_weight, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
├── stream key: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
└── StreamProject { exprs: [intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.change_time, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.market_value, intraday_position_by_asset_mv_next.total_average_cost, intraday_position_by_asset_mv_next.fair_value, intraday_position_by_asset_mv_next.fair_value_system_currency, intraday_position_by_asset_mv_next.accrued_value, intraday_position_by_asset_mv_next.accrued_value_system_currency, intraday_position_by_asset_mv_next.market_value_system_currency, intraday_position_by_asset_mv_next.total_average_cost_system_currency, intraday_position_by_asset_mv_next.market_value_asset_currency, intraday_position_by_asset_mv_next.total_average_cost_asset_currency, intraday_position_by_asset_mv_next.fair_value_asset_currency, intraday_position_by_asset_mv_next.quantity, intraday_position_by_asset_mv_next.weight, intraday_position_by_asset_mv_next.fair_value_weight, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code] }
    ├── output: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.change_time, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.market_value, intraday_position_by_asset_mv_next.total_average_cost, intraday_position_by_asset_mv_next.fair_value, intraday_position_by_asset_mv_next.fair_value_system_currency, intraday_position_by_asset_mv_next.accrued_value, intraday_position_by_asset_mv_next.accrued_value_system_currency, intraday_position_by_asset_mv_next.market_value_system_currency, intraday_position_by_asset_mv_next.total_average_cost_system_currency, intraday_position_by_asset_mv_next.market_value_asset_currency, intraday_position_by_asset_mv_next.total_average_cost_asset_currency, intraday_position_by_asset_mv_next.fair_value_asset_currency, intraday_position_by_asset_mv_next.quantity, intraday_position_by_asset_mv_next.weight, intraday_position_by_asset_mv_next.fair_value_weight, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
    ├── stream key: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
    └── StreamFilter { predicate: Not(IsNull(intraday_position_by_asset_mv_next.change_time)) }
        ├── output: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.market_value, intraday_position_by_asset_mv_next.total_average_cost, intraday_position_by_asset_mv_next.fair_value, intraday_position_by_asset_mv_next.accrued_value, intraday_position_by_asset_mv_next.market_value_system_currency, intraday_position_by_asset_mv_next.total_average_cost_system_currency, intraday_position_by_asset_mv_next.fair_value_system_currency, intraday_position_by_asset_mv_next.accrued_value_system_currency, intraday_position_by_asset_mv_next.market_value_asset_currency, intraday_position_by_asset_mv_next.total_average_cost_asset_currency, intraday_position_by_asset_mv_next.fair_value_asset_currency, intraday_position_by_asset_mv_next.quantity, intraday_position_by_asset_mv_next.weight, intraday_position_by_asset_mv_next.fair_value_weight, intraday_position_by_asset_mv_next.change_time, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
        ├── stream key: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
        └── StreamTableScan { table: intraday_position_by_asset_mv_next, columns: [account_group_id, position_type, asset_id, currency_code, market_value, total_average_cost, fair_value, accrued_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, quantity, weight, fair_value_weight, change_time, intraday_position_summary_mv_next.currency_code] }
            ├── output: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.market_value, intraday_position_by_asset_mv_next.total_average_cost, intraday_position_by_asset_mv_next.fair_value, intraday_position_by_asset_mv_next.accrued_value, intraday_position_by_asset_mv_next.market_value_system_currency, intraday_position_by_asset_mv_next.total_average_cost_system_currency, intraday_position_by_asset_mv_next.fair_value_system_currency, intraday_position_by_asset_mv_next.accrued_value_system_currency, intraday_position_by_asset_mv_next.market_value_asset_currency, intraday_position_by_asset_mv_next.total_average_cost_asset_currency, intraday_position_by_asset_mv_next.fair_value_asset_currency, intraday_position_by_asset_mv_next.quantity, intraday_position_by_asset_mv_next.weight, intraday_position_by_asset_mv_next.fair_value_weight, intraday_position_by_asset_mv_next.change_time, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
            ├── stream key: [ intraday_position_by_asset_mv_next.account_group_id, intraday_position_by_asset_mv_next.asset_id, intraday_position_by_asset_mv_next.position_type, intraday_position_by_asset_mv_next.currency_code, intraday_position_by_asset_mv_next.intraday_position_summary_mv_next.currency_code ]
            ├── Upstream { output: [ account_group_id, position_type, asset_id, currency_code, market_value, total_average_cost, fair_value, accrued_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, quantity, weight, fair_value_weight, change_time, intraday_position_summary_mv_next.currency_code ], stream key: [] }
            └── BatchPlanNode { output: [ account_group_id, position_type, asset_id, currency_code, market_value, total_average_cost, fair_value, accrued_value, market_value_system_currency, total_average_cost_system_currency, fair_value_system_currency, accrued_value_system_currency, market_value_asset_currency, total_average_cost_asset_currency, fair_value_asset_currency, quantity, weight, fair_value_weight, change_time, intraday_position_summary_mv_next.currency_code ], stream key: [] }
RWM Console cluster: risingwave-adib.adib-rw.svc.cluster.local
