Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 35EC69FA2D2 for ; Mon, 30 Jul 2007 13:37:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 00419-05 for ; Mon, 30 Jul 2007 13:37:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.190]) by postgresql.org (Postfix) with ESMTP id 70C3B9FA24D for ; Mon, 30 Jul 2007 13:37:12 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id i10so2353691mue for ; Mon, 30 Jul 2007 09:37:08 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition:x-google-sender-auth; b=eGvIy10QFtCMz7WZxR+Gw1O4tqh4j4FOELxknV4PjALGmnRxAINdj/yHczzrdXaQAhCnX7zJZ686tAhbedrPAyrFjkIj8cFLjHwXbdroo6LvWDu+EQlaRc+XO8jiPvP8TRivHb78MCa92W7Ki+ErJ92WW1Dcwj/EvX5UbDz6/zY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition:x-google-sender-auth; b=ZM9XVbM1Kv9Cw0caJ3zHi5tD6Km3lduP+e6UStORDz8kQ0R7RGPiBIWrxi0TB5sob+FyJkm1hzFxRNYvgMhLmzibmTJYH/Qv8j1KBBRCEVpJ4F3SKuVOW/7SJIJ7d3uughHfSrRc7WpgEkqcEruUaG0RSuCkxhDMy+vvRuALwpQ= Received: by 10.82.126.5 with SMTP id y5mr4489757buc.1185811871075; Mon, 30 Jul 2007 09:11:11 -0700 (PDT) Received: by 10.82.151.16 with HTTP; Mon, 30 Jul 2007 09:11:11 -0700 (PDT) Message-ID: <32c009ea0707300911h74f588f6se7d03f5f28d598e5@mail.gmail.com> Date: Mon, 30 Jul 2007 19:11:11 +0300 From: "Milen A. Radev" To: pgsql-admin@postgresql.org Subject: Lock Statistics MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Google-Sender-Auth: da684072a5e307be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/334 X-Sequence-Number: 26315 I have performance problems with a DB (slow queries) and I suspect the main cause is that a lot of queries wait for a lock on one small table. That's why I need some stats about the number and (average) wait-time for locks (even only for this particular table). After a bit of googling I found a project in PgFoundry with a promising description - http://pgfoundry.org/projects/pglockdiag/. Unfortunately the projects seems stillborn - no published files and nothing in CVS. -- Milen A. Radev