> ## 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 information about quotas.

# system.quotas

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

Contains information about [quotas](/reference/system-tables/quotas).

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

* `name` ([String](/reference/data-types)) — Quota name.
* `id` ([UUID](/reference/data-types)) — Quota ID.
* `storage` ([String](/reference/data-types)) — Storage of quotas. Possible value: 'users.xml' if a quota configured in the users.xml file, 'disk' if a quota configured by an SQL-query.
* `keys` ([Array(Enum8('user\_name' = 1, 'ip\_address' = 2, 'forwarded\_ip\_address' = 3, 'client\_key' = 4, 'normalized\_query\_hash' = 7))](/reference/data-types)) — Key specifies how the quota should be shared. If two connections use the same quota and key, they share the same amounts of resources. Values: \[] — All users share the same quota, \['user\_name'] — Connections with the same user name share the same quota, \['ip\_address'] — Connections from the same IP share the same quota. \['client\_key'] — Connections with the same key share the same quota. A key must be explicitly provided by a client. When using clickhouse-client, pass a key value in the --quota\_key parameter, or use the quota\_key parameter in the client configuration file. When using HTTP interface, use the X-ClickHouse-Quota header, \['user\_name', 'client\_key'] — Connections with the same client\_key share the same quota. If a key isn't provided by a client, the quota is tracked for `user_name`, \['client\_key', 'ip\_address'] — Connections with the same client\_key share the same quota. If a key isn't provided by a client, the quota is tracked for ip\_address.
* `durations` ([Array(UInt32)](/reference/data-types)) — Time interval lengths in seconds.
* `apply_to_all` ([UInt8](/reference/data-types)) — Logical value. It shows which users the quota is applied to. Values: 0 — The quota applies to users specify in the apply\_to\_list. 1 — The quota applies to all users except those listed in apply\_to\_except.
* `apply_to_list` ([Array(String)](/reference/data-types)) — List of user names/roles that the quota should be applied to.
* `apply_to_except` ([Array(String)](/reference/data-types)) — List of user names/roles that the quota should not apply to.

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

* [SHOW QUOTAS](/reference/statements/show#show-quotas)