Skip site navigation (1) Skip section navigation (2)

Re: We want to monitor total size of database

From: Yumiko Izumi <izumi-yumiko(at)scnet(dot)co(dot)jp>
To: PostgreSQL Novice Mailing Group <pgsql-novice(at)postgresql(dot)org>
Subject: Re: We want to monitor total size of database
Date: 2006-01-05 04:01:58
Message-ID: 20060105130039.1781.IZUMI-YUMIKO@scnet.co.jp (view raw or flat)
Thread:
Lists: pgsql-novice
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.


In response to

Responses

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2006-01-05 06:17:01
Subject: Re: We want to monitor total size of database
Previous:From: Frank BaxDate: 2006-01-05 01:02:41
Subject: Re: Best way to manage users

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group