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

← cluster insights objects intraday_holdings_latest_mv
Overview Objects Graph History
materialized view · insights.intraday_holdings_latest_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
138
State size
22.2 KiB
Created
2026-07-01 17:52
Initialized
2026-07-01 17:52
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
96821 5348 26 running
96822 5348 26 running
98247 5349 26 running
98248 5349 26 running
sql · insights.intraday_holdings_latest_mv — click to expand 
CREATE MATERIALIZED VIEW insights.intraday_holdings_latest_mv AS
SELECT
  account_id,
  asset_id,
  currency_code,
  purchased_quantity,
  average_cost_per_unit,
  market_value,
  holding_timestamp
FROM (
  SELECT
    account_id,
    asset_id,
    currency_code,
    purchased_quantity,
    average_cost_per_unit,
    market_value,
    holding_timestamp,
    ROW_NUMBER() OVER (PARTITION BY account_id, asset_id ORDER BY holding_timestamp DESC) AS rn
  FROM olap.holding_values_intraday_ft
  WHERE
    disabled_at IS NULL
)
WHERE
  rn = 1
Lineage · insights.intraday_holdings_latest_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.