feedback/testing wanted - pyramid_debugtoolbar_api_sqlalchemy

13 views
Skip to first unread message

Jonathan Vanasco

unread,
May 10, 2017, 4:49:43 PM5/10/17
to pylons-discuss
Thanks to some changes in debugtoolbar 4.0 by Michael Merickel, I was able to update and release our SqlAlchemy profiling tool

* via pip/pypi `pyramid_debugtoolbar_api_sqlalchemy`

This package relies on the existing SqlAlchemy Panel that ships with the debugtoolbar to do all the real work.

This package simply makes the existing panel's data downloadable into a `.csv` format - via a button or a machine-friendly/predictable URL.

Our use case:

We enable this panel during integrated testing, and download/archive all the csv files.
A separate process analyzes the CSVs for too many queries, slow queries or "slowing" queries (i.e. queries getting slower over time), and reports the routes that were used.
This lets us find issues before they are deployed (not using lazyloading, needing indexing, bad selects, etc)

Reply all
Reply to author
Forward
0 new messages