Project went 16gb over compute hours without having worked on it since the new periode
So I have this nextjs application where I seed your(neon) database (once, not every boot) with a sql file which creates two tables to display chat messages. Total chat users e.g. : Row A - Name, Row B - Name, this only contans 5 or six rows.
Then I have the table which I tore the messages in which accumilate around, well i'm not sure 250-500k. I query on the front-end (NextJS) via drizzle ORM which worked perfectly fine, I check the first table to match name in table 2 with the messages and dispay whatsapp history like that, with some additionalf eaturs like favouriting, better-search yadadad.
Long story short. Previous month I just got over 5gb due to importing hundred thousands of sql statements I suppose. This month I worked about a day on it but did NOT import anything not really change anything int he query language but for some reason now I can't work on the project because i'm over the quota. Which also means I can't dump my data out of your panel it seems like.
Trouble shooting in regards of logs seems useleess as there is no info retended. I've tired some SQL statements to check out if there's history of weird behaviour but since i'm limited i can't do anything.
There is only one user, which is me. To be honest i'm getting to the point I want to migrate over to local dockr and my vps. There's no real logical reason or docs why this happends and how to prvent it. Please look into why I used 16gb. Btw, i only run this locally. No other pople can have accessed it.
Poject ID is
restless-frost-832967741 Reply
rare-sapphire•12mo ago
Hey! Based on your descripotion it seems that you ran into the Data transfer (Egress) limit of 5 GB per month. Data transfer usage refers to the total volume of data transferred out of Neon (known as "egress") during a given billing period.
I query on the front-end (NextJS) via drizzle ORMSo, every time your Next.js app runs, and you query your database, data is transferred out of Neon.
display whatsapp history like thatIf there are a lot of messages being displayed, then this is likely how you exceeded the data transfer limit When querying your database, are you getting this error: Also, do you mind sharing a screenshot of your usage's page? https://console.neon.tech/app/billing#usage