Re: dbsize command - Mailing list pgsql-general

From salman
Subject Re: dbsize command
Date
Msg-id 485FFC1F.3040306@quietcaresystems.com
Whole thread Raw
In response to Re: dbsize command  (Brad Nicholson <bnichols@ca.afilias.info>)
Responses Re: dbsize command  ("Leif B. Kristensen" <leif@solumslekt.org>)
List pgsql-general
Brad Nicholson wrote:
> On Mon, 2008-06-23 at 10:50 -0700, Reynolds, Gregory A wrote:
>> In past versions there was a contrib/dbsize command that would tell
>> you how much storage space was being taken by a table. Is that is
>> still a supported feature in 8.3, and if so what is the syntax or
>> where is the documentation on how to use it?
>
> There are a series of functions in the database core that will tell you
> this now.
>
> http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
>

This is what I use: SELECT
pg_size_pretty(pg_database_size(current_database()));

Found it a while back on pg-general.

-salman

pgsql-general by date:

Previous
From: "Mike Gould"
Date:
Subject: Re: Data Types
Next
From: "Daniel Futerman"
Date:
Subject: Update Join Query