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