> SELECT application_name, client_addr, client_hostname, client_port
> FROM pg_stat_activity
> WHERE procpid = 14740;
> (Replace 14740 of the process ID of the "idle in transaction" backend).
> Look on the client machine and find the process that holds TCP port
> "client_port" open (on Linux you can use "lsof" for that).
Ours is a web-based application and all calls are made "only" from where the
web server is running. No external calls are allowed in my case. Hence,
the "only" client machine in my case is the web server.
In response to
pgsql-admin by date
|Next:||From: Albe Laurenz||Date: 2012-05-04 11:08:18|
|Subject: Re: Very long "<IDLE> in transaction" query|
|Previous:||From: Kevin Grittner||Date: 2012-05-03 17:54:25|
|Subject: Re: DELETE and UPDATE triggers on parent table of
partioned table not firing.|