Re: Associating client PIDs with backend PIDs

I use a separate command like lsof to map processes to tcp/unix ports on the client and server machines.

--- On Mon 11/24, Rich Cullingford < rculling(at)sysd(dot)com > wrote:
From: Rich Cullingford [mailto: rculling(at)sysd(dot)com]
To: pgsql-admin(at)postgresql(dot)org
Date: Mon, 24 Nov 2003 11:55:07 -0500
Subject: [ADMIN] Associating client PIDs with backend PIDs

All,<br>This is a pretty obvious question, but I can't find an answer in the <br>standard docs/archive: if I have an installation in which there are a <br>number of long-running client processes interacting (one-on-one) with <br>backend processes, how do I find the associations? I can see the client <br>PIDs in an appropriate 'ps' (grepping on the client program name, for <br>example), and the backend PIDs in the standard queries or pgmonitor. But <br>I can't tell which goes with which (except by trying to infer the <br>association by looking at the query that's running -- assuming I can <br>catch it).<br><br> Thanks for any help,<br> Rich Cullingford<br> rculling(at)sysd(dot)com<br><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 8: explain analyze is your friend<br>

_______________________________________________
No banners. No pop-ups. No kidding.
Introducing My Way - http://www.myway.com