Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find the hits on the databases and tables in Postgres - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to find the hits on the databases and tables in Postgres
Date
Msg-id ac6119da-fe24-89ec-6683-3ade0b8ac46f@aklaver.com
Whole thread Raw
In response to How to find the hits on the databases and tables in Postgres  (nikhil raj <nikhilraj474@gmail.com>)
Responses Re: How to find the hits on the databases and tables in Postgres
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Heath
Date:
Subject: Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
Next
From: Tom Lane
Date:
Subject: Re: Query planner riddle (array-related?)