Questions tagged with Performance Insights
Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action.
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
68 results
I'm experiencing unexpectedly high CPU usage on my AWS Lightsail instance, with the majority of CPU time categorized as "Other." The attached graph shows a significant portion of CPU usage labeled as ...
I have been seeing this for sometime now, wherein the CPU spent in processing incoming requests from my application is always attributed as 'CPU Nice'. But I believe it should be 'CPU User', given tha...
I’ve been running a large insert query on my SQL Server database (around 15 columns, ~3 million rows). While I expected some delay, the insertion has stopped making progress.
The query is still activ...
I have seen intermittent issues with the Performance of the Select Queries where the same query randomly takes 8-10s. I have enabled Slow query logs and randomly some queries that are simple and use p...
Hi
I am following steps mentioned here -https://docs.aws.amazon.com/documentdb/latest/developerguide/performance-insights-enabling.html
to enable performance insights
Documentation mentions that,
...
The AWS documentation says that Performance Insight does not use instance storage, but we've noticed something different.
We activated it into a reader instance (MySQL Aurora 3.06.0 - r6g.2xlarge). T...
We have enable the Performance Insights, but we can't show the call/sec..etc in each query.
![Enter image description here](/media/postImages/original/IMkasMYu4AQoui3bo2H0pT8A)
We don't really know...
![![Enter image description here](/media/postImages/original/IMFS53IpuyTse4k_w1s4c1Fw)
![Enter image description here](/media/postImages/original/IMB8CzPhKYRx6-axpyWWeO1Q)
There are 3 drops in Freea...
![Enter image description here](/media/postImages/original/IMdQlbBkN6TSaKxgrd6S8AmQ)
Both queries are the same except WHERE entity in (different identifier) as the first step in a CTE.
The entity in ...
Hello,
I am using performance insights to troubleshoot high CPU(98%) issue on PostgreSQL RDS.
RDS -> Writer Instance -> sessions (Current activity) -> Dimensions -> Top hosts
There I can see Unknown ...
If an RDS has a writer and a reader instance. If I then want to complete Analytics work by connecting to the Reader instance. Given that both instances connect to the same DB. Is there a potential to ...
We were originally using a db.r5.8xlarge as our write instance, and Performance Insights was displaying the DB load queries properly. However, after updating to a db.r5.16xlarge more than a week ago, ...