SVCS_CONCURRENCY_SCALING_USAGE - 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 .

SVCS_CONCURRENCY_SCALING_USAGE

Records the usage periods for concurrency scaling. Each usage period is a consecutive duration where an individual concurrency scaling cluster is actively processing queries.

SVCS_CONCURRENCY_SCALING_USAGE This table is visible to superusers. The database's superuser can choose to open it up to all users.

Table columns

Column name Data type Description
start_time timestamp without time zone When the usage period starts.
end_time timestamp without time zone When the usage period ends.
queries bigint Number of queries run during this usage period.
usage_in_seconds numeric(27,0) Total seconds in this usage period.

Sample queries

To view the usage duration in seconds for a specific period, enter the following query:

select * from svcs_concurrency_scaling_usage order by start_time; start_time | end_time | queries | usage_in_seconds ----------------------------+----------------------------+---------+------------------ 2019-02-14 18:43:53.01063 | 2019-02-14 19:16:49.781649 | 48 | 1977