Re: How to find the hits on the databases and tables in Postgres

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@aklaver.com