By using AWS re:Post, you agree to the AWS re:Post Terms of Use

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.

70 results
Currently, I've noticed there is no real option to view full MySQL statements in Performance Insights. Download option gives file with the same truncated statement even though the UI shows "To view ...
3
answers
0
votes
486
views
asked 2 years ago
I am using AWS RDS Performance Insights and am trying to establish who and what is generating DB load, when viewing 'Slice By User' I see the expected username of the DB connection cross-referenced wi...
1
answers
0
votes
4.2K
views
asked 2 years ago
The purpose is to delete an old database (Size: db.m5.xlarge; DB Engine: 8.0.16 Version). First, we tried to disable Delete Protection, but it shows an error message as below: ***** *We're sorry, yo...
1
answers
0
votes
3.6K
views
asked 3 years ago
Hello. I was having CPU usage issues where the CPU would reach over 50%. So I upgraded from a db.t4g.medium to a db.r6g.xlarge. Now, all is good and running smooth. But one thing intrigues me: Why a...
1
answers
0
votes
562
views
asked 3 years ago
Hello Team, MySQL RDS instance has been restarted on its own and now online. Would like to know why it was restarted and root cause and fix to not repeat. Only I see from CloudWatch is below one. Ple...
2
answers
0
votes
916
views
asked 3 years ago
Hi. we have the Mysql database with Saas in AWS and I need to know how I do an alert that after a 1minute alarm to me from email with the deadlock?
Accepted AnswerPerformance Insights
1
answers
0
votes
304
views
asked 3 years ago
Query Plans in Performance Insights was announced on July 2, 2020, at https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-performance-insights-supports-query-plan-capture/. It said: "RD...
1
answers
0
votes
919
views
asked 4 years ago
A query for `select datname, pid, usename, application_name, client_addr, client_hostname, wait_event_type, wait_event, query, backend_type from pg_stat_activity where state = 'active'` is running p...
1
answers
0
votes
636
views
asked 4 years ago
Hello, We have an db.t3.large RDS instance running Postgres 11.4. We have enabled performance insights but when we go to view the page for our database, we only see the bar chart at the bottom o...
Accepted AnswerPerformance Insights
1
answers
0
votes
509
views
asked 5 years ago
I have a RDS db.t2.medium MySQL DB. I've just upgraded from MySQL 5 to MySQL 8.0.13 successfully... but then Performance Insights seem to stop working: - no data are being recorded anymore in the Pe...
1
answers
0
votes
676
views
asked 6 years ago