Understand DPUs in Explain Analyze Verbose
Aurora DSQL provides statement-level Distributed Processing Unit (DPU) information in EXPLAIN ANALYZE VERBOSE plan output, giving you deeper visibility into query cost during development:
What is a DPU? A Distributed Processing Unit (DPU) is the normalized measure of work done by Aurora DSQL. It is composed of:
ComputeDPU – Time spent executing SQL queries
ReadDPU – Resources used to read data from storage
WriteDPU - Resources used to write data to storage
-MultiRegionWriteDPU – Resources used to replicate writes to peered clusters in multi-Region configurations
Aurora DSQL extends EXPLAIN ANALYZE VERBOSE to include a statement-level DPU usage estimate at the end of the output. This provides immediate visibility into query cost, helping you identify workload cost drivers, tune query performance, and better forecast resource usage.
Here is the example of EXPLAIN ANALYZE VERBOSE of the SELECT query in the single-region cluster:
We see ComputeDPU and ReadDPU being presented only, as it's a read statement.
Here is the example of EXPLAIN ANALYZE VERBOSE of the INSERT statement in the multi-region cluster:
We see ComputeDPU, the same values for WriteDPU and MultiRegionWriteDPU, and a small portion of ReadDPU being presented, as it's a multi-region write statement.
For more information about the integrated query editor, please read the article Understanding DPUs in EXPLAIN ANALYZE.
Top comments (0)