How to get the queries made to AWS/RDS in Grafana

Question

I have a grafana instance running in a kubernetes cluster. I have set up a CoudWatch Datasource with the corresponding credentials and I can retrieve some metrics.

My specific need is to know if I can retrieve the queries to the DB (or SQL digest) like RDS does in TOP SQL on AWS Console (https://i.stack.imgur.com/H6sO4.png) or something similar, so I can check the query performance.

Thank you so much in advance.

user_4157589 · Answer

You can do this with the following steps:

First, Enable the Query logging for Amazon RDS: eg. PostgreSQL and MySQL
Then, publish the logs to Amazon CloudWatch Logs
And, in the Grafana side, add the AWS CloudWatch data source integration

This way you be able to get your queries in Grafana like this Cloudwatch Logs integration example.

If you want you can analise/filter your RDS logs using CloudWatch Logs Insights in Grafana.

How to get the queries made to AWS/RDS in Grafana

1 Answers