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

← cluster alinma_bff objects report_allocation_twrr_daily_mv
Overview Objects Graph History
materialized view · alinma_bff.report_allocation_twrr_daily_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
128,657
State size
44.7 MiB
Created
2026-08-20 17:57
Initialized
2026-08-20 17:57
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
747506 64528 51 running
747507 64528 51 running
747508 64529 51 running
747509 64529 51 running
747781 64530 51 running
747782 64530 51 running
747783 64532 51 running
747784 64532 51 running
747785 64531 51 running
747786 64531 51 running
747791 64533 51 running
747792 64533 51 running
sql · alinma_bff.report_allocation_twrr_daily_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.report_allocation_twrr_daily_mv AS
SELECT
  pag.portfolio_id,
  pag.type AS account_group_type,
  t.dim_balance_date,
  t.distribution_type,
  t.taxonomy_node_id AS item_id,
  t.currency_code,
  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_by_distribution_mv AS t
  ON t.account_group_id = pag.account_group_id
Lineage · alinma_bff.report_allocation_twrr_daily_mv 4 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.