holding_values_raw_mv · insights

materialized view · insights.holding_values_raw_mv Explain plan ▶

Parallelism

2

Actors

6 / 6

running

Distribution

HASH

Rows

7,133

State size

2.1 MiB

Created

2026-08-26 08:22

Initialized

2026-08-26 08:22

Fragment flags

MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
123907	25373	26	running
123908	25373	26	running
123909	25374	26	running
123910	25374	26	running
123911	25375	26	running
123912	25375	26	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-adib.adib-rw.svc.cluster.local