On Mon, 2022-10-17 at 09:48 -0700, Ron Watkins wrote:
> I have a request to supply business owner with both the available size of DB as well
> as the used size of the DB. I have been able to locate the used size, but I don't see
> any way to query the available size (used + unused space). How can I find that in PSQL?
The available size would be the size of the file system that contains the data directory.
You cannot query that size from the database; you have to ask the operating system.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com