Skip to main content
Skip to main content
Edit this page

system.quotas_usage

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.

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.

See Also​