Re: any way to query for current connections to db?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: any way to query for current connections to db?
Дата
Msg-id 200711092257.lA9Mven21892@momjian.us
обсуждение исходный текст
Ответ на Re: any way to query for current connections to db?  ("Jeff Larsen" <jlar310@gmail.com>)
Ответы Re: any way to query for current connections to db?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
Jeff Larsen wrote:
> > Is there any way to query the database to identify what the current
> > connections are (connections, sessions, or whatever you want to call them)?
>
> select * from pg_stat_activity;

Is this an FAQ?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: "Jeff Larsen"
Дата:
Сообщение: Re: any way to query for current connections to db?
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: any way to query for current connections to db?