Postgres Pro
Downloads
Home   >   mailing lists

Re: how to know the current size of a database - Mailing list pgsql-general

From D. Dante Lorenso
Subject Re: how to know the current size of a database
Date
Msg-id 46F14F3B.2060107@lorenso.com
Whole thread Raw
In response to how to know the current size of a database  (son@raider.co.nz)
List pgsql-general
Tree view 
son@raider.co.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

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Tsearch2 - spanish
Next
From: Erik Jones
Date:
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER