X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4BAE29FB1C2 for ; Fri, 7 Jul 2006 14:50:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 01494-04 for ; Fri, 7 Jul 2006 14:50:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.201]) by postgresql.org (Postfix) with ESMTP id 46A779FB0D1 for ; Fri, 7 Jul 2006 14:50:49 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s13so798011wxc for ; Fri, 07 Jul 2006 10:50:48 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=mE37gnr7GUlB3n5UAUkKZAoU7UVSyxKL/5kMYShZwCVOhI2HNY+D2zXxmA4QE7ZaOjMcBcO6NHIm9u23EYMEDQVX0PkrjxmKJj25i0RtDGmmIE55bcuH3c/jgKLEuG4ohkj4mI4t53gsjX3IHPvHVdUkavIS2HYfDh36+nLAkS4= Received: by 10.70.67.7 with SMTP id p7mr1263150wxa; Fri, 07 Jul 2006 10:50:48 -0700 (PDT) Received: by 10.70.73.15 with HTTP; Fri, 7 Jul 2006 10:50:48 -0700 (PDT) Message-ID: <1d219a6f0607071050y4599b1f7w5f416ad72a382e0e@mail.gmail.com> Date: Fri, 7 Jul 2006 13:50:48 -0400 From: "Chris Hoover" To: "Benjamin Krajmalnik" Subject: Re: Querying database size Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_126697_13852991.1152294648330" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/47 X-Sequence-Number: 22293 ------=_Part_126697_13852991.1152294648330 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/7/06, Benjamin Krajmalnik 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 ------=_Part_126697_13852991.1152294648330 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

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

------=_Part_126697_13852991.1152294648330--