Re: Latest connections

Поиск
Список
Период
Сортировка
От desmodemone
Тема Re: Latest connections
Дата
Msg-id CAEs9oF=V2ygSTaR9JqczkA_JJQpfVr2hx49V_ok7pG5ho_edOg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Latest connections  (bricklen <bricklen@gmail.com>)
Список pgsql-admin
Дерево обсуждения



2014-03-16 20:00 GMT+01:00 bricklen <bricklen@gmail.com>:
On Sun, Mar 16, 2014 at 11:52 AM, Karel Riverón Escobar <kre@uci.cu> wrote:
I'm kind of new in PostgreSQL administration and I need to know how to get latest connections to my PostgreSQL Server. I don't really know  if something like that is possible, but I wanna know if all my databases are really being used, because I have many of them.

From within the cluster, you can see connection and query times from the pg_stat_activity view. See http://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW


+1 for pg_stat_activity view

Moreover it's better you enable to logging of connection in postgresql.conf to log who is connecting to your database , so you could trace some days.
See at parameters of postgresql.conf   "log_connections" and "log_line_prefix" , after change them, remember to do a reload with pg_ctl .

Mat Dba

В списке pgsql-admin по дате отправления:

Предыдущее
От: bricklen
Дата:
Сообщение: Re: Latest connections
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Safe way to check for PostgreSQL replication delay/lag