DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:cc:subject:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=sapyiHMT7/BAZNUCVWqoRA5LiSxC7dTEFJwLFNQi6TpHm2AIqIaP1lXBvn1FPSwY35
	xd94Fmx974gFvaul2Mhm9nXsf6artlpmipu50sJTpaEB+dHsETl7lRgQnUcVsaBN1UKM
	2bDgBjkAqtElz9G4t8zn+nx+n3BRUVSJukBGk=
Message-ID: <4cdd6266.08c08e0a.59ee.ffffe39b@mx.google.com>
Date: Fri, 12 Nov 2010 08:50:41 -0700
From: Joshua Tolley <eggyknap@gmail.com>
To: Bryce Nesbitt <bryce2@obviously.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: "slow lock" log in addition to
	log_min_duration_statement ?
References: <4CDB007E.7010904@obviously.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="3V7upXqbjpZ4EhLz"
Content-Disposition: inline
In-Reply-To: <4CDB007E.7010904@obviously.com>
User-Agent: Mutt/1.5.18 (2008-05-17)


--3V7upXqbjpZ4EhLz
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 10, 2010 at 12:28:46PM -0800, Bryce Nesbitt wrote:
> I have a cluster with log_min_duration_statement set to log slow =20
> queries. Presently what I'm tracking down is almost certainly a lock =20
> problem.  Is there any analog of log_min_duration_statement for locks?  =
=20
> If there is a lock on a certain critical tables for more than a few =20
> hundredths of a second I want to know.

You could try log_lock_waits:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html#=
GUC-LOG-LOCK-WAITS

It's defined in terms of deadlock_timeout, and reducing that to "a few
hundredths of a second" like you're interested in might cause all kinds of
load from the deadlock detector.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--3V7upXqbjpZ4EhLz
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkzdYlEACgkQRiRfCGf1UMOdGwCgr9nmq3OlWjFFyiem5TkRM5oH
CrIAn3g9SpF0kBjv7rH+kMDLxkPMB4c8
=OipI
-----END PGP SIGNATURE-----

--3V7upXqbjpZ4EhLz--