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 ...
1
answers
0
votes
19
views
asked 9 days ago
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...
1
answers
0
votes
43
views
asked 2 months ago
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...
1
answers
0
votes
57
views
asked 2 months ago
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...
1
answers
0
votes
87
views
asked 3 months ago
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, ...
1
answers
0
votes
85
views
asked 3 months ago
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...
0
answers
0
votes
329
views
asked 3 months ago
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...
1
answers
0
votes
462
views
asked 4 months ago
![![Enter image description here](/media/postImages/original/IMFS53IpuyTse4k_w1s4c1Fw) ![Enter image description here](/media/postImages/original/IMB8CzPhKYRx6-axpyWWeO1Q) There are 3 drops in Freea...
1
answers
0
votes
266
views
asked 5 months ago
![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 ...
2
answers
0
votes
265
views
asked 5 months ago
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 ...
1
answers
0
votes
982
views
asked 6 months ago
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 ...
2
answers
0
votes
441
views
asked 8 months ago
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, ...
1
answers
0
votes
389
views
asked 8 months ago