Postgres Pro
Downloads
Home   >   mailing lists

PATCH: numeric timestamp in log_line_prefix - Mailing list pgsql-hackers

From Tomas Vondra
Subject PATCH: numeric timestamp in log_line_prefix
Date
Msg-id 550E0300.8040502@2ndquadrant.com
Whole thread Raw
Responses Re: PATCH: numeric timestamp in log_line_prefix  (Bruce Momjian <bruce@momjian.us>)
Re: PATCH: numeric timestamp in log_line_prefix  (David Rowley <dgrowleyml@gmail.com>)
Re: PATCH: numeric timestamp in log_line_prefix  (Fabien COELHO <coelho@cri.ensmp.fr>)
Re: PATCH: numeric timestamp in log_line_prefix  (Andres Freund <andres@2ndquadrant.com>)
Re: PATCH: numeric timestamp in log_line_prefix  (Jeff Janes <jeff.janes@gmail.com>)
Re: PATCH: numeric timestamp in log_line_prefix  (Fabien COELHO <coelho@cri.ensmp.fr>)
Re: PATCH: numeric timestamp in log_line_prefix  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Hi,

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.

regards

--
Tomas Vondra                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: INT64_MIN and _MAX
Next
From: Tom Lane
Date:
Subject: Display of multi-target-table Modify plan nodes in EXPLAIN