Skip to main content

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

SHOW CACHE;

Returns

The returned table has the following columns.
Column nameData TypeDescription
ssd_usageTEXTThe SSD utilization is formatted as: <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%)’