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 ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# SYS monitoring views
<a name="serverless_views-monitoring"></a>

*Monitoring views* are system views in Amazon Redshift that are used to monitor query and workload resource usage of provisioned clusters and serverless workgroups. These views are located in the `pg_catalog` schema. To display the information provided by these views, run SQL SELECT statements.

Unless noted otherwise, these views are available for Amazon Redshift clusters and Amazon Redshift Serverless workgroups.

*SYS\_SERVERLESS\_USAGE* gathers usage data for Amazon Redshift Serverless only.

**Topics**
+ [SYS\_ANALYZE\_COMPRESSION\_HISTORY](r_SYS_ANALYZE_COMPRESSION_HISTORY.md)
+ [SYS\_ANALYZE\_HISTORY](SYS_ANALYZE_HISTORY.md)
+ [SYS\_APPLIED\_MASKING\_POLICY\_LOG](SYS_APPLIED_MASKING_POLICY_LOG.md)
+ [SYS\_AUTOMATIC\_OPTIMIZATION](SYS_AUTOMATIC_OPTIMIZATION.md)
+ [SYS\_AUTO\_TABLE\_OPTIMIZATION](r_SYS_AUTO_TABLE_OPTIMIZATION.md)
+ [SYS\_CHILD\_QUERY\_TEXT](SYS_CHILD_QUERY_TEXT.md)
+ [SYS\_CONNECTION\_LOG](SYS_CONNECTION_LOG.md)
+ [SYS\_COPY\_JOB](SYS_COPY_JOB.md)
+ [SYS\_COPY\_JOB\_DETAIL](SYS_COPY_JOB_DETAIL.md)
+ [SYS\_COPY\_JOB\_INFO](SYS_COPY_JOB_INFO.md)
+ [SYS\_COPY\_REPLACEMENTS](SYS_COPY_REPLACEMENTS.md)
+ [SYS\_DATASHARE\_CHANGE\_LOG](SYS_DATASHARE_CHANGE_LOG.md)
+ [SYS\_DATASHARE\_CROSS\_REGION\_USAGE](r_SYS_DATASHARE_CROSS_REGION_USAGE.md)
+ [SYS\_DATASHARE\_USAGE\_CONSUMER](SYS_DATASHARE_USAGE_CONSUMER.md)
+ [SYS\_DATASHARE\_USAGE\_PRODUCER](SYS_DATASHARE_USAGE_PRODUCER.md)
+ [SYS\_EXTERNAL\_QUERY\_DETAIL](SYS_EXTERNAL_QUERY_DETAIL.md)
+ [SYS\_EXTERNAL\_QUERY\_ERROR](SYS_EXTERNAL_QUERY_ERROR.md)
+ [SYS\_EXTRA\_COMPUTE\_FOR\_AUTOMATIC\_OPTIMIZATION](SYS_EXTRA_COMPUTE_FOR_AUTOMATIC_OPTIMIZATION.md)
+ [SYS\_INTEGRATION\_ACTIVITY](r_SYS_INTEGRATION_ACTIVITY.md)
+ [SYS\_INTEGRATION\_TABLE\_ACTIVITY](r_SYS_INTEGRATION_TABLE_ACTIVITY.md)
+ [SYS\_INTEGRATION\_TABLE\_STATE\_CHANGE](r_SYS_INTEGRATION_TABLE_STATE_CHANGE.md)
+ [SYS\_LOAD\_DETAIL](SYS_LOAD_DETAIL.md)
+ [SYS\_LUDF\_DETAIL](SYS_LUDF_DETAIL.md)
+ [SYS\_LOAD\_ERROR\_DETAIL](SYS_LOAD_ERROR_DETAIL.md)
+ [SYS\_LOAD\_HISTORY](SYS_LOAD_HISTORY.md)
+ [SYS\_MV\_REFRESH\_HISTORY](SYS_MV_REFRESH_HISTORY.md)
+ [SYS\_MV\_STATE](SYS_MV_STATE.md)
+ [SYS\_PROCEDURE\_CALL](SYS_PROCEDURE_CALL.md)
+ [SYS\_PROCEDURE\_MESSAGES](SYS_PROCEDURE_MESSAGES.md)
+ [SYS\_QUERY\_DETAIL](SYS_QUERY_DETAIL.md)
+ [SYS\_QUERY\_EXPLAIN](SYS_QUERY_EXPLAIN.md)
+ [SYS\_QUERY\_HISTORY](SYS_QUERY_HISTORY.md)
+ [SYS\_QUERY\_TEXT](SYS_QUERY_TEXT.md)
+ [SYS\_REDSHIFT\_TEMPLATE](SYS_REDSHIFT_TEMPLATE.md)
+ [SYS\_RESTORE\_LOG](SYS_RESTORE_LOG.md)
+ [SYS\_RESTORE\_STATE](SYS_RESTORE_STATE.md)
+ [SYS\_SCHEMA\_QUOTA\_VIOLATIONS](r_SYS_SCHEMA_QUOTA_VIOLATIONS.md)
+ [SYS\_SERVERLESS\_USAGE](SYS_SERVERLESS_USAGE.md)
+ [SYS\_SESSION\_HISTORY](SYS_SESSION_HISTORY.md)
+ [SYS\_SPATIAL\_SIMPLIFY](SYS_SPATIAL_SIMPLIFY.md)
+ [SYS\_STREAM\_SCAN\_ERRORS](r_SYS_STREAM_SCAN_ERRORS.md)
+ [SYS\_STREAM\_SCAN\_STATES](r_SYS_STREAM_SCAN_STATES.md)
+ [SYS\_TRANSACTION\_HISTORY](SYS_TRANSACTION_HISTORY.md)
+ [SYS\_UDF\_LOG](SYS_UDF_LOG.md)
+ [SYS\_UNLOAD\_DETAIL](SYS_UNLOAD_DETAIL.md)
+ [SYS\_UNLOAD\_HISTORY](SYS_UNLOAD_HISTORY.md)
+ [SYS\_USERLOG](SYS_USERLOG.md)
+ [SYS\_VACUUM\_HISTORY](SYS_VACUUM_HISTORY.md)