| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Ron Watkins <rwatki(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Allocated size of DB? |
| Date: | 2022-10-18 02:48:28 |
| Message-ID: | bb6a6cec2eeed4a70f64636f23233af7792b29bc.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Connah | 2022-10-18 11:55:00 | Re: Just switched to Mac - Postgres.app or Homebrew or some other distribution? |
| Previous Message | Keith Fiske | 2022-10-17 16:51:49 | Re: Allocated size of DB? |