> ## 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 a history of all events occurred with filesystem cache for objects on a remote filesystem.
It is safe to truncate or drop this table at any time.

# system.filesystem_cache_log

Contains a history of all events occurred with filesystem cache for objects on a remote filesystem.

It is safe to truncate or drop this table at any time.

Columns:

* `hostname` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Hostname
* `event_date` ([Date](/reference/data-types/date)) — Event date
* `event_time` ([DateTime](/reference/data-types/datetime)) — Event time
* `query_id` ([String](/reference/data-types/string)) — Id of the query
* `source_file_path` ([String](/reference/data-types/string)) — File segment path on filesystem
* `file_segment_range` ([Tuple(UInt64, UInt64)](/reference/data-types/tuple)) — File segment range
* `total_requested_range` ([Tuple(UInt64, UInt64)](/reference/data-types/tuple)) — Full read range
* `key` ([String](/reference/data-types/string)) — File segment key
* `offset` ([UInt64](/reference/data-types/int-uint)) — File segment offset
* `size` ([UInt64](/reference/data-types/int-uint)) — Read size
* `read_type` ([String](/reference/data-types/string)) — Read type: READ\_FROM\_CACHE, READ\_FROM\_FS\_AND\_DOWNLOADED\_TO\_CACHE, READ\_FROM\_FS\_BYPASSING\_CACHE
* `read_from_cache_attempted` ([UInt8](/reference/data-types/int-uint)) — Whether reading from cache was attempted
* `read_buffer_id` ([String](/reference/data-types/string)) — Internal implementation read buffer id
* `user_id` ([String](/reference/data-types/string)) — User id of the user which created the file segment