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)

pgpool-II 4.6.0                                       2023                                SHOW POOL_PROCESSES(1)