Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4A8F79FB4B4 for ; Wed, 18 Apr 2007 01:19:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 81206-03 for ; Wed, 18 Apr 2007 01:19:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 64E8E9FB3A3 for ; Wed, 18 Apr 2007 01:19:29 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so253044ugf for ; Tue, 17 Apr 2007 21:19:28 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Q1gWKWdHA9i49JEwmIWMuHMMhsEcPy9W9Cxu8ox1aSyI8wpDb/hy5de/IrzijEdfpwlop6vLvotPxAjWq0KGWdHa4sSGmgnsY0sySv/xYJoKk1k7vu0H3lOwL4JNsNeFMH+ddhuZpPMRg3nAK20Y228FUplVtsDEOquaJQGka0E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=DGWi0nktJyrMAXqkZXmLdYOniFEmGtOeqMy8SAkdB6eCO7e1rszWyChaSGobNjjwNRXfaGfrp9nUDaPZqgAz6mDm+yvpaa1nILDmVJngu2PqDNLonhPCKpLbJ0B7wI32uUcghYnzPxBCY/CqzxyFc6CTlSVAwed/eTtyhxlfUSQ= Received: by 10.82.155.10 with SMTP id c10mr74983bue.1176869968082; Tue, 17 Apr 2007 21:19:28 -0700 (PDT) Received: by 10.82.146.12 with HTTP; Tue, 17 Apr 2007 21:19:28 -0700 (PDT) Message-ID: <1c66bda80704172119x70d3c12fjf3760064ebe766d5@mail.gmail.com> Date: Wed, 18 Apr 2007 16:19:28 +1200 From: adey To: "Trula Thomas" Subject: Re: Cript for DISK SPACE USE psql Cc: pgsql-admin@postgresql.org In-Reply-To: <980032.39869.qm@web56912.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31488_31522939.1176869968039" References: <980032.39869.qm@web56912.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/167 X-Sequence-Number: 25231 ------=_Part_31488_31522939.1176869968039 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Try this:- -- Query returns size of a database calculated from the no. 8k pages allocated to tables SELECT -- * sum( relpages*8/1024 ) as MB FROM pg_class WHERE -- relname != '' -- relname = 'document' relnamespace = '2200' On 4/16/07, Trula Thomas wrote: > > Hello, would anyone know the cript for disk space use (psql)? Please help. > Thank you > Trula > > ------------------------------ > Ahhh...imagining that irresistible "new car" smell? > Check out new cars at Yahoo! Autos. > > ------=_Part_31488_31522939.1176869968039 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Try this:-
 
-- Query returns size of a database calculated from the no. 8k pages allocated to tables
SELECT
-- *
 sum( relpages*8/1024 ) as MB
FROM
 pg_class
WHERE
-- relname != ''
-- relname = 'document'
 relnamespace = '2200'

 
On 4/16/07, Trula Thomas <trulathomas@yahoo.com> wrote:
Hello, would anyone know the cript for disk space use (psql)? Please help.
Thank you
Trula


Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.


------=_Part_31488_31522939.1176869968039--