High IOWait in CPU
I see a lot of IOWait in my cpu usage, what are the possible solutions and what could be causing this?
Is there any possibility that this is due to the disk that is assigned to my project being slow?
14 Replies
would you be able to share a screenshot of the issue you're seeing
Ah sorry I forgot
I've figured that a large part of it could also be that I store embeddings in one table which has gotten quite large (60 gb + 27 gb index), but wanted to confirm in case the issue can be from Supabase side.
That could be it, i can't see any reports of similar issue so i think something in your setup is leading to heavy I/O operations
perhaps worth checking this infrastructure page also https://supabase.com/dashboard/project/_/settings/infrastructure to see if anything stands out
The infrastructure page just shows the max usage for each during last week, no more info I found
Are you feeling the effects of this when you run your code i.e slow running queries?
I didn't mainly feel a lot difference, a bit yes on my app
But in sentry logs I saw few users faced
Timed out fetching connection issue (about 200 incidents)are you query performances telling you anything about what queries are taking especially long https://supabase.com/dashboard/project/_/reports/query-performance
Sorry didn't notice it
Yeah mostly the slow queries are also the embeddings insert/reads along with some others
that is probably the issue then, you might to see if you need to upgrade resources or rearchitect
Yeah we would likely need to upgrade or offload embeddings to other provider
Thanks for the help 🙂