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

Re: Selects query stats?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Dan Gorman <dgorman(at)hi5(dot)com>
Cc: mischa(at)ca(dot)sophos(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Selects query stats?
Date: 2006-05-23 18:51:12
Message-ID: 1148410273.2755.179.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 2006-05-23 at 11:33 -0700, Dan Gorman 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?
> 
> 
> I have a perl script that can test this, but no way the db tells me
> how fast it's going.
> 
> 
> (e.g. in oracle: select sum(executions) from v$sqlarea;)

The Oracle query you show doesn't do that either. It tells you how many
statements have been executed since startup, not per second.

The main problem with what you ask is it only seems to have value. If
the value dips for some reason, you have no way of knowing whether that
occurred because the arrival rate dropped off, there is a system problem
or whether statements just happened to access more data over that time
period. You can collect information that would allow you to understand
what is happening on your system and summarise that as you choose.

-- 
  Simon Riggs
  EnterpriseDB          http://www.enterprisedb.com


In response to

Responses

pgsql-performance by date

Next:From: Dan GormanDate: 2006-05-23 19:08:05
Subject: Re: Selects query stats?
Previous:From: Jim C. NasbyDate: 2006-05-23 18:41:00
Subject: Re: Selects query stats?

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