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

← cluster alinma_bff objects advisor_kpi_user_portfolios_mv
Overview Objects Graph History
materialized view · alinma_bff.advisor_kpi_user_portfolios_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
5,698
State size
468.5 KiB
Created
2026-08-15 03:41
Initialized
2026-08-15 03:41
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
740653 54927 51 running
740654 54927 51 running
740661 54928 51 running
740662 54928 51 running
740663 54929 51 running
740664 54929 51 running
740665 54931 51 running
740666 54931 51 running
740671 54930 51 running
740672 54930 51 running
740677 54932 51 running
740678 54932 51 running
sql · alinma_bff.advisor_kpi_user_portfolios_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_user_portfolios_mv AS
SELECT
  user_portfolios.user_id,
  user_portfolios.portfolio_id
FROM (
  SELECT
    utm.user_id,
    ttp.portfolio_id
  FROM authz.active_teams_memberships_mv AS utm
  JOIN authz.team_to_portfolios_mv AS ttp
    ON ttp.team_id = utm.team_id
  WHERE
    utm.access_type = 'DIRECT'
) AS user_portfolios
GROUP BY
  user_portfolios.user_id,
  user_portfolios.portfolio_id
Lineage · alinma_bff.advisor_kpi_user_portfolios_mv 8 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.