Skip to content
DuckDB Extensions All extensions VGI

Maintenance functions in the VGI DuckDB extension

Function category

Maintenance

2 functions

Clear VGI's caches and pooled workers to force fresh state on the next call.

vgi_clear_cache

Table function Maintenance
Signature
vgi_clear_cache() → None
Returns

A table with the following columns:

Column Success Type BOOLEAN Description True when the caches were cleared.
Description

Clear cached catalog metadata (schemas, tables, functions, statistics) for all attached VGI catalogs, returning one row per catalog cleared. Forces the next query to re-fetch metadata from the worker.

1 Example 1 
SELECT * FROM vgi_clear_cache();

vgi_worker_pool_flush

Table function Maintenance
Signature
vgi_worker_pool_flush() → None
Returns

A table with the following columns:

Column flushed Type BIGINT Description Number of subprocess-pooled workers that were flushed.
Description

Clear all subprocess-pooled VGI workers, returning one row with the count of workers flushed. Has no effect on launch:/unix:// workers, which are pooled by the OS-level AF_UNIX socket rather than this process.

1 Example 1 
SELECT * FROM vgi_worker_pool_flush();