On Wed, May 24, 2006 at 12:27:41PM +0200, Robin Ericsson wrote: > On 5/23/06, Dan Gorman <dgorman@xxxxxxx> 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. Somehow that doesn't surprise me... In any case, if we at least provide a raw counter, it's not that hard to turn that into selects per second over some period of time. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
