Re: when a table was last vacuumed

[AI Rumman <rummandba@xxxxxxxxx>]

But I am using Postgresql 8.1 and here no clumn named last_vacuum.

On Wed, Feb 10, 2010 at 4:12 PM, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:

Le 10/02/2010 10:48, AI Rumman a écrit :

> If it possible to find out when a table was last vacuumed?
>

SELECT schemaname, relname, last_vacuum, last_autovacuum
FROM pg_stat_all_tables;


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com