Search Postgresql Archives

Last autovacuum time - what is it?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux