Postgres Pro
Downloads
Home   >   mailing lists

Re: Cript for DISK SPACE USE psql - Mailing list pgsql-admin

From adey
Subject Re: Cript for DISK SPACE USE psql
Date
Msg-id 1c66bda80704172119x70d3c12fjf3760064ebe766d5@mail.gmail.com
Whole thread Raw
In response to Cript for DISK SPACE USE psql  (Trula Thomas <trulathomas@yahoo.com>)
List pgsql-admin
Tree view
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@yahoo.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.


pgsql-admin by date:

Previous
From: adey
Date:
Subject: Re: Checking a size of a given database
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Checking a size of a given database