Is there any way setting compute hours to 0? Or does it reset automatically every day or month?
.
IHey!
Compute hours are reset on the first of the month, every month.
You can also upgrade to your Launch or Scale plan.
Compute hours are reset on the first of the month, every month.
You can also upgrade to your Launch or Scale plan.
Salright thanks.
Show interaction with the database is called the compute hour?
II'm not sure I understand, are you asking why its called a compute hour?
Syeah
Swhat's the compute hour
Sduration of staying connected with the database?
IA CU (Compute Unit) is Neon's measure of compute size. It's basically how big was your database in vCPU, and for how long. Running a 0.25vCPU database for 4 hours will cost you 1CU, whereas running a 1vCPU database for 4 hours will cost you 4CU (it's vCPU * time)
Sfor 4 hours means?
Stime taken per request for data transfer from the server?
INo, how long the database was active for
SBut I keep connected to the server 24/7
INeon has auto scaling, so much of that time is most likely spend inactive. What does your CPU over time graph in the monitoring tab look like look?
SLike I have my discord bot in python which connects to the database on startup
IYes, but a connection will not keep the database active, only traffic to the database
Sit says no data to show
Sin the time duration box I see only 26th sept and 27th sept
ICan you change the window to last 24h?
Sso doing what woul reduce my compute hours?
Syeah
Sbut its still no data to show
Scause I am unable to connect to the database since 2 days as it reached the limit and declines connection
IAs in you're out of CU?
IDo you have your database min size set to 0.25vCPU?
S
ITo reduce your compute hour usage you want to make sure that you haev your min CPU size set to 0.25, and you want to make sure you dont have any cron jobs or anything that constantly pulls out database out of inactivity
SI do have some jobs that call fetch data every 5 seconds
Sand that's the main purpose of my database
IThen you won't be able to make use of the Neon auto scaling, and will run out of compute every month around the 16th
Sthis month is the first time I got this issue
Si am using neon from 2-3years
Snot 5 sec, I do 2fetches every 1 minute and 2fetches 30 seconds
IIf you hit your database in intervals of less than 5 minutes, you will keep your database on 24/7. You were most liketly not hitting your database as often before
SSo I should give requests every 5 minutes of interval?
INo, you'll still be keeping the database on 24/7 since it takes 5 minutes for scale to zero to hit.
Sthen? 10 minutes?
S@Sam its the first day of the month but the compute hours didn't reset yet.
IThey will reset, it just depends on your time zone.
You can have a look at last months discussions : ❓｜questions-and-answersQuota not resetting after new billing cycle (Free Plan)
You can have a look at last months discussions : ❓｜questions-and-answersQuota not resetting after new billing cycle (Free Plan)
Iwell it depends on your use case. When you're using Neon, you just want to avoid running cron jobs since it keeps the database on. But, if thats what your app requires, then you won't be able to make use of the scale-to-zero feature, and will run out of compute hours.
Sits mid night + 48minutes
Snah its been midnight + 2hours
II believe we reset all quotas at the same time, and because you're in an earlier time zone it will reset further into the first of the month
Sdo you have any estimate like how many hours later it is gonna be reset? I am in Indian Standard time
SAsia/Kolkata
SGMT + 5:30
IHey! Has everything been reset alright?
