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

519,138

State size

219.7 MiB

Created

2026-08-19 23:10

Initialized

2026-08-19 23:10

Fragment flags

LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
740401	61990	51	running
740402	61990	51	running
740403	61992	51	running
740404	61992	51	running
740715	61985	51	running
740716	61985	51	running
740719	61986	51	running
740720	61986	51	running
740721	61987	51	running
740722	61987	51	running
740723	61988	51	running
740724	61988	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