Strange connections
Hey guys,
I'm pretty new to Supabase, so maybe I'm missing something. I have a self-hosted setup, two applications are connecting to the DB (Prisma ORM). I use Supabase Supavisor to handle the connection pools. The two above-mentioned applications are connecting to Supervisor's pool under the named users (for example: XXX_app.tenant_id. All works great, but not...
Here is the issue:
I'm pretty new to Supabase, so maybe I'm missing something. I have a self-hosted setup, two applications are connecting to the DB (Prisma ORM). I use Supabase Supavisor to handle the connection pools. The two above-mentioned applications are connecting to Supervisor's pool under the named users (for example: XXX_app.tenant_id. All works great, but not...
Here is the issue:
- I see apps/users creating the connections, 1 connection per app - all fine here;
- BUT I also see
user creates 30+ connections??? OK, it is probably Supavisor, but why then it needs 3 connections and why are they accounted seperatly from named users?postgres - On top of that, 30+ connections under
supabase_admin. What I do have is Analitycs and Realtime, which is used by one of the apps to poll changes on 1! table. Edge functions and Auth are disabled... Why on earth are 30+ connections needed?
