From b8fdee7d0ca8bd2165d46fb1468f75571b706a01 Mon Sep 17 00:00:00 2001
From: Michael Paquier
Date: Mon, 3 Aug 2020 13:38:48 +0900
Subject: Add %P to log_line_prefix for parallel group leader
This is useful for monitoring purposes with log parsing. Similarly to
pg_stat_activity, the leader's PID is shown only for active parallel
workers, minimizing the log footprint for the leaders as the equivalent
shared memory field is set as long as a backend is alive.
Author: Justin Pryzby
Reviewed-by: Álvaro Herrera, Michael Paquier, Julien Rouhaud, Tom Lane
Discussion: https://postgr.es/m/20200315111831.GA21492@telsasoft.com
---
doc/src/sgml/config.sgml | 9 ++++++++-
1 file changed, 8 insertions(+), 1 deletion(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 994155ca00e..7a7177c5508 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -6694,6 +6694,12 @@ local0.* /var/log/postgresql
Process ID
no
+
+ %P
+ Process ID of the parallel group leader, if this process
+ is a parallel query worker
+ no
+
%t
Time stamp without milliseconds
@@ -7026,7 +7032,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
character count of the error position therein,
location of the error in the PostgreSQL source code
(if log_error_verbosity is set to verbose),
- application name, and backend type.
+ application name, backend type, and process ID of parallel group leader.
Here is a sample table definition for storing CSV-format log output:
@@ -7056,6 +7062,7 @@ CREATE TABLE postgres_log
location text,
application_name text,
backend_type text,
+ leader_pid integer,
PRIMARY KEY (session_id, session_line_num)
);
--
cgit v1.2.3