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

← cluster search objects olap_reference_identifier_terms_mv explain
Overview Objects Graph History
materialized view · search.olap_reference_identifier_terms_mv profiled over 5s
seconds (1–30)

Job is idle — throughput ~0; structure shown.

7 operators
Materialize · search.olap_reference_identifier_terms_mv
0% idle 2 actors
Project · reference_identifiers
— — 2 actors
ProjectSet · reference_identifiers
0% idle 2 actors
Filter · reference_identifiers
0% idle 2 actors
StreamScan · reference_identifiers
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.
Materialize · search.olap_reference_identifier_terms_mv Materialize search.olap_reference_i… idle · 2 actors Project · reference_identifiers Project reference_identifiers — · 2 actors ProjectSet · reference_identifiers ProjectSet reference_identifiers idle · 2 actors Filter · reference_identifiers Filter reference_identifiers idle · 2 actors StreamScan · reference_identifiers StreamScan reference_identifiers 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 51599 (Actor 736030,736031)
StreamMaterialize { columns: [owner_entity_id, owner_entity_type, val, ar_val, reference_identifiers.id(hidden), _rw_projected_row_id(hidden)], stream_key: [reference_identifiers.id, _rw_projected_row_id], pk_columns: [reference_identifiers.id, _rw_projected_row_id], pk_conflict: NoCheck }
├── output: [ reference_identifiers.entity_id, reference_identifiers.entity_type, Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), reference_identifiers.id, _rw_projected_row_id ]
├── stream key: [ reference_identifiers.id, _rw_projected_row_id ]
└── StreamProject { exprs: [reference_identifiers.entity_id, reference_identifiers.entity_type, Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), reference_identifiers.id, _rw_projected_row_id] }
    ├── output: [ reference_identifiers.entity_id, reference_identifiers.entity_type, Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), reference_identifiers.id, _rw_projected_row_id ]
    ├── stream key: [ reference_identifiers.id, _rw_projected_row_id ]
    └── StreamProjectSet { select_list: [$0, $1, Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), $3] }
        ├── output: [ _rw_projected_row_id, reference_identifiers.entity_type, reference_identifiers.entity_id, Unnest(Array($2, Replace($2, '-':Varchar, '':Varchar))), reference_identifiers.id ]
        ├── stream key: [ reference_identifiers.id, _rw_projected_row_id ]
        └── StreamFilter { predicate: In(reference_identifiers.entity_type, 'account':Varchar, 'client':Varchar, 'portfolio':Varchar) }
            ├── output: [ reference_identifiers.entity_type, reference_identifiers.entity_id, reference_identifiers.value, reference_identifiers.id ]
            ├── stream key: [ reference_identifiers.id ]
            └── StreamTableScan { table: reference_identifiers, columns: [entity_type, entity_id, value, id] }
                ├── output: [ reference_identifiers.entity_type, reference_identifiers.entity_id, reference_identifiers.value, reference_identifiers.id ]
                ├── stream key: [ reference_identifiers.id ]
                ├── Upstream { output: [ entity_type, entity_id, value, id ], stream key: [] }
                └── BatchPlanNode { output: [ entity_type, entity_id, value, id ], stream key: [] }