Seamless and Efficient Database Monitoring out of box tool
Use Cases and Deployment Scope
We leverage Amazon RDS Performance Insights to better understand the load on our Postgres RDS instance and to find queries or jobs with room for improvement in regards to performance. Amazon RDS Performance Insights also brings a lot of out of the box metrics and data that help us make decisions on how to break our DB management and how to scale it.
Pros
- RDS Infrastructure Metrics
- RDS Logical Metrics
- Real time visualization of query load
- Identify Performance Bottlenecks
- Historical Performance Analysis of load
Cons
- Easier way to identify to which service the query comes from
- Easier way to identify correlation between metrics
- More customization, right now it is too restricted
- The interval could be smaller between data points for peaks of usage
Likelihood to Recommend
When you need to monitor your database at low level metrics such as query load or CPU usage at some point in time. You can also use it to understand which component is a heavy load on your DB. It is a great tool for routine monitoring of your DB and to help plan for capacity.
I would not use it as an exclusive source for scaling your DB though since the is not long-term or very granular data to be able to run a thorough analysis on peaks of predictive analysis.
