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-17 11:38
Initialized
2026-08-17 11:38
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
735975 56606 51 running
735976 56606 51 running
736001 56607 51 running
736002 56607 51 running
736007 56608 51 running
736008 56608 51 running
736024 56609 51 running
736025 56609 51 running
736032 56610 51 running
736033 56610 51 running
736113 56611 51 running
736114 56611 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 -> 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.