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

← cluster adib_rm objects sdk_order_execution_aggregates_mv
Overview Objects Graph History
materialized view · adib_rm.sdk_order_execution_aggregates_mv
Parallelism
2
Actors
6 / 6
running
Distribution
HASH
Rows
0
State size
—
Created
2026-06-30 21:38
Initialized
2026-06-30 21:38
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
53365 2487 3 running
53366 2487 3 running
54092 2486 3 running
54093 2486 3 running
54162 2488 3 running
54163 2488 3 running
sql · adib_rm.sdk_order_execution_aggregates_mv — click to expand 
CREATE MATERIALIZED VIEW adib_rm.sdk_order_execution_aggregates_mv AS
SELECT
  ex.order_id,
  SUM(CAST(ex.quantity AS DECIMAL)) AS filled_quantity,
  SUM(
    CAST(ex.quantity AS DECIMAL) * CAST((
      ex.price -> 'amount' ->> 'value'
    ) AS DECIMAL)
  ) AS total_amount,
  SUM(CAST((
    ex.commission -> 'amount' ->> 'value'
  ) AS DECIMAL)) AS total_fees,
  SUM(
    CAST(ex.quantity AS DECIMAL) * CAST((
      ex.price -> 'amount' ->> 'value'
    ) AS DECIMAL)
  ) / NULLIF(SUM(CAST(ex.quantity AS DECIMAL)), 0) AS average_price,
  MAX(ex.price -> 'currency_code' ->> 'value') AS execution_currency_code
FROM order_service.order_executions AS ex
JOIN order_service.orders AS o
  ON o.id = ex.order_id
GROUP BY
  ex.order_id
Lineage · adib_rm.sdk_order_execution_aggregates_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.