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
15,733
State size
6.0 MiB
Created
2026-08-20 17:55
Initialized
2026-08-20 17:55
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
744820 64499 51 running
744821 64499 51 running
744822 64500 51 running
744823 64500 51 running
744824 64501 51 running
744825 64501 51 running
744966 64505 51 running
744967 64505 51 running
747421 64498 51 running
747422 64498 51 running
747423 64497 51 running
747424 64497 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.