X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id CE7949FB309 for ; Tue, 8 Aug 2006 23:54:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 20216-02-2 for ; Wed, 9 Aug 2006 02:54:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 341419FB2DA for ; Tue, 8 Aug 2006 23:54:25 -0300 (ADT) Received: from [192.168.42.113] (natpool.bovine.net [67.100.216.14]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id E4CF15643D; Tue, 8 Aug 2006 21:54:24 -0500 (CDT) In-Reply-To: <00ab01c6bac2$2ef55690$be05a8c0@ng3024> References: <00ab01c6bac2$2ef55690$be05a8c0@ng3024> Mime-Version: 1.0 (Apple Message framework v752.2) X-Priority: 3 Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: Database,TempDB,index,Transaction log sizes Date: Tue, 8 Aug 2006 11:57:16 -0500 To: Sharma;G.S. X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/105 X-Sequence-Number: 22648 On Aug 8, 2006, at 3:10 AM, Sharma;G.S. wrote: > Dear all, > I have a database of 53GB , i want to know break up of these 53GB . > Is there any command or way through which i can find out that how > much space is used by database,Transaction Log,TempDB, tables > indexes etc. The sysviews project on http://pgfoundry.org has system views that will contain some of that info. You can also look in $PGDATA; there's a tool (in contrib, I think) that will convert the filenames into what relation they are. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461