Skip to content

evict_expired

Remove expired cache entries.

Signature

semantic_cache.evict_expired() RETURNS bigint

Parameters

None

Returns

  • bigint: Number of expired entries removed

Description

Removes all cache entries where expires_at is in the past. Should be run regularly as part of maintenance.

Example

-- Remove all expired entries
SELECT semantic_cache.evict_expired();
-- Returns: 23 (23 expired entries removed)

Scheduling

-- Run every 15 minutes with pg_cron
SELECT cron.schedule(
    'cache-evict-expired',
    '*/15 * * * *',
    'SELECT semantic_cache.evict_expired()'
);

See Also