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

← cluster insights objects benchmark_twrr_by_distribution_mv
Overview Objects Graph History
materialized view · insights.benchmark_twrr_by_distribution_mv
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
0
State size
—
Created
2026-06-30 21:43
Initialized
2026-06-30 21:43
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
54260 2605 3 running
54261 2605 3 running
54262 2602 3 running
54263 2602 3 running
54264 2603 3 running
54265 2603 3 running
54266 2604 3 running
54267 2604 3 running
54270 2606 3 running
54271 2606 3 running
54272 2607 3 running
54273 2607 3 running
sql · insights.benchmark_twrr_by_distribution_mv — click to expand 
CREATE MATERIALIZED VIEW insights.benchmark_twrr_by_distribution_mv AS
SELECT
  c.benchmark_id,
  c.fact_date,
  ad.distribution_type,
  ad.item_id,
  SUM(a.daily_subperiod_return * c.weight * ad.share) AS daily_subperiod_return
FROM olap.basket_index_benchmark_constituents_ft AS c
JOIN insights.asset_twrr_mv AS a
  ON a.asset_id = c.asset_id AND a.fact_date = c.fact_date
JOIN insights.asset_distributions_for_consumers_mv AS ad
  ON ad.asset_id = c.asset_id
  AND c.fact_date >= ad.effective_start_date
  AND c.fact_date < ad.effective_end_date
WHERE
  c.disabled_at IS NULL AND NOT a.daily_subperiod_return IS NULL
GROUP BY
  c.benchmark_id,
  c.fact_date,
  ad.distribution_type,
  ad.item_id
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.