> is perhaps this query the problem?

As itself this query should not be a problem, but if it is not closed
properly - yes, it may cause the leak.
You can from time to time try to commit the transaction inside of
which this query run or disconnect/connect the connection to see if it
make any difference.

SY, SD.