def METHOD_NAME(tmpdir):
    tmpdir = str(tmpdir)
    db = FakeDatabase()
    log = RecordedQueryLog(collections.deque(maxlen=100), db, dest=tmpdir)
    log.threshold = 0.00000001
    for _ in range(5):
        log.append(QUERY)
    assert len(log) == 5
    assert len(db.execute_calls) == 5
    for _call in db.execute_calls:
        args, kw = _call
        assert args == ('EXPLAIN VERBOSE {}'.format(QUERY['sql']),)
    path = os.path.join(tmpdir, '{}.sqlite'.format(os.path.basename(sys.argv[0])))
    assert os.path.exists(path)
    # verify the results
    def dict_factory(cursor, row):
        d = {}
        for idx, col in enumerate(cursor.description):
            d[col[0]] = row[idx]
        return d
    cursor = sqlite3.connect(path)
    cursor.row_factory = dict_factory
    queries_logged = cursor.execute('SELECT * FROM queries').fetchall()
    assert len(queries_logged) == 5
    for q in queries_logged:
        assert q['pid'] == os.getpid()
        assert q['version'] == awx.__version__
        assert q['time'] == 0.01
        assert q['sql'] == QUERY['sql']
        assert EXPLAIN in q['explain']
        assert 'test_sql_above_threshold' in q['bt']