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

← cluster insights objects settled_cost_basis_latest_mv
Overview Objects Graph History
materialized view · insights.settled_cost_basis_latest_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
735
State size
112.6 KiB
Created
2026-08-13 17:26
Initialized
2026-08-13 17:26
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
737522 52258 51 running
737523 52258 51 running
737524 52259 51 running
737525 52259 51 running
sql · insights.settled_cost_basis_latest_mv — click to expand 
CREATE MATERIALIZED VIEW insights.settled_cost_basis_latest_mv AS
SELECT
  account_id,
  asset_id,
  type,
  currency_code,
  dim_value_date,
  average_cost_per_unit,
  average_cost_per_unit_system_currency,
  total_cost_system_currency,
  cost_fx_provenance,
  purchased_quantity,
  m_is_stub
FROM (
  SELECT
    account_id,
    asset_id,
    type,
    currency_code,
    dim_value_date,
    average_cost_per_unit,
    average_cost_per_unit_system_currency,
    total_cost_system_currency,
    cost_fx_provenance,
    purchased_quantity,
    m_is_stub,
    ROW_NUMBER() OVER (
      PARTITION BY account_id, asset_id
      ORDER BY (
        m_is_stub IS TRUE
      ), dim_value_date DESC, type
    ) AS rn
  FROM insights.settled_cost_basis_carried_mv
) AS ranked
WHERE
  rn = 1
Lineage · insights.settled_cost_basis_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.