> Hi, > Any one can please help me out > > How to monitor the Hits on database and how many hits on each user tables > Through query. > Is there any other tools for that so it can full fill my requirement for it
There are some statistic per tables: .. select * from pg_stat_user_tables, indexes: select * from pg_stat_user_indexes, and databases: select * from pg_stat_database;