X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 89FDE9FA279 for ; Tue, 23 May 2006 15:25:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 23031-07 for ; Tue, 23 May 2006 15:25:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp1.ActiveState.com (gw.activestate.com [209.17.183.249]) by postgresql.org (Postfix) with ESMTP id 0BBEB9FA169 for ; Tue, 23 May 2006 15:25:07 -0300 (ADT) Received: from smtp3.activestate.com (smtp3.activestate.com [192.168.3.19]) by smtp1.ActiveState.com (8.12.10/8.12.10) with ESMTP id k4NIP5hI002740 for ; Tue, 23 May 2006 11:25:05 -0700 (envelope-from mischa@ca.sophos.com) Received: from [192.168.99.210] (mallet.activestate.com [192.168.99.210]) by smtp3.ActiveState.com (8.13.4/8.13.4) with ESMTP id k4NIP5Qb006038 for ; Tue, 23 May 2006 11:25:05 -0700 (envelope-from mischa@ca.sophos.com) Message-ID: <4473553C.1010804@ca.sophos.com> Date: Tue, 23 May 2006 11:32:28 -0700 From: Mischa Sandberg Reply-To: mischa@ca.sophos.com User-Agent: Thunderbird 1.5.0.2 (X11/20060420) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Selects query stats? References: <9C4E40CF-6C06-4297-AF32-A7EF2A3F3C0F@hi5.com> <4473512E.7020805@ca.sophos.com> <82252882-2A15-4823-A517-7AB3161889D1@hi5.com> In-Reply-To: <82252882-2A15-4823-A517-7AB3161889D1@hi5.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/432 X-Sequence-Number: 19219 Dan Gorman wrote: > What I am looking for is that our DB is doing X selects a min. What specifically would you like to measure? Duration for specific queries? Queries in an app for which you have no source? There may be a way to get what you want by other means ... Details? I gather you cannot just time the app that's doing the selects, nor extract those selects and run them via psql and time them on their own? >> Dan Gorman wrote: >>> All, >>> I might be completely crazy here, but it seems every other database >>> exposes select query stats. Postgres only exposes >>> updates/deletes/inserts. Is there something I am missing here?