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

← cluster alpheya_experience_bff objects report_allocation_daily_mv
Overview Objects Graph History
materialized view · alpheya_experience_bff.report_allocation_daily_mv Explain plan ▶
Parallelism
2
Actors
18 / 18
running
Distribution
HASH
Rows
98,306
State size
38.7 MiB
Created
2026-08-25 13:23
Initialized
2026-08-25 13:22
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
167044 20175 33 running
167045 20175 33 running
167046 20176 33 running
167047 20176 33 running
167048 20173 33 running
167049 20173 33 running
167050 20177 33 running
167051 20177 33 running
167052 20171 33 running
167053 20171 33 running
167054 20172 33 running
167055 20172 33 running
+ 6 more actor(s) (18 running)
sql · alpheya_experience_bff.report_allocation_daily_mv — click to expand 
CREATE MATERIALIZED VIEW alpheya_experience_bff.report_allocation_daily_mv AS
SELECT
  pag.portfolio_id,
  pag.type AS account_group_type,
  d.dim_balance_date,
  d.distribution_type,
  d.taxonomy_node_id AS item_id,
  d.taxonomy_node_id,
  tn.name_en AS item_name_en,
  tn.name_ar AS item_name_ar,
  d.currency_code,
  d.market_value,
  d.fair_value,
  d.market_value_system_currency,
  d.fair_value_system_currency,
  d.weight,
  d.fair_value_weight
FROM insights.portfolio_to_account_groups_mv AS pag
JOIN insights.position_by_distribution_mv AS d
  ON d.account_group_id = pag.account_group_id
  AND d.position_type = 'POSITION'
  AND d.source_entity_type = 'portfolio'
LEFT JOIN asset_service.taxonomy_nodes_dm AS tn
  ON tn.node_id = d.taxonomy_node_id
Lineage · alpheya_experience_bff.report_allocation_daily_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.