Re: WIP patch - INSERT-able log statements - Mailing list pgsql-patches

From daveg
Subject Re: WIP patch - INSERT-able log statements
Date
Msg-id 20070221220011.GB11978@sonic.net
Whole thread Raw
In response to Re: WIP patch - INSERT-able log statements  ("FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>)
List pgsql-patches
On Thu, Feb 22, 2007 at 11:50:06AM +1100, FAST PostgreSQL wrote:
> - The log output will be in COPY format and will include the following
> information, irrespective of the log_line_prefix setting.
> ( timestamp_with_milliseconds,  timestamp, username,  databasename,
> sessionid,  host_and_port, host, proc_id, command_tag,  session_start,
> transaction_id,  error_severity,  SQL_State_Code, statement/error_message);

Why are there two timestamps?

What about durations? Do they include all this?

Is the statement log written when the statement starts or when it completes?

-dg

--
David Gould                      daveg@sonic.net
If simplicity worked, the world would be overrun with insects.

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [previously on HACKERS] "Compacting" a relation
Next
From: Bruce Momjian
Date:
Subject: Re: [previously on HACKERS] "Compacting" a relation