Hello,
I want to see when autovacuum start in the log.
Due to some reasons we need to see when autovaccum starts and end.
1) Is there any easy way to enable any logging switch and it would go to
log? I tired it but could not see anything in log(auto vacuum was running
and completing)
2) If option one is not possible then can I write a trigger on
pg_stat_user_tables? and push something in log in that trigger when
last_autovacuum changes?
- Farrukh Usman
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Autovacuum-tp4754835p4754835.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.