Programmatically download RDS/Performance insights details using python SDK

Question

I have an RDS that has Performance insights enabled. I can view the performance from the console. Is there a way to download the various metrics from the Dimensions Tab? I am specifically interested in downloading the "Top SQL" rows once a day using python SDK.

Answer

Hello.

As far as I can see from the document below, it may be possible to display it by using "get_resource_metrics" or "describe_dimension_keys".  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.API.html

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/pi/client/get_resource_metrics.html
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/pi/client/describe_dimension_keys.html

Programmatically download RDS/Performance insights details using python SDK

Relevanter Inhalt