Postgres Pro
Downloads
Home   >   mailing lists

Re: Latest connections - Mailing list pgsql-admin

From bricklen
Subject Re: Latest connections
Date
Msg-id CAGrpgQ-wL1b5wzHNpVsL4BpCoqr6uLgb43MCRhcjx7tAnxEG6g@mail.gmail.com
Whole thread Raw
In response to Latest connections  (Karel Riverón Escobar <kre@uci.cu>)
Responses Re: Latest connections  (desmodemone <desmodemone@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Karel Riverón Escobar
Date:
Subject: Latest connections
Next
From: desmodemone
Date:
Subject: Re: Latest connections