holding_values_mv · insights

materialized view · insights.holding_values_mv Explain plan ▶

Parallelism

2

Actors

6 / 6

running

Distribution

HASH

Rows

35,693

State size

19.1 MiB

Created

2026-08-25 12:34

Initialized

2026-08-25 12:33

Fragment flags

MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
164660	19520	33	running
164661	19520	33	running
164662	19521	33	running
164663	19521	33	running
164664	19522	33	running
164665	19522	33	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 9 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.

RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local