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 6 columns:

•pool_pid is the PID of the displayed Pgpool-II process.

•start_time is the timestamp of when this process was launched.

•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.

•create_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.

Here is an example session:



    test=# show pool_processes;


    pool_pid |     start_time      | database | username |     create_time     | pool_counter


    ----------+---------------------+----------+----------+---------------------+--------------


    19696    | 2016-10-17 13:24:17 | postgres | t-ishii  | 2016-10-17 13:35:12 | 1


    19697    | 2016-10-17 13:24:17 |          |          |                     |


    19698    | 2016-10-17 13:24:17 |          |          |                     |


    19699    | 2016-10-17 13:24:17 |          |          |                     |


    19700    | 2016-10-17 13:24:17 |          |          |                     |


    19701    | 2016-10-17 13:24:17 |          |          |                     |


    19702    | 2016-10-17 13:24:17 |          |          |                     |


    19703    | 2016-10-17 13:24:17 |          |          |                     |


    19704    | 2016-10-17 13:24:17 |          |          |                     |


    19705    | 2016-10-17 13:24:17 |          |          |                     |


    19706    | 2016-10-17 13:24:17 |          |          |                     |


    19707    | 2016-10-17 13:24:17 |          |          |                     |


    19708    | 2016-10-17 13:24:17 |          |          |                     |


    19709    | 2016-10-17 13:24:17 |          |          |                     |


    19710    | 2016-10-17 13:24:17 |          |          |                     |


    19711    | 2016-10-17 13:24:17 |          |          |                     |


    19712    | 2016-10-17 13:24:17 |          |          |                     |


    19713    | 2016-10-17 13:24:17 |          |          |                     |


    19714    | 2016-10-17 13:24:17 |          |          |                     |


    19715    | 2016-10-17 13:24:17 |          |          |                     |


    19716    | 2016-10-17 13:24:17 |          |          |                     |


    19717    | 2016-10-17 13:24:17 |          |          |                     |


    19718    | 2016-10-17 13:24:17 |          |          |                     |


    19719    | 2016-10-17 13:24:17 |          |          |                     |


    19720    | 2016-10-17 13:24:17 |          |          |                     |


    20024    | 2016-10-17 13:33:46 |          |          |                     |


    19722    | 2016-10-17 13:24:17 | test     | t-ishii  | 2016-10-17 13:34:42 | 1


    19723    | 2016-10-17 13:24:17 |          |          |                     |


    19724    | 2016-10-17 13:24:17 |          |          |                     |


    19725    | 2016-10-17 13:24:17 |          |          |                     |


    19726    | 2016-10-17 13:24:17 |          |          |                     |


    19727    | 2016-10-17 13:24:17 |          |          |                     |


    (32 rows)

2020	pgpool-II 4.1.4