Re: Number of Connections ?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Number of Connections ?
Дата
Msg-id 200111281301.fASD1Ec04092@saturn.jw.home
обсуждение исходный текст
Ответ на Number of Connections ?  (Erwin Ambrosch <ambre@ebutec.com>)
Список pgsql-general
Erwin Ambrosch wrote:
> Hi,
>
> is there a query to ask my PostgeSql backend how much connections are
> currently open?

    New functionality in v7.2. Given your configuration starts at
    least  the  collector  daemon  (defaults  to   get   started,
    configuration is in postgres.conf), you can

        SELECT count(*) from pg_stat_activity;


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

Предыдущее
От: "Khan"
Дата:
Сообщение: PostgreSQL ODBC for Windows
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: [HACKERS] How to turn off TOAST on a table/column