SVCS_CONCURRENCY_SCALING_USAGE - Amazon Redshift
Table columnsSample queries
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).

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