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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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