performance_analysis_report_recommendations

Creates, updates, deletes, gets or lists a performance_analysis_report_recommendations resource.

Overview

Name	performance_analysis_report_recommendations
Type	Resource
Id	aws.pi.performance_analysis_report_recommendations

Fields

The following fields are returned by SELECT queries:

list_performance_analysis_report_recommendations

Name	Datatype	Description
recommendation_description	string	The recommendation details to help resolve the performance issue. For example, Investigate the following SQLs that contributed to 100% of the total DBLoad during that time period: sql-id (pattern: <code>(.|\n)*</code>)
recommendation_details	string	Detailed information about the recommendation, including steps to resolve the performance issue. (pattern: <code>(.|\n)*</code>)
recommendation_id	string	The unique identifier for the recommendation. (pattern: <code>.\S.</code>)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_performance_analysis_report_recommendations	select	region		Retrieves recommendations for a performance analysis report.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

list_performance_analysis_report_recommendations

Retrieves recommendations for a performance analysis report.

SELECT
recommendation_description,
recommendation_details,
recommendation_id
FROM aws.pi.performance_analysis_report_recommendations
WHERE region = '{{ region }}' -- required
;