Re: Selects query stats?

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
>