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 C44BD9F9398 for ; Wed, 24 May 2006 18:34:11 -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 42059-04-3 for ; Wed, 24 May 2006 18:33:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A0A1B9FA3AD for ; Wed, 24 May 2006 18:33:56 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 6A7B656431; Wed, 24 May 2006 16:33:55 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 24 May 2006 16:33:53 -0500 Date: Wed, 24 May 2006 16:33:53 -0500 From: "Jim C. Nasby" To: Robin Ericsson Cc: Dan Gorman , pgsql-performance@postgresql.org Subject: Re: Selects query stats? Message-ID: <20060524213352.GN59464@pervasive.com> References: <9C4E40CF-6C06-4297-AF32-A7EF2A3F3C0F@hi5.com> <4473512E.7020805@ca.sophos.com> <82252882-2A15-4823-A517-7AB3161889D1@hi5.com> <4473553C.1010804@ca.sophos.com> <127D68F6-7620-4A62-8D1A-9B475E7571CD@hi5.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060524:lobbin@gmail.com::eGIZIcesqs0wgw6x:06bwP X-Hashcash: 1:20:060524:dgorman@hi5.com::v0wiC8vauIMRbtyW:0087B/ X-Hashcash: 1:20:060524:pgsql-performance@postgresql.org::ZYoYtSlXRNrkCYsR:00000 0000000000000000000000000WOa X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/458 X-Sequence-Number: 19245 On Wed, May 24, 2006 at 12:27:41PM +0200, Robin Ericsson wrote: > On 5/23/06, Dan Gorman wrote: > > > >In any other DB (oracle, mysql) I know how many queries (selects) per > >second > >the database is executing. How do I get this > >number out of postgres? > > Mysql does AFAIR only count the number of queries and then uses the > "seconds since startup" to estimate the number of queries per second. > If your server is hammered with queries 1 hour a day it's not giving > you a fair result. Somehow that doesn't surprise me... In any case, if we at least provide a raw counter, it's not that hard to turn that into selects per second over some period of time. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461