Analyzing database performance for a period of time
You can create a performance analysis report for a period of time and find out any performance issues such as resource bottlenecks or changes in a query in your DB instance. The Performance Insights dashboard allows you to select a time period and create a performance analysis report. You can also add one or more tags to the report.
To use this feature, you must be using the paid tier retention period. For more information, see Pricing and data retention for Performance Insights
The report is available in the Performance analysis reports - new tab to select and view. The report contains the insights, related metrics, and recommendations to resolve the performance issue. The report is available to view for the duration of Performance Insights retention period.
The report is deleted if the start time of the report analysis period is outside of the retention period. You can also delete the report before the retention period ends.
To detect the performance issues and generate the analysis report for your DB instance, you must turn on Performance Insights. For more information about turning on Performance Insights, see Turning Performance Insights on and off.
For the region, DB engine, and instance class support information for this feature, see Amazon RDS DB engine, Region, and instance class support for Performance Insights features
Creating a performance analysis report
You can create a performance analysis report for a specific period in the Performance Insights dashboard. You can select a time period and add one or more tags to the analysis report.
The analysis period can range from 5 minutes to 6 days. There must be at least 24 hours of performance data before the analysis start time.
To create a performance analysis report for a time period
Open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
In the left navigation pane, choose Performance Insights.
-
Choose a DB instance.
The Performance Insights dashboard appears for the DB instance.
-
Choose Analyze performance in Database load section on the dashboard.
The fields to set the time period and add one or more tags to the performance analysis report are displayed.
-
Choose the time period. If you set a time period in the Relative range or Absolute range in the upper right, you can only enter or select the analysis report date and time within this time period. If you select the analysis period outside of this time period, an error message displays.
To set the time period, you can do any of the following:
-
Press and drag any of the sliders on the DB load chart.
The Performance analysis period box displays the selected time period and DB load chart highlights the selected time period.
-
Choose the Start date, Start time, End date, and End time in the Performance analysis period box.
-
-
(Optional) Enter Key and Value-optional to add a tag for the report.
Choose Analyze performance.
A banner displays a message whether the report generation is successful or failed. The message also provides the link to view the report.
The following example shows the banner with the report creation successful message.
The report is available to view in Performance analysis reports - new tab.
You can create a performance analysis report using the Amazon CLI. For an example on how to create a report using Amazon CLI, see Creating a performance analysis report for a time period.
Viewing a performance analysis report
The Performance analysis reports - new tab lists all the reports that are created for the DB instance. The following are displayed for each report:
-
ID: Unique identifier of the report.
-
Name: Tag key added to the report.
-
Report creation time: Time you created the report.
-
Analysis start time: Start time of the analysis in the report.
-
Analysis end time: End time of the analysis in the report.
To view a performance analysis report
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
In the left navigation pane, choose Performance Insights.
-
Choose a DB instance for which you want to view the analysis report.
The Performance Insights dashboard appears for the DB instance.
-
Scroll down and choose Performance analysis reports - new tab.
All the analysis reports for the different time periods are displayed.
-
Choose ID of the report you want to view.
The DB load chart displays the entire analysis period by default if more than one insight is identified. If the report has identified one insight then the DB load chart displays the insight by default.
The dashboard also lists the tags for the report in the Tags section.
The following example shows the entire analysis period for the report.
-
Choose the insight in the Database load insights list you want to view if more than one insight is identified in the report.
The dashboard displays the insight message, DB load chart highlighting the time period of the insight, analysis and recommendations, and the list of report tags.
The following example shows the DB load insight in the report.
Adding tags to a performance analysis report
You can add a tag when you create or view a report. You can add up to 50 tags for a report.
You need permissions to add the tags. For more information about the access policies for Performance Insights, see Configuring access policies for Performance Insights
To add one or more tags while creating a report, see step 6 in the procedure Creating a performance analysis report.
To add one or more tags when viewing a report
Open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
In the left navigation pane, choose Performance Insights.
-
Choose a DB instance.
The Performance Insights dashboard appears for the DB instance.
-
Scroll down and choose Performance analysis reports - new tab.
Choose the report for which you want to add the tags.
The dashboard displays the report.
-
Scroll down to Tags and choose Manage tags.
-
Choose Add new tag.
-
Enter the Key and Value - optional, and choose Add new tag.
The following example provides the option to add a new tag for the selected report.
A new tag is created for the report.
The list of tags for the report is displayed in the Tags section on the dashboard. If you want to remove a tag from the report, choose Remove next to the tag.
Deleting a performance analysis report
You can delete a report from the list of reports displayed in the Performance analysis reports tab or while viewing a report.
To delete a report
Open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
In the left navigation pane, choose Performance Insights.
-
Choose a DB instance.
The Performance Insights dashboard appears for the DB instance.
-
Scroll down and choose Performance analysis reports - new tab.
-
Select the report you want to delete and choose Delete in the upper right.
A confirmation window is displayed. The report is deleted after you choose confirm.
-
(Optional) Choose ID of the report you want to delete.
In the report page, choose Delete in the upper right.
A confirmation window is displayed. The report is deleted after you choose confirm.