Re: log_line_info plan
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2004-02-18T04:11:04Z
Lists: 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