Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026.
We will start enforcing it in phases. For more information on the details of Python end of life
and migration options, see the
blog post
STL_USAGE_CONTROL
The STL_USAGE_CONTROL view contains information that is logged when a usage limit is reached. For more information about usage limits, see Managing Usage Limits in the Amazon Redshift Management Guide.
STL_USAGE_CONTROL is visible only to superusers. For more information, see Visibility of data in system tables and views.
Table columns
| Column name | Data type | Description |
|---|---|---|
| eventtime | timestamp | The time (UTC) when the query exceeded a usage limit. |
| query | integer | The query identifier. You can use this ID to join various other system tables and views. |
| xid | bigint | The transaction identifier. |
| pid | integer | The process identifier associated with the query. |
| usage_limit_id | character(40) | A universally unique identifier (UUID) generated by Amazon Redshift, for example
25d9297e-3e7b-41c8-9f4d-c4b6eb731c09. |
| feature_type | character(30) | The feature whose usage limit was exceeded.
Possible values include CONCURRENCY_SCALING and
SPECTRUM. |
Sample query
The following SQL example returns some of the information logged when a usage limit is reached.
select query, pid, eventtime, feature_type from stl_usage_control order by eventtime desc limit 5;