holding_values_raw_mv · insights

materialized view · insights.holding_values_raw_mv Explain plan ▶

Parallelism

2

Actors

6 / 6

running

Distribution

HASH

Rows

801,997

State size

117.7 MiB

Created

2026-08-25 14:39

Initialized

2026-08-25 14:39

Fragment flags

MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
33323	12273	33	running
33324	12273	33	running
33467	12275	33	running
33468	12275	33	running
33477	12274	33	running
33478	12274	33	running

sql · insights.holding_values_raw_mv — click to expand

CREATE MATERIALIZED VIEW insights.holding_values_raw_mv AS
SELECT
  account_id,
  asset_id,
  dim_value_date,
  type,
  currency_code,
  market_value,
  average_cost_per_unit,
  purchased_quantity,
  average_cost_per_unit_system_currency,
  total_cost_system_currency,
  CAST(NULL AS DECIMAL) AS deposit_profit_accrued
FROM insights.holding_values_journal_density_mv AS holding_values_journal_density_mv_next
UNION ALL
SELECT
  account_id,
  asset_id,
  dim_value_date,
  type,
  currency_code,
  market_value,
  average_cost_per_unit,
  purchased_quantity,
  CAST(NULL AS DECIMAL) AS average_cost_per_unit_system_currency,
  CAST(NULL AS DECIMAL) AS total_cost_system_currency,
  CAST(NULL AS DECIMAL) AS deposit_profit_accrued
FROM insights.cash_values_journal_density_mv AS cash_values_journal_density_mv_next

Lineage · insights.holding_values_raw_mv 6 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.platform.svc.cluster.local