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

AWS RDS Insights Metrics Query

0

Hi, I would like to query metric values for the RDS instance using the Cloudwatch Metrics Insights query language. The result should be grouped by DBInstanceIdentifier and filtered by engineName e.g. only metric values for 'mysql' instances should be returned. I've tried running the query like this:

SELECT AVG (CPUUtilization) FROM SCHEMA ("AWS/RDS", EngineName, DBInstanceIdentifier) WHERE EngineName = 'mysql' GROUP BY DBInstanceIdentifier

but it doesn't return any results

Could I ask for help? Regards

Topics
Management & GovernanceNetworking & Content DeliveryDatabase
Tags
Amazon CloudWatchAmazon RDS for SQL Server
Language
English
Jakub Krawczak
asked 10 months ago343 views
1 Answer
0

Try this one. Minor edits...

SELECT AVG(CPUUtilization) 
FROM "AWS/RDS" 
WHERE EngineName = 'mysql' 
GROUP BY DBInstanceIdentifier
profile picture
EXPERT
Giovanni Lauria
answered 10 months ago
  • Jakub Krawczak
    10 months ago

    I got the result like this:

    "Messages": [],
"MetricDataResults": [
    {
        "Id": "m1",
        "Label": "Other",
        "StatusCode": "Complete",
        "Timestamps": [
            some timestamps data
        ],
        "Values": [
            some metric data
        ]
    }
]

    }

    No idea why there is only one result with the 'Other' Label

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