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

← cluster alpheya_experience_bff objects report_twrr_daily_mv
Overview Objects Graph History
materialized view · alpheya_experience_bff.report_twrr_daily_mv Explain plan ▶
Parallelism
2
Actors
20 / 20
running
Distribution
HASH
Rows
3,248
State size
1.2 MiB
Created
2026-08-25 13:10
Initialized
2026-08-25 13:09
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
166486 20035 33 running
166487 20035 33 running
166488 20037 33 running
166489 20037 33 running
166490 20031 33 running
166491 20031 33 running
166492 20033 33 running
166493 20033 33 running
166494 20036 33 running
166495 20036 33 running
166496 20032 33 running
166497 20032 33 running
+ 8 more actor(s) (20 running)
sql · alpheya_experience_bff.report_twrr_daily_mv — click to expand 
CREATE MATERIALIZED VIEW alpheya_experience_bff.report_twrr_daily_mv AS
SELECT
  pag.portfolio_id,
  pag.type AS account_group_type,
  t.dim_balance_date,
  t.currency_code,
  ps.market_value,
  ps.fair_value,
  t.daily_subperiod_return,
  t.daily_subperiod_fair_value_return,
  t.daily_subperiod_return_system_currency,
  t.daily_subperiod_fair_value_return_system_currency
FROM insights.portfolio_to_account_groups_mv AS pag
JOIN insights.twrr_mv AS t
  ON t.account_group_id = pag.account_group_id
JOIN insights.position_summary_mv AS ps
  ON ps.account_group_id = t.account_group_id
  AND ps.dim_balance_date = t.dim_balance_date
  AND ps.currency_code = t.currency_code
  AND ps.position_type = 'POSITION'
  AND ps.source_entity_type = 'portfolio'
Lineage · alpheya_experience_bff.report_twrr_daily_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.