Re: duration logging setting in 7.4 - Mailing list pgsql-performance

Ryszard Lach wrote:
>
> Hi.
>
> I'm trying to set run-time environment in pgsql7.4 so, that it prints
> all statements with duration time, but I can't understand why setting
> log_min_duration_statement to '0' causes printing to syslog plenty of
> lines ending with 'duration: statement:', i.e. without any statement
> string (except expected ones). Can anybody help me?

Can you show us some of the log file?  If I do:

    test=> set log_min_duration_statement = 0;
    SET
    test=> select 1;
     ?column?
    ----------
            1
    (1 row)

I get:

    LOG:  duration: 0.861 ms  statement: select 1;

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073