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

← cluster alinma_bff objects party_task_counts_mv
Overview Objects Graph History
materialized view · alinma_bff.party_task_counts_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
3
State size
139 Bytes
Created
2026-08-19 22:39
Initialized
2026-08-19 22:39
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
738568 61214 51 running
738569 61214 51 running
738592 61215 51 running
738593 61215 51 running
sql · alinma_bff.party_task_counts_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.party_task_counts_mv AS
SELECT
  party_id,
  CAST(COUNT(*) FILTER(WHERE
    status IN ('TO_DO', 'IN_PROGRESS')) AS INT) AS active_count,
  CAST(COUNT(*) FILTER(WHERE
    status IN ('TO_DO', 'IN_PROGRESS') AND priority = 'HIGH') AS INT) AS high_priority_count,
  CAST(COUNT(*) FILTER(WHERE
    status IN ('TO_DO', 'IN_PROGRESS') AND is_overdue) AS INT) AS overdue_count
FROM alinma_bff.party_task_unique_mv AS party_task_unique_mv_next
GROUP BY
  party_id
Lineage · alinma_bff.party_task_counts_mv 3 objects
Direct (1-hop) dependencies from rw_depend, across schemas. Click a neighbor to expand its dependencies; ⌘/Ctrl-click opens its page. Drag to pan, scroll to zoom. External source/sink endpoints (Kafka, Iceberg) are not shown.