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