RWM Console cluster: risingwave.platform.svc.cluster.local

← cluster insights objects private_asset_holdings_mv
Overview Objects Graph History
materialized view · insights.private_asset_holdings_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
0
State size
—
Created
2026-07-30 10:59
Initialized
2026-07-30 10:59
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
32763 9701 33 running
32764 9701 33 running
32765 9703 33 running
32766 9703 33 running
32782 9700 33 running
32783 9700 33 running
32784 9702 33 running
32785 9702 33 running
32786 9704 33 running
32787 9704 33 running
32788 9705 33 running
32789 9705 33 running
sql · insights.private_asset_holdings_mv — click to expand 
CREATE MATERIALIZED VIEW insights.private_asset_holdings_mv AS
SELECT
  cp.portfolio_id,
  ph.asset_id,
  pa.name,
  pa.local_name,
  pa.category,
  ph.ownership_percentage
FROM olap.private_holdings_dm AS ph
JOIN olap.private_assets_dm AS pa
  ON pa.id = ph.asset_id AND pa.disabled_at IS NULL
JOIN olap.clients_portfolios_dm AS cp
  ON cp.client_id = ph.client_id
  AND cp.owner_type = 'PRIMARY'
  AND cp.disabled_at IS NULL
WHERE
  ph.disabled_at IS NULL
Lineage · insights.private_asset_holdings_mv 5 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.