Thread: Cript for DISK SPACE USE psql
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.
Thank you
Trula
Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.
You can use combinations of
Database Object Size Functions to create the script.
Hope this will help
with regards
Ashish...
Trula Thomas <trulathomas@yahoo.com> wrote:
Hello, would anyone know the cript for disk space use (psql)? Please help.
Thank you
Trula
Check out what you're missing if you're not on Yahoo! Messenger
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'
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.