On Thu, Jun 28, 2007, Paul J Stevens <[EMAIL PROTECTED]> said: > Aaron Stone wrote: > >> Last night I wrote up the code, and depending on how long the query takes, >> it escalates the debugging level, all the way up to WARNING (level 2) for >> queries taking longer than 30 seconds. I don't actually know if this is a >> fair value, but I picked a number. I'll commit this code later today to >> get some feedback. > > Since you're on a roll; I would also be useful if we could track the > time of whole transactions (db_begin_transaction/db_commit_transaction). > > just a thought.
YES! I actually wrote some code previously* that would track the transaction state and tell if we'd issued several begin's or a commit without a begin. Timing it is just a few more lines. Great idea! * it's in one of my trees; I haven't taken the time to wrap my head around git yet, so trying to merge my various hacks has been awful :-\ Aaron _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
