I deleted all records in my database and it still showed 1.43GB of data, this is bad because I’m being charged for it. How many discrepancies exist where I’m being charged for hallucinated resources? One table with 0 records showed 886MB storage and another table with 0 records showed 550MB storage, not good.
WARNING: I HAD ZERO (0) RECORDS IN THE TABLES, DON’T DO WHAT I DID IF YOUR TABLES HAVE DATA:
The only way I was able to get it to reflect my true storage value was to delete the two tables and re-create them.
I asked assistant to “give me an SQL command that would re-create my [TABLE_NAME] table”
Now give me sql command to delete my [TABLE_NAME] table
Once I did this it reflected the actual table size of 16kB