Re: Pgbouncer and Node JS application Query read timeout error

On Wed, 2026-04-08 at 10:51 +0530, KK CHN wrote:
> List, I am using pgbouncer(PgBouncer 1.23.1 RHEL 9.4) along with  Postgres16(RHEL 9.4)
> for connection pooling.   
>
> Running a nodejs application which is throwing some errors  related to query timeout
> which the development team suspect after pgbouncer deployment this behaviour appears,
> but not sure 
>
> The error which is thrown from  the nodejs logs as follows.. 
>
> [image showing an error "Query read timeout"]
>
> Is this due to   pgbouncer config issues or   nodejs  pool config issues ?
>
> for  reference here the pgbouncer  config params and  node js  params at present.
>
> pgbouncer.ini
>
> [...]
> [pgbouncer]
> pool_mode = transaction
> default_pool_size = 50
> min_pool_size = 30
> reserve_pool_size = 10
> reserve_pool_timeout = 5
> max_db_connections = 130
> max_user_connections = 180
> server_lifetime = 3600
> server_idle_timeout = 600
> [...]


The only way I can imagine that pgBouncer is leading to timeouts on the client side
is if client sessions are waiting, because all connections are in use.

You can run SHOW POOLS in the pgBouncer console to see if there are any "cl_waiting".
If that is the case, you should configure the Node.js pools smaller, so that no
connection has to wait.

Yours,
Laurenz Albe