How to monitor query execution time in postgres

Recently, I had to debug our database to find out why some of the transaction takes more time.

This can be done by making use of the postgresql.conf.

Enable logging of long queries#

With the below configuration property, we can tell the postgres to log statements that take too long to execute.

log_min_duration_statement='300' # Time in milliseconds

Now, we can monitor the logs to see the long queries.