Skip site navigation (1) Skip section navigation (2)

Re: Cript for DISK SPACE USE psql

From: adey <adey11(at)gmail(dot)com>
To: "Trula Thomas" <trulathomas(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Cript for DISK SPACE USE psql
Date: 2007-04-18 04:19:28
Message-ID: 1c66bda80704172119x70d3c12fjf3760064ebe766d5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)yahoo(dot)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.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->
>
>

In response to

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2007-04-18 04:23:57
Subject: Re: Checking a size of a given database
Previous:From: adeyDate: 2007-04-18 04:18:02
Subject: Re: Checking a size of a given database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group