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.
