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 Explain plan ▶
Parallelism
2
Actors
6 / 6
running
Distribution
HASH
Rows
245
State size
22.7 KiB
Created
2026-07-06 17:26
Initialized
2026-07-06 17:26
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
96771 9227 26 running
96772 9227 26 running
98462 9228 26 running
98463 9228 26 running
98549 9229 26 running
98550 9229 26 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.