From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
---|---|
To: | Yumiko Izumi <izumi-yumiko(at)scnet(dot)co(dot)jp> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: We want to monitor total size of database |
Date: | 2005-12-28 14:22:04 |
Message-ID: | c2d9e70e0512280622x427a1500uec9a918da2cf4035@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 12/27/05, Yumiko Izumi <izumi-yumiko(at)scnet(dot)co(dot)jp> wrote:
> Hello.
>
> We want to monitor the following items with respect to PostgreSQL.
> *Total Size of database
> *Size of used space of the entire database
> *Size of free space of the entire database
> *Size of fragmentation area of the entire database
>
> But the following items are getting monitored in PostgreSQL7.3.8.
> ("Pgstattuple" is used for monitoring)
> *Total of sizes of all the tables in database
> *Total of used space by all the tables in database
> *Total of free space of all the tables in database
> *Total of fragmentation area of all the tables in database
>
> In short, in 7.3.8 we are not able to acquire the information on the space
> related to
> index but the information of the partial area of the database is monitored.
>
> Therefore, we are in search of the method to monitor the space of the entire
> database.
>
> Our question is:
> Is there any method available in PostgreSQL8.1.0 for monitoring the space of
> the entire database ?
>
> Best Regards,
>
>
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
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
From | Date | Subject | |
---|---|---|---|
Next Message | Vanja | 2005-12-28 14:53:59 | limiting number of allowed rows in a table |
Previous Message | Larry Rosenman | 2005-12-28 14:00:11 | Re: We want to monitor total size of database |