RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.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
89
State size
6.6 KiB
Created
2026-08-19 08:30
Initialized
2026-08-19 08:29
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
156717 16675 33 running
156718 16675 33 running
156761 16676 33 running
156762 16676 33 running
156769 16677 33 running
156770 16677 33 running
156773 16678 33 running
156774 16678 33 running
156785 16679 33 running
156786 16679 33 running
156789 16682 33 running
156790 16682 33 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 -> 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.