NAME
SHOW_POOL_PROCESSES - sends back a list of all Pgpool-II processes waiting for connections and dealing with a connectionSYNOPSIS
SHOW POOL_PROCESSES
DESCRIPTION
SHOW POOL_PROCESSES sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection. It has 8 columns:•pool_pid is the PID of the displayed
Pgpool-II process.
•start_time is the timestamp of when
this process was launched.
•If child_life_time is set not 0, the
time before process restarting is displayed.
•client_connection_count counts the
number of times this process has been used by clients.
•database is the database name of the
currently active backend for this process.
•username is the user name used in the
connection of the currently active backend for this process.
•backend_connection_time is the
creation time and date of the connection.
•pool_counter counts the number of
times this pool of connections (process) has been used by clients.
•status is current status of this
process. Possible values are:
Here is an example session:
•Execute command: Executing a
command.
•Idle: The process is waiting for a new
client command.
•Idle: The process is waiting for a new
client command in a transaction.
•Wait for connection: The process is
waiting for a new client connection.
test=# show pool_processes; pool_pid | start_time | client_connection_count | database | username | backend_connection_time | pool_counter | status ----------+------------------------------------------------------+-------------------------+----------+----------+-------------------------+--------------+--------------------- 32641 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection 32642 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection 32643 | 2021-09-28 04:40:45 | 0 | test | kawamoto | 2021-09-28 04:40:48 | 1 | Idle 32644 | 2021-09-28 04:40:45 | 0 | test | kawamoto | 2021-09-28 04:43:15 | 1 | Execute command 32645 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection 32646 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection 32647 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection 32648 | 2021-09-28 04:40:45 (3:15 before process restarting) | 2 | | | | | Wait for connection (8 rows)
| 2023 | pgpool-II 4.3.5 |