Associating client PIDs with backend PIDs - Mailing list pgsql-admin

From Rich Cullingford
Subject Associating client PIDs with backend PIDs
Date
Msg-id 3FC237EB.3050302@sysd.com
Whole thread Raw
List pgsql-admin
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@sysd.com


pgsql-admin by date:

Previous
From: William Yu
Date:
Subject: Re: WHAT IS THE ADVANTAGE
Next
From: "Anjan Dave"
Date:
Subject: Re: file too large, segmentation fault