'\" t .\" Title: SHOW POOL_PROCESSES .\" Author: The Pgpool Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot .\" Date: 2020 .\" Manual: pgpool-II 4.1.4 Documentation .\" Source: pgpool-II 4.1.4 .\" Language: English .\" .TH "SHOW POOL_PROCESSES" "1" "2020" "pgpool-II 4.1.4" "pgpool-II 4.1.4 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" SHOW_POOL_PROCESSES \- sends back a list of all Pgpool\-II processes waiting for connections and dealing with a connection .SH "SYNOPSIS" .sp .nf SHOW POOL_PROCESSES .fi .SH "DESCRIPTION" .PP \fBSHOW POOL_PROCESSES\fR sends back a list of all Pgpool\-II processes waiting for connections and dealing with a connection\&. .PP It has 6 columns: .sp .RS 4 .ie n \{\ \h'-04'\(bu\h'+03'\c .\} .el \{\ .sp -1 .IP \(bu 2.3 .\} pool_pid is the PID of the displayed Pgpool\-II process\&. .RE .sp .RS 4 .ie n \{\ \h'-04'\(bu\h'+03'\c .\} .el \{\ .sp -1 .IP \(bu 2.3 .\} start_time is the timestamp of when this process was launched\&. .RE .sp .RS 4 .ie n \{\ \h'-04'\(bu\h'+03'\c .\} .el \{\ .sp -1 .IP \(bu 2.3 .\} database is the database name of the currently active backend for this process\&. .RE .sp .RS 4 .ie n \{\ \h'-04'\(bu\h'+03'\c .\} .el \{\ .sp -1 .IP \(bu 2.3 .\} username is the user name used in the connection of the currently active backend for this process\&. .RE .sp .RS 4 .ie n \{\ \h'-04'\(bu\h'+03'\c .\} .el \{\ .sp -1 .IP \(bu 2.3 .\} create_time is the creation time and date of the connection\&. .RE .sp .RS 4 .ie n \{\ \h'-04'\(bu\h'+03'\c .\} .el \{\ .sp -1 .IP \(bu 2.3 .\} pool_counter counts the number of times this pool of connections (process) has been used by clients\&. .RE .PP Here is an example session: .sp .if n \{\ .RS 4 .\} .nf test=# show pool_processes; pool_pid | start_time | database | username | create_time | pool_counter \-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\- 19696 | 2016\-10\-17 13:24:17 | postgres | t\-ishii | 2016\-10\-17 13:35:12 | 1 19697 | 2016\-10\-17 13:24:17 | | | | 19698 | 2016\-10\-17 13:24:17 | | | | 19699 | 2016\-10\-17 13:24:17 | | | | 19700 | 2016\-10\-17 13:24:17 | | | | 19701 | 2016\-10\-17 13:24:17 | | | | 19702 | 2016\-10\-17 13:24:17 | | | | 19703 | 2016\-10\-17 13:24:17 | | | | 19704 | 2016\-10\-17 13:24:17 | | | | 19705 | 2016\-10\-17 13:24:17 | | | | 19706 | 2016\-10\-17 13:24:17 | | | | 19707 | 2016\-10\-17 13:24:17 | | | | 19708 | 2016\-10\-17 13:24:17 | | | | 19709 | 2016\-10\-17 13:24:17 | | | | 19710 | 2016\-10\-17 13:24:17 | | | | 19711 | 2016\-10\-17 13:24:17 | | | | 19712 | 2016\-10\-17 13:24:17 | | | | 19713 | 2016\-10\-17 13:24:17 | | | | 19714 | 2016\-10\-17 13:24:17 | | | | 19715 | 2016\-10\-17 13:24:17 | | | | 19716 | 2016\-10\-17 13:24:17 | | | | 19717 | 2016\-10\-17 13:24:17 | | | | 19718 | 2016\-10\-17 13:24:17 | | | | 19719 | 2016\-10\-17 13:24:17 | | | | 19720 | 2016\-10\-17 13:24:17 | | | | 20024 | 2016\-10\-17 13:33:46 | | | | 19722 | 2016\-10\-17 13:24:17 | test | t\-ishii | 2016\-10\-17 13:34:42 | 1 19723 | 2016\-10\-17 13:24:17 | | | | 19724 | 2016\-10\-17 13:24:17 | | | | 19725 | 2016\-10\-17 13:24:17 | | | | 19726 | 2016\-10\-17 13:24:17 | | | | 19727 | 2016\-10\-17 13:24:17 | | | | (32 rows) .fi .if n \{\ .RE .\} .sp