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