On 05/04/2018 04:44 AM, nikhil raj 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 .
https://www.postgresql.org/docs/10/static/monitoring-stats.html
https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-DATABASE-VIEW
https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-DATABASE-VIEW
pg_stat_user_tables Same as pg_stat_all_tables, except that only user
tables are shown.
>
> Thanks,
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com