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

← cluster alinma_bff objects advisor_kpi_period_balance_series_mv
Overview Objects Graph History
materialized view · alinma_bff.advisor_kpi_period_balance_series_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
7,039
State size
632.7 KiB
Created
2026-08-19 23:23
Initialized
2026-08-19 23:23
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
741378 62256 51 running
741379 62256 51 running
741380 62258 51 running
741381 62258 51 running
741432 62253 51 running
741433 62253 51 running
741434 62254 51 running
741435 62254 51 running
741436 62255 51 running
741437 62255 51 running
741438 62257 51 running
741439 62257 51 running
sql · alinma_bff.advisor_kpi_period_balance_series_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_period_balance_series_mv AS
SELECT
  up.user_id,
  b.period_kind,
  b.period_start,
  SUM(b.relationship_value) AS relationship_value,
  SUM(b.net_assets) AS net_assets
FROM alinma_bff.advisor_kpi_user_portfolios_mv AS up
JOIN alinma_bff.advisor_kpi_portfolio_balance_buckets_mv AS b
  ON b.portfolio_id = up.portfolio_id
GROUP BY
  up.user_id,
  b.period_kind,
  b.period_start
Lineage · alinma_bff.advisor_kpi_period_balance_series_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.