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 292B69FA42B for ; Wed, 24 May 2006 07:27:53 -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 50592-08 for ; Wed, 24 May 2006 07:27:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id 44F079FA2DB for ; Wed, 24 May 2006 07:27:42 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 18so1525468nzp for ; Wed, 24 May 2006 03:27:42 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=c8rVjWsDZslxfpqlPbU+tLmG0TkaZg/0VyIaLa7Vr4r0+fBbO/HggJykAag1Kx3MnrpojRQJLym3Yu4hYwCFAxHuc4y0ZzwRm6BB0lQbmWVA55hek4jsvePsLfJUw/iNFVClampnLLzW26GAHRD2dWUBgF4H78HsCGFA08IX9kI= Received: by 10.64.152.2 with SMTP id z2mr2802248qbd; Wed, 24 May 2006 03:27:42 -0700 (PDT) Received: by 10.65.216.18 with HTTP; Wed, 24 May 2006 03:27:41 -0700 (PDT) Message-ID: Date: Wed, 24 May 2006 12:27:41 +0200 From: "Robin Ericsson" To: "Dan Gorman" Subject: Re: Selects query stats? Cc: pgsql-performance@postgresql.org In-Reply-To: <127D68F6-7620-4A62-8D1A-9B475E7571CD@hi5.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/444 X-Sequence-Number: 19231 On 5/23/06, Dan Gorman wrote: > > In any other DB (oracle, mysql) I know how many queries (selects) per sec= ond > 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. --=20 regards, Robin