| From: | Durumdara <durumdara(at)gmail(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Last autovacuum time - what is it? |
| Date: | 2019-11-13 17:57:36 |
| Message-ID: | CAEcMXhmjcb-w75u=DeBQTxc3m+4SCLCxhMHcM5nJZOSmvK+mrg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-11-13 18:57:33 | Re: terminated by signal 11: Segmentation fault |
| Previous Message | Moreno Andreo | 2019-11-13 17:03:37 | Re: CASE(?) to write in a different column based on a string pattern |