Configuring your database to monitor slow SQL queries with Database Insights for Amazon Aurora - Amazon Aurora

Configuring your database to monitor slow SQL queries with Database Insights for Amazon Aurora

To configure your database to monitor slow SQL queries with Database Insights, create or modify the DB cluster parameter group for your DB cluster.

To create or modify your DB cluster parameter group, see the following topics.

Amazon Aurora MySQL

To configure your Amazon Aurora MySQL DB cluster to monitor slow SQL queries, set the following parameters.

  • slow_query_log – set to 1

  • long_query_time – set to 0.001

  • log_output – set to FILE

Amazon Aurora PostgreSQL

To configure your Amazon Aurora PostgreSQL DB cluster to monitor slow SQL queries, set the following parameters.

  • log_min_duration_statement – set to 1

  • log_statement – set to none

  • log_destination – set to stderr