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
16,117
State size
3.5 MiB
Created
2026-08-20 17:39
Initialized
2026-08-20 17:39
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
747182 64182 51 running
747183 64182 51 running
747184 64181 51 running
747185 64181 51 running
747186 64183 51 running
747187 64183 51 running
747188 64185 51 running
747189 64185 51 running
747196 64184 51 running
747197 64184 51 running
747198 64186 51 running
747199 64186 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.