View a markdown version of this page

Usage metrics for autonomics operations - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 that was published on June 30, 2025.

Usage metrics for autonomics operations

If you've enabled extra compute resources for automatic optimizations, you can see information about your billed autonomics usage using the Amazon Redshift console. For more information on autonomics metrics on the console for serverless workgroups, see the resource management section in Amazon Redshift Serverless console in the Amazon Redshift Management Guide.

The following system tables hold usage metrics about autonomics:

  • SYS_EXTRA_COMPUTE_FOR_AUTOMATIC_OPTIMIZATION ‐ Use SYS_EXTRA_COMPUTE_FOR_AUTOMATIC_OPTIMIZATION to see the amount of time that Amazon Redshift runs provisioned cluster autonomics operations in a given usage period.

  • SYS_AUTOMATIC_OPTIMIZATION ‐ Use SYS_AUTOMATIC_OPTIMIZATION to see detailed information on autonomics operations for both provisioned clusters and serverless workgroups.

  • SYS_SERVERLESS_USAGE ‐ Use SYS_SERVERLESS_USAGE to see the amount of time that Amazon Redshift runs serverless workgroup autonomics operations in a given usage period.