Source: https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/data-admin/show/show-all-warnings/
Documentation version: v5.3.2

# SHOW ALL WARNINGS command

The SHOW ALL WARNINGS command shows all the warnings that are generated from previous query executions in the service group. Warnings alert users to non-critical issues without raising an exception or terminating the query.

Note

As warnings are stored in the memory of the Graph service, they are automatically cleared when the Graph service is stopped or restarted. To avoid high memory usage, you can use [CLEAR WARNINGS](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/data-admin/clear/clear-warnings/) or [CLEAR ALL WARNINGS](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/data-admin/clear/clear-all-warnings/) to clear warnings.

The following table describes the returned information:

 | Column | Description
 | `code` | The warning code.
 | `username` | The username of the user who executed the query that resulted in the warning.
 | `nums` | The number of the warning occurred in the service group.

To suppress a warning, you can set the value of the configuration option `suppressed_warning_codes` to the related warning code using GLOBAL SET.

## Prerequisites

You must be the user with the role `ADMIN` in the service group. For more information, see [Roles and privileges](https://dev-docs.nebula-graph.io/v5.3.2/server-admin/authorization/). 

## Syntax

diagramsource

 show_all_warnings_command  

````
show_all_warnings_command ::=
    'SHOW' 'ALL' 'WARNINGS'

````

## Examples

````
SHOW ALL WARNINGS

````

Return:

````
+-------+--------------------+------+
| code  | username           | nums |
+-------+--------------------+------+
| 01005 | user_show_warnings | 1    |
| 01005 | root               | 1    |
+-------+--------------------+------+

````