What is cache_only_miss in the system activity History explore?

Knowledge Drop

Last tested: May 14, 2020

Looker has a feature that will fetch results from the cache if they existed before the page has fully loaded. If the cache only check does not find any results, we’ll mark that as a cache_only_miss.

If we do find things in the cache there will be a complete record with a results_source of cache.

If there is a miss (cache only miss) the queries will be executed again (without the cache only requirement) and the queries will be run from the database.