Re: Selects query stats? - Mailing list pgsql-performance

From Robin Ericsson
Subject Re: Selects query stats?
Date
Msg-id c014a9590605240327h3f95ebbat8a6fcbc90680633@mail.gmail.com
Whole thread Raw
In response to Re: Selects query stats?  (Dan Gorman <dgorman@hi5.com>)
Responses Re: Selects query stats?
List pgsql-performance
On 5/23/06, Dan Gorman <dgorman@hi5.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

pgsql-performance by date:

Previous
From: Mischa Sandberg
Date:
Subject: Re: Selects query stats?
Next
From: "Daniel J. Luke"
Date:
Subject: Getting even more insert performance (250m+rows/day)