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

← cluster alpheya_experience_bff objects investment_holdings_latest_mv
Overview Objects Graph History
materialized view · alpheya_experience_bff.investment_holdings_latest_mv Explain plan ▶
Parallelism
2
Actors
16 / 16
running
Distribution
HASH
Rows
228
State size
61.5 KiB
Created
2026-08-25 12:40
Initialized
2026-08-25 12:39
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
164994 19604 33 running
164995 19604 33 running
164996 19608 33 running
164997 19608 33 running
164998 19606 33 running
164999 19606 33 running
165000 19603 33 running
165001 19603 33 running
165002 19607 33 running
165003 19607 33 running
165004 19601 33 running
165005 19601 33 running
+ 4 more actor(s) (16 running)
sql · alpheya_experience_bff.investment_holdings_latest_mv — click to expand 
CREATE MATERIALIZED VIEW alpheya_experience_bff.investment_holdings_latest_mv AS
SELECT
  h.account_id,
  h.asset_id,
  h.type,
  h.dim_value_date,
  h.currency_code,
  h.market_value,
  h.fair_value,
  h.market_value_system_currency,
  h.fair_value_system_currency
FROM insights.holding_values_latest_mv AS h
JOIN olap.accounts_dm AS a
  ON a.account_id = h.account_id AND a.disabled_at IS NULL AND a.closing_date IS NULL
JOIN olap.product_types_dm AS pt
  ON pt.product_type_id = a.product_type_id
WHERE
  pt.type IN ('INVESTMENT', 'STRUCTURED_DEPOSIT')
Lineage · alpheya_experience_bff.investment_holdings_latest_mv 6 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.