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

← cluster insights objects asset_distributions_week_binned_mv
Overview Objects Graph History
materialized view · insights.asset_distributions_week_binned_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
44,490
State size
9.9 MiB
Created
2026-08-19 22:50
Initialized
2026-08-19 22:50
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
739609 61621 51 running
739610 61621 51 running
739613 61623 51 running
739614 61623 51 running
739633 61619 51 running
739634 61619 51 running
739635 61618 51 running
739636 61618 51 running
739637 61620 51 running
739638 61620 51 running
739643 61622 51 running
739644 61622 51 running
sql · insights.asset_distributions_week_binned_mv — click to expand 
CREATE MATERIALIZED VIEW insights.asset_distributions_week_binned_mv AS
SELECT
  ad.asset_id,
  ad.distribution_type,
  ad.effective_start_date,
  ad.effective_end_date,
  ad.taxonomy_node_id,
  ad.taxonomy_code,
  ad.share,
  spine.dim_value_week
FROM insights.asset_distributions_for_consumers_mv AS ad
JOIN (
  SELECT DISTINCT
    asset_id,
    CAST(DATE_TRUNC('WEEK', dim_value_date) AS DATE) AS dim_value_week
  FROM insights.position_asset_values_mv AS position_asset_values_mv_next
) AS spine
  ON spine.asset_id = ad.asset_id
  AND spine.dim_value_week >= CAST(DATE_TRUNC('WEEK', ad.effective_start_date) AS DATE)
  AND spine.dim_value_week <= ad.effective_end_date
Lineage · insights.asset_distributions_week_binned_mv 4 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.