All Content 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
68 results
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...
1
answers
0
votes
23
views
asked 21 days 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...
1
answers
0
votes
36
views
Eloy
asked 25 days 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...
1
answers
0
votes
51
views
asked a month 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
58
views
dev
asked 2 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)....
0
answers
0
votes
314
views
dirk39
asked 2 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
343
views
Tomas
asked 3 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...
1
answers
0
votes
241
views
Han
asked 4 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
232
views
Han
asked 4 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
913
views
rgri
asked 5 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
412
views
asked 6 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
367
views
Hoon
asked 7 months ago