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.klaver@xxxxxxxxxxx
