Last autovacuum time - what is it?

Поиск
Список
Период
Сортировка
От Durumdara
Тема Last autovacuum time - what is it?
Дата
Msg-id CAEcMXhmjcb-w75u=DeBQTxc3m+4SCLCxhMHcM5nJZOSmvK+mrg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Last autovacuum time - what is it?
Список pgsql-general
Hello!

I need to ask about  last_autovacuum column  in pg_stat_all_tables.

I'm not sure is this a starting time, or when the daemon finished.

I make an "accident" with changing many rows in a huge table. 
I didn't want to start autovacuum with this operation.

They reported slowing, but I'm not sure this caused the problem or other thing.
This points to night, but I don't know is this the starting of the cleaning, or when the daemon finished, so how to calculate the daemon's working interval.

Thank you for your help!

Best regards
dd

last_autovacuumtimestamp with time zoneLast time at which this table was vacuumed by the autovacuum daemon

В списке pgsql-general по дате отправления:

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Re: CASE(?) to write in a different column based on a string pattern
Следующее
От: Tom Lane
Дата:
Сообщение: Re: terminated by signal 11: Segmentation fault