I logged into the Digital Ocean console today to find that a notification saying that one of my managed databases is running low on disk space. I tried to go increase the disk size, but the only option I can find that will do that is the buy more expensive nodes. I’m on a 25GB node right now, and it seems to have more than enough RAM and CPU. The next size up will cost 2x the price and not even double my disk space (but it does double my CPU and RAM, neither of which I’m low on). So a few questions, which I’ve been unable to answer from reading the docs: How can I increase just the disk size? Where can I see how much of the disk is used at any given time, or do I just have to wait for a notification via the DO console? I would really like to integrate this kind of thing into existing monitoring solutions so detection and alerting can occur via the proper channels, instead of hoping someone signs into the console in time. Can I see the usage of the other resources? I said I have “more than enough RAM and CPU” but in reality I have no idea what kind of usage the DB nodes are seeing, and so I have no way to verify that. I just haven’t seen any reason to suspect they’re not.

- Community
- DigitalOcean
- Community
- DigitalOcean

How do I increase my managed DB's disk without increasing the other resources?

Posted on April 20, 2020

DigitalOcean Managed PostgreSQL Database

I logged into the Digital Ocean console today to find that a notification saying that one of my managed databases is running low on disk space.

I tried to go increase the disk size, but the only option I can find that will do that is the buy more expensive nodes. I’m on a 25GB node right now, and it seems to have more than enough RAM and CPU. The next size up will cost 2x the price and not even double my disk space (but it does double my CPU and RAM, neither of which I’m low on). So a few questions, which I’ve been unable to answer from reading the docs:

How can I increase just the disk size?
Where can I see how much of the disk is used at any given time, or do I just have to wait for a notification via the DO console? I would really like to integrate this kind of thing into existing monitoring solutions so detection and alerting can occur via the proper channels, instead of hoping someone signs into the console in time.
Can I see the usage of the other resources? I said I have “more than enough RAM and CPU” but in reality I have no idea what kind of usage the DB nodes are seeing, and so I have no way to verify that. I just haven’t seen any reason to suspect they’re not.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby

April 20, 2020

Hi there @finnn,

In order to check your current resources’ utilization like RAM, CPU and disk storage, what you need to do is go to your Database Cluster, click on Insights, then from the ‘Select object’ dropdown make sure to select your Database cluster name and then scroll a bit further down, there you will see metrics like the CPU usage, Memory usage, and your Disk usage.

Here is a screenshot of that:

Usage

Regarding the upgrade of disk usage only, I think that it might not possible yet. I think that it is a great idea, it sounds like it’d be super useful!

The best thing to do to get your voice heard regarding this would be to head over to our Product Ideas board and post a new idea, including as much information as possible for what you’d like to see implemented.