table of contents
| SHOW POOL_PROCESSES(1) | pgpool-II 4.1.4 Documentation | SHOW POOL_PROCESSES(1) |
NAME¶
SHOW_POOL_PROCESSES - sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection
SYNOPSIS¶
SHOW POOL_PROCESSES
DESCRIPTION¶
SHOW POOL_PROCESSES sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection.
It has 6 columns:
•pool_pid is the PID of the displayed Pgpool-II
process.
•start_time is the timestamp of when this process
was launched.
•database is the database name of the currently
active backend for this process.
•username is the user name used in the connection
of the currently active backend for this process.
•create_time is the creation time and date of the
connection.
•pool_counter counts the number of times this pool
of connections (process) has been used by clients.
Here is an example session:
test=# show pool_processes;
pool_pid | start_time | database | username | create_time | pool_counter
----------+---------------------+----------+----------+---------------------+--------------
19696 | 2016-10-17 13:24:17 | postgres | t-ishii | 2016-10-17 13:35:12 | 1
19697 | 2016-10-17 13:24:17 | | | |
19698 | 2016-10-17 13:24:17 | | | |
19699 | 2016-10-17 13:24:17 | | | |
19700 | 2016-10-17 13:24:17 | | | |
19701 | 2016-10-17 13:24:17 | | | |
19702 | 2016-10-17 13:24:17 | | | |
19703 | 2016-10-17 13:24:17 | | | |
19704 | 2016-10-17 13:24:17 | | | |
19705 | 2016-10-17 13:24:17 | | | |
19706 | 2016-10-17 13:24:17 | | | |
19707 | 2016-10-17 13:24:17 | | | |
19708 | 2016-10-17 13:24:17 | | | |
19709 | 2016-10-17 13:24:17 | | | |
19710 | 2016-10-17 13:24:17 | | | |
19711 | 2016-10-17 13:24:17 | | | |
19712 | 2016-10-17 13:24:17 | | | |
19713 | 2016-10-17 13:24:17 | | | |
19714 | 2016-10-17 13:24:17 | | | |
19715 | 2016-10-17 13:24:17 | | | |
19716 | 2016-10-17 13:24:17 | | | |
19717 | 2016-10-17 13:24:17 | | | |
19718 | 2016-10-17 13:24:17 | | | |
19719 | 2016-10-17 13:24:17 | | | |
19720 | 2016-10-17 13:24:17 | | | |
20024 | 2016-10-17 13:33:46 | | | |
19722 | 2016-10-17 13:24:17 | test | t-ishii | 2016-10-17 13:34:42 | 1
19723 | 2016-10-17 13:24:17 | | | |
19724 | 2016-10-17 13:24:17 | | | |
19725 | 2016-10-17 13:24:17 | | | |
19726 | 2016-10-17 13:24:17 | | | |
19727 | 2016-10-17 13:24:17 | | | |
(32 rows)
| 2020 | pgpool-II 4.1.4 |