© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
24 replies
abaum

debugging `canceling statement due to statement timeout` error

I have an RPC that has started returning
canceling statement due to statement timeout
canceling statement due to statement timeout
errors. when I run the exact same function in the SQL editor using
EXPLAIN ANALYZE
EXPLAIN ANALYZE
it executes in ~4s. it is a slow query, but I'm curious if there are other suggestions to figure out why it would be timing out? I have not modified
statement_timeout
statement_timeout
(and when I run
select setting from pg_settings where name = 'statement_timeout'
select setting from pg_settings where name = 'statement_timeout'
it appears to be 120s, though I'm not sure if client queries have a different setting).

[editing this because I was mis-reading the memory usage, though initial question remains]
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

canceling statement due to statement timeout
SupabaseSSupabase / help-and-questions
4y ago
canceling statement due to statement timeout
SupabaseSSupabase / help-and-questions
3y ago
cancelling statement due to statement timeout
SupabaseSSupabase / help-and-questions
8mo ago
Cancelling statement due to statemtn timeout
SupabaseSSupabase / help-and-questions
7mo ago