CODE EXAMPLE FOR SQL

postgresql log

Here you can find all the informations about logs and how to 
set them with your preferences:
https://www.postgresql.org/docs/9.1/runtime-config-logging.html