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