Last autovacuum time - what is it?

Started by Durumdaraover 6 years ago2 messagesgeneral
Jump to latest
#1Durumdara
durumdara@gmail.com

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_autovacuum timestamp with time zone Last time at which this table was
vacuumed by the autovacuum daemon

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Durumdara (#1)
Re: Last autovacuum time - what is it?

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