def run_with_explain(session, query): explain_results = session.execute(explain_postgres(query)).first() print(explain_results)
def explain_single_file_id(file_id): with sessionMaker.session_scope() as session: query = session.query(Instance).filter( Instance.file_id == file_id) explain_results = session.execute(explain_postgres(query)).first() print(explain_results)
def primary_key(project_id):
with sessionMaker.session_scope() as session:
query = session.query(Project).filter(Project.id == project_id)
explain_results = session.execute(explain_postgres(query)).first()
print(explain_results)
def primary_key(id):
with sessionMaker.session_scope() as session:
query = session.query(Attribute_Template).filter(
Attribute_Template.id == id)
explain_results = session.execute(explain_postgres(query)).first()
print(explain_results)
def foreign_key(group_id):
with sessionMaker.session_scope() as session:
query = session.query(Attribute_Template).filter(
Attribute_Template.group_id == group_id)
explain_results = session.execute(explain_postgres(query)).first()
print(explain_results)
def foreign_key(processing_deferred):
with sessionMaker.session_scope() as session:
query = session.query(Input).filter(
Input.processing_deferred == processing_deferred)
explain_results = session.execute(explain_postgres(query)).first()
print(explain_results)