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

> This table contains warning messages about clickhouse server.

# system.warnings

<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>

This table shows warnings about the ClickHouse server.
Warnings of the same type are combined into a single warning.
For example, if the number N of attached databases exceeds a configurable threshold T, a single entry containing the current value N is shown instead of N separate entries.
If current value drops below the threshold, the entry is removed from the table.

The table can be configured with these settings:

* [max\_table\_num\_to\_warn](/reference/settings/server-settings/settings#max_table_num_to_warn)
* [max\_database\_num\_to\_warn](/reference/settings/server-settings/settings#max_database_num_to_warn)
* [max\_dictionary\_num\_to\_warn](/reference/settings/server-settings/settings#max_dictionary_num_to_warn)
* [max\_view\_num\_to\_warn](/reference/settings/server-settings/settings#max_view_num_to_warn)
* [max\_part\_num\_to\_warn](/reference/settings/server-settings/settings#max_part_num_to_warn)
* [max\_pending\_mutations\_to\_warn](/reference/settings/server-settings/settings#max_pending_mutations_to_warn)
* [max\_pending\_mutations\_execution\_time\_to\_warn](/reference/settings/server-settings/settings#max_pending_mutations_execution_time_to_warn)
* [max\_named\_collection\_num\_to\_warn](/reference/settings/server-settings/settings#max_named_collection_num_to_warn)
* [resource\_overload\_warnings](/concepts/features/configuration/settings/server-overload#resource-overload-warnings)

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

* `message` ([String](/reference/data-types/string)) — Warning message.
* `message_format_string` ([LowCardinality(String)](/reference/data-types/string)) — The format string used to format the message.

<h2 id="example">
  Example
</h2>

```sql title="Query" theme={null}
 SELECT * FROM system.warnings LIMIT 2 \G;
```

```text title="Response" theme={null}
Row 1:
──────
message:               The number of active parts is more than 10.
message_format_string: The number of active parts is more than {}.

Row 2:
──────
message:               The number of attached databases is more than 2.
message_format_string: The number of attached databases is more than {}.
```