Thread: Last autovacuum time - what is it?
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 |
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