[ADMIN] pg_stat_activity - proc id

2013-10-06 Thread Rajagopalan, Jayashree
Hi: 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!! Regards Jayashree

Re: [ADMIN] pg_stat_activity - proc id

2013-10-06 Thread Sergey Konoplev
On Sun, Oct 6, 2013 at 7:38 PM, Rajagopalan, Jayashree 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: