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.