backend type in log_line_prefix?

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2020-02-13T08:56:38Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add backend type to csvlog and optionally log_line_prefix
- 70a7b4776be4 13.0 landed
Remove am_syslogger global variable
- d90bd24391fd 13.0 landed
Unify several ways to tracking backend type
- 8e8a0becb335 13.0 landed
Refactor ps_status.c API
- bf68b79e50e3 13.0 landed
Add background worker type
- 5373bc2a0867 11.0 cited

Attachments

0001-Add-backend-type-placeholder-to-log_line_prefix.patch (text/plain) patch 0001

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?

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