SHOW POOL_PROCESSES(1)

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)