Skip site navigation (1) Skip section navigation (2)

Autvacuum and Analyze stats?

From: "Machiel Richards" <machielr(at)rdc(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Autvacuum and Analyze stats?
Date: 2010-04-13 10:03:26
Message-ID: 011d01cadaf0$91bd9f10$b538dd30$ (view raw, whole thread or download thread mbox)
Lists: 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







pgsql-novice by date

Next:From: Ognjen BlagojevicDate: 2010-04-13 10:16:59
Subject: Re: Getting started
Previous:From: Danny LoDate: 2010-04-13 08:44:39
Subject: Re: Partitioning for query performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group