> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference and syntax for the SHOW ALL command.

# SHOW ALL

<span className="feature-tag">Nightly Feature</span>

Returns a table with a row for each engine setting, with its current value and its description, ordered by name.

`SHOW ALL` is a projection over [pg\_catalog.pg\_settings](/reference-sql/information-schema/pg_settings), so it covers every setting the engine defines: the public ones, meaning the settings Firebolt documents, supports, and keeps stable, and the internal ones, whose names and defaults change between releases. Query `pg_catalog.pg_settings` directly for the remaining columns, such as the default value and the setting type, or query [information\_schema.settings](/reference-sql/information-schema/settings) for the same columns over the public settings only. For the other views in these schemas, see [Information schema](/reference-sql/information-schema). For the meaning of individual settings and how to change them, see [System settings](/reference-sql/system-settings).

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SHOW ALL;
```

`SHOW ALL` takes no arguments.

## Returns

The returned table has the following columns.

| Column name | Data Type | Description                            |
| :---------- | :-------- | :------------------------------------- |
| name        | TEXT      | Name of the setting.                   |
| setting     | TEXT      | Current value of the setting, as text. |
| description | TEXT      | Description of the setting.            |

## Example

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SHOW ALL;
```

| name                  | setting | description                                                                               |
| :-------------------- | :------ | :---------------------------------------------------------------------------------------- |
| enable\_result\_cache | true    | If false, disables result caching. Note that subresult caching is still enabled.          |
| max\_result\_rows     | 0       | Limit on the result size in rows of SELECT queries. Values of zero or below set no limit. |
| timezone              | UTC     | The default time zone for displaying and interpreting timestamps with time zone support   |

The output above is truncated; `SHOW ALL` returns every setting. To list only the public ones, query [information\_schema.settings](/reference-sql/information-schema/settings).