Igor Neyman <ineyman@perceptron.com> writes:
> From: Wells Oliver [mailto:wells.oliver@gmail.com]
>> Do you guys have any kind of regular monitoring in place to flag users who don't politely close their connections?
> idle_in_transaction_session_timeout GUC is your friend.
Good idea, though it's only been around since 9.6.
Also, if you just want to monitor rather than impose a hard limit,
I imagine you can get Nagios to watch for this.
regards, tom lane