Postgres Pro
Downloads
Home   >   mailing lists

Re: We want to monitor total size of database - Mailing list pgsql-novice

From Yumiko Izumi
Subject Re: We want to monitor total size of database
Date
Msg-id 20060105130039.1781.IZUMI-YUMIKO@scnet.co.jp
Whole thread Raw
In response to Re: We want to monitor total size of database  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: We want to monitor total size of database  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-novice
Tree view 
Thank you for a reply.

> yes... in 8.1.x there are specific functions to do this...
> http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE

We understand that the following is acquirable in
pg_total_relation_size().
*Total Size of database

However, now, the following is unacquirable.
*Size of used space of the entire database
*Size of free space of the entire database
*Size of fragmentation area of the entire database

Is there any method of acquiring the above?

Thanks.

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Best way to manage users
Next
From: Jaime Casanova
Date:
Subject: Re: We want to monitor total size of database