RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster alpheya_experience_bff objects party_portfolio_counts_mv
Overview Objects Graph History
materialized view · alpheya_experience_bff.party_portfolio_counts_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
13
State size
452 Bytes
Created
2026-08-11 22:06
Initialized
2026-08-11 22:05
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
158005 12917 33 running
158006 12917 33 running
158007 12918 33 running
158008 12918 33 running
sql · alpheya_experience_bff.party_portfolio_counts_mv — click to expand 
CREATE MATERIALIZED VIEW alpheya_experience_bff.party_portfolio_counts_mv AS
SELECT
  pp.party_id,
  CAST(COUNT(pp.portfolio_id) AS INT) AS portfolio_count
FROM alpheya_experience_bff.party_active_portfolio_involvements_mv AS pp
GROUP BY
  pp.party_id
Lineage · alpheya_experience_bff.party_portfolio_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.