如何从应用层设置postgres查询执行超时？

 ```python

 import psycopg2

 conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

 conn.set_session(autocommit=True)

 cursor = conn.cursor()

 # 设置查询执行超时时间为10秒

 cursor.execute("SET statement_timeout = '10s'")

 # 执行查询语句

 cursor.execute("SELECT * FROM your_table")

 # 处理查询结果

 rows = cursor.fetchall()

 # 关闭数据库连接

 cursor.close()

 conn.close()

 ```

 ```java

 import java.sql.*;

 Connection conn = DriverManager.getConnection("jdbc:postgresql://your_host:your_port/your_database", "your_user", "your_password");

 Statement stmt = conn.createStatement();

 // 设置查询执行超时时间为10秒

 stmt.setQueryTimeout(10);

 // 执行查询语句

 ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");

 // 处理查询结果

 while (rs.next()) {

     // 处理每一行数据

 }

 // 关闭数据库连接

 rs.close();

 stmt.close();

 conn.close();

 ```