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: (view raw, whole thread or download thread mbox)
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.


In response to


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-2017 The PostgreSQL Global Development Group