Chris Travers wrote:
> If it is truly idle in a transaction, maybe it has locks that are
holding up other transactions?
>
> Locks are usually held until commit time, except advisory locks iirc
but those have to be explicitly
> checked, so if you don't know if you are using them you probably
aren't.
Yes, but locks that block a new connection from succeeding?
Yours,
Laurenz Albe