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.relnamespace AND relkind = 'r' AND nspname = 'public' ORDER BY relpages DESC;
relkind = 'i' for indexes.
--
Guillaume Cottenceau