Re: Finding out db size...

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: Christopher(dot)Becker(at)apcc(dot)com, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Finding out db size...
Date: 2004-04-30 18:17:44
Message-ID: BCB856D8.320E3%awitney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


If you install the dbsize extension in the contrib directory for the source
code, then you can run queries like this

SELECT database_size('my_database');
SELECT relation_size('my_table');

HTH

adam

>
> Is there any possible way to do a SQL query to return some sort of
> representation of how large the entire db is? Or even how large a single
> table is?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-05-01 04:08:00 Re: postmaster does not shut down
Previous Message Devrim GUNDUZ 2004-04-30 18:03:20 Re: Finding out db size...