>How to monitor the Hits on database and how many hits on each user tables
> Through query.
*Do these help? You can run them through a cron job.*
*-- For all databases*
*SELECT pg_stat_database.datname,pg_stat_database.blks_read,
pg_stat_database.blks_hit,round((pg
2018-05-05 13:03 GMT+02:00 PT :
> On Fri, 4 May 2018 17:14:39 +0530
> 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 r
On Fri, 4 May 2018 17:14:39 +0530
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
pgBadger has always been my go
nikhil raj schrieb am 04.05.2018 um 18:45:
But here is the issue is here we have 200+ databases and 5 servers so
cannot manually runs this command all ways is there any 3rd party
tool for that which would give me the hits on DB and tables in it so
that it would be so help full for me.
now curre
On 05/04/2018 09:45 AM, nikhil raj wrote:
Hi Adrian Klaver,
Thanks for the fast response .
But here is the issue is here we have 200+ databases and 5 servers so
cannot manually runs this command all ways is there any 3rd party tool
for that which would give me the hits on DB and tables in it
Hi Adrian Klaver,
Thanks for the fast response .
But here is the issue is here we have 200+ databases and 5 servers so
cannot manually runs this command all ways is there any 3rd party tool for
that which would give me the hits on DB and tables in it so that it would
be so help full for me.
now
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/monit
