SHOW_POOL_POOLS(1)
✨ NAME ✨
SHOW_POOL_POOLS — bestie, it's the Pgpool-II command that sends back a list of pools handled by Pgpool-II. That's the whole vibe. (Manual page SHOW_POOL_POOLS(1), in case you were wondering which girl we're talking about 💅)
🫧 SYNOPSIS 🫧
SHOW POOL_POOLS🌸 DESCRIPTION 🌸
Okay so, not me being obsessed with this one, but SHOW POOL_POOLS sends back a list of pools handled by Pgpool-II. Literally that's the job. She serves and she serves only that. 💖
It has 20 columns, and here is the full tea on every single one:
pool_pid— the PID of the displayed Pgpool-II process. 👑start_time— the timestamp of when this process was launched. 🕰️- If
child_life_timeis set not0, the time before process restarting is displayed.
- If
client_connection_count— counts the number of times this process has been used by clients.pool_id— the pool identifier (should be between0andmax_pool - 1).backend_id— the backend identifier (should be between0and the number of configured backends minus one).database— the database name for this process's pool id connection.username— the user name for this process's pool id connection.backend_connection_time— the creation time and date of the connection.client_connection_time— the date when a client last used this connection.client_disconnection_time— the date when a client last disconnected from this connection. 😭client_idle_duration— the time (sec) that a client is in idle.- If
client_idle_limitis set not0, the time before client disconnected is displayed.
- If
majorversionandminorversion— 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— the PID of the PostgreSQL process.pool_connected— true (1) if a frontend is currently using this backend.status— 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— true (1) if a frontend is currently using this backend and the backend is load balance node.client_host— client's host name or IP address.client_port— client's port number.statement— the SQL statement last executed.
It'll always return num_init_children * max_pool * number_of_backends lines. No cap, that's the math. 💯
Here is an example session, so you can see her in her natural habitat:
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)and that's the whole page bestie!! 🎀 you're literally a pool-pools girlie now. This was <rainbow>pgpool-II 4.7.2</rainbow> documentation, dated <purple>2023</purple>, page SHOW_POOL_POOLS(1). mwah 💖✨🦋
📦 where this page comes from
- ubuntu stonking: pgpool2 4.7.2-1build1
- 💖 girlified by deepseek-ai/DeepSeek-V4.1-Flash on : a language model's rewrite of the original, under its terms