system.quotas_usage

System table containing formation about quota usage by all users.

Querying in ClickHouse Cloud

The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the clusterAllReplicas function. See here for further details.

Description

Quota usage by all users.

Columns

• quota_name (String) — Quota name.
• quota_key (String) — Key value.
• is_current (UInt8) — Quota usage for current user.
• start_time (Nullable(DateTime)) — Start time for calculating resource consumption.
• end_time (Nullable(DateTime)) — End time for calculating resource consumption.
• duration (Nullable(UInt32)) — Length of the time interval for calculating resource consumption, in seconds.
• queries (Nullable(UInt64)) — The current number of executed queries.
• max_queries (Nullable(UInt64)) — The maximum allowed number of queries of all types allowed to be executed.
• query_selects (Nullable(UInt64)) — The current number of executed SELECT queries.
• max_query_selects (Nullable(UInt64)) — The maximum allowed number of SELECT queries allowed to be executed.
• query_inserts (Nullable(UInt64)) — The current number of executed INSERT queries.
• max_query_inserts (Nullable(UInt64)) — The maximum allowed number of INSERT queries allowed to be executed.
• errors (Nullable(UInt64)) — The current number of queries resulted in an error.
• max_errors (Nullable(UInt64)) — The maximum number of queries resulted in an error allowed within the specified period of time.
• result_rows (Nullable(UInt64)) — The current total number of rows in the result set of all queries within the current period of time.
• max_result_rows (Nullable(UInt64)) — The maximum total number of rows in the result set of all queries allowed within the specified period of time.
• result_bytes (Nullable(UInt64)) — The current total number of bytes in the result set of all queries within the current period of time.
• max_result_bytes (Nullable(UInt64)) — The maximum total number of bytes in the result set of all queries allowed within the specified period of time.
• read_rows (Nullable(UInt64)) — The current total number of rows read during execution of all queries within the current period of time.
• max_read_rows (Nullable(UInt64)) — The maximum number of rows to read during execution of all queries allowed within the specified period of time.
• read_bytes (Nullable(UInt64)) — The current total number of bytes read during execution of all queries within the current period of time.
• max_read_bytes (Nullable(UInt64)) — The maximum number of bytes to read during execution of all queries allowed within the specified period of time.
• execution_time (Nullable(Float64)) — The current total amount of time (in nanoseconds) spent to execute queries within the current period of time
• max_execution_time (Nullable(Float64)) — The maximum amount of time (in nanoseconds) allowed for all queries to execute within the specified period of time
• written_bytes (Nullable(UInt64)) — The current total number of bytes written during execution of all queries within the current period of time.
• max_written_bytes (Nullable(UInt64)) — The maximum number of bytes to written during execution of all queries allowed within the specified period of time.
• failed_sequential_authentications (Nullable(UInt64)) — The current number of consecutive authentication failures within the current period of time.
• max_failed_sequential_authentications (Nullable(UInt64)) — The maximum number of consecutive authentication failures allowed within the specified period of time.
• queries_per_normalized_hash (Nullable(UInt64)) — The current maximum number of executions of any single normalized query within the current period of time.
• max_queries_per_normalized_hash (Nullable(UInt64)) — The maximum number of executions of any single normalized query allowed within the specified period of time.

See Also

• SHOW QUOTA)