log_min_duration_statement oddity

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: log_min_duration_statement oddity
Date: 2005-10-19 15:01:46
Message-ID: 1129734106.27587.112.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Postgres version: 8.0.3

I wonder if I understood correctly what log_min_duration_statement
does... I set it to 2000, and the result is that all queries running
more than 2 seconds on _local_ connections are logged, but long running
queries on remote connections are not logged. Is this something to be
expected, or it's a bug ?

Thanks,
Csaba.

The complete log relevant configuration as I have it in postgresql.conf:

# - When to Log -

#client_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2,
debug1,
# log, notice, warning, error

log_min_messages = info # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2,
debug1,
# info, notice, warning, error, log,
fatal,
# panic

log_error_verbosity = default # terse, default, or verbose messages

#log_min_error_statement = panic # Values in order of increasing
severity:
# debug5, debug4, debug3, debug2,
debug1,
# info, notice, warning, error,
panic(off)

log_min_duration_statement = 2000 # -1 is disabled, in milliseconds.

#silent_mode = false # DO NOT USE without syslog or
redirect_stderr

# - What to Log -

debug_print_parse = false
debug_print_rewritten = false
debug_print_plan = false
debug_pretty_print = false
#log_connections = false
#log_disconnections = false
log_duration = true
log_line_prefix = '%d:%p:%r:%t:' # e.g. '<%u%%%d> '
# %u=user name %d=database name
# %r=remote host and port
# %p=PID %t=timestamp %i=command tag
# %c=session id %l=session line number
# %s=session start timestamp
%x=transaction id
# %q=stop here in non-session processes
# %%='%'
log_statement = 'none' # none, mod, ddl, all
#log_statement = 'all'
#log_hostname = false

Responses

Browse pgsql-general by date

  From Date Subject
Next Message codeWarrior 2005-10-19 15:05:53 Re: Reverse engineering SW
Previous Message Tom Lane 2005-10-19 14:53:58 Re: getting around---division by zero on numeric