By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Programmatically download RDS/Performance insights details using python SDK

0

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.

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServicePerformance Insights
Language
English
Ravi-7952350
asked 7 months ago310 views
1 Answer
0

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

profile picture
EXPERT
Riku_Kobayashi
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content