Re: Associating client PIDs with backend PIDs

Rich Cullingford wrote:

> 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).

if your client uses libpq, you could use

PQbackendPID Returns the process ID of the backend server handling this
connection.

int PQbackendPID(const PGconn *conn);

to save the backend's pid to a known file after you connected

/Björn

>
> Thanks for any help,
> Rich Cullingford
> rculling(at)sysd(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend