Re: Table size - Mailing list pgsql-admin

From Jim Nasby
Subject Re: Table size
Date
Msg-id F8EF74FD-0F4E-4D26-A80F-844CB5A67A0A@decibel.org
Whole thread Raw
In response to Re: Table size  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
On Jun 14, 2007, at 8:16 AM, Michael Fuhr wrote:
> On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
>> How can I calculate a table size in postgres ?
>
> To find the size of an existing table use pg_relation_size() or
> pg_total_relation_size() (8.1 and later; in earlier versions use
> the functions in contrib/dbsize).

If you don't need an exact size, you can also look at
pg_class.relpages, which is the size of a relation in pages. The
relation_size functions actually read the size off the filesystem,
which seems to be quite a bit slower if you're dealing with more than
a few files.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



pgsql-admin by date:

Previous
From: Jim Nasby
Date:
Subject: Re: How to restore updated records
Next
From: Aleksander Kmetec - INTERA
Date:
Subject: Re: How to restore updated records