How to download entire sql query on RDS

Question

I am using RDS and there are some queries causing load issues. How to download the entire query?

When I use the download button on the specific query, it only downloads a partial query. Is there a way to inform the AWS team that their SQL download button is broken?

Answer

By default, each row in the Top SQL table shows 500 bytes of SQL text for each SQL statement.
When a SQL statement exceeds 500 bytes, you can view more text in the SQL text section below the Top SQL table. In this case, the maximum length for the text displayed in SQL text is 4 KB. 
This limit is introduced by the console and is subject to the limits set by the database engine. 
To save the text shown in SQL text, choose Download.

[+] Accessing more SQL text in the Performance Insights dashboard - Text size limits for Amazon RDS engines - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.SQLTextSize.html#sql-text-engine-limits

How to download entire sql query on RDS

相關內容