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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: How to find the hits on the databases and tables in Postgres
Дата
Msg-id ac6119da-fe24-89ec-6683-3ade0b8ac46f@aklaver.com
обсуждение исходный текст
Ответ на How to find the hits on the databases and tables in Postgres  (nikhil raj <nikhilraj474@gmail.com>)
Ответы Re: How to find the hits on the databases and tables in Postgres  (nikhil raj <nikhilraj474@gmail.com>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Adrian Heath
Дата:
Сообщение: Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query planner riddle (array-related?)