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:
It'll always return num_init_children * max_pool * number_of_backends lines.
Here is an example session:
•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.
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)
| 2023 | pgpool-II 4.3.5 |