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

← cluster insights objects portfolios_with_accounts_mv
Overview Objects Graph History
materialized view · insights.portfolios_with_accounts_mv
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
16
State size
832 Bytes
Created
2026-06-30 21:40
Initialized
2026-06-30 21:40
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
53842 2548 3 running
53843 2548 3 running
53844 2549 3 running
53845 2549 3 running
54158 2550 3 running
54159 2550 3 running
54166 2551 3 running
54167 2551 3 running
sql · insights.portfolios_with_accounts_mv — click to expand 
CREATE MATERIALIZED VIEW insights.portfolios_with_accounts_mv AS
SELECT DISTINCT
  atp.portfolio_id
FROM olap.account_to_portfolios_dm AS atp
JOIN insights.open_accounts_mv AS oa
  ON oa.account_id = atp.account_id
WHERE
  atp.disabled_at IS NULL
Lineage · insights.portfolios_with_accounts_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.