I am using AWS RDS to host one PostgreSQL database. I notice that the disk usage at the AWS dashboard is much more (2x) than what is shown at PgAdmin. Hopefully someone can help me to figure out it.

AWS

[![enter image description here][1]][1]

PgAdmin

[![enter image description here][2]][2]

I find this issue after I tried several times to create a materialized view for caching very complex query results. All failed because of out of space (for computing?). I expect the remaining space (~7GB originally) would return but it didn't!! [1]: https://i.sstatic.net/1TqTQ.png [2]: https://i.sstatic.net/pu5qd.png

I am using AWS RDS to host one PostgreSQL database. I notice that the disk usage at the AWS dashboard is much more (2x) than what is shown at PgAdmin. Hopefully someone can help me to figure out it.

AWS

PgAdmin

I find this issue after I tried several times to create a materialized view for caching very complex query results. All failed because of out of space (for computing?). I expect the remaining space (~7GB originally) would return but it didn't!!