Re: log_line_info plan

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