Skip site navigation (1) Skip section navigation (2)

Re: Selects query stats?

From: "Robin Ericsson" <lobbin(at)gmail(dot)com>
To: "Dan Gorman" <dgorman(at)hi5(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Selects query stats?
Date: 2006-05-24 10:27:41
Message-ID: c014a9590605240327h3f95ebbat8a6fcbc90680633@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 5/23/06, Dan Gorman <dgorman(at)hi5(dot)com> 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.


-- 
        regards,
        Robin

In response to

Responses

pgsql-performance by date

Next:From: kynnDate: 2006-05-24 15:49:52
Subject: Optimizing a huge_table/tiny_table join
Previous:From: sibel karaasmaDate: 2006-05-24 08:44:43
Subject: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group