Postgres Pro
Downloads
Home   >   mailing lists

Thread: Auto Vaccum

Auto Vaccum

From
akp geek
Date:
Hi All -

                  how can I find out when the last vaccum run on the databse? Can you please help?

regards

Re: Auto Vaccum

From
Devrim GÜNDÜZ
Date:
On Wed, 2009-12-02 at 12:13 -0500, akp geek wrote:
> how can I find out when the last vaccum run on the
> databse?

Check pg_stat_user_tables.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Attachment

Re: Auto Vaccum

From
akp geek
Date:
thank you

2009/12/2 Devrim GÜNDÜZ <devrim@gunduz.org>
On Wed, 2009-12-02 at 12:13 -0500, akp geek wrote:
> how can I find out when the last vaccum run on the
> databse?

Check pg_stat_user_tables.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz