RWM Console cluster: risingwave.platform.svc.cluster.local

← cluster insights objects settled_cash_balances_mv
Overview Objects Graph History
materialized view · insights.settled_cash_balances_mv Explain plan ▶
Parallelism
2
Actors
6 / 6
running
Distribution
HASH
Rows
154
State size
11.3 KiB
Created
2026-08-18 09:50
Initialized
2026-08-18 09:50
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
32663 11656 33 running
32664 11656 33 running
32665 11657 33 running
32666 11657 33 running
33271 11658 33 running
33272 11658 33 running
sql · insights.settled_cash_balances_mv — click to expand 
CREATE MATERIALIZED VIEW insights.settled_cash_balances_mv AS
WITH daily AS (
  SELECT
    account_id,
    currency_code,
    dim_settlement_date,
    SUM(settlement_amount_delta) AS settlement_amount_delta,
    CAST(SUM(transaction_count) AS BIGINT) AS transaction_count
  FROM insights.settled_cash_series_mv AS settled_cash_series_mv_next
  GROUP BY
    account_id,
    currency_code,
    dim_settlement_date
)
SELECT
  account_id,
  currency_code,
  dim_settlement_date,
  settlement_amount_delta,
  SUM(settlement_amount_delta) OVER (PARTITION BY account_id, currency_code ORDER BY dim_settlement_date) AS settled_cash_balance,
  transaction_count
FROM daily
Lineage · insights.settled_cash_balances_mv 3 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.