| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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->
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-04-18 04:23:57 | Re: Checking a size of a given database |
| Previous Message | adey | 2007-04-18 04:18:02 | Re: Checking a size of a given database |