In the debugtoolbar queries through SQLAlchemy are picked up and logged, and it shows the query, as well as how long it took.

https://github.com/pylons/pyramid_debugtoolbar

The cool thing is that you can also click on EXPLAIN and get back information from the DB directly on what indexes it is using/maybe not using.