SHOW POOL_PROCESSES(1) | pgpool-II 4.3.5 Documentation | SHOW POOL_PROCESSES(1) |
SHOW_POOL_PROCESSES - sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection
SHOW POOL_PROCESSES
SHOW POOL_PROCESSES sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection.
It has 8 columns:
Here is an example session:
test=# show pool_processes;
pool_pid | start_time | client_connection_count | database | username | backend_connection_time | pool_counter | status ----------+------------------------------------------------------+-------------------------+----------+----------+-------------------------+--------------+---------------------
32641 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection
32642 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection
32643 | 2021-09-28 04:40:45 | 0 | test | kawamoto | 2021-09-28 04:40:48 | 1 | Idle
32644 | 2021-09-28 04:40:45 | 0 | test | kawamoto | 2021-09-28 04:43:15 | 1 | Execute command
32645 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection
32646 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection
32647 | 2021-09-28 04:40:45 | 0 | | | | | Wait for connection
32648 | 2021-09-28 04:40:45 (3:15 before process restarting) | 2 | | | | | Wait for connection (8 rows)
2023 | pgpool-II 4.3.5 |