I am using aurora-postgresql version 9.6.8. and I have one main instance , one writer and one reader replica.
I am looking for below information:
- How I can check on a particular instance when autovacuum was executed when I am trying to use "pg_stat_user_tables" this show lot of dead tuple. But when we see max last autovacuum executed date its one month back. Seems like autovacuum not executed from last one month on any of the table. In my environment we have huge insert update and delete every day.
Thank you in advance for any suggestion!!!
Below is my auto vacuum configuration:
name setting autovacuum_analyze_scale_factor 0.05