[GENERAL] Auto Vaccum

2009-12-02 Thread akp geek
Hi All -

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

regards


Re: [GENERAL] Auto Vaccum

2009-12-02 Thread Devrim GÜNDÜZ
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


signature.asc
Description: This is a digitally signed message part


Re: [GENERAL] Auto Vaccum

2009-12-02 Thread akp geek
thank you

2009/12/2 Devrim GÜNDÜZ dev...@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