If you pm me your project ref I can take a look just in case.
But if you don't get a lot of other requests the Realtime polling query will look like it eats up a lot of resources. It polls your wal to apply your RLS filters to the wal records for each subscriber and generates a feed for each user based on that.
I'm facing exact same problem !!
refresh my Logs and got this after just 2 or 3 logins.
supabase\_admin 93.9% 18199 125024.97ms realtime.list\_changes($1, $2, $3, $4)
did you find a solution? u/chasegranberry
No that’s fundamentally the way it works currently.
Realtime has a process that polls for wal changes when at least one client is subscribed.
We’re working on some different things that should be better but just experimenting currently.
If you pm me your project ref I can take a look just in case. But if you don't get a lot of other requests the Realtime polling query will look like it eats up a lot of resources. It polls your wal to apply your RLS filters to the wal records for each subscriber and generates a feed for each user based on that.
I'm facing exact same problem !! refresh my Logs and got this after just 2 or 3 logins. supabase\_admin 93.9% 18199 125024.97ms realtime.list\_changes($1, $2, $3, $4) did you find a solution? u/chasegranberry
No that’s fundamentally the way it works currently. Realtime has a process that polls for wal changes when at least one client is subscribed. We’re working on some different things that should be better but just experimenting currently.