Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

statement_timeout

Values (Default in Bold)

0 (turns off limitation), x milliseconds

Description

Aborts any statement that takes over the specified number of milliseconds.

If WLM timeout (max_execution_time) is also specified as part of a WLM configuration, the lower of statement_timeout and max_execution_time is used. For more information, see WLM Timeout.

Example

Because the following query takes longer than 1 millisecond, it times out and is cancelled.

Copy
set statement_timeout to 1; select * from listing where listid>5000; ERROR: Query (150) cancelled on user's request