1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
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.
Contenus pertinents
- demandé il y a 2 mois
- demandé il y a 8 mois
- Réponse acceptéedemandé il y a 7 mois
- demandé il y a 4 mois
- AWS OFFICIELA mis à jour il y a 4 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 2 ans
thank you so much Riku, its work