Обсуждение: last analyze / vacuum

Поиск
Список
Период
Сортировка

last analyze / vacuum

От
Kevin Kempter
Дата:
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

От
Steve Crawford
Дата:
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