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]
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.