Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin - Mailing list pgsql-general

On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]

The problem is users will connect using DBeaver and their sessions 
will sit idle.

Idle is not a problem, "idle in transaction" is.

From my perspective "idle in transaction" isn't necessarily a problem (although I don't like seeing sessions sitting like that for a long time). 

Well, it is, since you are sitting in an open transaction.

This fixes it: idle_in_transaction_session_timeout
https://www.postgresql.org/docs/9.6/runtime-config-client.html