Disk space occupied by a table in postgresql

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:

aravind chandu <avin_friends@yahoo.com> schrieb:

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.

You can use the pg_relation_size() - function, described here:
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�

On Sat, Aug 09, 2008 at 12:18:46AM -0700, aravind chandu wrote:

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.

select pg_relation_size('table_name');
or
select pg_total_relation_size('table_name');

both return size in bytes.

pg_total_relation_size includes disk space used by indexes and external
storage (long texts are kept not in table datafile, but in separate
"toast" tables).

Best regards,

depesz

--
Linked in: http://www.linkedin.com/in/depesz
jid/gtalk: depesz@depesz.com
aim: depeszhdl
skype: depesz_hdl

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'))