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

← cluster search objects party_holder_edges_mv
Overview Objects Graph History
materialized view · search.party_holder_edges_mv Explain plan ▶
Parallelism
2
Actors
26 / 26
running
Distribution
HASH
Rows
791
State size
87.3 KiB
Created
2026-08-26 08:22
Initialized
2026-08-26 08:21
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
123607 25347 26 running
123608 25347 26 running
123609 25343 26 running
123610 25343 26 running
123611 25345 26 running
123612 25345 26 running
123613 25344 26 running
123614 25344 26 running
123615 25346 26 running
123616 25346 26 running
123617 25350 26 running
123618 25350 26 running
+ 14 more actor(s) (26 running)
sql · search.party_holder_edges_mv — click to expand 
CREATE MATERIALIZED VIEW search.party_holder_edges_mv AS
SELECT
  inv.party_id,
  inv.account_id AS entity_id,
  'account' AS entity_type
FROM authz.active_parties_to_accounts_mv AS inv
JOIN search.active_parties_mv AS p
  ON p.id = inv.party_id
JOIN olap.accounts_dm AS a
  ON a.account_id = inv.account_id AND a.disabled_at IS NULL
UNION ALL
SELECT
  inv.party_id,
  inv.portfolio_id,
  'portfolio'
FROM authz.active_parties_to_portfolios_mv AS inv
JOIN search.active_parties_mv AS p
  ON p.id = inv.party_id
JOIN olap.portfolios_dm AS port
  ON port.portfolio_id = inv.portfolio_id AND port.disabled_at IS NULL
Lineage · search.party_holder_edges_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.