Wednesday, August 13, 2008

Re: [GENERAL] Disk space occupied by a table in postgresql

On Sat, 2008-08-09 at 04:59 -0400, Fouad Zaryouh wrote:
> Hi Aravind,
>
> Run the following query
>
> SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class
> ORDER BY relpages DESC;
>
>
>
> relname = table name
> relpages = size in MB
> reltuples = number of rows.
>
> Hope this help.
>
>
>
> Fouad Zaryouh
>
> http://www.flipcore.com
>
>
>
>
> On Sat, Aug 9, 2008 at 3:18 AM, aravind chandu
> <avin_friends@yahoo.com> wrote:
> Hello,
>
> I installed postgresql on linux system, I
> create a table and inserted a large data into the table what I
> would like to know is how to calculate the disk space occupied
> by the table .Is there any procedure to find it out or simply
> a command .Please give me some suggestion.
>
>
> Thank You,
> Avin.
>
>
>
>

This may be of use in recent versions...
select pg_size_pretty(pg_database_size('table_name'))

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: