Autvacuum and Analyze stats? - Mailing list pgsql-novice

From Machiel Richards
Subject Autvacuum and Analyze stats?
Date
Msg-id 011d01cadaf0$91bd9f10$b538dd30$@co.za
Whole thread Raw
Responses Re: Autvacuum and Analyze stats?  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-novice

Hi All

 

     I have a couple of databases on which the autovacuum is configured.

 

                Is there a way to confirm when last the autovacuum ran (and if so was there any errors).

 

                                                *** The auto vacuum is configured to run every 60 seconds, however the check_postgres package states that the last vacuum was 12 days ago and I need to see if I can confirm this manually.

 

                I am also trying to find out if there is a way of seeing when last a table / database had been analyzed if ever.

 

 

   I hope someone can assist (or understand what I am looking for though J    )

 

 

Regards

Machiel

 

pgsql-novice by date:

Previous
From: "Danny Lo"
Date:
Subject: Re: Partitioning for query performance
Next
From: Ognjen Blagojevic
Date:
Subject: Re: Getting started