Search Shortcut cmd + k | ctrl + k
query_condition_cache

This extension provides a cache for query conditions, which is useful for repeated-query workloads like metrics monitoring dashboards, log investigations, etc.

Maintainer(s): Andrewtangtang, peterxcli, dentiny

Installing and Loading

INSTALL query_condition_cache FROM community;
LOAD query_condition_cache;

Example

SELECT * FROM condition_cache_build('t', 'val = 42 AND msg LIKE ''%2''');

About query_condition_cache

This extension enhances DuckDB core capability and improves query performance for repeated-query workloads by caching the query conditions.

Added Functions

function_name function_type description comment examples
__condition_cache_filter scalar NULL NULL  
condition_cache_build table NULL NULL  
condition_cache_info table NULL NULL  

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

name description input_type scope aliases
use_query_condition_cache Enable automatic query condition cache build and apply BOOLEAN GLOBAL []