> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing formation about quota usage by the current user such as how much of the quota is used and how much is left.

# system.quota_usage

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

<h2 id="description">
  Description
</h2>

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

<h2 id="columns">
  Columns
</h2>

* `quota_name` ([String](/reference/data-types)) — Quota name.
* `quota_key` ([String](/reference/data-types)) — Key value.
* `start_time` ([Nullable(DateTime)](/reference/data-types)) — Start time for calculating resource consumption.
* `end_time` ([Nullable(DateTime)](/reference/data-types)) — End time for calculating resource consumption.
* `duration` ([Nullable(UInt32)](/reference/data-types)) — Length of the time interval for calculating resource consumption, in seconds.
* `queries` ([Nullable(UInt64)](/reference/data-types)) — The current number of executed queries.
* `max_queries` ([Nullable(UInt64)](/reference/data-types)) — The maximum allowed number of queries of all types allowed to be executed.
* `query_selects` ([Nullable(UInt64)](/reference/data-types)) — The current number of executed SELECT queries.
* `max_query_selects` ([Nullable(UInt64)](/reference/data-types)) — The maximum allowed number of SELECT queries allowed to be executed.
* `query_inserts` ([Nullable(UInt64)](/reference/data-types)) — The current number of executed INSERT queries.
* `max_query_inserts` ([Nullable(UInt64)](/reference/data-types)) — The maximum allowed number of INSERT queries allowed to be executed.
* `errors` ([Nullable(UInt64)](/reference/data-types)) — The current number of queries resulted in an error.
* `max_errors` ([Nullable(UInt64)](/reference/data-types)) — The maximum number of queries resulted in an error allowed within the specified period of time.
* `result_rows` ([Nullable(UInt64)](/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)](/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)](/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)](/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)](/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)](/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)](/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)](/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)](/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)](/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)](/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)](/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)](/reference/data-types)) — The current number of consecutive authentication failures within the current period of time.
* `max_failed_sequential_authentications` ([Nullable(UInt64)](/reference/data-types)) — The maximum number of consecutive authentication failures allowed within the specified period of time.
* `queries_per_normalized_hash` ([Nullable(UInt64)](/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)](/reference/data-types)) — The maximum number of executions of any single normalized query allowed within the specified period of time.

<h2 id="see-also">
  See Also
</h2>

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