pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLatest connections
3+ messages / 3 participants
[nested] [flat]
* Latest connections
@ 2014-03-16 18:52 Karel Riverón Escobar <kre@uci.cu>
0 siblings, 1 reply; 3+ messages in thread
From: Karel Riverón Escobar @ 2014-03-16 18:52 UTC (permalink / raw)
To: pgsql-admin
Hi everyone,
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.
Thanks in advance.
Regards,
Karel Riverón
Software engeener
________________________________________________________________________________________________
I Conferencia Científica Internacional UCIENCIA 2014 en la UCI del 24 al 26 de abril de 2014, La Habana, Cuba. Ver http://uciencia.uci.cu
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Latest connections
@ 2014-03-16 19:00 bricklen <bricklen@gmail.com>
parent: Karel Riverón Escobar <kre@uci.cu>
0 siblings, 1 reply; 3+ messages in thread
From: bricklen @ 2014-03-16 19:00 UTC (permalink / raw)
To: Karel Riverón Escobar <kre@uci.cu>; +Cc: pgsql-admin
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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Latest connections
@ 2014-03-16 19:36 desmodemone <desmodemone@gmail.com>
parent: bricklen <bricklen@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: desmodemone @ 2014-03-16 19:36 UTC (permalink / raw)
To: bricklen <bricklen@gmail.com>; +Cc: Karel Riverón Escobar <kre@uci.cu>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-03-16 19:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-03-16 18:52 Latest connections Karel Riverón Escobar <kre@uci.cu>
2014-03-16 19:00 ` bricklen <bricklen@gmail.com>
2014-03-16 19:36 ` desmodemone <desmodemone@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox