Re: Determining table size

From: Yusuf <yusuf0478(at)netscape(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Determining table size
Date: 2003-06-25 13:29:38
Message-ID: 3EF9A3C2.3030006@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I usually do the following:

for table tbl: select relpages * 8 from pg_class where relname = 'tbl' (This would give you an answer in KB)
for a db: select sum(relpages)* 8 from pg_class where relname not like 'pg_%'

Browse pgsql-general by date

  From Date Subject
Next Message abremond 2003-06-25 13:32:26 Problem with duplicate file.
Previous Message Benjamin Jury 2003-06-25 13:10:03 Administration Documentation....