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

← cluster alinma_bff objects advisor_kpi_entity_bucket_adds_mv
Overview Objects Graph History
materialized view · alinma_bff.advisor_kpi_entity_bucket_adds_mv Explain plan ▶
Parallelism
2
Actors
32 / 32
running
Distribution
HASH
Rows
1,436
State size
111.2 KiB
Created
2026-08-17 11:38
Initialized
2026-08-17 11:38
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
736107 56614 51 running
736108 56614 51 running
736384 56619 51 running
736385 56619 51 running
736386 56616 51 running
736387 56616 51 running
736388 56615 51 running
736389 56615 51 running
736390 56617 51 running
736391 56617 51 running
736392 56618 51 running
736393 56618 51 running
+ 20 more actor(s) (32 running)
sql · alinma_bff.advisor_kpi_entity_bucket_adds_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_entity_bucket_adds_mv AS
SELECT
  CAST('PORTFOLIO' AS VARCHAR) AS entity_type,
  portfolio_id AS entity_id,
  CAST('WEEKLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('WEEK', opening_date) AS DATE) AS period_start
FROM olap.portfolios_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('PORTFOLIO' AS VARCHAR) AS entity_type,
  portfolio_id AS entity_id,
  CAST('MONTHLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('MONTH', opening_date) AS DATE) AS period_start
FROM olap.portfolios_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('PORTFOLIO' AS VARCHAR) AS entity_type,
  portfolio_id AS entity_id,
  CAST('QUARTERLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('QUARTER', opening_date) AS DATE) AS period_start
FROM olap.portfolios_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('PORTFOLIO' AS VARCHAR) AS entity_type,
  portfolio_id AS entity_id,
  CAST('YEARLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('YEAR', opening_date) AS DATE) AS period_start
FROM olap.portfolios_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('CLIENT' AS VARCHAR) AS entity_type,
  id AS entity_id,
  CAST('WEEKLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('WEEK', onboarding_date) AS DATE) AS period_start
FROM olap.clients_dm
WHERE
  disabled_at IS NULL AND NOT onboarding_date IS NULL
UNION ALL
SELECT
  CAST('CLIENT' AS VARCHAR) AS entity_type,
  id AS entity_id,
  CAST('MONTHLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('MONTH', onboarding_date) AS DATE) AS period_start
FROM olap.clients_dm
WHERE
  disabled_at IS NULL AND NOT onboarding_date IS NULL
UNION ALL
SELECT
  CAST('CLIENT' AS VARCHAR) AS entity_type,
  id AS entity_id,
  CAST('QUARTERLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('QUARTER', onboarding_date) AS DATE) AS period_start
FROM olap.clients_dm
WHERE
  disabled_at IS NULL AND NOT onboarding_date IS NULL
UNION ALL
SELECT
  CAST('CLIENT' AS VARCHAR) AS entity_type,
  id AS entity_id,
  CAST('YEARLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('YEAR', onboarding_date) AS DATE) AS period_start
FROM olap.clients_dm
WHERE
  disabled_at IS NULL AND NOT onboarding_date IS NULL
UNION ALL
SELECT
  CAST('ACCOUNT' AS VARCHAR) AS entity_type,
  account_id AS entity_id,
  CAST('WEEKLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('WEEK', opening_date) AS DATE) AS period_start
FROM olap.accounts_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('ACCOUNT' AS VARCHAR) AS entity_type,
  account_id AS entity_id,
  CAST('MONTHLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('MONTH', opening_date) AS DATE) AS period_start
FROM olap.accounts_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('ACCOUNT' AS VARCHAR) AS entity_type,
  account_id AS entity_id,
  CAST('QUARTERLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('QUARTER', opening_date) AS DATE) AS period_start
FROM olap.accounts_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
UNION ALL
SELECT
  CAST('ACCOUNT' AS VARCHAR) AS entity_type,
  account_id AS entity_id,
  CAST('YEARLY' AS VARCHAR) AS period_kind,
  CAST(DATE_TRUNC('YEAR', opening_date) AS DATE) AS period_start
FROM olap.accounts_dm
WHERE
  disabled_at IS NULL AND NOT opening_date IS NULL
Lineage · alinma_bff.advisor_kpi_entity_bucket_adds_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.