psycopg2设置语句执行时间超时

不止于python

发布于 2022-05-31 20:32:04

2.3K00

代码可运行

文章被收录于专栏：不止于python不止于python

运行总次数：0

代码可运行

原文

https://stackoverflow.com/questions/19963954/set-transaction-query-timeout-in-psycopg2

设置方式

1.代码中添加options

>>> import psycopg2
>>> cnn = psycopg2.connect("dbname=test options='-c statement_timeout=1000'")
>>> cur = cnn.cursor()
>>> cur.execute("select pg_sleep(2000)")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg2.extensions.QueryCanceledError: canceling statement due to statement timeout

2.添加到系统环境变量中(PGOPTIONS)

>>> import os
>>> os.environ['PGOPTIONS'] = '-c statement_timeout=1000'
>>> import psycopg2
>>> cnn = psycopg2.connect("dbname=test")
>>> cur = cnn.cursor()
>>> cur.execute("select pg_sleep(2000)")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg2.extensions.QueryCanceledError: canceling statement due to statement timeout

相关文章参考

https://postgresqlco.nf/doc/en/param/statement_timeout/
https://blog.crunchydata.com/blog/control-runaway-postgres-queries-with-statement-timeout
https://iotespresso.com/how-to-configure-statement-timeout-in-psycopg2/

本文参与腾讯云自媒体同步曝光计划，分享自微信公众号。

原始发表：2022-03-21，如有侵权请联系 cloudcommunity@tencent.com 删除

https