> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8c05c8a2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Contains information about all entries inside filesystem cache for remote objects.

# system.filesystem_cache

<h2 id="description">
  Description
</h2>

Contains information about all entries inside filesystem cache for remote objects.

<h2 id="columns">
  Columns
</h2>

* `cache_name` ([String](/reference/data-types/index)) — Name of the cache object. Can be used in `SYSTEM DESCRIBE FILESYSTEM CACHE <name>`, `SYSTEM DROP FILESYSTEM CACHE <name>` commands
* `cache_base_path` ([String](/reference/data-types/index)) — Path to the base directory where all cache files (of a cache identified by `cache_name`) are stored.
* `cache_path` ([String](/reference/data-types/index)) — Path to a particular cache file, corresponding to a file segment in a source file
* `key` ([String](/reference/data-types/index)) — Cache key of the file segment
* `file_segment_range_begin` ([UInt64](/reference/data-types/index)) — Offset corresponding to the beginning of the file segment range
* `file_segment_range_end` ([UInt64](/reference/data-types/index)) — Offset corresponding to the (including) end of the file segment range
* `size` ([UInt64](/reference/data-types/index)) — Size of the file segment
* `state` ([String](/reference/data-types/index)) — File segment state (DOWNLOADED, DOWNLOADING, PARTIALLY\_DOWNLOADED, ...)
* `finished_download_time` ([DateTime](/reference/data-types/index)) — Time when file segment finished downloading.
* `cache_hits` ([UInt64](/reference/data-types/index)) — Number of cache hits of corresponding file segment
* `references` ([UInt64](/reference/data-types/index)) — Number of references to corresponding file segment. Value 1 means that nobody uses it at the moment (the only existing reference is in cache storage itself)
* `downloaded_size` ([UInt64](/reference/data-types/index)) — Downloaded size of the file segment
* `kind` ([String](/reference/data-types/index)) — File segment kind (used to distinguish between file segments added as a part of 'Temporary data in cache')
* `unbound` ([UInt8](/reference/data-types/index)) — Internal implementation flag
* `user_id` ([String](/reference/data-types/index)) — User id of the user which created the file segment
* `segment_type` ([String](/reference/data-types/index)) — Type of the segment. Used to separate data files(`.json`, `.txt` and etc) from data file(`.bin`, mark files).
* `file_size` ([Nullable(UInt64)](/reference/data-types/index)) — File size of the file to which current file segment belongs