Re: : Performance Improvement Strategy

Venkat Balaji <venkat.balaji 'at' verse.in> writes:

> Hello,
>
> I was attempting to calculate the actual occupied space by a Table.

SELECT relname, reltuples, pg_size_pretty(relpages*8*1024) as size FROM pg_class, pg_namespace WHERE pg_namespace.oid =
pg_class.relnamespaceAND relkind = 'r' AND nspname = 'public' ORDER BY relpages DESC; 

relkind = 'i' for indexes.

--
Guillaume Cottenceau