Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id E2D5B1337B53
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  3 Jan 2011 02:58:10 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 94378-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  3 Jan 2011 06:58:04 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id 5087C133655C
	for <pgsql-admin@postgresql.org>; Mon,  3 Jan 2011 02:58:03 -0400 (AST)
Received: by fxm20 with SMTP id 20so12989169fxm.19
	for <pgsql-admin@postgresql.org>; Sun, 02 Jan 2011 22:58:02 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:mime-version:received:from:date
	:message-id:subject:to:content-type;
	bh=csI1/0s2QV9gLV/oYFVJEtoZFMUHP78tF1Ue2jwd0No=;
	b=OLNMM9/qGtf++E2GOwRNp05dkjQfOZbGsk6pLbk2gdcdUs1F/YUUgXF4TQvfy6PCW4
	8FKodh7uHfYUdQ4ZRdtk6Mndhs0G+jzUpvrLogBPhxwYQ5IySqzJwW2AGtact3JpVSMF
	6huIKQVcDc6TZFmqzlZ9ZaRiLJmx6j6eKLYqc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:from:date:message-id:subject:to:content-type;
	b=kildUqc3rjLRCdbxCaswLVQIpfDzwbUNf7mMlRWvpSM3u/Q4jtp6HX/T49z/loQQNy
	YOrU3dWPXhi2Yv1NrAzzMcZBIUHP14zJcbScmwQvxaV782mTc22O528CFweo9V4BsLWK
	QjoXFyQ2d91GAJux78d0OUB28CLtCMisWizr4=
Received: by 10.223.103.12 with SMTP id i12mr561237fao.43.1294037882229; Sun,
	02 Jan 2011 22:58:02 -0800 (PST)
MIME-Version: 1.0
Received: by 10.223.119.211 with HTTP; Sun, 2 Jan 2011 22:57:42 -0800 (PST)
From: sharilalipv <sharilalipv@gmail.com>
Date: Mon, 3 Jan 2011 01:57:42 -0500
Message-ID: <AANLkTimHfd5kKanx3O=74DvO2e9GzGMT04Af1CDCSzhr@mail.gmail.com>
Subject: hanging query
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=20cf3054a5474bf7b20498ebac6e
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.587 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_LOW=-0.7, RFC_ABUSE_POST=0.001,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201101/1
X-Sequence-Number: 36441

--20cf3054a5474bf7b20498ebac6e
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

How can we find hanging query in postgresql?

Thanks in Advance
Sharil

--20cf3054a5474bf7b20498ebac6e
Content-Type: text/html; charset=ISO-8859-1

Hi All,<br><br>How can we find hanging query in postgresql?<br clear="all"><br>Thanks in Advance<br>Sharil<br><br>

--20cf3054a5474bf7b20498ebac6e--