https://supabase.com/ logo
#help-and-questions
app.supabase.com - fetching tables -Error: [500] An error has occurred: Failed to fetch
# help-and-questions
j

justifi

05/25/2023, 6:28 PM
I am unable to use the dashboard/supabase studio. Whenever I go to any of the pages under the 'Database' icon (https://app.supabase.com/project/my_project_id/database/), there are a number of API calls to the
pg-meta
service They all work fine except for
/tables
, e.g https://api.supabase.io/platform/pg-meta/my_project_id/tables I consistently get the same error. Using the logs, I identified the query that's called from
pg-meta/tables
( see below ) When I run it in my SQL editor, its taking >30 seconds - is the 500 Error caused by a timeout on the query? I played around with the last line of the query, excluding various schemas to identify the bottleneck. I am using supabase as my database for a Strapi instance (headless CMS with lots of relations), and that schema is taking nearly 15 seconds on its own. What are my options here? I'd like to be able to use the supabase dashboard - I use Supabase Webhooks to notify external systems of changes to my CMS.

https://cdn.discordapp.com/attachments/1111360080433139783/1111360080697372722/image.png

https://cdn.discordapp.com/attachments/1111360080433139783/1111360081775304744/message.txt
g

garyaustin

05/25/2023, 7:18 PM
How do your database metrics look? I skimmed thru issues on github and did not see anything related to tables, but it was not exhaustive search. Not much a user can do for you in this forum unless they hit the same thing. You may need to generate an issue in supabase github or contact support.

https://cdn.discordapp.com/attachments/1111360080433139783/1111372757817630720/image.png

j

justifi

05/25/2023, 8:08 PM
@garyaustin thanks for the response. Database metrics look fine; performance all-around has been great except for this one particular i even upgraded my instance to a 'Large Add-on' to see if the issue was resource-related. No significant change I have reached out to support, thanks.
g

garyaustin

05/25/2023, 8:10 PM
Oh definitely do as you are Pro.