Managing the Query Planner Cache (Preview)

Dremio 15.0.0 improves query performance by providing an in-memory cache for the query planner. Dremio stores query plans in the cache so that it doesn’t need to reproduce the query plan the next time it encounters that query. The feature is diabled by default. To enable the feature, set the planner.query_plan_cache.enabled support key to true. See Support Keys for instructions on setting support keys.

Setting Maximum Entries in the Cache

By default, the cache stores 1000 query plans. Dremio administrators may customize the maximum by setting the planner.plan_cache_max_entries support key to the desired value.

Setting Cache Expirations

By default, the cache expires after 10,000 minutes. Dremio administrators may customize the expirations by setting the planner.plan_cache_expiration_minutes support key to the desired value.

Setting a Memory Limit for the Cache

By default, the cache may use ??? MB of memory. Dremio administrators may customize this limit by setting the planner.plan_cache_memory_limits support key to the desired value.

Limitations

The query planner cache does not support Apache Iceberg and Hive tables.