Name

freelist_count — Return number of free pages in database file

Common Usage

PRAGMA [database.]freelist_count;

Description

The freelist_count pragma returns a single integer indicating how many database pages are currently marked as free and available (contain no valid data). These pages can be recovered by vacuuming the database.

See Also

auto_vacuum, incremental_vacuum, VACUUM [SQL Cmd, Ap C]