But, I am looking for some thing which gives me the list of tables.
For example here is the scenario:
When you run the query once a day
select datname, age(datfrozenxid) from pg_database;
If you find the datfrozenxid is increasing then it means the auto vacuuming process is lagging behind. This will cause a transaction xid wrap around soon and will result in force shut down of the postgres.
So, When i find the age of the datfrozenxid is increasing I want to check the tables and manually vacuum the tables.