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

← cluster alinma_bff objects party_advisor_kpi_user_customers_mv
Overview Objects Graph History
materialized view · alinma_bff.party_advisor_kpi_user_customers_mv Explain plan ▶
Parallelism
2
Actors
20 / 20
running
Distribution
HASH
Rows
64
State size
6.6 KiB
Created
2026-08-20 17:09
Initialized
2026-08-20 17:09
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
744930 62946 51 running
744931 62946 51 running
744932 62947 51 running
744933 62947 51 running
744992 62948 51 running
744993 62948 51 running
744994 62949 51 running
744995 62949 51 running
744996 62950 51 running
744997 62950 51 running
744998 62952 51 running
744999 62952 51 running
+ 8 more actor(s) (20 running)
sql · alinma_bff.party_advisor_kpi_user_customers_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.party_advisor_kpi_user_customers_mv AS
SELECT
  utm.user_id,
  tp.party_id,
  acr.customer_relationship_id,
  MAX(tp.updated_at) AS updated_at
FROM authz.active_teams_memberships_mv AS utm
JOIN authz.team_to_parties_mv AS tp
  ON tp.team_id = utm.team_id
JOIN alinma_bff.party_active_customer_relationships_mv AS acr
  ON acr.party_id = tp.party_id
WHERE
  utm.access_type = 'DIRECT'
GROUP BY
  utm.user_id,
  tp.party_id,
  acr.customer_relationship_id
Lineage · alinma_bff.party_advisor_kpi_user_customers_mv 8 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.