[backport-1.6]: Introduce idle sessions timeout to prevent reaching max connection limit on cnpg-keycloak cluster

A solution for issue #3515 (closed) needs to be backported to 1.6.x