Re: identify database process given client process - Mailing list pgsql-general

From Joey K.
Subject Re: identify database process given client process
Date
Msg-id 467669b30803171153o688dcc8ag84bd224efc47324@mail.gmail.com
Whole thread Raw
In response to identify database process given client process  (hogcia <hogcia@gmail.com>)
Responses Re: identify database process given client process  (Shane Ambler <pgsql@Sheeky.Biz>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fragments in tsearch2 headline
Next
From: Bob Pawley
Date:
Subject: Re: Updating