we set the application_name to some unique id such as client process ID or processid#threadid when client Start the new session.
jov
在 2013-10-7 上午10:39,"Rajagopalan, Jayashree" <Jayashree.Rajagopalan@xxxxxxx>写道:
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