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

← cluster insights objects benchmark_values_by_currency_mv
Overview Objects Graph History
materialized view · insights.benchmark_values_by_currency_mv Explain plan ▶
Parallelism
2
Actors
16 / 16
running
Distribution
HASH
Rows
2,618
State size
209.6 KiB
Created
2026-08-20 16:59
Initialized
2026-08-20 16:59
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
743041 62567 51 running
743042 62567 51 running
743625 62562 51 running
743626 62562 51 running
743627 62563 51 running
743628 62563 51 running
743643 62564 51 running
743644 62564 51 running
743645 62565 51 running
743646 62565 51 running
743647 62566 51 running
743648 62566 51 running
+ 4 more actor(s) (16 running)
sql · insights.benchmark_values_by_currency_mv — click to expand 
CREATE MATERIALIZED VIEW insights.benchmark_values_by_currency_mv
WITH (
  backfill_order=FIXED(asset_service.assets_dm_next -> asset_service.benchmark_constituents_ft, asset_service.benchmarks_dm -> asset_service.benchmark_constituents_ft)
) AS
SELECT
  c.benchmark_id,
  c.date AS fact_date,
  a.issue_currency_code AS currency_code,
  SUM(c.weight) AS weight
FROM asset_service.benchmark_constituents_ft AS c
JOIN asset_service.assets_dm AS a
  ON a.id = c.asset_id
JOIN asset_service.benchmarks_dm AS b
  ON b.id = c.benchmark_id
WHERE
  b.disabled_at IS NULL AND NOT a.issue_currency_code IS NULL
GROUP BY
  c.benchmark_id,
  c.date,
  a.issue_currency_code
Lineage · insights.benchmark_values_by_currency_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.