Re: Querying database size - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Querying database size
Date
Msg-id 1d219a6f0607071050y4599b1f7w5f416ad72a382e0e@mail.gmail.com
Whole thread Raw
In response to Querying database size  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgsql-admin


On 7/7/06, Benjamin Krajmalnik <kraj@illumen.com> wrote:
Is there a query which can be issued which will return the size of a
database?
I see that in pgadmin you can get the values on a per table manner.
I have looced at the pg_catalog schema, but to be truthful I cannot
figure out how to get that information.

TIA,

Benjamin

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


select datname, pg_database_size(datname) from pg_database;

This assumes your are running 8.x (might be 8.1.x).

chris

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Querying database size
Next
From: Jeff Frost
Date:
Subject: Re: Querying database size