Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4488F1336B42 for ; Wed, 10 Nov 2010 16:46:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 80118-02 for ; Wed, 10 Nov 2010 20:46:07 +0000 (UTC) X-Greylist: delayed 00:17:18.24177 by SQLgrey-1.7.6 Received: from out-0.mx.aerioconnect.net (out-0-22.mx.aerioconnect.net [216.240.47.82]) by mail.postgresql.org (Postfix) with ESMTP id DAF98133616B for ; Wed, 10 Nov 2010 16:46:06 -0400 (AST) Received: from idiom.com (postfix@mx0.idiom.com [216.240.32.160]) by out-0.mx.aerioconnect.net (8.13.8/8.13.8) with ESMTP id oAAKSljF021219 for ; Wed, 10 Nov 2010 12:28:47 -0800 X-Client-Authorized: MaGic Cook1e Received: from [192.168.1.178] (75-149-45-155-SFBA.hfc.comcastbusiness.net [75.149.45.155]) by idiom.com (Postfix) with ESMTP id 65DD92D601A for ; Wed, 10 Nov 2010 12:28:46 -0800 (PST) Message-ID: <4CDB007E.7010904@obviously.com> Date: Wed, 10 Nov 2010 12:28:46 -0800 From: Bryce Nesbitt User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.15) Gecko/20101027 SeaMonkey/2.0.10 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: "slow lock" log in addition to log_min_duration_statement ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.67 on 216.240.47.51 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201011/15 X-Sequence-Number: 34753 I have a cluster with log_min_duration_statement set to log slow queries. Presently what I'm tracking down is almost certainly a lock problem. Is there any analog of log_min_duration_statement for locks? If there is a lock on a certain critical tables for more than a few hundredths of a second I want to know. Similarly in pg_stat_activity, is there a way to get the parameters to the current_query? I see the placeholders (e.g. $1, $2) but not the data. This is with PostgreSQL 8.3.4 Thanks!