Amazon Redshift
Database Developer Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

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.

By default, this view is visible by a superuser only. The database 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