Re: how to know the current size of a database

From: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>
To: son(at)raider(dot)co(dot)nz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to know the current size of a database
Date: 2007-09-19 16:32:59
Message-ID: 46F14F3B.2060107@lorenso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

son(at)raider(dot)co(dot)nz wrote:
> I want to know about the size of my database. For example, I want to know
> how many Mb of data for current myDatabase database in a postgres server.

SELECT pg_size_pretty(pg_database_size(current_database()));

-- Dante

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-09-19 16:39:24 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Teodor Sigaev 2007-09-19 16:30:42 Re: Tsearch2 - spanish