Hi All,
Hi All,
I am using Neon PostgreSQL for my Database. And I am on a free plan of it.
I have been using this server for last 6-7 months. But suddenly, I have seen a hike in its compute usage. The compute hours have reached to 192. And as it provides the 190 hours only in the free plan, now I am unable to use that database into my application anywhere.
This is more scary for me as I have planned to use thus Neon database for production environment as well.
Also I tried to get to the usage statistics from the monitoring tab but I could not find anything there, as it is not showing me any matrices there.
So guys if you could help me identify the culprit for such a sudden hike in the compute usage it will really be a great help to me! 😄
Feel free to let me know if you need any additional information. I will be more than happy to bring it here for you if it can be helpful.
Thanks in advance for any help!
5 Replies
ratty-blush•4mo ago
It sounds like you're not scaling to zero or your compute size is larger than it should be.
Is there anything that might be keeping your compute alive, such as a connected app, service, or data replication?
You can check your compute size following these instructions:
https://neon.tech/docs/manage/computes#edit-a-compute
A smaller compute will use fewer compute hours.
rival-black•4mo ago
Yes, the one thing that I assume keeping the compute of my database alive is Scheduled Cron Job. That cron job is running every minute.
Do you think this can be a one possible reason?
Apart from this, as an additional information, My Compute Size is on Auto Scaling from 0.25 vCPU 1 GB RAM to 2 vCPU 8 GB RAM.
And also what can be the solution in my case.
ratty-blush•4mo ago
Yes, on the Free plan, your database suspends after 5 minutes of inactivity. If you run a cron job every minute, the database stays active and consumes compute hours continuously. This will quickly use up your Free plan allowance. If the cron job must stay, consider reducing your compute size to 0.25 vCPU (fixed). With 191 compute hours included for a 1 vCPU compute, a 0.25 vCPU compute can run all month (191 × 4 hours).
ratty-blush•4mo ago
Neon
Neon plans - Neon Docs
Neon's plans are designed to meet different user requirements, ranging from hobby projects to enterprise level production workloads. We also offer custom enterprise plans with volume based discounts f...
rival-black•4mo ago
Okay Thanks @Daniel for your valuable inputs.