This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

SHOW CACHE

Returns the current SSD usage (ssd_usage) for the current engine. SHOW CACHE returns values at the engine level, not by each node.

Syntax

SHOW CACHE;

The results of SHOW CACHE are formatted as follows:

<ssd_used>/<ssd_available> GB (<percent_utilization>%)

These components are defined as follows:

Example returned output is shown below.

| ssd_usage             |
+-----------------------+
| 3.82/73.28 GB (5.22%) |