SYS monitoring views - Amazon Redshift

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 .

SYS monitoring views

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.