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

← cluster insights objects holding_values_mv
Overview Objects Graph History
materialized view · insights.holding_values_mv Explain plan ▶
Parallelism
2
Actors
6 / 6
running
Distribution
HASH
Rows
313,225
State size
130.8 MiB
Created
2026-08-18 13:18
Initialized
2026-08-18 13:18
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
739715 58879 51 running
739716 58879 51 running
739719 58880 51 running
739720 58880 51 running
739721 58881 51 running
739722 58881 51 running
sql · insights.holding_values_mv — click to expand 
CREATE MATERIALIZED VIEW insights.holding_values_mv AS
SELECT
  account_id,
  asset_id,
  dim_value_date,
  type,
  currency_code,
  market_value,
  average_cost,
  average_cost_per_unit,
  purchased_quantity,
  fair_value,
  accrued_value,
  accrued_value_system_currency,
  market_value_system_currency,
  average_cost_system_currency,
  average_cost_per_unit_system_currency,
  fair_value_system_currency
FROM insights.holding_values_with_accruals_mv AS holding_values_with_accruals_mv_next
UNION ALL
SELECT
  account_id,
  asset_id,
  dim_value_date,
  type,
  currency_code,
  market_value,
  average_cost,
  average_cost_per_unit,
  purchased_quantity,
  fair_value,
  accrued_value,
  accrued_value_system_currency,
  market_value_system_currency,
  average_cost_system_currency,
  average_cost_per_unit_system_currency,
  fair_value_system_currency
FROM insights.orphan_accruals_mv AS orphan_accruals_mv_next
Lineage · insights.holding_values_mv 10 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.