notes_sink · explain — RWM Console

sink · alinma_bff.notes_sink profiled over 5s

Job is idle — throughput ~0; structure shown.

Heat tree Operator graph

6 operators

Sink · alinma_bff.notes_sink

0% idle 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

StreamScan · notes_mv

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 52951 (Actor 738452,738453)
StreamSink { type: upsert, columns: [id, content_text, content_format, created_at, updated_at, is_archived, archived_at, client_id, portfolio_id, account_id, draft_account_id, party_id, entity_type, entity_id, tag_ids, created_by_id, updated_by_id, client_display_name, client_local_display_name, client_preferred_name, client_customer_identification_file, portfolio_number, portfolio_owners, account_name, account_number, account_owners], downstream_pk: [notes_mv.id] }
├── output:
│   ┌── notes_mv.id
│   ├── notes_mv.content_text
│   ├── notes_mv.content_format
│   ├── notes_mv.created_at
│   ├── notes_mv.updated_at
│   ├── notes_mv.is_archived
│   ├── notes_mv.archived_at
│   ├── notes_mv.client_id
│   ├── notes_mv.portfolio_id
│   ├── notes_mv.account_id
│   ├── notes_mv.draft_account_id
│   ├── notes_mv.party_id
│   ├── notes_mv.entity_type
│   ├── notes_mv.entity_id
│   ├── notes_mv.tag_ids
│   ├── notes_mv.created_by_id
│   ├── notes_mv.updated_by_id
│   ├── notes_mv.client_display_name
│   ├── notes_mv.client_local_display_name
│   ├── notes_mv.client_preferred_name
│   ├── notes_mv.client_customer_identification_file
│   ├── notes_mv.portfolio_number
│   ├── notes_mv.portfolio_owners
│   ├── notes_mv.account_name
│   ├── notes_mv.account_number
│   └── notes_mv.account_owners
├── stream key: [ notes_mv.account_id, notes_mv.portfolio_id, notes_mv.client_id, notes_mv.id ]
└── MergeExecutor
    ├── output:
    │   ┌── notes_mv.id
    │   ├── notes_mv.content_text
    │   ├── notes_mv.content_format
    │   ├── notes_mv.created_at
    │   ├── notes_mv.updated_at
    │   ├── notes_mv.is_archived
    │   ├── notes_mv.archived_at
    │   ├── notes_mv.client_id
    │   ├── notes_mv.portfolio_id
    │   ├── notes_mv.account_id
    │   ├── notes_mv.draft_account_id
    │   ├── notes_mv.party_id
    │   ├── notes_mv.entity_type
    │   ├── notes_mv.entity_id
    │   ├── notes_mv.tag_ids
    │   ├── notes_mv.created_by_id
    │   ├── notes_mv.updated_by_id
    │   ├── notes_mv.client_display_name
    │   ├── notes_mv.client_local_display_name
    │   ├── notes_mv.client_preferred_name
    │   ├── notes_mv.client_customer_identification_file
    │   ├── notes_mv.portfolio_number
    │   ├── notes_mv.portfolio_owners
    │   ├── notes_mv.account_name
    │   ├── notes_mv.account_number
    │   └── notes_mv.account_owners
    └── stream key: [ notes_mv.account_id, notes_mv.portfolio_id, notes_mv.client_id, notes_mv.id ]

Fragment 52952 (Actor 738590,738591)
StreamTableScan { table: notes_mv, columns: [id, content_text, content_format, created_at, updated_at, is_archived, archived_at, client_id, portfolio_id, account_id, draft_account_id, party_id, entity_type, entity_id, tag_ids, created_by_id, updated_by_id, client_display_name, client_local_display_name, client_preferred_name, client_customer_identification_file, portfolio_number, portfolio_owners, account_name, account_number, account_owners] }
├── output:
│   ┌── notes_mv.id
│   ├── notes_mv.content_text
│   ├── notes_mv.content_format
│   ├── notes_mv.created_at
│   ├── notes_mv.updated_at
│   ├── notes_mv.is_archived
│   ├── notes_mv.archived_at
│   ├── notes_mv.client_id
│   ├── notes_mv.portfolio_id
│   ├── notes_mv.account_id
│   ├── notes_mv.draft_account_id
│   ├── notes_mv.party_id
│   ├── notes_mv.entity_type
│   ├── notes_mv.entity_id
│   ├── notes_mv.tag_ids
│   ├── notes_mv.created_by_id
│   ├── notes_mv.updated_by_id
│   ├── notes_mv.client_display_name
│   ├── notes_mv.client_local_display_name
│   ├── notes_mv.client_preferred_name
│   ├── notes_mv.client_customer_identification_file
│   ├── notes_mv.portfolio_number
│   ├── notes_mv.portfolio_owners
│   ├── notes_mv.account_name
│   ├── notes_mv.account_number
│   └── notes_mv.account_owners
├── stream key: [ notes_mv.account_id, notes_mv.portfolio_id, notes_mv.client_id, notes_mv.id ]
├── Upstream { output: [ id, content_text, content_format, created_at, updated_at, is_archived, archived_at, client_id, portfolio_id, account_id, draft_account_id, party_id, entity_type, entity_id, tag_ids, created_by_id, updated_by_id, client_display_name, client_local_display_name, client_preferred_name, client_customer_identification_file, portfolio_number, portfolio_owners, account_name, account_number, account_owners ], stream key: [] }
└── BatchPlanNode { output: [ id, content_text, content_format, created_at, updated_at, is_archived, archived_at, client_id, portfolio_id, account_id, draft_account_id, party_id, entity_type, entity_id, tag_ids, created_by_id, updated_by_id, client_display_name, client_local_display_name, client_preferred_name, client_customer_identification_file, portfolio_number, portfolio_owners, account_name, account_number, account_owners ], stream key: [] }

RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local