freelistCount

Queries the number of unused pages in the database file's freelist.

This read-only pragma returns an integer representing the total number of pages on the database freelist. These are pages that were once used to store data but have since been deallocated and are now available for reuse. A large number of freelist pages might indicate that running the VACUUM command could shrink the database file.

This pragma is only a query and cannot be set.

See also