On Wed, May 24, 2006 at 12:27:41PM +0200, Robin Ericsson wrote: > On 5/23/06, Dan Gorman <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
