[pgpool-general: 7164] Idle connection in database

[Nikhil Shetty]

Hi Team,

We have set below parameters in pgpool.conf for connections:

 - serialize_accept = on
 - client_idle_limit = 600
 - child_life_time = 0
 - child_max_connections = 10
 - connection_life_time = 600
 - num_init_children = 4000
 - max_pool = 1

So after executing a query, as per client_idle_limit  of 5mins, idle
sessions should be disconnected after 5mins but we can still see a lot of
idle connections on the database from pgpool.

We are receiving around 10 connections every 5mins as seen in the table
below. We have almost 2k connections in idle state in the database from
pgpool.Why are these connections not getting terminated?


state |    query     |          backend_start
-------+--------------+----------------------------------
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.409933 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.409931 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.4094 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.409005 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.40897 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.407784 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.407632 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.407399 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.407044 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:05:35.344228 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.30343 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.300526 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.300472 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.300048 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.29958 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.299185 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.299048 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.298708 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.296888 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 18:00:35.249235 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.127723 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.127523 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.127436 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.127145 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.127117 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.126906 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.126708 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.126449 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.125814 +05:30
 idle  |  DISCARD ALL | 27-JUL-20 17:55:35.063099 +05:30
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200727/250727cf/attachment.html>