Re: identify database process given client process

On Mon, Mar 17, 2008 at 6:58 AM, hogcia <hogcia(at)gmail(dot)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