Re: log_line_info plan - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: log_line_info plan
Date
Msg-id 4032E5D8.1030908@dunslane.net
Whole thread Raw
In response to Re: log_line_info plan  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers

Joshua D. Drake wrote:

> Andrew Dunstan wrote:
>
>>
>> I am about to redo the patch that would allow tagging of log lines 
>> with info via a printf-style string.
>>
>> Current plans are to call the config parameter "log_line_info" and 
>> implement the following escapes:
>>
>> %U = user
>> %D = database
>> %T = timestamp
>> %P = pid
>> %L = session log line number
>> %C = sessionid cookie (hex encoded session start time + pid)
>> %S = session start timestamp
>> %I = Command Tag (e.g. "CREATE TABLE")
>>
>> Any comments or suggestions before I start?
>
>
> My be kind of cool if we a a duration variable in there, especially if 
> combined with %I
>

Duration of what?

This patch will not generate a single extra log line. It is intended to 
tag existing log lines, particularly to make creating log analysis tools 
and loading logs to tables easier.

cheers

andrew





pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: log_line_info plan
Next
From: Tom Lane
Date:
Subject: Re: log_line_info plan