Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine number of established connections - Mailing list pgsql-general

From A. Kretschmer
Subject Re: How to determine number of established connections
Date
Msg-id 20060220182412.GA27346@webserv.wug-glas.de
Whole thread Raw
In response to How to determine number of established connections  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
am  20.02.2006, um 19:39:55 +0200 mailte Andrus folgendes:
> When connectiong to database my application needs to determine how many
> connections is currently established to Postgres server.

select * from pg_stat_activity ;


> I can create temporary table at startup of each connection. But how to count
> the number of temporary tables created by all applications ?

Why do you need this information?


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: How to specify infinity for intervals ?
Next
From: "Andrus"
Date:
Subject: Re: How to determine number of established connections