pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How many connections are in use?
2+ messages / 2 participants
[nested] [flat]

* How many connections are in use?
@ 2007-11-02 07:02  Campbell, Lance <lance@uiuc.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Campbell, Lance @ 2007-11-02 07:02 UTC (permalink / raw)
  To: pgsql-admin

PostgreSQL: 8.2.4

OS: Linux Enterprise 4

 

Is there a way to log into PostgreSQL and determine how many database
connections are in use?  I know how many I have allocated in the
postgresql.conf file.  I would think there is some command in SQL or
command line parameter that would tell me how many connections are
currently being used.

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: How many connections are in use?
@ 2007-11-02 08:42  Rodrigo De León <rdeleonp@gmail.com>
  parent: Campbell, Lance <lance@uiuc.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Rodrigo De León @ 2007-11-02 08:42 UTC (permalink / raw)
  To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-admin

On 11/2/07, Campbell, Lance <lance@uiuc.edu> wrote:
> Is there a way to log into PostgreSQL and determine how many database
> connections are in use?

Use pg_stat_activity.

See:
http://www.postgresql.org/docs/8.2/static/monitoring-stats.html#MONITORING-STATS-VIEWS



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-11-02 08:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-02 07:02 How many connections are in use? Campbell, Lance <lance@uiuc.edu>
2007-11-02 08:42 ` Rodrigo De León <rdeleonp@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