SHOW Statements

Query with the `ILIKE` clause:

```
SHOW SETTINGS ILIKE '%CONNECT_timeout%'
```

```
┌─name────────────────────────────────────┬─type─────────┬─value─┐
│ connect_timeout                         │ Seconds      │ 10    │
│ connect_timeout_with_failover_ms        │ Milliseconds │ 50    │
│ connect_timeout_with_failover_secure_ms │ Milliseconds │ 100   │
└─────────────────────────────────────────┴──────────────┴───────┘
```

Query with the `CHANGED` clause:

```
SHOW CHANGED SETTINGS ILIKE '%MEMORY%'
```

```
┌─name─────────────┬─type───┬─value───────┐
│ max_memory_usage │ UInt64 │ 10000000000 │
└──────────────────┴────────┴─────────────┘
```

## SHOW SETTING[​](#show-setting "Direct link to SHOW SETTING")

The `SHOW SETTING` statement outputs setting value for specified setting name.

### Syntax[​](#syntax-22 "Direct link to Syntax")

```
SHOW SETTING <name>
```

### See also[​](#see-also-4 "Direct link to See also")

- [`system.settings`](/docs/operations/system-tables/settings) table

## SHOW FILESYSTEM CACHES[​](#show-filesystem-caches "Direct link to SHOW FILESYSTEM CACHES")

### Examples[​](#examples-7 "Direct link to Examples")

```
SHOW FILESYSTEM CACHES
```

```
┌─Caches────┐
│ s3_cache  │
└───────────┘
```

### See also[​](#see-also-5 "Direct link to See also")

- [`system.settings`](/docs/operations/system-tables/settings) table

## SHOW ENGINES[​](#show-engines "Direct link to SHOW ENGINES")

The `SHOW ENGINES` statement outputs the content of the [`system.table_engines`](/docs/operations/system-tables/table_engines) table,
that contains description of table engines supported by server and their feature support information.

### Syntax[​](#syntax-23 "Direct link to Syntax")

```
SHOW ENGINES [INTO OUTFILE filename] [FORMAT format]
```

### See also[​](#see-also-6 "Direct link to See also")

- [system.table\_engines](/docs/operations/system-tables/table_engines) table

## SHOW FUNCTIONS[​](#show-functions "Direct link to SHOW FUNCTIONS")

The `SHOW FUNCTIONS` statement outputs the content of the [`system.functions`](/docs/operations/system-tables/functions) table.

### Syntax[​](#syntax-24 "Direct link to Syntax")

```
SHOW FUNCTIONS [LIKE | ILIKE '<pattern>']
```

If either `LIKE` or `ILIKE` clause is specified, the query returns a list of system functions whose names match the provided `<pattern>`.

### See Also[​](#see-also-7 "Direct link to See Also")

- [`system.functions`](/docs/operations/system-tables/functions) table

## SHOW MERGES[​](#show-merges "Direct link to SHOW MERGES")

The `SHOW MERGES` statement returns a list of merges.
All merges are listed in the [`system.merges`](/docs/operations/system-tables/merges) table:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Column Description|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `table` Table name.|  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `database` The name of the database the table is in.|  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `estimate_complete` The estimated time to complete (in seconds).|  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `elapsed` The time elapsed (in seconds) since the merge started.|  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | | `progress` The percentage of completed work (0-100 percent).|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | `is_mutation` 1 if this process is a part mutation.|  |  |  |  | | --- | --- | --- | --- | | `size_compressed` The total size of the compressed data of the merged parts.|  |  | | --- | --- | | `memory_usage` Memory consumption of the merge process. | | | | | | | | | | | | | | | | | |

### Syntax[​](#syntax-25 "Direct link to Syntax")

```
SHOW MERGES [[NOT] LIKE|ILIKE '<table_name_pattern>'] [LIMIT <N>]
```

### Examples[​](#examples-8 "Direct link to Examples")

```
SHOW MERGES;
```

```
┌─table──────┬─database─┬─estimate_complete─┬─elapsed─┬─progress─┬─is_mutation─┬─size_compressed─┬─memory_usage─┐
│ your_table │ default  │              0.14 │    0.36 │    73.01 │           0 │        5.40 MiB │    10.25 MiB │
└────────────┴──────────┴───────────────────┴─────────┴──────────┴─────────────┴─────────────────┴──────────────┘
```

```
SHOW MERGES LIKE 'your_t%' LIMIT 1;
```

```
┌─table──────┬─database─┬─estimate_complete─┬─elapsed─┬─progress─┬─is_mutation─┬─size_compressed─┬─memory_usage─┐
│ your_table │ default  │              0.14 │    0.36 │    73.01 │           0 │        5.40 MiB │    10.25 MiB │
└────────────┴──────────┴───────────────────┴─────────┴──────────┴─────────────┴─────────────────┴──────────────┘
```

## SHOW CREATE MASKING POLICY[​](#show-create-masking-policy "Direct link to SHOW CREATE MASKING POLICY")

The `SHOW CREATE MASKING POLICY` statement shows parameters which were used at [masking policy creation](/docs/sql-reference/statements/create/masking-policy).

### Syntax[​](#syntax-26 "Direct link to Syntax")

```
SHOW CREATE MASKING POLICY name ON [database.]table
```