| From: | Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> |
|---|---|
| To: | Julien Rouhaud <rjuju123(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: backend type in log_line_prefix? |
| Date: | 2020-02-13 09:43:32 |
| Message-ID: | d7dd4aad-c0f3-ecc3-e0f9-def491951e2f@oss.nttdata.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2020-02-13 11:00:54 | allow running parts of src/tools/msvc/ under not Windows |
| Previous Message | Julien Rouhaud | 2020-02-13 09:39:45 | Re: [PATCH] Erase the distinctClause if the result is unique by definition |