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

← cluster insights objects account_to_account_groups_sink explain
Overview Objects Graph History
sink · insights.account_to_account_groups_sink profiled over 5s
seconds (1–30)

Job is idle — throughput ~0; structure shown.

6 operators
Sink · insights.account_to_account_groups_sink
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · account_to_account_groups_membership_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.
Sink · insights.account_to_account_groups_sink Sink insights.account_to_acc… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamScan · account_to_account_groups_membership_mv_next StreamScan account_to_account_grou… idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand 
Fragment 62309 (Actor 741528,741529)
StreamSink
├─type: upsert
├─columns: [account_id, account_group_id, effective_start_date, effective_end_date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1(hidden), account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src(hidden), account_to_account_groups_membership_mv_next.$src(hidden)]
└─downstream_pk: [account_to_account_groups_membership_mv_next.account_id, account_to_account_groups_membership_mv_next.account_group_id, account_to_account_groups_membership_mv_next.effective_start_date]
├── output: [ account_to_account_groups_membership_mv_next.account_id, account_to_account_groups_membership_mv_next.account_group_id, account_to_account_groups_membership_mv_next.effective_start_date, account_to_account_groups_membership_mv_next.effective_end_date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.$src ]
├── stream key: [ account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.$src ]
└── MergeExecutor
    ├── output: [ account_to_account_groups_membership_mv_next.account_id, account_to_account_groups_membership_mv_next.account_group_id, account_to_account_groups_membership_mv_next.effective_start_date, account_to_account_groups_membership_mv_next.effective_end_date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.$src ]
    └── stream key: [ account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.$src ]

Fragment 62310 (Actor 738639,738638)
StreamTableScan { table: account_to_account_groups_membership_mv_next, columns: [account_id, account_group_id, effective_start_date, effective_end_date, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, $src] }
├── output: [ account_to_account_groups_membership_mv_next.account_id, account_to_account_groups_membership_mv_next.account_group_id, account_to_account_groups_membership_mv_next.effective_start_date, account_to_account_groups_membership_mv_next.effective_end_date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.$src ]
├── stream key: [ account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_group_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_membership_mv_next.account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_membership_mv_next.$src ]
├── Upstream { output: [ account_id, account_group_id, effective_start_date, effective_end_date, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, $src ], stream key: [] }
└── BatchPlanNode { output: [ account_id, account_group_id, effective_start_date, effective_end_date, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, $src ], stream key: [] }