Skip to content

Instantly share code, notes, and snippets.

Created March 27, 2012 19:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/2219343 to your computer and use it in GitHub Desktop.
Save anonymous/2219343 to your computer and use it in GitHub Desktop.
> Integrity check
+ The database is sane
> Reindex
+ The database has been reindexed
> Orphans expiration
+ Database cleaned up
> Coherence check
+ The database is coherent
> Vacuum
Initial database size is 71680 KiB
+ The database has been vacuumed
Final database size is 71680 KiB
> Statistics
Database size is 71680 KiB
user_version is 19
page_size is 4096
cache_size is 1024
journal_mode is wal
synchronous is 1
History can store a maximum of 104858 unique pages
Table moz_bookmarks has 1566 records
Table moz_bookmarks_roots has 5 records
Table moz_keywords has 1 records
Table sqlite_sequence has 1 records
Table moz_favicons has 3541 records
Table moz_annos has 400 records
Table moz_anno_attributes has 13 records
Table moz_items_annos has 922 records
Table moz_places has 105050 records
Table moz_historyvisits has 163347 records
Table moz_inputhistory has 455 records
Table moz_hosts has 8291 records
Table sqlite_stat1 has 23 records
Index sqlite_autoindex_moz_bookmarks_roots_1
Index sqlite_autoindex_moz_keywords_1
Index sqlite_autoindex_moz_favicons_1
Index sqlite_autoindex_moz_anno_attributes_1
Index sqlite_autoindex_moz_inputhistory_1
Index sqlite_autoindex_moz_hosts_1
Index moz_bookmarks_itemindex
Index moz_bookmarks_parentindex
Index moz_bookmarks_itemlastmodifiedindex
Index moz_places_faviconindex
Index moz_places_hostindex
Index moz_places_visitcount
Index moz_places_frecencyindex
Index moz_historyvisits_placedateindex
Index moz_historyvisits_fromindex
Index moz_historyvisits_dateindex
Index moz_places_lastvisitdateindex
Index moz_annos_placeattributeindex
Index moz_items_annos_itemattributeindex
Index moz_places_url_uniqueindex
Index moz_bookmarks_guid_uniqueindex
Index moz_places_guid_uniqueindex
Index moz_favicons_guid_uniqueindex
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment