NAME
SHOW_POOL_PROCESSES - sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection
SYNOPSIS
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:
• 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.
Here is an example session:
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)