Postgres Pro
Downloads
Home   >   mailing lists

Re: calculation of database size - Mailing list pgsql-general

From bricklen
Subject Re: calculation of database size
Date
Msg-id AANLkTim_-qymdqYdTdHf9SovRoPMJQKsmT+oX-Q4fh9+@mail.gmail.com
Whole thread Raw
In response to Re: calculation of database size  ("Jaiswal Dhaval Sudhirkumar" <JaiswalDS@microland.com>)
List pgsql-general
Tree view 
On Thu, Dec 9, 2010 at 8:37 AM, Jaiswal Dhaval Sudhirkumar
<JaiswalDS@microland.com> wrote:
> How can I measure the approximate database size based on raw* data.
> Is there any calculation template?
>
> --
> Thanks & Regards
> DJ

One option:
select pg_size_pretty( pg_database_size( 'yourdatabase' ) );

pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: monitoring warm standby lag in 8.4?
Next
From: Merlin Moncure
Date:
Subject: Re: use a variable name for an insert in a trigger for an audit