system.quota_usage

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/operations/system-tables/quota_usage.md)

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](/docs/operations/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.

Quota usage by the current user: how much is used and how much is left.

Columns:

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

## See Also[​](#see-also "Direct link to See Also")

- [SHOW QUOTA](/docs/sql-reference/statements/show#show-quota))

- [See Also](#see-also)

Was this page helpful?