[pgpool-general: 7609] Pool status check

valsaraj pv valsarajpv at gmail.com
Thu Jul 1 15:14:50 JST 2021


Hi,

postgres=# SHOW POOL_POOLS;
 pool_pid |     start_time      | pool_id | backend_id |       database
   | username |     create_time     | majorversion | minorversion
| pool_counter | pool_backendpid | pool_connected
----------+---------------------+---------+------------+-----------------------+----------+---------------------+--------------+--------------
+--------------+-----------------+----------------

 141705   | 2021-07-01 01:51:20 | 0       | 0          | postgres
   | postgres  | 2021-07-01 02:04:36 | 3            | 0
| 1            | 154957          | 1
 141705   | 2021-07-01 01:51:20 | 0       | 1          | postgres
   | postgres  | 2021-07-01 02:04:36 | 3            | 0
| 1            | 121689

Here pool_pid is the same for both entries but pool_backendpid is
different.
Anyone please help me to understand what are 2 different ids.
Also if we use postgres DB, connection_cache can be off since pgpool won't
cache connections to postgres DB?

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210701/965c95f4/attachment.htm>


More information about the pgpool-general mailing list