RWM Console cluster: risingwave-adib.adib-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
10 / 10
running
Distribution
HASH
Rows
4,128
State size
930.8 KiB
Created
2026-08-25 16:38
Initialized
2026-08-25 16:37
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
113270 24394 26 running
113271 24394 26 running
113272 24393 26 running
113273 24393 26 running
113274 24392 26 running
113275 24392 26 running
113276 24395 26 running
113277 24395 26 running
113278 24396 26 running
113279 24396 26 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.