Re: when a table was last vacuumed

From: AI Rumman <rummandba(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: when a table was last vacuumed
Date: 2010-02-10 10:23:27
Message-ID: 2a7905441002100223p662805c0s1d6beb4beb81a655@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
<guillaume(at)lelarge(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2010-02-10 10:30:20 Re: when a table was last vacuumed
Previous Message Anton Maksimenkov 2010-02-10 10:13:58 Re: Memory Usage and OpenBSD