Since I'm using a scraper every 3-4 days i constantly add and update records in my database. There was a time when i reached a big capacity on the volume, like 90% (now i'm on 98%) so I tried dropping data directly from my IDEA by connecting with the public url for my database, since I didn't want to wipe the whole volume (I have data that I don't want to drop/delete).

But when I did that, the volume remained unchanged. I've reached 5GB of memory for now and I really don't know how....

Since It is not affordable for me to upgrade to the Pro plan right now, what is the workaround here?

Above is the initial thread I put up.

I was talking with @itsrems but he closed the thread and I think we didn't finish the conversation we had...

Anyway, i ran this query:

SELECT pg_size_pretty(SUM(total_bytes - index_bytes - COALESCE(toast_bytes, 0))) AS total_table_bytes FROM ( SELECT pg_total_relation_size(c.oid) AS total_bytes, pg_indexes_size(c.oid) AS index_bytes, pg_total_relation_size(reltoastrelid) AS toast_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE relkind = 'r' ) a;

and I got 4162 MB and on your service I have 5GB at 100% capacity atm. What is the issue here that I am missing??