to get the total pages count: PRAGMA PAGE_COUNT; to get the free pages count before running the Vacuum: PRAGMA freelist_count; to run the vacuum query : VACUUM;