Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 07E6E64FCBF for ; Tue, 16 Dec 2008 15:34:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91344-04 for ; Tue, 16 Dec 2008 15:34:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f10.google.com (mail-gx0-f10.google.com [209.85.217.10]) by mail.postgresql.org (Postfix) with ESMTP id 241A164FC2D for ; Tue, 16 Dec 2008 15:34:36 -0400 (AST) Received: by gxk3 with SMTP id 3so29369gxk.19 for ; Tue, 16 Dec 2008 11:34:35 -0800 (PST) Received: by 10.150.202.9 with SMTP id z9mr15246232ybf.199.1229455921322; Tue, 16 Dec 2008 11:32:01 -0800 (PST) Received: by 10.151.153.17 with HTTP; Tue, 16 Dec 2008 11:32:01 -0800 (PST) Message-ID: <3073cc9b0812161132w3ae157a8n69e2b0cccea05ca2@mail.gmail.com> Date: Tue, 16 Dec 2008 14:32:01 -0500 From: "Jaime Casanova" To: "psql performance list" Subject: measure database contention MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/157 X-Sequence-Number: 32193 Hi, we have a some bad queries (developers are working on that), some of them run in 17 secs and that is the average but when analyzing logs i found that from time to time some of them took upto 3 mins (the same query that normally runs in 17secs). so my question is: how could i look for contention problems? --=20 Atentamente, Jaime Casanova Soporte y capacitaci=F3n de PostgreSQL Asesor=EDa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157