RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.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
818
State size
78.2 KiB
Created
2026-08-19 08:43
Initialized
2026-08-19 08:43
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
158233 16827 33 running
158234 16827 33 running
158235 16828 33 running
158236 16828 33 running
158239 16829 33 running
158240 16829 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.