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

← cluster opportunity objects portfolio_unrealized_loss_delta_mv
Overview Objects Graph History
materialized view · opportunity.portfolio_unrealized_loss_delta_mv Explain plan ▶
Parallelism
2
Actors
13 / 13
running
Distribution
HASH
Rows
9,923
State size
72.4 KiB
Created
2026-08-19 23:13
Initialized
2026-08-19 23:13
Fragment flags
LOCALITY_PROVIDERMVIEWNOWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
740959 62052 51 running
740960 62052 51 running
740961 62053 51 running
740962 62053 51 running
740963 62054 51 running
740964 62054 51 running
740965 62056 51 running
740966 62057 51 running
740967 62057 51 running
740968 62055 51 running
740969 62055 51 running
740970 62058 51 running
+ 1 more actor(s) (13 running)
sql · opportunity.portfolio_unrealized_loss_delta_mv — click to expand 
CREATE MATERIALIZED VIEW opportunity.portfolio_unrealized_loss_delta_mv AS
SELECT
  pag.portfolio_id,
  pnl.dim_balance_date,
  pnl.currency_code,
  ABS(pnl.unrealized_gain_loss / pnl.total_average_cost) AS loss_ratio
FROM insights.pnl_summary_mv AS pnl
JOIN insights.portfolio_to_account_groups_mv AS pag
  ON pag.account_group_id = pnl.account_group_id AND pag.type = 'all'
WHERE
  pnl.position_type = 'POSITION'
  AND pnl.unrealized_gain_loss < 0
  AND pnl.total_average_cost <> 0
  AND CAST(pnl.dim_balance_date AS TIMESTAMPTZ) >= CURRENT_TIMESTAMP - INTERVAL '30 DAYS'
Lineage · opportunity.portfolio_unrealized_loss_delta_mv 5 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.