party_holder_edges_mv · search

materialized view · search.party_holder_edges_mv Explain plan ▶

Parallelism

2

Actors

34 / 34

running

Distribution

HASH

Rows

42

State size

2.9 KiB

Created

2026-08-21 06:24

Initialized

2026-08-21 06:24

Fragment flags

LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
157834	17903	33	running
157835	17903	33	running
157836	17904	33	running
157837	17904	33	running
157850	17897	33	running
157851	17897	33	running
157852	17899	33	running
157853	17899	33	running
157854	17898	33	running
157855	17898	33	running
157856	17900	33	running
157857	17900	33	running

+ 22 more actor(s) (34 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.

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