Python explain_postgres Examples

Example #1

def run_with_explain(session, query):
	explain_results = session.execute(explain_postgres(query)).first()
	print(explain_results)

Example #2

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)

Example #3

File: project_performance_test.py Project: svirmi/diffgram

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)

Example #4

File: performance_attribute_template.py Project: svirmi/diffgram

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)

Example #5

File: performance_attribute_template.py Project: svirmi/diffgram

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)

Example #6

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)