Re: when a table was last vacuumed

--- On Wed, 10/2/10, AI Rumman <rummandba@gmail.com> wrote:

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

Try:

select pg_stat_get_last_vacuum_time(oid) from "pg_catalog".pg_class where relname = 'tablename';

select pg_stat_get_last_autovacuum_time(oid) from "pg_catalog".pg_class where relname = 'tablename';