Re: pg_stat_activity - proc id

From: Jov <zhao6014(at)gmail(dot)com>
To: "Rajagopalan, Jayashree" <Jayashree(dot)Rajagopalan(at)emc(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_stat_activity - proc id
Date: 2013-10-07 08:27:50
Message-ID: CADyrUxOxFPaRUh9sxwqbXhLLrEFyL8eJcOAMizuuu9Xtp4c4sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

we set the application_name to some unique id such as client process ID or
processid#threadid when client Start the new session.

jov
在 2013-10-7 上午10:39，"Rajagopalan, Jayashree" <Jayashree(dot)Rajagopalan(at)emc(dot)com
>写道：

> Hi:****
>
> ** **
>
> How to correlate the procpid in pg_stat activity table to any application
> process? I need to track down some connections to the queries/application
> threads. Please help!!****
>
> ** **
>
> Regards****
>
> Jayashree****
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Venakata Ramana 2013-10-07 12:03:13 Reg. Restore
Previous Message Sergey Konoplev 2013-10-07 05:18:26 Re: pg_stat_activity - proc id