In my API I only use the Db object on the
Service base class. I am using Azure basic PostgreSQL package which only allows 50 connections and I frequently hit errors of no connection slots available.
Looking in pg_activity I can see the connections fill up as I use the API, especially when I use some import features that make a lot of queries. They seem to be status “idle” and eventually timeout. This isn’t a production app, just something in development with just me using it.
Do you have any idea why the connections are not being disposed of and remaining open?