Postgres Pro
Downloads
Home   >   mailing lists

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 1238091273.16568.530.camel@ebony.2ndQuadrant
Whole thread Raw
In response to 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  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
List pgsql-hackers
Tree view 
On Wed, 2009-03-25 at 18:08 +0900, Tatsuhito Kasahara 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.

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

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: tuplestore API problem
Next
From: Simon Riggs
Date:
Subject: maintenance_work_mem and autovacuum