For planning or space monitoring, we often need to know how big the database is.
We can do this in the following two ways:
If you look at the size of the actual files, you'll need to make sure that you include the data directory and all subdirectories, as well as all other directories that contain tablespaces. That can be tricky, and it is also difficult to break out all the different pieces.
The easiest way is to just ask the database a simple query, such as the following:
However, this is limited to only the current database. If you want to find ...