Cloud SQL CPU Utilization < 25% but underprovisioned?

[maham1243]

Greetings,
We have a database instance deployed for some time on GCP with very light workload and is using PostgresSQL. This instance is at around 20-25% utilization although only 3 clients are accessing it and all queries have been optimized on indexes. I would like to understand why GCP is flagging this as underprovisioend.  The instance machine is 1 vCPU, 0.614 GB, shared core.

I also have questions on the "blank periods" I can see in the graph but I will put those in a different topic.

Any insights will be greatly appreciated! Thank you!

[ronnelg]

Hi @maham1243, 

Welcome to Google Cloud Community!

Have you tried to click the Underprovisioned resource warning on the instance health issues? It will show some insight and recommendation. Because, it might be not only the CPU utilization that affects the performance of the instance but other metrics as well such as memory components and usage specially since the instance is using only 614 MB. You can check the other available metrics on the chart.

Also, to check if there is really an underprovisioned instance, you can use the Recommender to help you detect instances that have high CPU and/or memory utilization. It then provides recommendations for how to optimize the instance.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[maham1243]

Thank you. Sorry for the late reply, in my country, today is a business day following some holidays.

We have very low memory utilization unlike what the recommender is saying. CPU Utilization is also not that high. Is this something the recommender will just do if we have lower base configuration?
 

 

[ronnelg]

Yes, that is correct. The 614 MB memory is so small. So you need to edit your instance to increase the memory to 3.75 GB to prevent out-of-memory events .

[maham1243]

It still seems less than convincing because the recommender doesn't have the metrics to reliably tell if my workload is going to demand me to upscale or resize but wants me to go the costlier route anyway. 

I will end on this note, assuming my understanding is correct. Thank you so much for replying and for your valuable time!