Debugging db (query) issues
Techniques for finding root cause when queries are involved.
When you face unexpected behavior as a result of some database query (z_db:q et al), you either have to hunt down the queries and re-run them by hand, which is really time consuming and painful, or, which this cookbook will detail, have postgresql log the queries for you.
The principal documentation and with more details, may be found here: https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html
A working system where you want to inspect the db queries being run.
postgresql.conf file, enabling
'all'. This file has a lot of options commented out, with comments
which you may review. Options of interest in this scenario all begin
with “log” (or similar).
log_destination = 'stderr' and
on, you can capture your logging output to file.