Re: Selects query stats?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux