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

← cluster alinma_bff objects advisor_kpi_portfolio_daily_mv
Overview Objects Graph History
materialized view · alinma_bff.advisor_kpi_portfolio_daily_mv Explain plan ▶
Parallelism
2
Actors
5 / 5
running
Distribution
HASH
Rows
7,024
State size
408.7 KiB
Created
2026-08-20 17:49
Initialized
2026-08-20 17:48
Fragment flags
LOCALITY_PROVIDERMVIEWNOWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
747408 64356 51 running
747409 64356 51 running
747410 64358 51 running
747411 64357 51 running
747412 64357 51 running
sql · alinma_bff.advisor_kpi_portfolio_daily_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_portfolio_daily_mv AS
SELECT
  portfolio_id,
  dim_balance_date,
  SUM(COALESCE(relationship_value_system_currency, 0)) AS relationship_value,
  SUM(COALESCE(market_value_system_currency, 0)) AS net_assets
FROM alinma_bff.report_position_daily_mv AS report_position_daily_mv_next
WHERE
  account_group_type = 'all'
  AND CAST(dim_balance_date AS TIMESTAMPTZ) >= CURRENT_TIMESTAMP - INTERVAL '400 DAYS'
GROUP BY
  portfolio_id,
  dim_balance_date
Lineage · alinma_bff.advisor_kpi_portfolio_daily_mv 4 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.