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 < [EMAIL PROTECTED] > wrote: From: Rich Cullingford [mailto: [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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> [EMAIL PROTECTED]<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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
