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

← cluster insights objects benchmark_twrr_by_distribution_mv
Overview Objects Graph History
materialized view · insights.benchmark_twrr_by_distribution_mv Explain plan ▶
Parallelism
2
Actors
14 / 14
running
Distribution
HASH
Rows
20,513
State size
3.0 MiB
Created
2026-08-14 17:30
Initialized
2026-08-14 17:30
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
740451 54900 51 running
740452 54900 51 running
740601 54896 51 running
740602 54896 51 running
740603 54897 51 running
740604 54897 51 running
740605 54898 51 running
740606 54898 51 running
740607 54899 51 running
740608 54899 51 running
740611 54901 51 running
740612 54901 51 running
+ 2 more actor(s) (14 running)
sql · insights.benchmark_twrr_by_distribution_mv — click to expand 
CREATE MATERIALIZED VIEW insights.benchmark_twrr_by_distribution_mv AS
SELECT
  b.benchmark_id,
  b.fact_date,
  ad.distribution_type,
  ad.taxonomy_node_id,
  ad.taxonomy_code,
  SUM(b.daily_subperiod_return * ad.share) AS daily_subperiod_return
FROM insights.benchmark_twrr_by_asset_mv AS b
JOIN insights.asset_distributions_for_consumers_mv AS ad
  ON ad.asset_id = b.asset_id
  AND b.fact_date >= ad.effective_start_date
  AND b.fact_date < ad.effective_end_date
GROUP BY
  b.benchmark_id,
  b.fact_date,
  ad.distribution_type,
  ad.taxonomy_node_id,
  ad.taxonomy_code
Lineage · insights.benchmark_twrr_by_distribution_mv 7 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.