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

Поиск
Список
Период
Сортировка
От nikhil raj
Тема Re: How to find the hits on the databases and tables in Postgres
Дата
Msg-id CAG1ps1zidpNEraUNyoQO--1XV6Nkfbrty22OiOaJuNtBEBf1Pw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to find the hits on the databases and tables in Postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to find the hits on the databases and tables in Postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: How to find the hits on the databases and tables in Postgres  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
Дерево обсуждения
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

Thanks,

On Fri, May 4, 2018 at 6:51 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: relkind='p' has no pg_stat_user_tables
Следующее
От: Ian Harding
Дата:
Сообщение: statement_timeout issue