'\" t .\" Title: pcp_proc_info .\" Author: The Pgpool Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot .\" Date: 2023 .\" Manual: pgpool-II 4.3.7 Documentation .\" Source: pgpool-II 4.3.7 .\" Language: English .\" .TH "PCP_PROC_INFO" "1" "2023" "pgpool-II 4.3.7" "pgpool-II 4.3.7 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" pcp_proc_info \- displays the information on the given Pgpool\-II child process ID .SH "SYNOPSIS" .HP \w'\fBpcp_proc_info\fR\ 'u \fBpcp_proc_info\fR [\fIoptions\fR...] [\fIpgpool_child_processid\fR] .SH "DESCRIPTION" .PP \fBpcp_proc_info\fR displays the information on the given Pgpool\-II child process ID\&. .SH "OPTIONS" .PP .PP \fB\-a\fR .br \fB\-\-all\fR .RS 4 Display all child processes and their available connection slots\&. .RE .PP \fB\-P \fR\fB\fIPID\fR\fR .br \fB\-\-process\-id=\fR\fB\fIPID\fR\fR .RS 4 PID of Pgpool\-II child process\&. .RE .PP \fBOther options \fR .RS 4 See \fBpcp_common_options\fR(1)\&. .RE If \-a nor \-P is not specified, process information of all connected Pgpool\-II child process will be printed\&. In this case if there\*(Aqs no connected Pgpool\-II child process, nothing but "No process information available" message will be printed\&. .SH "EXAMPLE" .PP Here is an example output: .sp .if n \{\ .RS 4 .\} .nf $ pcp_proc_info \-p 1100 test postgres 2021\-09\-28 04:16:00 (4:56 before process restarting) 1 3 0 2021\-09\-28 04:16:16 2021\-09\-28 04:16:16 0 2021\-09\-28 04:16:33 1 30795 0 30750 0 Wait for connection test postgres 2021\-09\-28 04:16:00 (4:56 before process restarting) 1 3 0 2021\-09\-28 04:16:16 2021\-09\-28 04:16:16 0 2021\-09\-28 04:16:33 1 30796 0 30750 1 Wait for connection test kawamoto 2021\-09\-28 04:16:00 0 3 0 2021\-09\-28 04:16:03 2021\-09\-28 04:16:03 34 (4:26 before client disconnected) 1 30763 1 30751 0 Idle test kawamoto 2021\-09\-28 04:16:00 0 3 0 2021\-09\-28 04:16:03 2021\-09\-28 04:16:03 34 (4:26 before client disconnected) 1 30764 1 30751 1 Idle $ pcp_proc_info \-p 11001 30751 test kawamoto 2021\-09\-28 04:16:00 0 3 0 2021\-09\-28 04:16:03 2021\-09\-28 04:16:03 58 (4:02 before client disconnected) 1 30763 1 30751 0 Idle test kawamoto 2021\-09\-28 04:16:00 0 3 0 2021\-09\-28 04:16:03 2021\-09\-28 04:16:03 58 (4:02 before client disconnected) 1 30764 1 30751 1 Idle .fi .if n \{\ .RE .\} .PP The result is in the following order: .sp .if n \{\ .RS 4 .\} .nf 1\&. connected database name 2\&. connected user name 3\&. process start\-up timestamp (If child_life_time is set not 0, the time before process restarting is displayed\&.) 4\&. process\-reuse counter for child_max_connections 5\&. protocol major version 6\&. protocol minor version 7\&. connection created timestamp 8\&. last client connected timestamp 9\&. client idle duration (sec) (If client_idle_limit is set not 0, the time before client disconnected is displayed\&.) 10\&. last client disconnected timestamp 11\&. connection\-reuse counter 12\&. PostgreSQL backend process id 13\&. 1 if frontend connected 0 if not 14\&. pgpool child process id 15\&. PostgreSQL backend id 16\&. process status .fi .if n \{\ .RE .\} .PP If \-a or \-\-all option is not specified and there is no connection to the backends, nothing will be displayed\&. If there are multiple connections, one connection\*(Aqs information will be displayed on each line multiple times\&. Timestamps are displayed in EPOCH format\&. .PP The \fB\-\-verbose\fR option can help understand the output\&. For example: .sp .if n \{\ .RS 4 .\} .nf $ pcp_proc_info \-p 11001 \-\-verbose Database : test Username : postgres Start time : 2021\-09\-28 04:16:00 (2:52 before process restarting) Client connection count : 1 Major : 3 Minor : 0 Backend connection time : 2021\-09\-28 04:16:16 Client connection time : 2021\-09\-28 04:16:16 Client idle duration : 0 Client disconnection time : 2021\-09\-28 04:16:33 Pool Counter : 1 Backend PID : 30795 Connected : 0 PID : 30750 Backend ID : 0 Status : Wait for connection Database : test Username : postgres Start time : 2021\-09\-28 04:16:00 (2:52 before process restarting) Client connection count : 1 Major : 3 Minor : 0 Backend connection time : 2021\-09\-28 04:16:16 Client connection time : 2021\-09\-28 04:16:16 Client idle duration : 0 Client disconnection time : 2021\-09\-28 04:16:33 Pool Counter : 1 Backend PID : 30796 Connected : 0 PID : 30750 Backend ID : 1 Status : Wait for connection Database : test Username : kawamoto Start time : 2021\-09\-28 04:16:00 Client connection count : 0 Major : 3 Minor : 0 Backend connection time : 2021\-09\-28 04:16:03 Client connection time : 2021\-09\-28 04:16:03 Client idle duration : 158 (2:22 before client disconnected) Client disconnection time : Pool Counter : 1 Backend PID : 30763 Connected : 1 PID : 30751 Backend ID : 0 Status : Idle Database : test Username : kawamoto Start time : 2021\-09\-28 04:16:00 Client connection count : 0 Major : 3 Minor : 0 Backend connection time : 2021\-09\-28 04:16:03 Client connection time : 2021\-09\-28 04:16:03 Client idle duration : 158 (2:22 before client disconnected) Client disconnection time : Pool Counter : 1 Backend PID : 30764 Connected : 1 PID : 30751 Backend ID : 1 Status : Idle .fi .if n \{\ .RE .\}