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.
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.
Syntax
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%)’ |