From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Julien Rouhaud <rjuju123@gmail.com>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: backend type in log_line_prefix?
Date: Thu, 13 Feb 2020 18:43:32 +0900
Message-ID: <d7dd4aad-c0f3-ecc3-e0f9-def491951e2f@oss.nttdata.com> (raw)
In-Reply-To: <20200213091428.GA15600@nol>
References: <c65e5196-4f04-4ead-9353-6088c19615a3@2ndquadrant.com>
<20200213091428.GA15600@nol>
On 2020/02/13 18:14, Julien Rouhaud wrote:
> On Thu, Feb 13, 2020 at 09:56:38AM +0100, Peter Eisentraut wrote:
>> Attached is a demo patch that adds a placeholder %b for log_line_prefix (not
>> in the default setting) that contains the backend type, the same that you
>> see in pg_stat_activity and in the ps status. I would have found this
>> occasionally useful when analyzing logs, especially if you have a lot of
>> background workers active. Thoughts?
If we do this, backend type should be also included in csvlog?
Regarding the patch, postgresql.conf.sample needs to be updated.
Regards,
--
Fujii Masao
NTT DATA CORPORATION
Advanced Platform Technology Group
Research and Development Headquarters
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: masao.fujii@oss.nttdata.com, rjuju123@gmail.com, peter.eisentraut@2ndquadrant.com
Subject: Re: backend type in log_line_prefix?
In-Reply-To: <d7dd4aad-c0f3-ecc3-e0f9-def491951e2f@oss.nttdata.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox