query_timeout doesn't cancel anything
In node-postgres, query_timeout gives up on the client side only. The query keeps running on the server and the connection stays busy. Use statement_timeout and TCP keepalive.
measured ▸ query_timeout: error after 1 s, query still running on the server · statement_timeout: error 57014, 0 left running
postgresnode-postgresconnection pooltimeoutsreliability