portfolios_sink · explain

← cluster alinma_bff objects portfolios_sink explain
Overview Objects Graph History
sink · alinma_bff.portfolios_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
6 operators
Sink · alinma_bff.portfolios_sink
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · book_of_business_portfolios_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 61609 (Actor 739504,739503)
StreamSink { type: upsert, columns: [portfolio_id, number, base_currency_code, service_type_id, service_type, opening_date, closing_date, created_at, account_group_type, status_label_id, status_name_en, status_name_ar, status_color, currency_code, currency_name_en, currency_name_ar, currency_symbol, owners, owner_count, task_active_count, task_high_priority_count, market_value, fair_value, market_value_system_currency, fair_value_system_currency, reference_identifiers, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id(hidden), book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id(hidden), book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src(hidden), book_of_business_portfolios_mv_next.$src(hidden), book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded(hidden), book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag(hidden)], downstream_pk: [book_of_business_portfolios_mv_next.portfolio_id, book_of_business_portfolios_mv_next.account_group_type] }
├── output:
│   ┌── book_of_business_portfolios_mv_next.portfolio_id
│   ├── book_of_business_portfolios_mv_next.number
│   ├── book_of_business_portfolios_mv_next.base_currency_code
│   ├── book_of_business_portfolios_mv_next.service_type_id
│   ├── book_of_business_portfolios_mv_next.service_type
│   ├── book_of_business_portfolios_mv_next.opening_date
│   ├── book_of_business_portfolios_mv_next.closing_date
│   ├── book_of_business_portfolios_mv_next.created_at
│   ├── book_of_business_portfolios_mv_next.account_group_type
│   ├── book_of_business_portfolios_mv_next.status_label_id
│   ├── book_of_business_portfolios_mv_next.status_name_en
│   ├── book_of_business_portfolios_mv_next.status_name_ar
│   ├── book_of_business_portfolios_mv_next.status_color
│   ├── book_of_business_portfolios_mv_next.currency_code
│   ├── book_of_business_portfolios_mv_next.currency_name_en
│   ├── book_of_business_portfolios_mv_next.currency_name_ar
│   ├── book_of_business_portfolios_mv_next.currency_symbol
│   ├── book_of_business_portfolios_mv_next.owners
│   ├── book_of_business_portfolios_mv_next.owner_count
│   ├── book_of_business_portfolios_mv_next.task_active_count
│   ├── book_of_business_portfolios_mv_next.task_high_priority_count
│   ├── book_of_business_portfolios_mv_next.market_value
│   ├── book_of_business_portfolios_mv_next.fair_value
│   ├── book_of_business_portfolios_mv_next.market_value_system_currency
│   ├── book_of_business_portfolios_mv_next.fair_value_system_currency
│   ├── book_of_business_portfolios_mv_next.reference_identifiers
│   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id
│   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id
│   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src
│   ├── book_of_business_portfolios_mv_next.$src
│   ├── book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded
│   └── book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag
├── stream key: [ book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id, book_of_business_portfolios_mv_next.currency_code, book_of_business_portfolios_mv_next.portfolio_id, book_of_business_portfolios_mv_next.status_label_id, book_of_business_portfolios_mv_next.service_type_id, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src, book_of_business_portfolios_mv_next.$src, book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded, book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag ]
└── MergeExecutor
    ├── output:
    │   ┌── book_of_business_portfolios_mv_next.portfolio_id
    │   ├── book_of_business_portfolios_mv_next.number
    │   ├── book_of_business_portfolios_mv_next.base_currency_code
    │   ├── book_of_business_portfolios_mv_next.service_type_id
    │   ├── book_of_business_portfolios_mv_next.service_type
    │   ├── book_of_business_portfolios_mv_next.opening_date
    │   ├── book_of_business_portfolios_mv_next.closing_date
    │   ├── book_of_business_portfolios_mv_next.created_at
    │   ├── book_of_business_portfolios_mv_next.account_group_type
    │   ├── book_of_business_portfolios_mv_next.status_label_id
    │   ├── book_of_business_portfolios_mv_next.status_name_en
    │   ├── book_of_business_portfolios_mv_next.status_name_ar
    │   ├── book_of_business_portfolios_mv_next.status_color
    │   ├── book_of_business_portfolios_mv_next.currency_code
    │   ├── book_of_business_portfolios_mv_next.currency_name_en
    │   ├── book_of_business_portfolios_mv_next.currency_name_ar
    │   ├── book_of_business_portfolios_mv_next.currency_symbol
    │   ├── book_of_business_portfolios_mv_next.owners
    │   ├── book_of_business_portfolios_mv_next.owner_count
    │   ├── book_of_business_portfolios_mv_next.task_active_count
    │   ├── book_of_business_portfolios_mv_next.task_high_priority_count
    │   ├── book_of_business_portfolios_mv_next.market_value
    │   ├── book_of_business_portfolios_mv_next.fair_value
    │   ├── book_of_business_portfolios_mv_next.market_value_system_currency
    │   ├── book_of_business_portfolios_mv_next.fair_value_system_currency
    │   ├── book_of_business_portfolios_mv_next.reference_identifiers
    │   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id
    │   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id
    │   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src
    │   ├── book_of_business_portfolios_mv_next.$src
    │   ├── book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded
    │   └── book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag
    └── stream key: [ book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id, book_of_business_portfolios_mv_next.currency_code, book_of_business_portfolios_mv_next.portfolio_id, book_of_business_portfolios_mv_next.status_label_id, book_of_business_portfolios_mv_next.service_type_id, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src, book_of_business_portfolios_mv_next.$src, book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded, book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag ]

Fragment 61610 (Actor 739505,739506)
StreamTableScan { table: book_of_business_portfolios_mv_next, columns: [portfolio_id, number, base_currency_code, service_type_id, service_type, opening_date, closing_date, created_at, account_group_type, status_label_id, status_name_en, status_name_ar, status_color, currency_code, currency_name_en, currency_name_ar, currency_symbol, owners, owner_count, task_active_count, task_high_priority_count, market_value, fair_value, market_value_system_currency, fair_value_system_currency, reference_identifiers, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, $src, position_snapshot_mv_next.holding_values_latest_mv.type_expanded, position_snapshot_mv_next.flag] }
├── output:
│   ┌── book_of_business_portfolios_mv_next.portfolio_id
│   ├── book_of_business_portfolios_mv_next.number
│   ├── book_of_business_portfolios_mv_next.base_currency_code
│   ├── book_of_business_portfolios_mv_next.service_type_id
│   ├── book_of_business_portfolios_mv_next.service_type
│   ├── book_of_business_portfolios_mv_next.opening_date
│   ├── book_of_business_portfolios_mv_next.closing_date
│   ├── book_of_business_portfolios_mv_next.created_at
│   ├── book_of_business_portfolios_mv_next.account_group_type
│   ├── book_of_business_portfolios_mv_next.status_label_id
│   ├── book_of_business_portfolios_mv_next.status_name_en
│   ├── book_of_business_portfolios_mv_next.status_name_ar
│   ├── book_of_business_portfolios_mv_next.status_color
│   ├── book_of_business_portfolios_mv_next.currency_code
│   ├── book_of_business_portfolios_mv_next.currency_name_en
│   ├── book_of_business_portfolios_mv_next.currency_name_ar
│   ├── book_of_business_portfolios_mv_next.currency_symbol
│   ├── book_of_business_portfolios_mv_next.owners
│   ├── book_of_business_portfolios_mv_next.owner_count
│   ├── book_of_business_portfolios_mv_next.task_active_count
│   ├── book_of_business_portfolios_mv_next.task_high_priority_count
│   ├── book_of_business_portfolios_mv_next.market_value
│   ├── book_of_business_portfolios_mv_next.fair_value
│   ├── book_of_business_portfolios_mv_next.market_value_system_currency
│   ├── book_of_business_portfolios_mv_next.fair_value_system_currency
│   ├── book_of_business_portfolios_mv_next.reference_identifiers
│   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id
│   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id
│   ├── book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src
│   ├── book_of_business_portfolios_mv_next.$src
│   ├── book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded
│   └── book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag
├── stream key: [ book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.account_group_id, book_of_business_portfolios_mv_next.currency_code, book_of_business_portfolios_mv_next.portfolio_id, book_of_business_portfolios_mv_next.status_label_id, book_of_business_portfolios_mv_next.service_type_id, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.portfolio_id, book_of_business_portfolios_mv_next.portfolio_to_account_groups_mv.$src, book_of_business_portfolios_mv_next.$src, book_of_business_portfolios_mv_next.position_snapshot_mv_next.holding_values_latest_mv.type_expanded, book_of_business_portfolios_mv_next.position_snapshot_mv_next.flag ]
├── Upstream { output: [ portfolio_id, number, base_currency_code, service_type_id, service_type, opening_date, closing_date, created_at, account_group_type, status_label_id, status_name_en, status_name_ar, status_color, currency_code, currency_name_en, currency_name_ar, currency_symbol, owners, owner_count, task_active_count, task_high_priority_count, market_value, fair_value, market_value_system_currency, fair_value_system_currency, reference_identifiers, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, $src, position_snapshot_mv_next.holding_values_latest_mv.type_expanded, position_snapshot_mv_next.flag ], stream key: [] }
└── BatchPlanNode { output: [ portfolio_id, number, base_currency_code, service_type_id, service_type, opening_date, closing_date, created_at, account_group_type, status_label_id, status_name_en, status_name_ar, status_color, currency_code, currency_name_en, currency_name_ar, currency_symbol, owners, owner_count, task_active_count, task_high_priority_count, market_value, fair_value, market_value_system_currency, fair_value_system_currency, reference_identifiers, portfolio_to_account_groups_mv.account_group_id, portfolio_to_account_groups_mv.portfolio_id, portfolio_to_account_groups_mv.$src, $src, position_snapshot_mv_next.holding_values_latest_mv.type_expanded, position_snapshot_mv_next.flag ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
