Yeah, I'm not really concerned about the app or sys performance, just
a basic question of how do I get the rate of selects that are being
executed.
In a previous post from Jim, he noted it cannot be done. I am very
surprised postgres can't do this basic functionality. Does anyone
know if the postgres team is working on this?
(btw, I pasted in the wrong oracle query lol - but it can be done in
mysql and oracle)
Best Regards,
Dan Gorman
On May 23, 2006, at 11:51 AM, Simon Riggs wrote:
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
