twrr_by_asset_sink · explain

← cluster insights objects twrr_by_asset_sink explain
Overview Objects Graph History
sink · insights.twrr_by_asset_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
5 operators
Sink · insights.twrr_by_asset_sink
0% idle 2 actors
Filter · twrr_by_asset_mv_next
0% idle 2 actors
StreamScan · twrr_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 62357 (Actor 740485,740486)
StreamSink { type: upsert, columns: [account_group_id, dim_balance_date, asset_id, daily_subperiod_return, daily_sub_period_fair_value_return, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type(hidden), twrr_by_asset_mv_next.currency_code(hidden), twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded(hidden), twrr_by_asset_mv_next.asset_currency(hidden), twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type(hidden), twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded(hidden), twrr_by_asset_mv_next.position_by_asset_mv_next.flag(hidden), twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type(hidden), twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type(hidden), twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency(hidden), twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded(hidden), twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code(hidden), twrr_by_asset_mv_next.flow_by_asset_mv_next.flag(hidden)], downstream_pk: [twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id] }
├── output: [ twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id, twrr_by_asset_mv_next.daily_subperiod_return, twrr_by_asset_mv_next.daily_subperiod_fair_value_return, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type, twrr_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, twrr_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.position_by_asset_mv_next.flag, twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.flow_by_asset_mv_next.flag ]
├── stream key: [ twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type, twrr_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, twrr_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.position_by_asset_mv_next.flag, twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.flow_by_asset_mv_next.flag ]
└── StreamFilter { predicate: Not(IsNull(twrr_by_asset_mv_next.daily_subperiod_return)) AND Not(IsNull(twrr_by_asset_mv_next.daily_subperiod_fair_value_return)) }
    ├── output: [ twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id, twrr_by_asset_mv_next.daily_subperiod_return, twrr_by_asset_mv_next.daily_subperiod_fair_value_return, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type, twrr_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, twrr_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.position_by_asset_mv_next.flag, twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.flow_by_asset_mv_next.flag ]
    ├── stream key: [ twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type, twrr_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, twrr_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.position_by_asset_mv_next.flag, twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.flow_by_asset_mv_next.flag ]
    └── StreamTableScan { table: twrr_by_asset_mv_next, columns: [account_group_id, dim_balance_date, asset_id, daily_subperiod_return, daily_subperiod_fair_value_return, position_by_asset_mv_next.position_type, currency_code, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.flag] }
        ├── output: [ twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id, twrr_by_asset_mv_next.daily_subperiod_return, twrr_by_asset_mv_next.daily_subperiod_fair_value_return, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type, twrr_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, twrr_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.position_by_asset_mv_next.flag, twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.flow_by_asset_mv_next.flag ]
        ├── stream key: [ twrr_by_asset_mv_next.account_group_id, twrr_by_asset_mv_next.dim_balance_date, twrr_by_asset_mv_next.asset_id, twrr_by_asset_mv_next.position_by_asset_mv_next.position_type, twrr_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, twrr_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.position_by_asset_mv_next.source_entity_type, twrr_by_asset_mv_next.position_by_asset_mv_next.position_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.position_by_asset_mv_next.flag, twrr_by_asset_mv_next.position_by_asset_mv_next.position_summary_mv_next.source_entity_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.position_type, twrr_by_asset_mv_next.flow_by_asset_mv_next.asset_currency, twrr_by_asset_mv_next.flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, twrr_by_asset_mv_next.flow_by_asset_mv_next.currency_code, twrr_by_asset_mv_next.flow_by_asset_mv_next.flag ]
        ├── Upstream { output: [ account_group_id, dim_balance_date, asset_id, daily_subperiod_return, daily_subperiod_fair_value_return, position_by_asset_mv_next.position_type, currency_code, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.flag ], stream key: [] }
        └── BatchPlanNode { output: [ account_group_id, dim_balance_date, asset_id, daily_subperiod_return, daily_subperiod_fair_value_return, position_by_asset_mv_next.position_type, currency_code, position_by_asset_mv_next.position_values_mv_next.holding_currency_expanded, asset_currency, position_by_asset_mv_next.source_entity_type, position_by_asset_mv_next.position_values_mv_next.position_type_expanded, position_by_asset_mv_next.flag, position_by_asset_mv_next.position_summary_mv_next.source_entity_type, flow_by_asset_mv_next.position_type, flow_by_asset_mv_next.asset_currency, flow_by_asset_mv_next.flow_values_mv_next.position_type_expanded, flow_by_asset_mv_next.currency_code, flow_by_asset_mv_next.flag ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
