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




---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to