Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1DC6E63FED7 for ; Thu, 26 Mar 2009 15:14:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 99080-02-7 for ; Thu, 26 Mar 2009 15:14:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137146.authsmtp.com (outmail137146.authsmtp.com [62.13.137.146]) by mail.postgresql.org (Postfix) with ESMTP id 190F7634313 for ; Thu, 26 Mar 2009 15:14:04 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2QIDw0n095672; Thu, 26 Mar 2009 18:13:58 GMT Received: from [192.168.0.4] (85-211-223-92.dyn.gotadsl.co.uk [85.211.223.92]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2QIDva4055624; Thu, 26 Mar 2009 18:13:57 GMT Subject: Re: display previous query string of idle-in-transaction From: Simon Riggs To: Tatsuhito Kasahara Cc: pgsql-hackers@postgresql.org In-Reply-To: <49C9F49B.8020003@oss.ntt.co.jp> References: <49C9F49B.8020003@oss.ntt.co.jp> Content-Type: text/plain Date: Thu, 26 Mar 2009 18:14:33 +0000 Message-Id: <1238091273.16568.530.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: dfe523cf-1a31-11de-8156-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagNbYFhD HGQLW11EUVV7WGB/ bg0fZQBDYEtPQQdo U1ZAQE1QEQdtHhxP WBx/K200JgFGfXt2 Z0IsV3dfEhAsIEN/ QR0CCGxXZmZ9aWFL BV1QdgZSbQNKfx5N bwR8U3ReMCtlM3Bw LC8aFBMcBw5qYChU WRkJJENaWVwGAD87 WgtKBCgiB1xNXDkp LhopYlkSVEcdNkh3 MF1kRUgRNQQbARFf GEcl X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/1055 X-Sequence-Number: 135733 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.com PostgreSQL Training, Services and Support