Created
July 14, 2014 21:18
-
-
Save jvanasco/17e1118b3f04dee75353 to your computer and use it in GitHub Desktop.
sqlalchemy event timing
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import time | |
from sqlalchemy import event | |
from sqlalchemy.engine import Engine as SaEngine | |
from sqlalchemy.orm import Session as SaSession | |
logger = logging.getLogger("sqlalchemy.engine.base.Engine") | |
@event.listens_for(SaEngine, "before_cursor_execute") | |
def before_cursor_execute(conn, cursor, statement, | |
parameters, context, executemany): | |
context._query_start_time = time.time() | |
@event.listens_for(SaEngine, "after_cursor_execute") | |
def after_cursor_execute(conn, cursor, statement, | |
parameters, context, executemany): | |
total = time.time() - context._query_start_time | |
logger.info("Query Complete! Total Time: %f" % total) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment