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

← cluster adib_rm objects activity_transaction_account_portfolio_links_mv
Overview Objects Graph History
materialized view · adib_rm.activity_transaction_account_portfolio_links_mv Explain plan ▶
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
167
State size
39.2 KiB
Created
2026-07-28 16:20
Initialized
2026-07-28 16:20
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
96434 19722 26 running
96435 19722 26 running
96436 19723 26 running
96437 19723 26 running
96668 19721 26 running
96669 19721 26 running
96670 19720 26 running
96671 19720 26 running
sql · adib_rm.activity_transaction_account_portfolio_links_mv — click to expand 
CREATE MATERIALIZED VIEW adib_rm.activity_transaction_account_portfolio_links_mv AS
SELECT
  t.transaction_id,
  atp.portfolio_id
FROM adib_rm.sdk_activity_transactions_merged_mv AS t
JOIN olap.account_to_portfolios_dm AS atp
  ON atp.account_id = t.account_id
  AND atp.disabled_at IS NULL
  AND atp.effective_start_date <= t.transaction_valuation_date
  AND (
    atp.effective_end_date IS NULL
    OR atp.effective_end_date > t.transaction_valuation_date
  )
WHERE
  t.order_id IS NULL
Lineage · adib_rm.activity_transaction_account_portfolio_links_mv 4 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.