Home > mailing lists

my table is empty, pg_relation_size(name) return 38 MB - Mailing list pgsql-admin

From	Shivakumar Ramannavar
Subject	my table is empty, pg_relation_size(name) return 38 MB
Date	August 4, 2011 11:25:01
Msg-id	CACdOLXY7C19fcD+ULSjXe6b_VFiGh7+MvFnninGfPA9o7kRdTQ@mail.gmail.com Whole thread Raw
Responses	Re: my table is empty, pg_relation_size(name) return 38 MB ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List	pgsql-admin

Hi Team,

Though my table is empty, pg_relation_size(name) return 38 MB. I use below query to determine tables disk usages.

SELECT nspname || '.' || relname AS "Table",

pg_total_relation_size(C.oid) "Size",

pg_size_pretty(pg_total_relation_size(C.oid)) AS "Total size"

FROM pg_class C

LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)

WHERE nspname NOT IN ('pg_catalog', 'information_schema')

AND C.relkind <> 'i'

AND nspname !~ '^pg_toast'

Please help,

Thanks!

Shiva

--
Shivakumar Ramannavar

From: Scott Marlowe
Date: 03 August 2011, 14:03:00
Subject: Re: Postgres 8.2.5

From: "Kevin Grittner"
Date: 04 August 2011, 15:21:49
Subject: Re: my table is empty, pg_relation_size(name) return 38 MB