Re: identify database process given client process

Поиск
Список
Период
Сортировка
От Joey K.
Тема Re: identify database process given client process
Дата
Msg-id 467669b30803171153o688dcc8ag84bd224efc47324@mail.gmail.com
обсуждение исходный текст
Ответ на identify database process given client process  (hogcia <hogcia@gmail.com>)
Ответы Re: identify database process given client process
Список pgsql-general


On Mon, Mar 17, 2008 at 6:58 AM, hogcia <hogcia@gmail.com> wrote:
Hi,
I have to find a Postgres database process pid (or other
identification) for a given client process pid. Or client processes
for a database process. How are they connected? I was suggested maybe
netstat could give me the answer and I think those are two pf_unix
processes. But maybe there are some PostgreSQL functions that do this?
How should I approach this topic?
Thanks in advance,

Try

select pg_stat_activity;


Joey

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Fragments in tsearch2 headline
Следующее
От: Bob Pawley
Дата:
Сообщение: Re: Updating