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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/metadata/show-cache",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference and syntax for the SHOW CACHE command.

# SHOW CACHE

Returns the current SSD usage for the engine queried. `SHOW CACHE` returns values at the engine level, rather than by each node.
For a more detailed view, refer to the [`information_schema.engine_caches` view](/reference-sql/information-schema/engine-caches).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW CACHE;
```

## Returns

The returned table has the following columns.

| Column name | Data Type | Description                                                                                   |
| :---------- | :-------- | :-------------------------------------------------------------------------------------------- |
| ssd\_usage  | TEXT      | The SSD utilization is formatted as: `<ssd_used>/<ssd_available> GB (<percent_utilization>%)` |

## Components

| Component               | Description                                                                                                                |
| :---------------------- | :------------------------------------------------------------------------------------------------------------------------- |
| `<ssd_used>`            | The amount of storage currently used on your engine. This data includes storage that Firebolt reserves for internal usage. |
| `<ssd_available>`       | The amount of available storage on your engine.                                                                            |
| `<percent_utilization>` | The percent of used storage as compared to available storage.                                                              |

## Example

When the `SHOW CACHE` command is run, the usage displays as a result:

| ssd\_usage              |
| :---------------------- |
| '3.82/73.28 GB (5.22%)' |