report_allocation_daily_mv · alinma_bff

materialized view · alinma_bff.report_allocation_daily_mv Explain plan ▶

Parallelism

2

Actors

18 / 18

running

Distribution

HASH

Rows

129,559

State size

51.3 MiB

Created

2026-08-20 17:46

Initialized

2026-08-20 17:46

Fragment flags

LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
747192	64298	51	running
747193	64298	51	running
747194	64299	51	running
747195	64299	51	running
747427	64300	51	running
747428	64300	51	running
747429	64301	51	running
747430	64301	51	running
747431	64302	51	running
747432	64302	51	running
747433	64304	51	running
747434	64304	51	running

+ 6 more actor(s) (18 running)

sql · alinma_bff.report_allocation_daily_mv — click to expand

CREATE MATERIALIZED VIEW alinma_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 · alinma_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.

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