--- On Wed, 10/2/10, AI Rumman <[email protected]> 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';




-- 
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to