Aurora RDS Postgres DB alerts by query execution latency

0

Hi fam,

I have this requirement, DB alerts by query execution latency , this means we need to set alarm one of our query running more that 5 second. but i did not find any metric regarding this.

layansp
asked 6 months ago224 views
1 Answer
1
Accepted Answer

Hello.

As you may know, RDS metrics do not include metrics related to slow queries.
So, enable query logging for RDS PostgreSQL and change "log_statement" to 1 in the RDS parameter group.
Also, by setting the value of "log_min_duration_statement" to 5000, queries that take more than 5 seconds to execute will be output to the log.
Please set the type of query you want to output to the log with the value of "log_statement".
https://repost.aws/knowledge-center/rds-postgresql-query-logging

After outputting to CloudWatch Logs, you can create metrics by using a metric filter, etc., and then you can create alarms.

profile picture
EXPERT
answered 6 months ago
profile picture
EXPERT
reviewed 3 months ago
  • thank you so much Riku, its work

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