Обсуждение: Last autovacuum time - what is it?

Поиск

Список

Период

Сортировка

Last autovacuum time - what is it?

От

Durumdara

Дата:

13 ноября 2019 г., 17:57:36

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

last_autovacuum timestamp with time zone Last time at which this table was vacuumed by the autovacuum daemon

Re: Last autovacuum time - what is it?

От

Tom Lane

Дата:

13 ноября 2019 г., 19:16:30

Durumdara <durumdara@gmail.com> writes:
> 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.

Looks like it's the time that the vacuum operation finished.

            regards, tom lane

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Last autovacuum time - what is it?

Last autovacuum time - what is it?

Re: Last autovacuum time - what is it?