transactions_sink · explain

← cluster alinma_bff objects transactions_sink explain
Overview Objects Graph History
sink · alinma_bff.transactions_sink profiled over 5s
Job is idle — throughput ~0; structure shown.
Heat tree Operator graph
4 operators
Sink · alinma_bff.transactions_sink
0% idle 2 actors
StreamScan · book_of_business_transactions_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 61567 (Actor 739185,739184)
StreamSink { type: upsert, columns: [entity_type, entity_id, account_group_type, transaction_id, account_id, asset_id, transaction_type, status_id, side_id, currency_code, quantity, unit_price, gross_value, net_value, external_reference, creation_timestamp, valuation_timestamp, settlement_timestamp, type_id, order_id, description, source_asset_id, source_account_id, fee_type, fee_currency_code, fee_amount, fee_amount_system_currency, order_side_id, custom_fields, book_of_business_transactions_mv_next.account_to_account_groups_mv_next.account_id(hidden)], downstream_pk: [book_of_business_transactions_mv_next.entity_type, book_of_business_transactions_mv_next.entity_id, book_of_business_transactions_mv_next.account_group_type, book_of_business_transactions_mv_next.transaction_id, book_of_business_transactions_mv_next.account_id] }
├── output:
│   ┌── book_of_business_transactions_mv_next.entity_type
│   ├── book_of_business_transactions_mv_next.entity_id
│   ├── book_of_business_transactions_mv_next.account_group_type
│   ├── book_of_business_transactions_mv_next.transaction_id
│   ├── book_of_business_transactions_mv_next.account_id
│   ├── book_of_business_transactions_mv_next.asset_id
│   ├── book_of_business_transactions_mv_next.transaction_type
│   ├── book_of_business_transactions_mv_next.status_id
│   ├── book_of_business_transactions_mv_next.side_id
│   ├── book_of_business_transactions_mv_next.currency_code
│   ├── book_of_business_transactions_mv_next.quantity
│   ├── book_of_business_transactions_mv_next.unit_price
│   ├── book_of_business_transactions_mv_next.gross_value
│   ├── book_of_business_transactions_mv_next.net_value
│   ├── book_of_business_transactions_mv_next.external_reference
│   ├── book_of_business_transactions_mv_next.creation_timestamp
│   ├── book_of_business_transactions_mv_next.valuation_timestamp
│   ├── book_of_business_transactions_mv_next.settlement_timestamp
│   ├── book_of_business_transactions_mv_next.type_id
│   ├── book_of_business_transactions_mv_next.order_id
│   ├── book_of_business_transactions_mv_next.description
│   ├── book_of_business_transactions_mv_next.source_asset_id
│   ├── book_of_business_transactions_mv_next.source_account_id
│   ├── book_of_business_transactions_mv_next.fee_type
│   ├── book_of_business_transactions_mv_next.fee_currency_code
│   ├── book_of_business_transactions_mv_next.fee_amount
│   ├── book_of_business_transactions_mv_next.fee_amount_system_currency
│   ├── book_of_business_transactions_mv_next.order_side_id
│   ├── book_of_business_transactions_mv_next.custom_fields
│   └── book_of_business_transactions_mv_next.account_to_account_groups_mv_next.account_id
├── stream key: [ book_of_business_transactions_mv_next.transaction_id, book_of_business_transactions_mv_next.type_id, book_of_business_transactions_mv_next.account_to_account_groups_mv_next.account_id, book_of_business_transactions_mv_next.entity_type, book_of_business_transactions_mv_next.entity_id, book_of_business_transactions_mv_next.account_group_type ]
└── StreamTableScan { table: book_of_business_transactions_mv_next, columns: [entity_type, entity_id, account_group_type, transaction_id, account_id, asset_id, transaction_type, status_id, side_id, currency_code, quantity, unit_price, gross_value, net_value, external_reference, creation_timestamp, valuation_timestamp, settlement_timestamp, type_id, order_id, description, source_asset_id, source_account_id, fee_type, fee_currency_code, fee_amount, fee_amount_system_currency, order_side_id, custom_fields, account_to_account_groups_mv_next.account_id] }
    ├── output:
    │   ┌── book_of_business_transactions_mv_next.entity_type
    │   ├── book_of_business_transactions_mv_next.entity_id
    │   ├── book_of_business_transactions_mv_next.account_group_type
    │   ├── book_of_business_transactions_mv_next.transaction_id
    │   ├── book_of_business_transactions_mv_next.account_id
    │   ├── book_of_business_transactions_mv_next.asset_id
    │   ├── book_of_business_transactions_mv_next.transaction_type
    │   ├── book_of_business_transactions_mv_next.status_id
    │   ├── book_of_business_transactions_mv_next.side_id
    │   ├── book_of_business_transactions_mv_next.currency_code
    │   ├── book_of_business_transactions_mv_next.quantity
    │   ├── book_of_business_transactions_mv_next.unit_price
    │   ├── book_of_business_transactions_mv_next.gross_value
    │   ├── book_of_business_transactions_mv_next.net_value
    │   ├── book_of_business_transactions_mv_next.external_reference
    │   ├── book_of_business_transactions_mv_next.creation_timestamp
    │   ├── book_of_business_transactions_mv_next.valuation_timestamp
    │   ├── book_of_business_transactions_mv_next.settlement_timestamp
    │   ├── book_of_business_transactions_mv_next.type_id
    │   ├── book_of_business_transactions_mv_next.order_id
    │   ├── book_of_business_transactions_mv_next.description
    │   ├── book_of_business_transactions_mv_next.source_asset_id
    │   ├── book_of_business_transactions_mv_next.source_account_id
    │   ├── book_of_business_transactions_mv_next.fee_type
    │   ├── book_of_business_transactions_mv_next.fee_currency_code
    │   ├── book_of_business_transactions_mv_next.fee_amount
    │   ├── book_of_business_transactions_mv_next.fee_amount_system_currency
    │   ├── book_of_business_transactions_mv_next.order_side_id
    │   ├── book_of_business_transactions_mv_next.custom_fields
    │   └── book_of_business_transactions_mv_next.account_to_account_groups_mv_next.account_id
    ├── stream key: [ book_of_business_transactions_mv_next.transaction_id, book_of_business_transactions_mv_next.type_id, book_of_business_transactions_mv_next.account_to_account_groups_mv_next.account_id, book_of_business_transactions_mv_next.entity_type, book_of_business_transactions_mv_next.entity_id, book_of_business_transactions_mv_next.account_group_type ]
    ├── Upstream { output: [ entity_type, entity_id, account_group_type, transaction_id, account_id, asset_id, transaction_type, status_id, side_id, currency_code, quantity, unit_price, gross_value, net_value, external_reference, creation_timestamp, valuation_timestamp, settlement_timestamp, type_id, order_id, description, source_asset_id, source_account_id, fee_type, fee_currency_code, fee_amount, fee_amount_system_currency, order_side_id, custom_fields, account_to_account_groups_mv_next.account_id ], stream key: [] }
    └── BatchPlanNode { output: [ entity_type, entity_id, account_group_type, transaction_id, account_id, asset_id, transaction_type, status_id, side_id, currency_code, quantity, unit_price, gross_value, net_value, external_reference, creation_timestamp, valuation_timestamp, settlement_timestamp, type_id, order_id, description, source_asset_id, source_account_id, fee_type, fee_currency_code, fee_amount, fee_amount_system_currency, order_side_id, custom_fields, account_to_account_groups_mv_next.account_id ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
