Not out of the box, but it would be pretty easy to dump them all into sqllite or another other sql database and query them out when you want a report. And a little extra logic to not profile those queries so you don't recurse infinitely. Would love a patch! With sqlalchemy, it's pretty easy to make it database-agnostic too =)
On Mar 10, 2014, at 6:29 AM, Thierry Florac <tflo...@gmail.com> wrote: > That sounds really great. > Simple question : is there any way to use SQLTap in a multi-processes WSGI > environment ?? > > Best regards, > Thierry > > > 2014-03-10 5:28 GMT+01:00 Michael Bayer <mike...@zzzcomputing.com>: > hey that looks pretty nice, ill give it a shoutout. > > > On Mar 9, 2014, at 9:21 PM, Alan Shreve <a...@inconshreveable.com> wrote: > >> A few years ago, I built SQLTap, a simple library to hook into SQLAlchemy >> and pull out statistics and information on the queries you ran. This last >> couple days I've overhauled it an updated it to make it more useful! >> >> You basically just start the profiler and then it can dump out nice >> browsable HTML reports like this: >> >> http://sqltap.inconshreveable.com/_images/sqltap-report-example.png >> >> SQLTap helps you answer questions like: >> >> What queries is my application running? >> How long do they take on average? At maximum? At minimum? At median? >> What sequences of function calls lead to each invocation of a query? Where >> in my source code is the query executed? >> >> The latest updates and improvements make up sqltap version 0.3 and include: >> >> - The report now has a sexy new HTML UI based on bootstrap3. >> - You can add sqltap to any WSGI application and get a live, updating >> dashboard of all the queries going through an application. >> - The WSGI integration has controls to enable/disable the profiling at any >> time so you can even include it in production applications for selective >> profiling. >> - The library's API is now greatly improved, allowing you to do your own >> real-time collection of statistics as well as allowing you to create >> individual profilers for different engines instead of forcing a global >> profiler. >> - Updated/improved documentation >> >> Install with: >> >> pip install sqltap >> >> And in your code: >> >> import sqltap >> profiler = sqltap.start() >> >> # sometime later after queries have been run >> sqltap.report(profiler.collect(), "report.html") >> >> Links for reference: >> Code and some documentation (star it!): >> https://github.com/inconshreveable/sqltap >> Documentation: http://sqltap.inconshreveable.com/ >> On PyPI: https://pypi.python.org/pypi/sqltap >> >> Enjoy! >> >> - alan >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > > > -- > http://www.imagesdusport.com -- http://www.ztfy.org > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
