Questions tagged with Performance Insights
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
RDS performance insights Top Sql full query
According to this: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.SQLTextSize.html#view-download-text I should see a way to download the query in question. But I do not see a download button. I only see a copy button which also copies the shown 500 chars. How do I see the full query? Or see the download button to get it?
Feature request: show full MySQL statements in Performance Insights
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 the full SQL statement, choose Download." (It also shows "If the SQL statement exceeds 4096 characters, it is truncated" - and in principal only 1024 characters are being shown) I also enlarged digest max_digest_length / performance_schema_max_digest_length / performance_schema_max_sql_text_length to 50K but alas. The only workaround is to query performance_schema directly with the SQL Digest ID shown in Performance Insights.
RDS Performance Insights 'Slice By User' shows Unknown user generating DB load
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 with the host I am expecting, but I also see a large amount of load coming from the host generated by a user labelled as 'Unknown'. I am using SQL Server DB. Has anyone else experienced this or is able to explain why I would be seeing this behaviour? Thanks for any help
Can not turn off Performance Insights
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, your request to modify DB instance prod-uptrade-db has failed. Performance Insights not supported for this configuration, please disable this feature.* ****** Therefore, we tried to turn off Performance Insights by following this article (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html). However, after we clicked Modify, we can't find the Performance Insights section anywhere. Anyone can help? Thank you.
Why changing RDS aurora postgres from a db.t4g.medium (2vcpu) to a db.r6g.xlarge (4vcpu) descrease the number of commited transactions?
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 after the upgrade, represented in the image by the red line, did the number of committed transactions decrease? ![image](https://i.ibb.co/jJBwWZg/Captura-de-Tela-2022-04-12-a-s-17-28-32.png) https://i.ibb.co/jJBwWZg/Captura-de-Tela-2022-04-12-a-s-17-28-32.png
MySQL RDS Performance issue(RDS instance restart)
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. Please help guide with steps to diagnose and fix the issue as I was not quite sure where to see logs on RDS.Thanks for your help! ![Screenshot!] (\\cscinfo\dfs\homes\WilKtoZ\syadlapa\Desktop\11.png) Best Regards, Ravi Yadlapalli
Query Plans in Performance Insights
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: "RDS Performance Insights allows all database users to identify the most resource intensive SQL queries and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights also collects query plans of resource intensive SQL queries and stores them over time. You can determine if the changed performance of a SQL query is due to a different query plan, compare the old and new query plans, and then make improvements to your application such as optimizing a slow SQL query, adding an index to your database, and scaling your database." Now that announcement has been removed and there is no mention of this feature in the RDS docs or in the Performance Insights section of the RDS console. What is happening with this feature?
Performance Insights for Postgres 12.2 is consuming 100% CPU
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 permanently under user **rdsadmin** from 127.0.0.1, consuming 100% CPU on Postgres 12.2 in RDS.
Performance Insights Counter Metrics and Database Load graphs not visible.
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 of the page. Where the Counter Metrics and Database Load graphs should be visible, we only see a spinner that never loads the graphs. I have tried disabling and enabling performance insights on the database without success. Anyone else see this issue or have any ideas? Thank you and kind regards, Sean Flaherty
Performance Insights disappeared after upgrading to MySQL 8
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 Performance Insights panel since the upgrade - if I go to Database -> Modify, the "Performance Insights" section is no more visible - column "Current activity" in the DB summary always shows 0 Sessions (but my website is running ok) What's happened? Thank you Edited by: afrancesconi on Mar 22, 2019 6:01 AM Edited by: afrancesconi on Mar 22, 2019 6:02 AM