Performance Insights
You'll learn how Performance Insights helps you spot database performance problems quickly and understand what's slowing down your workload.
What Is Performance Insights?
Performance Insights is a dashboard tool built into managed database services (like AWS RDS) that visualizes what your database is doing right now and what's causing it to wait. Instead of sifting through raw metrics like CPU or memory percentages, you get a clear view of which specific queries are consuming resources and why your database might be struggling.
Think of it like a traffic report for your database. Instead of just knowing "traffic is bad" (high CPU), Performance Insights shows you which roads are jammed (specific slow queries) and why (waiting for locks, disk I/O, or network).
What Performance Insights Reveals
Database Load: A simple metric showing how many active sessions are running. If this exceeds your instance's capacity (e.g., your instance has 2 vCPUs but load is at 5), you have contention.
Top SQL Queries: See exactly which queries consume the most time. A poorly written query might scan entire tables instead of using indexes, hogging resources.
Wait Events: Understand why queries are slow—are they waiting for disk reads? Network? Row-level locks from other transactions?
Historical Data: Compare current performance against past trends to spot degradation over time.
Why It Matters
Without Performance Insights, troubleshooting feels like guessing. With it, you quickly identify whether you need better indexes, more compute power, or query optimization—saving hours of investigation.
Key Takeaway: Performance Insights transforms raw database metrics into actionable intelligence, showing you which queries are bottlenecks and why they're slow—essential for maintaining healthy managed databases.