client_to_account_groups_mv · explain

materialized view · insights.client_to_account_groups_mv profiled over 5s

Job is idle — throughput ~0; structure shown.

Heat tree Operator graph

24 operators

Materialize · insights.client_to_account_groups_mv

0% idle 2 actors

Union

0% idle 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project

— — 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project · clients_dm

— — 2 actors

Filter · clients_dm

0% idle 2 actors

StreamScan · clients_dm

0% idle 2 actors

BatchPlan

— — 2 actors

Merge

— — 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project

— — 2 actors

Merge

— — 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project

— — 2 actors

Merge

— — 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project

— — 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 9725 (Actor 32829,32830)
StreamMaterialize { columns: [client_id, account_group_id, type, $src(hidden)], stream_key: [client_id, $src], pk_columns: [client_id, $src], pk_conflict: NoCheck }
├── output: [ clients_dm.id, $expr1, 'all':Varchar, $src ]
├── stream key: [ clients_dm.id, $src ]
└── StreamUnion { all: true } { output: [ clients_dm.id, $expr1, 'all':Varchar, $src ], stream key: [ clients_dm.id, $src ] }
    ├── MergeExecutor { output: [ clients_dm.id, $expr1, 'all':Varchar, 0:Int32 ], stream key: [ clients_dm.id ] }
    ├── MergeExecutor { output: [ clients_dm.id, $expr2, 'restricted':Varchar, 1:Int32 ], stream key: [ clients_dm.id ] }
    ├── MergeExecutor { output: [ clients_dm.id, $expr3, 'un_restricted':Varchar, 2:Int32 ], stream key: [ clients_dm.id ] }
    └── MergeExecutor { output: [ clients_dm.id, $expr4, 'none':Varchar, 3:Int32 ], stream key: [ clients_dm.id ] }

Fragment 9726 (Actor 32832,32831)
StreamProject { exprs: [clients_dm.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(clients_dm.id, 'all':Varchar)::Bytea)) as $expr1, 'all':Varchar, 0:Int32] }
├── output: [ clients_dm.id, $expr1, 'all':Varchar, 0:Int32 ]
├── stream key: [ clients_dm.id ]
└── MergeExecutor { output: [ clients_dm.id ], stream key: [ clients_dm.id ] }

Fragment 9727 (Actor 32833,32834)
StreamProject { exprs: [clients_dm.id] } { output: [ clients_dm.id ], stream key: [ clients_dm.id ] }
└── StreamFilter { predicate: IsNull(clients_dm.closing_date) AND Not(IsTrue(clients_dm.m_is_stub)) }
    ├── output: [ clients_dm.id, clients_dm.closing_date, clients_dm.m_is_stub ]
    ├── stream key: [ clients_dm.id ]
    └── StreamTableScan { table: clients_dm, columns: [id, closing_date, m_is_stub] }
        ├── output: [ clients_dm.id, clients_dm.closing_date, clients_dm.m_is_stub ]
        ├── stream key: [ clients_dm.id ]
        ├── Upstream { output: [ id, closing_date, m_is_stub ], stream key: [] }
        └── BatchPlanNode { output: [ id, closing_date, m_is_stub ], stream key: [] }

Fragment 9728 (Actor 32835,32836)
StreamProject { exprs: [clients_dm.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(clients_dm.id, 'restricted':Varchar)::Bytea)) as $expr2, 'restricted':Varchar, 1:Int32] }
├── output: [ clients_dm.id, $expr2, 'restricted':Varchar, 1:Int32 ]
├── stream key: [ clients_dm.id ]
└── MergeExecutor { output: [ clients_dm.id ], stream key: [ clients_dm.id ] }

Fragment 9729 (Actor 32840,32839)
StreamProject { exprs: [clients_dm.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(clients_dm.id, 'un_restricted':Varchar)::Bytea)) as $expr3, 'un_restricted':Varchar, 2:Int32] }
├── output: [ clients_dm.id, $expr3, 'un_restricted':Varchar, 2:Int32 ]
├── stream key: [ clients_dm.id ]
└── MergeExecutor { output: [ clients_dm.id ], stream key: [ clients_dm.id ] }

Fragment 9730 (Actor 32838,32837)
StreamProject { exprs: [clients_dm.id, ConcatOp('account_group_':Varchar, Md5(ConcatOp(clients_dm.id, 'none':Varchar)::Bytea)) as $expr4, 'none':Varchar, 3:Int32] }
├── output: [ clients_dm.id, $expr4, 'none':Varchar, 3:Int32 ]
├── stream key: [ clients_dm.id ]
└── MergeExecutor { output: [ clients_dm.id ], stream key: [ clients_dm.id ] }

RWM Console cluster: risingwave.platform.svc.cluster.local