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

← cluster alinma_bff objects report_twrr_daily_mv
Overview Objects Graph History
materialized view · alinma_bff.report_twrr_daily_mv Explain plan ▶
Parallelism
2
Actors
20 / 20
running
Distribution
HASH
Rows
56,657
State size
21.9 MiB
Created
2026-08-19 23:12
Initialized
2026-08-19 23:12
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
740797 62032 51 running
740798 62032 51 running
740799 62033 51 running
740800 62033 51 running
740803 62034 51 running
740804 62034 51 running
740889 62035 51 running
740890 62035 51 running
740891 62036 51 running
740892 62036 51 running
740893 62038 51 running
740894 62038 51 running
+ 8 more actor(s) (20 running)
sql · alinma_bff.report_twrr_daily_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_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 · alinma_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.