Timeline for How can I find what's eating so much space in Postgres in AWS RDS Aurora?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 11 at 13:10 | comment | added | jjanes | Just replace "user" in "pg_statio_user_tables" with "all" in your current query. But be aware that your total_size column will then be double-counting the size of TOAST. | |
| Sep 11 at 2:10 | comment | added | Christian Saiki | @Martie I have about 33GB in FreeLocalStorage according to Cloudwatch, but my VolumeBytesUsed is 4.5TB | |
| Sep 11 at 2:06 | comment | added | Christian Saiki | @jjanes I think I do have access, which query should I use to check this hypothesis? | |
| Sep 11 at 1:09 | comment | added | Christian Saiki | @Vérace I don't have access to AWS Tech Support because my company doesn't want to pay for it, unfortunately. | |
| Sep 11 at 1:09 | comment | added | Christian Saiki |
@Vérace yes I tried VACUUM it cleared about 10GB of space
|
|
| Sep 10 at 20:44 | comment | added | jjanes | An obvious possibility is that isn't in the user table. Do you have access to query all_tables or sys_tables? | |
| Sep 9 at 22:34 | comment | added | Vérace |
Have you tried VACUUMing your system?
|
|
| Sep 9 at 8:54 | comment | added | Vérace | Hi, and welcome to dba.se! Why don't you have access to tech support? | |
| Sep 9 at 7:03 | comment | added | Martie | Is this post: dba.stackexchange.com/questions/312473/… helpfull? | |
| S Sep 9 at 6:07 | review | First questions | |||
| Sep 9 at 11:35 | |||||
| S Sep 9 at 6:07 | history | asked | Christian Saiki | CC BY-SA 4.0 |