config.py:
class Config(object):
...
DATABASE_QUERY_TIMEOUT = 0.0001 ##记录执行时间超过 0.0001秒的
SQLALCHEMY_RECORD_QUERIES = True
wsgi.py:
from flask import abort, request, _app_ctx_stack, jsonify
from app import create_app
from app.ik_global import ik_global
from app.ikdb.model.models import User
from flask_sqlalchemy import get_debug_queries
app = vpp_agent = create_app("production")
login_manager = flask_login.LoginManager()
login_manager.init_app(app)
@app.after_request
def after_request(response):
ik_global.Logger.info("after_request: {}".format(request.url))
for query in get_debug_queries():
if query.duration >= app.config["DATABASE_QUERY_TIMEOUT"]:
ik_global.Logger.info("Context:{}\n SLOW query: {}\n Params: {}\n Duration: {} ms\n".format(query.context, query.statement, query.parameters, query.duration*1000))
# some stuff here
return response