aiopg async与engine.acquire()是否关闭连接？

import aiopg

async def query_database():
    # 创建连接池
    pool = await aiopg.create_pool(dsn='postgresql://user:password@localhost/dbname')

    # 获取连接
    async with pool.acquire() as conn:
        # 执行数据库操作
        async with conn.cursor() as cur:
            await cur.execute('SELECT * FROM table_name')
            result = await cur.fetchall()
            print(result)

    # 关闭连接池
    pool.close()
    await pool.wait_closed()

# 调用查询数据库的函数
asyncio.run(query_database())