Thread: last analyze / vacuum

last analyze / vacuum

From
Kevin Kempter
Date:
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?


Thanks in advance,


/Kevin

Re: last analyze / vacuum

From
Steve Crawford
Date:
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