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 <guilla...@lelarge.info>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 >