AWSConfigRemediation-EnablePerformanceInsightsOnRDSInstance - Amazon Systems Manager Automation runbook reference
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).



The AWSConfigRemediation-EnablePerformanceInsightsOnRDSInstance runbook enables Performance Insights on the Amazon RDS DB instance you specify.

Run this Automation (console)

Document type







  • AutomationAssumeRole

    Type: String

    Description: (Required) The Amazon Resource Name (ARN) of the Amazon Identity and Access Management (IAM) role that allows Systems Manager Automation to perform the actions on your behalf.

  • DbiResourceId

    Type: String

    Description: (Required) The resource identifier for the DB instance you want to enable Performance Insights on.

  • PerformanceInsightsKMSKeyId

    Type: String

    Default: alias/aws/rds

    Description: (Optional) The Amazon Resource Name (ARN), key ID, or the key alias of the Amazon Key Management Service (Amazon KMS) customer managed key you want Performance Insights to use to encrypt all potentially sensitive data. If you enter the key alias for this parameter, prefix the value with alias/ . If you do not specify a value for this parameter, the Amazon managed key is used.

  • PerformanceInsightsRetentionPeriod

    Type: Integer

    Valid values: 7, 731

    Default: 7

    Description: (Optional) The number of days you want to retain Performance Insights data.

Required IAM permissions

The AutomationAssumeRole parameter requires the following actions to use the runbook successfully.

  • ssm:StartAutomationExecution

  • ssm:GetAutomationExecution

  • kms:CreateGrant

  • kms:DescribeKey

  • rds:DescribeDBInstances

  • rds:ModifyDBInstance

Document Steps

  • aws:executeAwsApi - Gathers the DB instance identifier from the DB instance resource identifier.

  • aws:assertAwsResourceProperty - Confirms the DB instance status is available .

  • aws:executeAwsApi - Gathers the ARN of the Amazon KMS customer managed key specified in the PerformanceInsightsKMSKeyId parameter.

  • aws:branch - Checks whether a value is already assigned to the PerformanceInsightsKMSKeyId property of the DB instance.

  • aws:executeAwsApi - Enables Performance Insights on the DB instance you specify in the DbiResourceId parameter.

  • aws:assertAwsResourceProperty - Confirms the value specified for the PerformanceInsightsKMSKeyId parameter was used to enable encryption for Performance Insights on the DB instance.

  • aws:assertAwsResourceProperty - Confirms Performance Insights is enabled on the DB instance.