Re: when a table was last vacuumed

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: when a table was last vacuumed
Date: 2010-02-10 10:12:48
Message-ID: 4B7286A0.1010908@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anton Maksimenkov 2010-02-10 10:13:58 Re: Memory Usage and OpenBSD
Previous Message Davor J. 2010-02-10 09:55:34 Re: One column to multiple columns based on constraints?