On 06/12/2018 08:25 PM, David G. Johnston wrote:
On Tuesday, June 12, 2018, Andrew Bartley <ambartley@xxxxxxxxx
<mailto:ambartley@xxxxxxxxx>> wrote:
On Wed, 13 Jun 2018 at 12:43 Laurenz Albe <laurenz.albe@xxxxxxxxxxx
<mailto:laurenz.albe@xxxxxxxxxxx>> wrote:
log_min_duration_statement = 0
[...]
log_min_duration_statement -1
You've disabled statement logging altogether. The zero value you were
directed to use is what causes everything to be logged.
Actually no:
https://www.postgresql.org/docs/10/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
log_min_duration_statement (integer)
"... Setting this to zero prints all statement durations. Minus-one (the
default) disables logging statement durations. ..."
"
So -1 only affects logging statements relative to duration.
If you have log_statements set then you will still get statements logged
if you have log_min_duration_statement = -1 :
Note
When using this option together with log_statement, the text of
statements that are logged because of log_statement will not be repeated
in the duration log message.
"
This is how I have my logging setup, log_min_duration_statement = -1
and log_statements = 'mod' and I see statements in the logs.
David J.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
