statement_timeout
Abort any statement that takes more than the specified amount of time. If log_min_error_statement is set to ERROR or lower, the statement that timed out will also be logged. If this value is specified without units, it is taken as milliseconds. A value of zero (the default) disables the timeout. The timeout is measured from the time a command arrives at the server until it is completed by the server. If multiple SQL statements appear in a single simple-query message, the timeout is applied to each statement separately. (PostgreSQL versions before 13 usually treated the timeout as applying to the whole query string.) In extended query protocol, the timeout starts running when any query-related message (Parse, Bind, Execute, Describe) arrives, and it is canceled by completion of an Execute or Sync message. Setting statement_timeout in postgresql.conf is not recommended because it would affect all sessions.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- 0
- category
- Client Connection Defaults / Statement Behavior
- context
- user
- documented
- true
- enumvals
- 未知
- extra desc
- 0 disables the timeout.
- lang
- en
- max val
- 2147483647
- metadata version
- 18
- min val
- 0
- name
- statement_timeout
- short desc
- Sets the maximum allowed duration of any statement.
- source
- pg-settings-source-snapshot
- unit
- ms
- vartype
- integer
版本定义 PG 18
Abort any statement that takes more than the specified amount of time. If log_min_error_statement is set to ERROR or lower, the statement that timed out will also be logged. If this value is specified without units, it is taken as milliseconds. A value of zero (the default) disables the timeout. The timeout is measured from the time a command arrives at the server until it is completed by the server. If multiple SQL statements appear in a single simple-query message, the timeout is applied to each statement separately. (PostgreSQL versions before 13 usually treated the timeout as applying to the whole query string.) In extended query protocol, the timeout starts running when any query-related message (Parse, Bind, Execute, Describe) arrives, and it is canceled by completion of an Execute or Sync message. Setting statement_timeout in postgresql.conf is not recommended because it would affect all sessions.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:9baca19b9fd45a8da430156b8e9a7d2ab701c8ead77fef43a15ba8ca4c01ad84
正文语言: en · english-manuals:9baca19b9fd45a8da430156b8e9a7d2ab701c8ead77fef43a15ba8ca4c01ad84