On 19.12.21 12:50, Shubham Mittal wrote:
> 2021-11-25 14:45:45.244 IST [18307] LOG C-0x6ae270:
> sit/postgres@abcdlogin attempt: db=sit user=postgres tls=no
> 2021-11-25 14:45:45.299 IST [18307] LOG S-0x6b4f48: sit/postgres@abcd
> new connection to server (from abcd)
> 2021-11-25 14:46:17.843 IST [18307] LOG S-0x6b4d10: sit/postgres@abcd
> *closing because: query timeout (age=185s)*
> 2021-11-25 14:46:17.843 IST [18307] LOG C-0x6ae038: sit/postgres@abcd
> *closing because: query timeout (age=185s)*
> 2021-11-25 14:46:17.843 IST [18307] WARNING C-0x6ae038:
> sit/postgres@*abcd pooler error: query timeout*
> 2021-11-25 14:46:25.763 IST [18307] LOG stats: 0 xacts/s, 0 queries/s,
> in 30 B/s, out 141 B/s, xact 3660 us, query 4362 us, wait 152 us
>
> Does this log mean that connection is closed and returned to the pool
> and can be reused again?? Or something else?? Please help.
A closed connection cannot be reused, since it's closed. But after the
connection is closed, there is a free slot in the pool to possibly open
a new connection if needed.