Turn on PostgreSQL logs in Qlik Sense

This article explains how to turn on PostgreSQL logs in Qlik Sense.

1. On the Qlik Sense Server, open Postgresql.conf in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6
2. Add or uncomment the following lines (refer to example of configuration file attached to this article):

      3. Restart Qlik Sense Repository Database (This will also restart all other Qlik Sense services)
      4. Logs will be created in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6\pg_log

If customer is concerend about resource requirements or performance "hit" with logging turned on, here are some comments from R&D (documented in SF case 1361021)

Average response time:

Slightly higher with logging enabled but the biggest difference was only 4ms. Average time without logging 163ms, with logging 166ms.

Processor time:

PostgreSQL used very little CPU time. Average time without logging was 0.29%, with logging 0.33%.

Memory usage:

Here, slightly less memory was used with logging enabled. Average without logging 1.16GB, with logging 1.13GB.

Log files on disk:

With logging enabled, a number of files were created on the local disk:   About 10MB of data were created every minute.