Обсуждение: Cript for DISK SPACE USE psql

You can use combinations of

Hope this will help

with regards

 

Ashish...

Trula Thomas <trulathomas@yahoo.com> wrote:

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'