X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7C12530E75E for ; Tue, 10 Jun 2003 05:36:50 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 32662-05 for ; Tue, 10 Jun 2003 02:36:39 -0300 (ADT) Received: from ll.mit.edu (LLMAIL.LL.MIT.EDU [129.55.12.40]) by svr1.postgresql.org (Postfix) with ESMTP id E8E8630FDF3 for ; Mon, 9 Jun 2003 19:21:26 +0000 (GMT) Received: (from smtp@localhost) by ll.mit.edu (8.12.9/8.8.8) id h59JLOtZ003708 for ; Mon, 9 Jun 2003 15:21:24 -0400 (EDT) Received: from sty.llan.ll.mit.edu( ), claiming to be "sty.llan" via SMTP by llpost, id smtpdAAA15aiQg; Mon Jun 9 15:21:12 2003 Date: Mon, 9 Jun 2003 15:21:12 -0400 From: george young To: pgsql-sql@postgresql.org Subject: find open transactions/locks in 7.2? Message-Id: <20030609152112.0cf0e5e3.gry@ll.mit.edu> Reply-To: gry@ll.mit.edu Organization: MIT Lincoln Laboratory X-Mailer: Sylpheed version 0.9.0 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200306/75 X-Sequence-Number: 13833 [select version() --> PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 3.0.4] I'm getting hangups every day or so, I presume due to some open transaction that insert/update/delete'ed on a table that is used by my main app without a commit. Is there some way (in 7.2!) to find who's locking what or who has a transaction open? -- George -- I cannot think why the whole bed of the ocean is not one solid mass of oysters, so prolific they seem. Ah, I am wandering! Strange how the brain controls the brain! -- Sherlock Holmes in "The Dying Detective"