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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: nikhil raj <nikhilraj474(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)com, k(dot)knizhnik(at)postgrespro(dot)ru
Subject: Re: How to find the hits on the databases and tables in Postgres
Date: 2018-05-04 18:36:43
Message-ID: 395a6921-9440-5815-415e-fe4073990ef4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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  so that it
> would be so help full for me.
>
> now currently prepared a scripts for that which goes and does for DB
> butr after that i have much manually work with it so is there any third
> party tool for that

The best I can do is point you at:

https://www.postgresql.org/download/products/5-reporting-tools/

Others on the list may be able to provide more information.

>
> Thanks,
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Neuner 2018-05-04 20:03:52 Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN
Previous Message Adrian Klaver 2018-05-04 18:28:35 Re: statement_timeout issue