Re: PATCH: numeric timestamp in log_line_prefix
От | Fabien COELHO |
---|---|
Тема | Re: PATCH: numeric timestamp in log_line_prefix |
Дата | |
Msg-id | alpine.DEB.2.10.1508220839000.30043@sto обсуждение исходный текст |
Ответ на | PATCH: numeric timestamp in log_line_prefix (Tomas Vondra <tomas.vondra@2ndquadrant.com>) |
Ответы |
Re: PATCH: numeric timestamp in log_line_prefix
|
Список | pgsql-hackers |
Hello Tomas, > from time to time I need to correlate PostgreSQL logs to other logs, > containing numeric timestamps - a prime example of that is pgbench. With > %t and %m that's not quite trivial, because of timezones etc. > > I propose adding two new log_line_prefix escape sequences - %T and %M, > doing the same thing as %t and %m, but formatting the value as a number. > > Patch attached, I'll add it to CF 2015-06. Are you planing to update this patch? I was wanting to use it for some tests and figured out that it had stayed as a proposal, too bad. I would suggest to maybe follow Tom's %u idea and fix the implementation details wrt to comments received? It seems to me that always having milliseconds "123456789.012" would be fine, it can easily be filtered out if not necessary or would be there if useful, so maybe just one more format is enough. -- Fabien.
В списке pgsql-hackers по дате отправления: