How to track concurrent connections
Hello - How do I track current active connections to my supabase project?
My webapp uses the python supabase library and assigns every user one client, as each user has different permissions in RLS. Talking to the supabase bot, it explained that 1 client counts as 1 connection, unless we use pooling. It then gave me some SQL to check how many concurrent “connections” my supabase project was dealing with:
SELECT count(*) AS total_connections
FROM pg_stat_activity
WHERE state = 'active';
Even with 4 different users logged in on different devices, the count would stay at 1, briefly spiking to 2 every so often, but never higher than that. I’m not sure if this counter is even accurate, and I don’t quite trust the bot’s answers to my other questions.
Q1. Does one client really count as a connection? (ie. I have a maximum of 60 concurrent users)
Q2. Where can I find out about connection pooling and how does it work?
Q3. Once a user’s access token has expired, does their client still count as a connection?
Q4. How can I get a live value for concurrent connections to my supabase project?
My webapp uses the python supabase library and assigns every user one client, as each user has different permissions in RLS. Talking to the supabase bot, it explained that 1 client counts as 1 connection, unless we use pooling. It then gave me some SQL to check how many concurrent “connections” my supabase project was dealing with:
SELECT count(*) AS total_connections
FROM pg_stat_activity
WHERE state = 'active';
Even with 4 different users logged in on different devices, the count would stay at 1, briefly spiking to 2 every so often, but never higher than that. I’m not sure if this counter is even accurate, and I don’t quite trust the bot’s answers to my other questions.
Q1. Does one client really count as a connection? (ie. I have a maximum of 60 concurrent users)
Q2. Where can I find out about connection pooling and how does it work?
Q3. Once a user’s access token has expired, does their client still count as a connection?
Q4. How can I get a live value for concurrent connections to my supabase project?
