We have a problem with too many connections to pgpool from QlikSense Logging Service. This number of connections exceeded the maximum number of pgpool allowed connections and therefore all the QlikSense environment is not accessible. Many of these connections are the COPY commands.
Why this connections can hang for so long and why there is so many number of them?
Is there a way to see what this service is doing, is there a log of this service?