Thread: Database,TempDB,index,Transaction log sizes

Database,TempDB,index,Transaction log sizes

From
"Sharma;G.S."
Date:
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
 
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.

Re: Database,TempDB,index,Transaction log sizes

From
Jim Nasby
Date:
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