2018-05-05 13:03 GMT+02:00 PT <wmoran@xxxxxxxxxxxxxxxxx>:
On Fri, 4 May 2018 17:14:39 +0530
nikhil raj <nikhilraj474@xxxxxxxxx> wrote:
> 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
pgBadger has always been my goto tool for that: https://github.com/dalibo/pgbadger
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;
Regards
Pavel
--
Bill Moran <wmoran@xxxxxxxxxxxxxxxxx>
