process type escape for log_line_prefix - Mailing list pgsql-hackers

From Andres Freund
Subject process type escape for log_line_prefix
Date
Msg-id 20160208143231.tqf6ydt5ohnosozn@alap3.anarazel.de
Whole thread Raw
Responses Re: process type escape for log_line_prefix  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Hi,

Frequently when reading postgres logs to do some post mortem analysis
I'm left wondering what process emitted an error/log message. After the
fact it's often hard to know wether an error message was emitted by a
user backend or by something internal, say the checkpointer or
autovacuum.  Logging all process starts is often impractical given the
log volume that causes.

So I'm proposing adding an escape displaying the process title (say 'k'
for kind?). So %k would emit something like "autovacuum worker process",
"wal sender process" etc.

I'm thinking it might make sense to give normal connections "" as the
name, they're usually already discernible.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby
Next
From: David Steele
Date:
Subject: Re: remove wal_level archive