Amazon RDS + Postgres – Activate slow query logs

Date Posted on 28th Aug 2015 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.

 



Let's Talk
Talk

Let’s Talk

Drop us a line by using the form

About us

FarEye’s technology solutions revolutionise enterprise operations by empowering the field workforce of a client company using a powerful mobile platform. FarEye’s intuitive dashboard delivers real-time visibility to CXOs to better serve their customers. This empowers the enterprises to build a competitive advantage by improving its agility. Read more

Resources

Quick Link