Re: when a table was last vacuumed - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: when a table was last vacuumed
Date
Msg-id 4B7286A0.1010908@lelarge.info
Whole thread Raw
In response to when a table was last vacuumed  (AI Rumman <rummandba@gmail.com>)
Responses Re: when a table was last vacuumed
List pgsql-general
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

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: logging statements from hibernate to valid SQL
Next
From: Anton Maksimenkov
Date:
Subject: Re: Memory Usage and OpenBSD