party_account_direct_mv · insights

materialized view · insights.party_account_direct_mv Explain plan ▶

Parallelism

2

Actors

16 / 16

running

Distribution

HASH

Rows

42

State size

10.5 KiB

Created

2026-08-25 14:38

Initialized

2026-08-25 14:38

Fragment flags

MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
33175	12194	33	running
33176	12194	33	running
33261	12201	33	running
33262	12201	33	running
33263	12196	33	running
33264	12196	33	running
33265	12195	33	running
33266	12195	33	running
33267	12197	33	running
33268	12197	33	running
33273	12198	33	running
33274	12198	33	running

+ 4 more actor(s) (16 running)

sql · insights.party_account_direct_mv — click to expand

CREATE MATERIALIZED VIEW insights.party_account_direct_mv AS
SELECT
  inv.party_id,
  inv.customer_relationship_id,
  inv.entity_id AS account_id,
  inv.effective_from AS effective_start_date,
  inv.effective_to AS effective_end_date,
  CAST('all' AS VARCHAR) AS type
FROM olap.party_involvements_dm AS inv
JOIN insights.open_accounts_mv AS oa
  ON oa.account_id = inv.entity_id
JOIN party.customer_relationships AS cr
  ON cr.id = inv.customer_relationship_id
  AND cr.type = 'CUSTOMER'
  AND cr.status = 'ACTIVE'
  AND cr.disabled_at IS NULL
WHERE
  inv.entity_type = 'ACCOUNT'
  AND inv.involvement_type IN ('ACCOUNT_HOLDER', 'JOINT_ACCOUNT_HOLDER')
  AND inv.status = 'ACTIVE'
  AND inv.disabled_at IS NULL
  AND (
    inv.effective_to IS NULL OR inv.effective_to > inv.effective_from
  )
UNION ALL
SELECT
  inv.party_id,
  inv.customer_relationship_id,
  inv.entity_id AS account_id,
  inv.effective_from AS effective_start_date,
  inv.effective_to AS effective_end_date,
  CAST(CASE WHEN oa.is_restricted THEN 'restricted' ELSE 'un_restricted' END AS VARCHAR) AS type
FROM olap.party_involvements_dm AS inv
JOIN insights.open_accounts_mv AS oa
  ON oa.account_id = inv.entity_id
JOIN party.customer_relationships AS cr
  ON cr.id = inv.customer_relationship_id
  AND cr.type = 'CUSTOMER'
  AND cr.status = 'ACTIVE'
  AND cr.disabled_at IS NULL
WHERE
  inv.entity_type = 'ACCOUNT'
  AND inv.involvement_type IN ('ACCOUNT_HOLDER', 'JOINT_ACCOUNT_HOLDER')
  AND inv.status = 'ACTIVE'
  AND inv.disabled_at IS NULL
  AND (
    inv.effective_to IS NULL OR inv.effective_to > inv.effective_from
  )

Lineage · insights.party_account_direct_mv 7 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.platform.svc.cluster.local