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
518,104
State size
185.0 MiB
Created
2026-08-19 23:17
Initialized
2026-08-19 23:17
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
741004 62122 51 running
741005 62122 51 running
741006 62121 51 running
741007 62121 51 running
741163 62124 51 running
741164 62124 51 running
741165 62123 51 running
741166 62123 51 running
741167 62125 51 running
741168 62125 51 running
741183 62126 51 running
741184 62126 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.