party_advisor_kpi_counts_mv · explain

materialized view · alinma_bff.party_advisor_kpi_counts_mv profiled over 5s

Job is idle — throughput ~0; structure shown.

Aggregation state — unbounded unless keyed or temporally filtered

Heat tree Operator graph

25 operators

Materialize · alinma_bff.party_advisor_kpi_counts_mv

0% idle 2 actors

Project

— — 2 actors

HashAgg Aggregation state — unbounded unless keyed or temporally filtered

0% idle 2 actors

LocalityProvider

0% idle 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Union

0% idle 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project · party_advisor_kpi_user_accounts_mv

— — 2 actors

StreamScan · party_advisor_kpi_user_accounts_mv

0% idle 2 actors

BatchPlan

— — 2 actors

Merge

— — 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project · party_advisor_kpi_user_portfolios_mv_next

— — 2 actors

StreamScan · party_advisor_kpi_user_portfolios_mv_next

0% idle 2 actors

BatchPlan

— — 2 actors

Merge

— — 2 actors

Merge

— — 2 actors

Exchange

0% idle 0 actors

Project · party_advisor_kpi_user_customers_mv

— — 2 actors

StreamScan · party_advisor_kpi_user_customers_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 60115 (Actor 737317,737318)
StreamMaterialize { columns: [user_id, clients_count, portfolios_count, accounts_count], stream_key: [user_id], pk_columns: [user_id], pk_conflict: NoCheck }
├── output: [ party_advisor_kpi_user_customers_mv.user_id, $expr1, $expr2, $expr3 ]
├── stream key: [ party_advisor_kpi_user_customers_mv.user_id ]
└── StreamProject { exprs: [party_advisor_kpi_user_customers_mv.user_id, sum(1:Int32)::Int32 as $expr1, sum(0:Int32)::Int32 as $expr2, sum(0:Int32)::Int32 as $expr3] }
    ├── output: [ party_advisor_kpi_user_customers_mv.user_id, $expr1, $expr2, $expr3 ]
    ├── stream key: [ party_advisor_kpi_user_customers_mv.user_id ]
    └── StreamHashAgg { group_key: [party_advisor_kpi_user_customers_mv.user_id], aggs: [sum(1:Int32), sum(0:Int32), sum(0:Int32), count] }
        ├── output: [ party_advisor_kpi_user_customers_mv.user_id, sum(1:Int32), sum(0:Int32), sum(0:Int32), count ]
        ├── stream key: [ party_advisor_kpi_user_customers_mv.user_id ]
        └── StreamLocalityProvider { locality_columns: [party_advisor_kpi_user_customers_mv.user_id] }
            ├── output:
            │   ┌── party_advisor_kpi_user_customers_mv.user_id
            │   ├── 1:Int32
            │   ├── 0:Int32
            │   ├── 0:Int32
            │   ├── party_advisor_kpi_user_customers_mv.user_id
            │   ├── party_advisor_kpi_user_customers_mv.party_id
            │   ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
            │   └── $src
            ├── stream key:
            │   ┌── party_advisor_kpi_user_customers_mv.user_id
            │   ├── party_advisor_kpi_user_customers_mv.user_id
            │   ├── party_advisor_kpi_user_customers_mv.party_id
            │   ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
            │   └── $src
            └── MergeExecutor
                ├── output:
                │   ┌── party_advisor_kpi_user_customers_mv.user_id
                │   ├── 1:Int32
                │   ├── 0:Int32
                │   ├── 0:Int32
                │   ├── party_advisor_kpi_user_customers_mv.user_id
                │   ├── party_advisor_kpi_user_customers_mv.party_id
                │   ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
                │   └── $src
                └── stream key:
                    ┌── party_advisor_kpi_user_customers_mv.user_id
                    ├── party_advisor_kpi_user_customers_mv.party_id
                    ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
                    └── $src

Fragment 60116 (Actor 737319,737320)
StreamUnion { all: true }
├── output:
│   ┌── party_advisor_kpi_user_customers_mv.user_id
│   ├── 1:Int32
│   ├── 0:Int32
│   ├── 0:Int32
│   ├── party_advisor_kpi_user_customers_mv.user_id
│   ├── party_advisor_kpi_user_customers_mv.party_id
│   ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
│   └── $src
├── stream key:
│   ┌── party_advisor_kpi_user_customers_mv.user_id
│   ├── party_advisor_kpi_user_customers_mv.party_id
│   ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
│   └── $src
├── MergeExecutor
│   ├── output:
│   │   ┌── party_advisor_kpi_user_customers_mv.user_id
│   │   ├── 1:Int32
│   │   ├── 0:Int32
│   │   ├── 0:Int32
│   │   ├── party_advisor_kpi_user_customers_mv.user_id
│   │   ├── party_advisor_kpi_user_customers_mv.party_id
│   │   ├── party_advisor_kpi_user_customers_mv.customer_relationship_id
│   │   └── 0:Int32
│   └── stream key:
│       ┌── party_advisor_kpi_user_customers_mv.user_id
│       ├── party_advisor_kpi_user_customers_mv.party_id
│       └── party_advisor_kpi_user_customers_mv.customer_relationship_id
├── MergeExecutor
│   ├── output:
│   │   ┌── party_advisor_kpi_user_portfolios_mv_next.user_id
│   │   ├── 0:Int32
│   │   ├── 1:Int32
│   │   ├── 0:Int32
│   │   ├── party_advisor_kpi_user_portfolios_mv_next.user_id
│   │   ├── party_advisor_kpi_user_portfolios_mv_next.portfolio_id
│   │   ├── null:Varchar
│   │   └── 1:Int32
│   └── stream key: [ party_advisor_kpi_user_portfolios_mv_next.user_id, party_advisor_kpi_user_portfolios_mv_next.portfolio_id ]
└── MergeExecutor
    ├── output:
    │   ┌── party_advisor_kpi_user_accounts_mv.user_id
    │   ├── 0:Int32
    │   ├── 0:Int32
    │   ├── 1:Int32
    │   ├── party_advisor_kpi_user_accounts_mv.user_id
    │   ├── party_advisor_kpi_user_accounts_mv.account_id
    │   ├── null:Varchar
    │   └── 2:Int32
    └── stream key: [ party_advisor_kpi_user_accounts_mv.user_id, party_advisor_kpi_user_accounts_mv.account_id ]

Fragment 60117 (Actor 736707,736706)
StreamProject { exprs: [party_advisor_kpi_user_customers_mv.user_id, 1:Int32, 0:Int32, 0:Int32, party_advisor_kpi_user_customers_mv.user_id, party_advisor_kpi_user_customers_mv.party_id, party_advisor_kpi_user_customers_mv.customer_relationship_id, 0:Int32] }
├── output: [ party_advisor_kpi_user_customers_mv.user_id, 1:Int32, 0:Int32, 0:Int32, party_advisor_kpi_user_customers_mv.user_id, party_advisor_kpi_user_customers_mv.party_id, party_advisor_kpi_user_customers_mv.customer_relationship_id, 0:Int32 ]
├── stream key: [ party_advisor_kpi_user_customers_mv.user_id, party_advisor_kpi_user_customers_mv.party_id, party_advisor_kpi_user_customers_mv.customer_relationship_id ]
└── StreamTableScan { table: party_advisor_kpi_user_customers_mv, columns: [user_id, party_id, customer_relationship_id] }
    ├── output: [ party_advisor_kpi_user_customers_mv.user_id, party_advisor_kpi_user_customers_mv.party_id, party_advisor_kpi_user_customers_mv.customer_relationship_id ]
    ├── stream key: [ party_advisor_kpi_user_customers_mv.user_id, party_advisor_kpi_user_customers_mv.party_id, party_advisor_kpi_user_customers_mv.customer_relationship_id ]
    ├── Upstream { output: [ user_id, party_id, customer_relationship_id ], stream key: [] }
    └── BatchPlanNode { output: [ user_id, party_id, customer_relationship_id ], stream key: [] }

Fragment 60118 (Actor 737438,737439)
StreamProject { exprs: [party_advisor_kpi_user_portfolios_mv_next.user_id, 0:Int32, 1:Int32, 0:Int32, party_advisor_kpi_user_portfolios_mv_next.user_id, party_advisor_kpi_user_portfolios_mv_next.portfolio_id, null:Varchar, 1:Int32] }
├── output: [ party_advisor_kpi_user_portfolios_mv_next.user_id, 0:Int32, 1:Int32, 0:Int32, party_advisor_kpi_user_portfolios_mv_next.user_id, party_advisor_kpi_user_portfolios_mv_next.portfolio_id, null:Varchar, 1:Int32 ]
├── stream key: [ party_advisor_kpi_user_portfolios_mv_next.user_id, party_advisor_kpi_user_portfolios_mv_next.portfolio_id ]
└── StreamTableScan { table: party_advisor_kpi_user_portfolios_mv_next, columns: [user_id, portfolio_id] }
    ├── output: [ party_advisor_kpi_user_portfolios_mv_next.user_id, party_advisor_kpi_user_portfolios_mv_next.portfolio_id ]
    ├── stream key: [ party_advisor_kpi_user_portfolios_mv_next.user_id, party_advisor_kpi_user_portfolios_mv_next.portfolio_id ]
    ├── Upstream { output: [ user_id, portfolio_id ], stream key: [] }
    └── BatchPlanNode { output: [ user_id, portfolio_id ], stream key: [] }

Fragment 60119 (Actor 737443,737442)
StreamProject { exprs: [party_advisor_kpi_user_accounts_mv.user_id, 0:Int32, 0:Int32, 1:Int32, party_advisor_kpi_user_accounts_mv.user_id, party_advisor_kpi_user_accounts_mv.account_id, null:Varchar, 2:Int32] }
├── output: [ party_advisor_kpi_user_accounts_mv.user_id, 0:Int32, 0:Int32, 1:Int32, party_advisor_kpi_user_accounts_mv.user_id, party_advisor_kpi_user_accounts_mv.account_id, null:Varchar, 2:Int32 ]
├── stream key: [ party_advisor_kpi_user_accounts_mv.user_id, party_advisor_kpi_user_accounts_mv.account_id ]
└── StreamTableScan { table: party_advisor_kpi_user_accounts_mv, columns: [user_id, account_id] }
    ├── output: [ party_advisor_kpi_user_accounts_mv.user_id, party_advisor_kpi_user_accounts_mv.account_id ]
    ├── stream key: [ party_advisor_kpi_user_accounts_mv.user_id, party_advisor_kpi_user_accounts_mv.account_id ]
    ├── Upstream { output: [ user_id, account_id ], stream key: [] }
    └── BatchPlanNode { output: [ user_id, account_id ], stream key: [] }

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