RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster alpheya_experience_bff objects account_owners_mv
Overview Objects Graph History
materialized view · alpheya_experience_bff.account_owners_mv Explain plan ▶
Parallelism
2
Actors
18 / 18
running
Distribution
HASH
Rows
59
State size
11.4 KiB
Created
2026-08-11 21:52
Initialized
2026-08-11 21:51
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
157580 12708 33 running
157581 12708 33 running
157582 12709 33 running
157583 12709 33 running
157680 12703 33 running
157681 12703 33 running
157682 12704 33 running
157683 12704 33 running
157684 12702 33 running
157685 12702 33 running
157686 12705 33 running
157687 12705 33 running
+ 6 more actor(s) (18 running)
sql · alpheya_experience_bff.account_owners_mv — click to expand 
CREATE MATERIALIZED VIEW alpheya_experience_bff.account_owners_mv AS
SELECT
  atc.account_id,
  JSONB_AGG(
    JSONB_BUILD_OBJECT(
      'id',
      c.id,
      'displayName',
      c.display_name,
      'localDisplayName',
      c.local_display_name,
      'preferredName',
      c.preferred_name,
      'ownerType',
      atc.owner_type
    )
  ) AS owners,
  CAST(COUNT(*) AS INT) AS owner_count
FROM olap.accounts_to_clients_dm AS atc
JOIN olap.clients_dm AS c
  ON c.id = atc.client_id AND c.closing_date IS NULL
JOIN insights.open_accounts_mv AS oa
  ON oa.account_id = atc.account_id
WHERE
  atc.disabled_at IS NULL AND atc.effective_end_date IS NULL
GROUP BY
  atc.account_id
Lineage · alpheya_experience_bff.account_owners_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.