SQLAlchemy: How do I acquire query response time statistics?

Asked Aug 24 '15 at 14:06

Active Aug 24 '15 at 14:06

Viewed 438 times

Using plain MySQL shell, it provides me the information on how long the query took. E.g.

41 rows in set (0.023 sec)

Now using Python/SQLAlchemy in plain SQL, how do I get that information?

db.engine.execute("SELECT id FROM [...]")

I seem unable to find any functionality in the SQLAlchemy API for it. I could of course comparing timestamps before and after the statement, but that's what MySQL is already doing for me I guess.

asked Aug 24 '15 at 14:06

gertvdijk

24,056
6
41
67

I think that this answer could help you http://stackoverflow.com/a/8428546/1527018 – mic4ael Aug 24 '15 at 14:13
@mic4ael Well, it provides some convenience, but it still reinventes the wheel on timetracking I see. – gertvdijk Aug 24 '15 at 15:05

SQLAlchemy: How do I acquire query response time statistics?

0 Answers0