How to determine number of established connections

Поиск
Список
Период
Сортировка
От Andrus
Тема How to determine number of established connections
Дата
Msg-id dtcutr$e0b$1@news.hub.org
обсуждение исходный текст
Ответы Re: How to determine number of established connections  (Michael Fuhr <mike@fuhr.org>)
Re: How to determine number of established connections  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general
Дерево обсуждения 
When connectiong to database my application needs to determine how many
connections is currently established to Postgres server.

Any idea which query I should use ?

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


Using Postgres 8.1

Andrus

В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: What is the syntax for setting a default date in PostgreSQL
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: How to determine number of established connections