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

← cluster adib_rm objects pnl_snapshot_mv
Overview Objects Graph History
materialized view · adib_rm.pnl_snapshot_mv Explain plan ▶
Parallelism
2
Actors
2 / 2
running
Distribution
HASH
Rows
1,042
State size
146.8 KiB
Created
2026-08-26 08:36
Initialized
2026-08-26 08:36
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
131944 26022 26 running
131945 26022 26 running
sql · adib_rm.pnl_snapshot_mv — click to expand 
CREATE MATERIALIZED VIEW adib_rm.pnl_snapshot_mv AS
SELECT
  account_group_id,
  dim_balance_date,
  position_type,
  currency_code,
  unrealized_gain_loss,
  total_average_cost,
  unrealized_gain_loss_system_currency,
  total_average_cost_system_currency
FROM (
  SELECT
    account_group_id,
    dim_balance_date,
    position_type,
    currency_code,
    unrealized_gain_loss,
    total_average_cost,
    unrealized_gain_loss_system_currency,
    total_average_cost_system_currency,
    ROW_NUMBER() OVER (
      PARTITION BY account_group_id, position_type, currency_code
      ORDER BY dim_balance_date DESC
    ) AS rn
  FROM insights.pnl_summary_mv AS pnl_summary_mv_next
)
WHERE
  rn = 1
Lineage · adib_rm.pnl_snapshot_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.