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

← cluster search objects party_active_relationships_mv
Overview Objects Graph History
materialized view · search.party_active_relationships_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
85
State size
5.2 KiB
Created
2026-08-20 17:02
Initialized
2026-08-20 17:02
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
744009 62694 51 running
744010 62694 51 running
744215 62693 51 running
744216 62693 51 running
sql · search.party_active_relationships_mv — click to expand 
CREATE MATERIALIZED VIEW search.party_active_relationships_mv AS
SELECT
  party_id,
  type,
  status
FROM (
  SELECT
    party_id,
    type,
    status,
    ROW_NUMBER() OVER (
      PARTITION BY party_id, type
      ORDER BY updated_at DESC, status_changed_at DESC, effective_from DESC, id DESC
    ) AS rn
  FROM party.customer_relationships AS customer_relationships_next
  WHERE
    disabled_at IS NULL
) AS deduped
WHERE
  rn = 1
Lineage · search.party_active_relationships_mv 4 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.