Statement timeout error
Hello! I have a script which upserts or deletes data from supabase tables. I'm running the script on a cron every X minutes. Some of the functionality includes running a method using
I've read this article https://supabase.com/docs/guides/database/postgres/configuration but I don't understand what is usefull from it. Should I run this
.rpc which deletes some rows. I get a canceling statement due to statement timeout error.I've read this article https://supabase.com/docs/guides/database/postgres/configuration but I don't understand what is usefull from it. Should I run this
alter role authenticator set statement_timeout = '15s'; ? But I don't use any roles. I also don't have any RLS set up. The project is on Pro plan,Updating the default configuration for your Postgres database.