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
727
State size
167.7 KiB
Created
2026-07-31 21:13
Initialized
2026-07-31 21:12
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
100494 20596 26 running
100495 20596 26 running
100496 20595 26 running
100497 20595 26 running
100498 20597 26 running
100499 20597 26 running
100500 20598 26 running
100501 20598 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.