Auto Vaccum

Started by akp geekover 16 years ago3 messagesgeneral
Jump to latest
#1akp geek
akpgeek@gmail.com

Hi All -

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

regards

#2Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: akp geek (#1)
Re: Auto Vaccum

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

#3akp geek
akpgeek@gmail.com
In reply to: Devrim GÜNDÜZ (#2)
Re: Auto Vaccum

thank you

2009/12/2 Devrim GÜNDÜZ <devrim@gunduz.org>

Show quoted text

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