FarEye Blog

Amazon RDS + Postgres – Activate slow query logs

Posted on in Blog

  1. Login to your AWS console and go to RDS.
  2. From the left menu, select Parameter Groups
  3. Create a new parameter group for Postgres, by copying the default Postgres parameter group
  4. Edit the following parameters in the new group:
    Parameter Name Value
    log_min_duration_statement 250
    log_statement none
    log_duration 0
  5. Modify the RDS instance and apply the new parameters group.
  6. Beware – If you are applying group for the first time, it will require a RDS reboot.