From ghanshyam@newgen.co.in Tue Aug 8 08:18:23 2006 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 AD8BE9FB296 for ; Tue, 8 Aug 2006 05:18:23 -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 52095-04 for ; Tue, 8 Aug 2006 08:18:20 +0000 (UTC) X-Greylist: delayed 00:06:38.212214 by SQLgrey- Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by postgresql.org (Postfix) with SMTP id DEA919FB286 for ; Tue, 8 Aug 2006 05:18:18 -0300 (ADT) Received: (qmail 3350 invoked by uid 507); 8 Aug 2006 08:11:36 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.1.3. Clear:RC:0(202.140.41.205):SA:0(-100.0/5.0):. Processed in 1.533975 secs); 08 Aug 2006 08:11:36 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 8 Aug 2006 08:11:35 -0000 Received: (qmail 23616 invoked by uid 504); 8 Aug 2006 08:11:02 -0000 Received: from ghanshyam@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.190):. Processed in 2.220302 secs); 08 Aug 2006 08:11:02 -0000 Received: from unknown (HELO ng3024) (192.168.5.190) by 192.168.5.243 with SMTP; 8 Aug 2006 08:11:00 -0000 Message-ID: <00ab01c6bac2$2ef55690$be05a8c0@ng3024> From: "Sharma;G.S." To: Subject: Database,TempDB,index,Transaction log sizes Date: Tue, 8 Aug 2006 13:40:59 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A8_01C6BAF0.48A2E430" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.69 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, HTML_TEXT_AFTER_BODY X-Spam-Level: X-Archive-Number: 200608/85 X-Sequence-Number: 22629 This is a multi-part message in MIME format. ------=_NextPart_000_00A8_01C6BAF0.48A2E430 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. Thanks in Advance=20 ------=_NextPart_000_00A8_01C6BAF0.48A2E430 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear all,
I have a database of 53GB , i want to=20 know break up of these 53GB .
Is there any command or way through = which i can=20 find out that how much space is used by database,Transaction Log,TempDB, = tables=20 indexes etc.
 
Thanks in Advance
 
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_00A8_01C6BAF0.48A2E430-- From jnasby@pervasive.com Wed Aug 9 02:54:32 2006 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