Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 21C5CB5DBE2 for ; Thu, 4 Aug 2011 08:25:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 44164-08 for ; Thu, 4 Aug 2011 11:24:54 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 51500B5DBE0 for ; Thu, 4 Aug 2011 08:24:53 -0300 (ADT) Received: by wyf22 with SMTP id 22so446213wyf.19 for ; Thu, 04 Aug 2011 04:24:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=WXy/mMpq/nf5FukHEbIxraB4CbbUm1pBXo/GGNIgazM=; b=Mzo6MPnz59WTTiFdDRrj9Vzqg2EmkTI0Gu+PwgfmCcbULIS2jE77AvGgGvkz1Q0lrj +8joiuVIpJNSmwXqv0wXQJ/xh1S0w1k8jV8UKKLClEBi+oO/cH4f4jtfUHQDhUFEs2dd SojzYybnTf4JEgiU6UpdzHSABVF7kCUjzJ29E= MIME-Version: 1.0 Received: by 10.216.188.202 with SMTP id a52mr1653738wen.114.1312457093579; Thu, 04 Aug 2011 04:24:53 -0700 (PDT) Received: by 10.216.138.207 with HTTP; Thu, 4 Aug 2011 04:24:53 -0700 (PDT) In-Reply-To: References: Date: Thu, 4 Aug 2011 16:54:53 +0530 Message-ID: Subject: my table is empty, pg_relation_size(name) return 38 MB From: Shivakumar Ramannavar To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016364d212bd8836204a9ac3a8f X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.888 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201108/17 X-Sequence-Number: 38004 --0016364d212bd8836204a9ac3a8f Content-Type: text/plain; charset=ISO-8859-1 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 -- Shivakumar Ramannavar --0016364d212bd8836204a9ac3a8f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
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 || &#= 39;.' || relname AS "Table",
=A0 =A0 pg_total_relation_size(C.oid) "Size",
=A0 = =A0 pg_size_pretty(pg_total_relation_size(C.oid)) AS "Total size"=
=A0 FROM pg_class C
=A0 LEFT JOIN pg_namespace N ON (N= .oid =3D C.relnamespace)
=A0 WHERE nspname NOT IN ('pg_catalog', 'information_schem= a')
=A0 =A0 AND C.relkind <> 'i'
=A0 = =A0 AND nspname !~ '^pg_toast'

Please help= ,
Thanks!
Shiva
--
Shivakumar= Ramannavar



--
Shivakumar Ramannavar
--0016364d212bd8836204a9ac3a8f--