sdk_home_overview_party_sink · explain

← cluster adib_rm objects sdk_home_overview_party_sink explain
Overview Objects Graph History
sink · adib_rm.sdk_home_overview_party_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
4 operators
Sink · adib_rm.sdk_home_overview_party_sink
0% idle 2 actors
StreamScan · sdk_home_overview_party_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 24771 (Actor 117418,117417)
StreamSink { type: upsert, columns: [party_id, base_currency_code, total_market_value, total_market_value_system_currency, unrealized_gain_loss, portfolios, cash_tiles, favourites, top_allocations, top_allocations_asset_type, top_allocations_sector, sdk_home_overview_party_mv_next.party_to_account_groups_mv.parties.id(hidden), sdk_home_overview_party_mv_next.party_to_account_groups_mv.null:Varchar(hidden), sdk_home_overview_party_mv_next.party_to_account_groups_mv.$src(hidden), sdk_home_overview_party_mv_next.position_snapshot_mv.holding_values_latest_mv_next.type_expanded(hidden), sdk_home_overview_party_mv_next.position_snapshot_mv.flag(hidden), sdk_home_overview_party_mv_next.party_to_account_groups_mv.account_group_id(hidden), sdk_home_overview_party_mv_next.pnl_snapshot_mv_next.position_type(hidden), sdk_home_overview_party_mv_next.intraday_position_summary_mv_next.position_type(hidden), sdk_home_overview_party_mv_next.party_top_allocations_mv_next.account_group_type(hidden), sdk_home_overview_party_mv_next.party_top_allocations_by_asset_type_mv_next.account_group_type(hidden), sdk_home_overview_party_mv_next.party_top_allocations_by_sector_mv_next.account_group_type(hidden)], downstream_pk: [sdk_home_overview_party_mv_next.party_id] }
├── output:
│   ┌── sdk_home_overview_party_mv_next.party_id
│   ├── sdk_home_overview_party_mv_next.base_currency_code
│   ├── sdk_home_overview_party_mv_next.total_market_value
│   ├── sdk_home_overview_party_mv_next.total_market_value_system_currency
│   ├── sdk_home_overview_party_mv_next.unrealized_gain_loss
│   ├── sdk_home_overview_party_mv_next.portfolios
│   ├── sdk_home_overview_party_mv_next.cash_tiles
│   ├── sdk_home_overview_party_mv_next.favourites
│   ├── sdk_home_overview_party_mv_next.top_allocations
│   ├── sdk_home_overview_party_mv_next.top_allocations_asset_type
│   ├── sdk_home_overview_party_mv_next.top_allocations_sector
│   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.parties.id
│   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.null:Varchar
│   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.$src
│   ├── sdk_home_overview_party_mv_next.position_snapshot_mv.holding_values_latest_mv_next.type_expanded
│   ├── sdk_home_overview_party_mv_next.position_snapshot_mv.flag
│   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.account_group_id
│   ├── sdk_home_overview_party_mv_next.pnl_snapshot_mv_next.position_type
│   ├── sdk_home_overview_party_mv_next.intraday_position_summary_mv_next.position_type
│   ├── sdk_home_overview_party_mv_next.party_top_allocations_mv_next.account_group_type
│   ├── sdk_home_overview_party_mv_next.party_top_allocations_by_asset_type_mv_next.account_group_type
│   └── sdk_home_overview_party_mv_next.party_top_allocations_by_sector_mv_next.account_group_type
├── stream key: [ sdk_home_overview_party_mv_next.party_id, sdk_home_overview_party_mv_next.party_to_account_groups_mv.parties.id, sdk_home_overview_party_mv_next.party_to_account_groups_mv.null:Varchar, sdk_home_overview_party_mv_next.party_to_account_groups_mv.$src, sdk_home_overview_party_mv_next.position_snapshot_mv.holding_values_latest_mv_next.type_expanded, sdk_home_overview_party_mv_next.position_snapshot_mv.flag, sdk_home_overview_party_mv_next.party_to_account_groups_mv.account_group_id, sdk_home_overview_party_mv_next.base_currency_code, sdk_home_overview_party_mv_next.pnl_snapshot_mv_next.position_type, sdk_home_overview_party_mv_next.intraday_position_summary_mv_next.position_type, sdk_home_overview_party_mv_next.party_top_allocations_mv_next.account_group_type, sdk_home_overview_party_mv_next.party_top_allocations_by_asset_type_mv_next.account_group_type, sdk_home_overview_party_mv_next.party_top_allocations_by_sector_mv_next.account_group_type ]
└── StreamTableScan { table: sdk_home_overview_party_mv_next, columns: [party_id, base_currency_code, total_market_value, total_market_value_system_currency, unrealized_gain_loss, portfolios, cash_tiles, favourites, top_allocations, top_allocations_asset_type, top_allocations_sector, party_to_account_groups_mv.parties.id, party_to_account_groups_mv.null:Varchar, party_to_account_groups_mv.$src, position_snapshot_mv.holding_values_latest_mv_next.type_expanded, position_snapshot_mv.flag, party_to_account_groups_mv.account_group_id, pnl_snapshot_mv_next.position_type, intraday_position_summary_mv_next.position_type, party_top_allocations_mv_next.account_group_type, party_top_allocations_by_asset_type_mv_next.account_group_type, party_top_allocations_by_sector_mv_next.account_group_type] }
    ├── output:
    │   ┌── sdk_home_overview_party_mv_next.party_id
    │   ├── sdk_home_overview_party_mv_next.base_currency_code
    │   ├── sdk_home_overview_party_mv_next.total_market_value
    │   ├── sdk_home_overview_party_mv_next.total_market_value_system_currency
    │   ├── sdk_home_overview_party_mv_next.unrealized_gain_loss
    │   ├── sdk_home_overview_party_mv_next.portfolios
    │   ├── sdk_home_overview_party_mv_next.cash_tiles
    │   ├── sdk_home_overview_party_mv_next.favourites
    │   ├── sdk_home_overview_party_mv_next.top_allocations
    │   ├── sdk_home_overview_party_mv_next.top_allocations_asset_type
    │   ├── sdk_home_overview_party_mv_next.top_allocations_sector
    │   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.parties.id
    │   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.null:Varchar
    │   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.$src
    │   ├── sdk_home_overview_party_mv_next.position_snapshot_mv.holding_values_latest_mv_next.type_expanded
    │   ├── sdk_home_overview_party_mv_next.position_snapshot_mv.flag
    │   ├── sdk_home_overview_party_mv_next.party_to_account_groups_mv.account_group_id
    │   ├── sdk_home_overview_party_mv_next.pnl_snapshot_mv_next.position_type
    │   ├── sdk_home_overview_party_mv_next.intraday_position_summary_mv_next.position_type
    │   ├── sdk_home_overview_party_mv_next.party_top_allocations_mv_next.account_group_type
    │   ├── sdk_home_overview_party_mv_next.party_top_allocations_by_asset_type_mv_next.account_group_type
    │   └── sdk_home_overview_party_mv_next.party_top_allocations_by_sector_mv_next.account_group_type
    ├── stream key: [ sdk_home_overview_party_mv_next.party_id, sdk_home_overview_party_mv_next.party_to_account_groups_mv.parties.id, sdk_home_overview_party_mv_next.party_to_account_groups_mv.null:Varchar, sdk_home_overview_party_mv_next.party_to_account_groups_mv.$src, sdk_home_overview_party_mv_next.position_snapshot_mv.holding_values_latest_mv_next.type_expanded, sdk_home_overview_party_mv_next.position_snapshot_mv.flag, sdk_home_overview_party_mv_next.party_to_account_groups_mv.account_group_id, sdk_home_overview_party_mv_next.base_currency_code, sdk_home_overview_party_mv_next.pnl_snapshot_mv_next.position_type, sdk_home_overview_party_mv_next.intraday_position_summary_mv_next.position_type, sdk_home_overview_party_mv_next.party_top_allocations_mv_next.account_group_type, sdk_home_overview_party_mv_next.party_top_allocations_by_asset_type_mv_next.account_group_type, sdk_home_overview_party_mv_next.party_top_allocations_by_sector_mv_next.account_group_type ]
    ├── Upstream { output: [ party_id, base_currency_code, total_market_value, total_market_value_system_currency, unrealized_gain_loss, portfolios, cash_tiles, favourites, top_allocations, top_allocations_asset_type, top_allocations_sector, party_to_account_groups_mv.parties.id, party_to_account_groups_mv.null:Varchar, party_to_account_groups_mv.$src, position_snapshot_mv.holding_values_latest_mv_next.type_expanded, position_snapshot_mv.flag, party_to_account_groups_mv.account_group_id, pnl_snapshot_mv_next.position_type, intraday_position_summary_mv_next.position_type, party_top_allocations_mv_next.account_group_type, party_top_allocations_by_asset_type_mv_next.account_group_type, party_top_allocations_by_sector_mv_next.account_group_type ], stream key: [] }
    └── BatchPlanNode { output: [ party_id, base_currency_code, total_market_value, total_market_value_system_currency, unrealized_gain_loss, portfolios, cash_tiles, favourites, top_allocations, top_allocations_asset_type, top_allocations_sector, party_to_account_groups_mv.parties.id, party_to_account_groups_mv.null:Varchar, party_to_account_groups_mv.$src, position_snapshot_mv.holding_values_latest_mv_next.type_expanded, position_snapshot_mv.flag, party_to_account_groups_mv.account_group_id, pnl_snapshot_mv_next.position_type, intraday_position_summary_mv_next.position_type, party_top_allocations_mv_next.account_group_type, party_top_allocations_by_asset_type_mv_next.account_group_type, party_top_allocations_by_sector_mv_next.account_group_type ], stream key: [] }
RWM Console cluster: risingwave-adib.adib-rw.svc.cluster.local
