Skip to main content

system.caches

An overview of various caches being managed in Databend.

The table below shows the cache name, the number of items in the cache, and the size of the cache:

SELECT * FROM system.caches;
+--------------------------------+-----------+------+
| name | num_items | size |
+--------------------------------+-----------+------+
| table_snapshot_cache | 2 | 2 |
| table_snapshot_statistic_cache | 0 | 0 |
| segment_info_cache | 64 | 64 |
| bloom_index_filter_cache | 0 | 0 |
| bloom_index_meta_cache | 0 | 0 |
| prune_partitions_cache | 2 | 2 |
| file_meta_data_cache | 0 | 0 |
+--------------------------------+-----------+------+