Re: display previous query string of idle-in-transaction - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: display previous query string of idle-in-transaction
Date
Msg-id 1238139418.16568.555.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: display previous query string of idle-in-transaction  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
Responses Re: display previous query string of idle-in-transaction
Re: display previous query string of idle-in-transaction
List pgsql-hackers
On Fri, 2009-03-27 at 15:44 +0900, Tatsuhito Kasahara wrote:
> Simon Riggs wrote:
> >> If we can also check previous query_string of idle-in-transaction,
> >> it is useful for analysis of long transaction problem.
> > 
> > I'm more interested in the problem itself. Why do you think there is a
> > problem and why does knowing this help you? I had similar problems
> > recently, so I'm interested in thoughts around this.
> In many case, applications don't know what queries they are doing.
> So, if a long transaction problem (unworking defragmnetation by HOT and
> VACUUM) occured, I don't understand which application is the cause with
> only "<IDLE> in transaction" message.
> 
> But if I can also check last query string, I guess which apllication
> do that and point out the problem point.
> # As I said, I think a long transaction is not a problem itself.
> 
> Does that answer your question ?

Not really. I want to understand the actual problem with
idle-in-transaction so we can consider all ways to solve it, rather than
just focus on one method.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Tatsuhito Kasahara
Date:
Subject: Re: display previous query string of idle-in-transaction
Next
From: Guillaume Smet
Date:
Subject: Re: display previous query string of idle-in-transaction