Re: last analyze / vacuum

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: last analyze / vacuum
Date: 2008-02-04 22:28:34
Message-ID: 47A79192.9030808@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kevin Kempter wrote:
> Hi List;
>
> Is there a system catalog, or other means where I can find out the last time a
> table was analyzed and the last time a table was vacuumed?
>
Start with:
select * from pg_stat_all_tables;

Cheers,
Steve

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Verna Vergara 2008-02-05 00:55:58 Re: Postgres permission denied
Previous Message Kevin Kempter 2008-02-04 22:00:27 last analyze / vacuum