Skip site navigation (1) Skip section navigation (2)

Re: growth of the database

From: Guido Neitzer <lists(at)event-s(dot)net>
To: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: growth of the database
Date: 2007-03-21 17:37:44
Message-ID: AA1DDA93-3883-4E39-BDA8-B41FC4134D68@event-s.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
On 21.03.2007, at 11:25, Karthikeyan Sundaram wrote:

>     Our database is growing fast.  I want to create a cronjob that  
> should tell me what is the current size of the database on each day.
>
>    How can I find this from the database? Is there any pre-written  
> scripts written by somebody to share?

Be aware of linebreaks ...

[Galadriel: cug ] cug $ psql -U postgres -c "select pg_size_pretty 
(pg_database_size('testdb'));"

pg_size_pretty
----------------
495 MB
(1 row)


In response to

pgsql-admin by date

Next:From: Brian A. SekleckiDate: 2007-03-21 17:46:53
Subject: Re: Read-only access to a database
Previous:From: Karthikeyan SundaramDate: 2007-03-21 17:25:51
Subject: growth of the database

pgsql-sql by date

Next:From: Guy FraserDate: 2007-03-21 20:32:26
Subject: Re: Regular Expressions
Previous:From: Ezequias R. da RochaDate: 2007-03-21 17:37:07
Subject: Re: Regular Expressions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group