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
32,283
State size
3.5 MiB
Created
2026-08-25 19:39
Initialized
2026-08-25 19:39
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
117827 24798 26 running
117828 24798 26 running
117829 24799 26 running
117830 24799 26 running
117831 24794 26 running
117832 24794 26 running
117833 24795 26 running
117834 24795 26 running
117835 24796 26 running
117836 24796 26 running
117837 24797 26 running
117838 24797 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.