Skip to main content
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

SHOW CACHE;
The results of SHOW CACHE are formatted as follows: <ssd_used>/<ssd_available> GB (<percent_utilization>%)

​
Components

ComponentDescription
<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%)