SEO

#1 (**permalink**) 04-10-2008, 08:17 AM

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

#2 (**permalink**) 04-10-2008, 08:17 AM

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/s...NG-STATS-VIEWS

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How many connections are in use?