Home > mailing lists

Re: pg_stat_activity - proc id - Mailing list pgsql-admin

From	Jov
Subject	Re: pg_stat_activity - proc id
Date	October 7, 2013 11:27:56
Msg-id	CADyrUxOxFPaRUh9sxwqbXhLLrEFyL8eJcOAMizuuu9Xtp4c4sQ@mail.gmail.com Whole thread Raw
In response to	pg_stat_activity - proc id ("Rajagopalan, Jayashree" <Jayashree.Rajagopalan@emc.com>)
List	pgsql-admin

Tree view

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@emc.com>写道：

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

pgsql-admin by date:

From: Sergey Konoplev
Date: 07 October 2013, 08:18:53
Subject: Re: pg_stat_activity - proc id

From: Venakata Ramana
Date: 07 October 2013, 19:58:29
Subject: Reg. Restore

Re: pg_stat_activity - proc id - Mailing list pgsql-admin

Previous

Next