Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 118649FB214
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 16 Jan 2007 09:48:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 64571-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 16 Jan 2007 09:48:23 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.238])
	by postgresql.org (Postfix) with ESMTP id CBD239FA4D4
	for <pgsql-performance@postgresql.org>;
	Tue, 16 Jan 2007 09:48:22 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so2110802wxd
	for <pgsql-performance@postgresql.org>;
	Tue, 16 Jan 2007 05:48:18 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=YNIpPA+jwZpptAaACtzVaqbb6WmRz7G/cRAzPdFyXIraI0w7IreFiKQywzwX/ubV8oW7TjuW7oROQo/y/rXysXDcTrIpzHjOnlzifdmOQmvRw1RjnaF2XJuGmKjMPmwrmEECBVsSEbYD4JuZHPW/VKAsVjDQSc4O4MZSiMdmeU8=
Received: by 10.90.72.10 with SMTP id u10mr4415621aga.1168955297579;
	Tue, 16 Jan 2007 05:48:17 -0800 (PST)
Received: by 10.90.73.1 with HTTP; Tue, 16 Jan 2007 05:48:17 -0800 (PST)
Message-ID: <7e4ba9550701160548v4980393buba8bbf6926e2b0a0@mail.gmail.com>
Date: Tue, 16 Jan 2007 19:18:17 +0530
From: "Gauri Kanekar" <meetgaurikanekar@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Table Size
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_94578_4189550.1168955297545"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/241
X-Sequence-Number: 22842

------=_Part_94578_4189550.1168955297545
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

Can anybody help me out to get following info of all the tables in a
database.

table_len
tuple_count
tuple_len
tuple_percent
dead_tuple_count
dead_tuple_len
dead_tuple_percent
free_space
free_percent

Thanks
Gauri

------=_Part_94578_4189550.1168955297545
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,</div>
<div><br clear="all">Can anybody help me out to get following info of all the tables in a database.</div>
<div>&nbsp;</div>
<div><font size="2">table_len</font></div>
<div><font size="2">tuple_count</font></div>
<div><font size="2">tuple_len</font></div>
<div><font size="2">tuple_percent</font></div>
<div><font size="2">dead_tuple_count</font></div>
<div><font size="2">dead_tuple_len</font></div>
<div><font size="2">dead_tuple_percent</font></div>
<div><font size="2">free_space</font></div>
<div><font size="2">free_percent</font></div>
<div>&nbsp;</div>
<div>Thanks&nbsp;</div>
<div>Gauri </div>

------=_Part_94578_4189550.1168955297545--