Provided by: pgpool2_4.3.7-1ubuntu4_amd64 
NAME
SHOW_POOL_POOLS - sends back a list of pools handled by Pgpool-II.
SYNOPSIS
SHOW POOL_POOLS
DESCRIPTION
SHOW POOL_POOLS sends back a list of pools handled by Pgpool-II
It has 17 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.
• pool_id is the pool identifier (should be between 0 and max_pool - 1)
• backend_id is the backend identifier (should be between 0 and the number of configured backends minus
one)
• database is the database name for this process's pool id connection.
• username is the user name for this process's pool id connection.
• backend_connection_time is the creation time and date of the connection.
• client_connection_time is the date when a client last used this connection.
• client_disconnection_time is the date when a client last disconnected from this connection.
• client_idle_duration is the time (sec) that a client is in idle.
• If client_idle_limit is set not 0, the time before client disconnected is displayed.
• majorversion and minorversion are the protocol version numbers used in this connection.
• pool_counter counts the number of times this pool of connections (process) has been used by clients.
• pool_backendpid is the PID of the PostgreSQL process.
• pool_connected is true (1) if a frontend is currently using this backend.
• 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 in transaction: The process is waiting for a new client command in a transaction.
• Wait for connection: The process is waiting for a new client connection.
It'll always return num_init_children * max_pool * number_of_backends lines. Here is an example session:
test=# show pool_pools;
pool_pid | start_time | client_connection_count | pool_id | backend_id | database | username | backend_connection_time | client_connection_time | client_disconnection_time | client_idle_duration | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected | status
----------+---------------------+-------------------------+---------+------------+----------+----------+-------------------------+------------------------+---------------------------+--------------------------------------+--------------+--------------+--------------+-----------------+----------------+---------------------
32641 | 2021-09-28 04:40:45 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32641 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32643 | 2021-09-28 04:40:45 | 0 | 0 | 0 | test | kawamoto | 2021-09-28 04:40:48 | 2021-09-28 04:40:48 | | 41 (4:19 before client disconnected) | 3 | 0 | 1 | 32660 | 1 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 0 | 1 | test | kawamoto | 2021-09-28 04:40:48 | 2021-09-28 04:40:48 | | 41 (4:19 before client disconnected) | 3 | 0 | 1 | 32661 | 1 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle
32643 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle
32644 | 2021-09-28 04:40:45 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32644 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32645 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection
32648 | 2021-09-28 04:40:45 | 1 | 0 | 0 | test | postgres | 2021-09-28 04:40:52 | 2021-09-28 04:40:52 | 2021-09-28 04:40:59 | 0 | 3 | 0 | 1 | 32681 | 0 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 0 | 1 | test | postgres | 2021-09-28 04:40:52 | 2021-09-28 04:40:52 | 2021-09-28 04:40:59 | 0 | 3 | 0 | 1 | 32682 | 0 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 1 | 0 | test | kawamoto | 2021-09-28 04:41:30 | 2021-09-28 04:41:30 | | 0 (5:00 before client disconnected) | 3 | 0 | 1 | 32746 | 1 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 1 | 1 | test | kawamoto | 2021-09-28 04:41:30 | 2021-09-28 04:41:30 | | 0 (5:00 before client disconnected) | 3 | 0 | 1 | 32747 | 1 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command
32648 | 2021-09-28 04:40:45 | 1 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command
(64 rows)
pgpool-II 4.3.7 2023 SHOW POOL_POOLS(1)