Re: Date last vacuum

From: Michael Crozier <crozierm(at)conducivetech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Date last vacuum
Date: 2006-02-15 19:04:55
Message-ID: Pine.GSO.4.10.10602151100240.590-100000@sss.sight-n-sound.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Is there a way do discover when was the last time a table or database vacuumed?

No, but you might look at the contrib pgstattuple function. The function
will give detailed information on the state of the table on disk.

michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nikola Ivanov 2006-02-15 19:33:29 Re: Postgres using 100% CPU
Previous Message rob 2006-02-15 18:10:29 Dynamic datalogging function/scheme