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
984
State size
74.7 KiB
Created
2026-08-20 16:55
Initialized
2026-08-20 16:55
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
742129 62448 51 running
742130 62448 51 running
742209 62450 51 running
742210 62450 51 running
742211 62451 51 running
742212 62451 51 running
742213 62452 51 running
742214 62452 51 running
742215 62453 51 running
742216 62453 51 running
742217 62449 51 running
742218 62449 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.