Postgres Pro
Downloads
Home   >   mailing lists

Last autovacuum time - what is it? - Mailing list pgsql-general

From Durumdara
Subject Last autovacuum time - what is it?
Date
Msg-id CAEcMXhmjcb-w75u=DeBQTxc3m+4SCLCxhMHcM5nJZOSmvK+mrg@mail.gmail.com
Whole thread Raw
Responses Re: Last autovacuum time - what is it?
List pgsql-general
Tree view
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 by date:

Previous
From: Moreno Andreo
Date:
Subject: Re: CASE(?) to write in a different column based on a string pattern
Next
From: Tom Lane
Date:
Subject: Re: terminated by signal 11: Segmentation fault