I recall reading posts in the past where one could query the stat tables and see how well autovacuum was performing. Not finding the posts.
I found this query: SELECT relname, relkind, reltuples, relpages FROM pg_class where relkind = 'r';
From the output how can I tell the number of dead tuples? Or how effective autovacuum is in the particular table..
Recently inheritted several large Postgresql DBs (tables in the hundreds of millions and some tables over a billion rows) and I am just starting to go over them and see how autovacuum has been performing.