How to Read Aurora Performance Insights: A Developer’s Guide to Faster Queries

Why Developers Should Care About PI

Enabling Performance Insights

performance_insights_enabled = true

1. Load & Latency

2. Select Patterns

3. Sorting

4. Rows & Temporary Tables

5. Locks

6. Per-Call Metrics

Putting It All Together

Example

SELECT * FROM orders WHERE YEAR(created_at) = 2024;

ALTER TABLE orders ADD INDEX idx_created_at (created_at);
SELECT * FROM orders WHERE created_at BETWEEN '2024-01-01' AND '2024-12-31';

Key Takeaways

Related Documentations