statement_timeout - Amazon Redshift
Values (default in bold)DescriptionExample

Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post .

statement_timeout

Values (default in bold)

0 (turns off limitation), x milliseconds

Description

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

The statement_timeout value is the maximum amount of time a query can run before Amazon Redshift terminates it. This time includes planning, queueing in workload management (WLM), and execution time. Compare this time to WLM timeout (max_execution_time) and a QMR (query_execution_time), which include only execution time.

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 canceled.

set statement_timeout = 1;

select * from listing where listid>5000;
ERROR:  Query (150) canceled on user's request