SHOW POOL_PROCESSES

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)