99% cpu usage

How to know what is usign the cpu the most? I get 99% cpu usage, but I want to bring it down. Is there an sql command to know what is using the cpu usage the most?
10 Replies
Rotimi Best - ClassroomIO.com
They have a very well designed Reporting system in the dashboard that you should checkout Once you open the project in the dashboard, at the left bottom there is Report section. I think you can see the various reports Egres, Ingres etc right there I used it last week too, my Egres was blowing up because I was using a video stored in storage on my landing page I had to remove the video from supabase and just keep it my Sveltekit app on vercel
garyaustin
garyaustin2y ago
Under the reports tab mentioned there is a query examiner you can see what queries are using the most time.
Maher
MaherOP2y ago
but why it doesn't show the query?
No description
Maher
MaherOP2y ago
I tried this but the information shown is not enough
garyaustin
garyaustin2y ago
That is odd.
garyaustin
garyaustin2y ago
No description
Maher
MaherOP2y ago
what is service_role then?
garyaustin
garyaustin2y ago
service_role is normally you calling the REST API with the service_role key. One other user hit this awhile back. He never responded if support fixed it or not.... https://discord.com/channels/839993398554656828/1129104369304993792/1129104369304993792
Maher
MaherOP2y ago
do you know how disable logs on supabase? entry_logs
garyaustin
garyaustin2y ago
I’m not sure what entry_logs refers to.

Did you find this page helpful?