| From: | Sergey Konoplev <gray(dot)ru(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 05:18:26 |
| Message-ID: | CAL_0b1tv+oBK+z-D0vDc49_Lmg4QsK3YdpASBeGGxCnP25UbiQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun, Oct 6, 2013 at 7:38 PM, Rajagopalan, Jayashree
<Jayashree(dot)Rajagopalan(at)emc(dot)com> wrote:
> 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!!
Note down the client_port from pg_stat_activity and run:
netstat -pnao | grep <client_port>
It should give you two lines one of which is the opposite side of the
connection. Look at the next to last column.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jov | 2013-10-07 08:27:50 | Re: pg_stat_activity - proc id |
| Previous Message | Rajagopalan, Jayashree | 2013-10-07 02:38:09 | pg_stat_activity - proc id |