Обсуждение: Auto Vaccum

Поиск
Список
Период
Сортировка

Auto Vaccum

От
akp geek
Дата:
Hi All -

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

regards

Re: Auto Vaccum

От
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
Вложения

Re: Auto Vaccum

От
akp geek
Дата:
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