Re: Latest connections

From: bricklen <bricklen(at)gmail(dot)com>
To: Karel Riverón Escobar <kre(at)uci(dot)cu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Latest connections
Date: 2014-03-16 19:00:35
Message-ID: CAGrpgQ-wL1b5wzHNpVsL4BpCoqr6uLgb43MCRhcjx7tAnxEG6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Mar 16, 2014 at 11:52 AM, Karel Riverón Escobar <kre(at)uci(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message desmodemone 2014-03-16 19:36:04 Re: Latest connections
Previous Message Karel Riverón Escobar 2014-03-16 18:52:24 Latest connections