On Sun, Oct 6, 2013 at 7:38 PM, Rajagopalan, Jayashree <jayashree.rajagopa...@emc.com> wrote: > How to correlate the procpid in pg_stat activity table to any application > process? I need to track down some connections to the queries/application > threads. Please help!!
Note down the client_port from pg_stat_activity and run: netstat -pnao | grep <client_port> It should give you two lines one of which is the opposite side of the connection. Look at the next to last column. -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 gray...@gmail.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin