Skip to content

Instantly share code, notes, and snippets.

@jvanasco
Created July 14, 2014 21:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jvanasco/17e1118b3f04dee75353 to your computer and use it in GitHub Desktop.
Save jvanasco/17e1118b3f04dee75353 to your computer and use it in GitHub Desktop.
sqlalchemy event timing
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