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@sysd.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend