Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# STL\_USAGE\_CONTROL
<a name="r_STL_USAGE_CONTROL"></a>

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](https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cluster-usage-limits.html) 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](cm_chap_system-tables.md#c_visibility-of-data).

## Table columns
<a name="r_STL_USAGE_CONTROL-table-columns"></a>


| 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
<a name="r_STL_USAGE_CONTROL-sample-queries"></a>

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;
```