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

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

Job is idle — throughput ~0; structure shown.

6 operators
Materialize · alinma_bff.tasks_mv
0% idle 2 actors
Project · tasks_dm
— — 2 actors
Filter · tasks_dm
0% idle 2 actors
StreamScan · tasks_dm
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 · alinma_bff.tasks_mv Materialize alinma_bff.tasks_mv idle · 2 actors Project · tasks_dm Project tasks_dm — · 2 actors Filter · tasks_dm Filter tasks_dm idle · 2 actors StreamScan · tasks_dm StreamScan tasks_dm 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 51735 (Actor 736474,736473)
StreamMaterialize { columns: [task_id, name, description, due_date, status, priority, assignee_id, created_by, updated_by, created_at, updated_at, is_automated, automation_type, resource_account_id, resource_client_id, resource_portfolio_id, resource_party_id, resource_draft_account_id, resource_referral_id, resource_type, resource_id], stream_key: [task_id], pk_columns: [task_id], pk_conflict: NoCheck } { output: [ tasks_dm.task_id, tasks_dm.name, tasks_dm.description, tasks_dm.due_date, tasks_dm.status, tasks_dm.priority, tasks_dm.assignee_id, tasks_dm.created_by, tasks_dm.updated_by, tasks_dm.created_at, tasks_dm.updated_at, tasks_dm.is_automated, tasks_dm.automation_type, tasks_dm.resource_account_id, tasks_dm.resource_client_id, tasks_dm.resource_portfolio_id, tasks_dm.resource_party_id, tasks_dm.resource_draft_account_id, tasks_dm.resource_referral_id, $expr1, $expr2 ], stream key: [ tasks_dm.task_id ] }
└── StreamProject { exprs: [tasks_dm.task_id, tasks_dm.name, tasks_dm.description, tasks_dm.due_date, tasks_dm.status, tasks_dm.priority, tasks_dm.assignee_id, tasks_dm.created_by, tasks_dm.updated_by, tasks_dm.created_at, tasks_dm.updated_at, tasks_dm.is_automated, tasks_dm.automation_type, tasks_dm.resource_account_id, tasks_dm.resource_client_id, tasks_dm.resource_portfolio_id, tasks_dm.resource_party_id, tasks_dm.resource_draft_account_id, tasks_dm.resource_referral_id, Case(Not(IsNull(tasks_dm.resource_client_id)), 'CLIENT':Varchar, Not(IsNull(tasks_dm.resource_portfolio_id)), 'PORTFOLIO':Varchar, Not(IsNull(tasks_dm.resource_account_id)), 'ACCOUNT':Varchar, Not(IsNull(tasks_dm.resource_referral_id)), 'REFERRAL':Varchar, Not(IsNull(tasks_dm.resource_draft_account_id)), 'DRAFT_ACCOUNT':Varchar, Not(IsNull(tasks_dm.resource_party_id)), 'PARTY':Varchar, null:Varchar) as $expr1, Coalesce(tasks_dm.resource_client_id, tasks_dm.resource_portfolio_id, tasks_dm.resource_account_id, tasks_dm.resource_referral_id, tasks_dm.resource_draft_account_id, tasks_dm.resource_party_id) as $expr2] }
    ├── output: [ tasks_dm.task_id, tasks_dm.name, tasks_dm.description, tasks_dm.due_date, tasks_dm.status, tasks_dm.priority, tasks_dm.assignee_id, tasks_dm.created_by, tasks_dm.updated_by, tasks_dm.created_at, tasks_dm.updated_at, tasks_dm.is_automated, tasks_dm.automation_type, tasks_dm.resource_account_id, tasks_dm.resource_client_id, tasks_dm.resource_portfolio_id, tasks_dm.resource_party_id, tasks_dm.resource_draft_account_id, tasks_dm.resource_referral_id, $expr1, $expr2 ]
    ├── stream key: [ tasks_dm.task_id ]
    └── StreamFilter { predicate: IsNull(tasks_dm.disabled_at) } { output: [ tasks_dm.task_id, tasks_dm.name, tasks_dm.description, tasks_dm.due_date, tasks_dm.assignee_id, tasks_dm.status, tasks_dm.priority, tasks_dm.resource_account_id, tasks_dm.resource_client_id, tasks_dm.resource_portfolio_id, tasks_dm.resource_referral_id, tasks_dm.resource_draft_account_id, tasks_dm.resource_party_id, tasks_dm.created_by, tasks_dm.updated_by, tasks_dm.is_automated, tasks_dm.automation_type, tasks_dm.created_at, tasks_dm.updated_at, tasks_dm.disabled_at ], stream key: [ tasks_dm.task_id ] }
        └── StreamTableScan { table: tasks_dm, columns: [task_id, name, description, due_date, assignee_id, status, priority, resource_account_id, resource_client_id, resource_portfolio_id, resource_referral_id, resource_draft_account_id, resource_party_id, created_by, updated_by, is_automated, automation_type, created_at, updated_at, disabled_at] } { output: [ tasks_dm.task_id, tasks_dm.name, tasks_dm.description, tasks_dm.due_date, tasks_dm.assignee_id, tasks_dm.status, tasks_dm.priority, tasks_dm.resource_account_id, tasks_dm.resource_client_id, tasks_dm.resource_portfolio_id, tasks_dm.resource_referral_id, tasks_dm.resource_draft_account_id, tasks_dm.resource_party_id, tasks_dm.created_by, tasks_dm.updated_by, tasks_dm.is_automated, tasks_dm.automation_type, tasks_dm.created_at, tasks_dm.updated_at, tasks_dm.disabled_at ], stream key: [ tasks_dm.task_id ] }
            ├── Upstream { output: [ task_id, name, description, due_date, assignee_id, status, priority, resource_account_id, resource_client_id, resource_portfolio_id, resource_referral_id, resource_draft_account_id, resource_party_id, created_by, updated_by, is_automated, automation_type, created_at, updated_at, disabled_at ], stream key: [] }
            └── BatchPlanNode { output: [ task_id, name, description, due_date, assignee_id, status, priority, resource_account_id, resource_client_id, resource_portfolio_id, resource_referral_id, resource_draft_account_id, resource_party_id, created_by, updated_by, is_automated, automation_type, created_at, updated_at, disabled_at ], stream key: [] }