How to I find how much storage a managed PostgreSQL database is using?
How do I find how close I am to using up all the storage in a a managed PostgreSQL database cluster? Are there alerts as I approach the maximum storage?
I can use
select pg_size_pretty(pg_database_size('postgres')); but I was hoping to see it in the web interface.
You can reach out to the Support Team to get the output for your Managed Database disk usage since we currently do not have a way for customers to monitor their disk space or other Cluster metrics from the Cloud Manager. The
select pg_size_pretty(pg_database_size('postgres')); command is going to be your best bet at this point.
Additionally, there is no alert system setup to let you know when you are approaching the limit of your storage space.
I've gone ahead and submitted your request for these features to the relevant teams. If it gets added to the platform, we'll reach back out to let you know.