This extension provides a cache for query conditions, which is useful for repeated-query workloads like metrics monitoring dashboards, log investigations, etc.
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 | [] |