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

← cluster insights objects flow_asset_values_mv
Overview Objects Graph History
materialized view · insights.flow_asset_values_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
55,208
State size
9.5 MiB
Created
2026-08-24 15:35
Initialized
2026-08-24 15:35
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
106394 23775 26 running
106395 23775 26 running
106396 23776 26 running
106397 23776 26 running
sql · insights.flow_asset_values_mv — click to expand 
CREATE MATERIALIZED VIEW insights.flow_asset_values_mv AS
SELECT
  account_group_id,
  dim_transaction_date,
  asset_id,
  asset_type,
  CASE WHEN GROUPING(position_type) = 1 THEN 'POSITION' ELSE position_type END AS position_type,
  group_currency,
  SUM(net_value_group) AS net_value_group,
  SUM(net_value_system) AS net_value_system
FROM insights.flow_values_mv AS flow_values_mv_next
GROUP BY
  GROUPING SETS (
    (
      account_group_id,
      dim_transaction_date,
      asset_id,
      asset_type,
      position_type,
      group_currency
    ),
    (account_group_id, dim_transaction_date, asset_id, asset_type, group_currency)
  )
HAVING
  GROUPING(position_type) = 1 OR NOT position_type IS NULL
Lineage · insights.flow_asset_values_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.