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
747
State size
170.9 KiB
Created
2026-08-26 08:31
Initialized
2026-08-26 08:31
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
129835 25864 26 running
129836 25864 26 running
129837 25865 26 running
129838 25865 26 running
129839 25867 26 running
129840 25867 26 running
129841 25866 26 running
129842 25866 26 running
129843 25868 26 running
129844 25868 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.