Man page - show_pool_pools(1)
Packages contains this manual
- pcp_invalidate_query_cache(1)
- pgpool_adm_pcp_node_count(3)
- pcp_proc_info(1)
- pcp_recovery_node(1)
- pcp_common_options(1)
- pgpool_adm_pcp_pool_status(3)
- pcp_proc_count(1)
- pcp_log_rotate(1)
- pgpool_adm_pcp_node_info(3)
- pgpool_adm_pcp_attach_node(3)
- pcp_stop_pgpool(1)
- pcp_node_count(1)
- pgpool_setup(1)
- pcp_health_check_stats(1)
- pgpool_adm_pcp_detach_node(3)
- pgpool_adm_pcp_health_check_stats(3)
- pg_md5(1)
- pcp_promote_node(1)
- pcp_pool_status(1)
- pcp_detach_node(1)
- wd_cli(1)
- pg_enc(1)
- pcp_reload_config(1)
- pgpool_adm_pcp_proc_info(3)
- pcp_watchdog_info(1)
- pgproto(1)
- pgpool(8)
- watchdog_setup(1)
- pcp_node_info(1)
- pcp_attach_node(1)
apt-get install pgpool2
Manual
SHOW POOL_POOLS
NAMESYNOPSIS
DESCRIPTION
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 20 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.
• load_balance_node is true (1) if a frontend is currently using this backend and the backend is load balance node.
• client_host is client's host name or IP address.
• client_port is client's port number.
• statement is the SQL statement last executed.
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 |
load_balance_node | client_host | client_port | statement
----------+------------------------------------------------------+-------------------------+---------+------------+----------+----------+-------------------------+------------------------+---------------------------+----------------------+--------------+--------------+--------------+-----------------+----------------+---------------------+-------------------+---------------+-------------+-------------
[snip]
1336537 | 2025-06-24 10:53:35 | 0 | 0 | 0 | test | t-ishii |
2025-06-24 10:55:58 | 2025-06-24 10:55:59 | | 0 | 3 | 0 | 1
| 1336703 | 1 | Idle | 0 | 192.168.10.11 | 39216 |
1336537 | 2025-06-24 10:53:35 | 0 | 0 | 1 | test | t-ishii |
2025-06-24 10:55:58 | 2025-06-24 10:55:59 | | 0 | 3 | 0 | 1
| 1336704 | 1 | Idle | 1 | 192.168.10.11 | 39216 | select 1;
1336537 | 2025-06-24 10:53:35 | 0 | 1 | 0 | | | | | | 0 | 0
| 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 |
1336537 | 2025-06-24 10:53:35 | 0 | 1 | 1 | | | | | | 0 | 0
| 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 | select
1;
1336537 | 2025-06-24 10:53:35 | 0 | 2 | 0 | | | | | | 0 | 0
| 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 |
1336537 | 2025-06-24 10:53:35 | 0 | 2 | 1 | | | | | | 0 | 0
| 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 | select
1;
1336537 | 2025-06-24 10:53:35 | 0 | 3 | 0 | | | | | | 0 | 0
| 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 |
1336537 | 2025-06-24 10:53:35 | 0 | 3 | 1 | | | | | | 0 | 0
| 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 | select
1;
[snip]
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 0 | 0 | test | t-ishii | 2025-06-24
10:53:42 | 2025-06-24 10:53:42 | 2025-06-24 10:55:37 | 0 | 3
| 0 | 1 | 1336573 | 0 | Wait for connection | 0 |
192.168.10.11 | 39162 | DISCARD ALL
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 0 | 1 | test | t-ishii | 2025-06-24
10:53:42 | 2025-06-24 10:53:42 | 2025-06-24 10:55:37 | 0 | 3
| 0 | 1 | 1336574 | 0 | Wait for connection | 0 |
192.168.10.11 | 39162 |
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 |
Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD
ALL
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 |
Wait for connection | 0 | 192.168.10.11 | 39162 |
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 |
Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD
ALL
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 |
Wait for connection | 0 | 192.168.10.11 | 39162 |
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 |
Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD
ALL
1336544 | 2025-06-24 10:53:35 (0:23 before process
restarting) | 1 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 |
Wait for connection | 0 | 192.168.10.11 | 39162 |
[snip]
(256 rows)