Skip to content

Instantly share code, notes, and snippets.

@bendk

bendk/dbsize.sql

Created June 23, 2022 14:52
Show Gist options
  • Save bendk/b59779155e9a751cf1177924d9af5a99 to your computer and use it in GitHub Desktop.
Save bendk/b59779155e9a751cf1177924d9af5a99 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dbsize.sql
/** Disk-Space Utilization Report For places.db
Page size in bytes................................ 32768
Pages in the whole file (measured)................ 82
Pages in the whole file (calculated).............. 82
Pages that store data............................. 82 100.0%
Pages on the freelist (per header)................ 0 0.0%
Pages on the freelist (calculated)................ 0 0.0%
Pages of auto-vacuum overhead..................... 0 0.0%
Number of tables in the database.................. 21
Number of indices................................. 26
Number of defined indices......................... 17
Number of implied indices......................... 9
Size of the file in bytes......................... 2686976
Bytes of user payload stored...................... 435112 16.2%
*** Page counts for all tables with their indices *****************************
MOZ_HISTORYVISITS................................. 27 32.9%
MOZ_PLACES........................................ 24 29.3%
MOZ_BOOKMARKS_SYNCED.............................. 4 4.9%
MOZ_BOOKMARKS..................................... 3 3.7%
MOZ_ORIGINS....................................... 3 3.7%
MOZ_HISTORYVISIT_TOMBSTONES....................... 2 2.4%
MOZ_INPUTHISTORY.................................. 2 2.4%
MOZ_KEYWORDS...................................... 2 2.4%
MOZ_PLACES_METADATA_SEARCH_QUERIES................ 2 2.4%
MOZ_TAGS.......................................... 2 2.4%
MOZ_BOOKMARKS_DELETED............................. 1 1.2%
MOZ_BOOKMARKS_SYNCED_STRUCTURE.................... 1 1.2%
MOZ_BOOKMARKS_SYNCED_TAG_RELATION................. 1 1.2%
MOZ_META.......................................... 1 1.2%
MOZ_PLACES_METADATA............................... 1 1.2%
MOZ_PLACES_STALE_FRECENCIES....................... 1 1.2%
MOZ_PLACES_TOMBSTONES............................. 1 1.2%
MOZ_TAGS_RELATION................................. 1 1.2%
SQLITE_SCHEMA..................................... 1 1.2%
SQLITE_STAT1...................................... 1 1.2%
SQLITE_STAT4...................................... 1 1.2%
*** Page counts for all tables and indices separately *************************
MOZ_PLACES........................................ 11 13.4%
MOZ_HISTORYVISITS................................. 6 7.3%
PLACEDATEINDEX.................................... 6 7.3%
DATEINDEX......................................... 5 6.1%
VISITS_FROM_TYPE_IDX.............................. 4 4.9%
FROMINDEX......................................... 3 3.7%
GUID_UNIQUEINDEX.................................. 3 3.7%
ISLOCALINDEX...................................... 3 3.7%
SQLITE_AUTOINDEX_MOZ_PLACES_1..................... 3 3.7%
FRECENCYINDEX..................................... 1 1.2%
HOSTINDEX......................................... 1 1.2%
ITEMLASTMODIFIEDINDEX............................. 1 1.2%
LASTVISITDATELOCALINDEX........................... 1 1.2%
LASTVISITDATEREMOTEINDEX.......................... 1 1.2%
MOZ_BOOKMARKS..................................... 1 1.2%
MOZ_BOOKMARKS_DELETED............................. 1 1.2%
MOZ_BOOKMARKS_SYNCED.............................. 1 1.2%
MOZ_BOOKMARKS_SYNCED_KEYWORDS..................... 1 1.2%
MOZ_BOOKMARKS_SYNCED_STRUCTURE.................... 1 1.2%
MOZ_BOOKMARKS_SYNCED_TAG_RELATION................. 1 1.2%
MOZ_BOOKMARKS_SYNCED_URLS......................... 1 1.2%
MOZ_HISTORYVISIT_TOMBSTONES....................... 1 1.2%
MOZ_INPUTHISTORY.................................. 1 1.2%
MOZ_KEYWORDS...................................... 1 1.2%
MOZ_META.......................................... 1 1.2%
MOZ_ORIGINS....................................... 1 1.2%
MOZ_PLACES_METADATA............................... 1 1.2%
MOZ_PLACES_METADATA_SEARCH_QUERIES................ 1 1.2%
MOZ_PLACES_STALE_FRECENCIES....................... 1 1.2%
MOZ_PLACES_TOMBSTONES............................. 1 1.2%
MOZ_TAGS.......................................... 1 1.2%
MOZ_TAGS_RELATION................................. 1 1.2%
ORIGINIDINDEX..................................... 1 1.2%
SQLITE_AUTOINDEX_MOZ_BOOKMARKS_1.................. 1 1.2%
SQLITE_AUTOINDEX_MOZ_BOOKMARKS_SYNCED_1........... 1 1.2%
SQLITE_AUTOINDEX_MOZ_HISTORYVISIT_TOMBSTONES_1.... 1 1.2%
SQLITE_AUTOINDEX_MOZ_INPUTHISTORY_1............... 1 1.2%
SQLITE_AUTOINDEX_MOZ_KEYWORDS_1................... 1 1.2%
SQLITE_AUTOINDEX_MOZ_ORIGINS_1.................... 1 1.2%
SQLITE_AUTOINDEX_MOZ_PLACES_METADATA_SEARCH_QUERIES_1 1 1.2%
SQLITE_AUTOINDEX_MOZ_TAGS_1....................... 1 1.2%
SQLITE_SCHEMA..................................... 1 1.2%
SQLITE_STAT1...................................... 1 1.2%
SQLITE_STAT4...................................... 1 1.2%
URL_HASHINDEX..................................... 1 1.2%
VISITCOUNTLOCAL................................... 1 1.2%
VISITCOUNTREMOTE.................................. 1 1.2%
*** All tables and indices ****************************************************
Percentage of total database...................... 100.0%
Number of entries................................. 66355
Bytes of storage consumed......................... 2686976
Bytes of payload.................................. 925037 34.4%
Bytes of metadata................................. 221427 8.2%
Average payload per entry......................... 13.94
Average unused bytes per entry.................... 23.22
Average metadata per entry........................ 3.34
Average fanout.................................... 6.00
Maximum payload per entry......................... 1301
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 9
Primary pages used................................ 73
Overflow pages used............................... 0
Total pages used.................................. 82
Unused bytes on index pages....................... 294463 99.85%
Unused bytes on primary pages..................... 1246049 52.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 1540512 57.3%
*** All tables ****************************************************************
Percentage of total database...................... 43.9%
Number of entries................................. 10418
Bytes of storage consumed......................... 1179648
Bytes of payload.................................. 445356 37.8%
Bytes of metadata................................. 53168 4.5%
Average payload per entry......................... 42.75
Average unused bytes per entry.................... 65.38
Average metadata per entry........................ 5.10
Average fanout.................................... 7.00
Maximum payload per entry......................... 1301
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 34
Overflow pages used............................... 0
Total pages used.................................. 36
Unused bytes on index pages....................... 65408 99.80%
Unused bytes on primary pages..................... 615716 55.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 681124 57.7%
*** All indices ***************************************************************
Percentage of total database...................... 56.1%
Number of entries................................. 55937
Bytes of storage consumed......................... 1507328
Bytes of payload.................................. 479681 31.8%
Bytes of metadata................................. 168259 11.2%
Average payload per entry......................... 8.58
Average unused bytes per entry.................... 15.36
Average metadata per entry........................ 3.01
Average fanout.................................... 6.00
Maximum payload per entry......................... 47
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 7
Primary pages used................................ 39
Overflow pages used............................... 0
Total pages used.................................. 46
Unused bytes on index pages....................... 229055 99.86%
Unused bytes on primary pages..................... 630333 49.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 859388 57.0%
*** Table MOZ_BOOKMARKS and all its indices ***********************************
Percentage of total database...................... 3.7%
Number of entries................................. 111
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 3822 3.9%
Bytes of metadata................................. 395 0.40%
Average payload per entry......................... 34.43
Average unused bytes per entry.................... 847.63
Average metadata per entry........................ 3.56
Maximum payload per entry......................... 137
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on primary pages..................... 94087 95.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 94087 95.7%
*** Table MOZ_BOOKMARKS w/o any indices ***************************************
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 2798 8.5%
Bytes of metadata................................. 157 0.48%
B-tree depth...................................... 1
Average payload per entry......................... 75.62
Average unused bytes per entry.................... 805.76
Average metadata per entry........................ 4.24
Maximum payload per entry......................... 137
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 29813 91.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 29813 91.0%
*** Indices of table MOZ_BOOKMARKS ********************************************
Percentage of total database...................... 2.4%
Number of entries................................. 74
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 1024 1.6%
Bytes of metadata................................. 238 0.36%
Average payload per entry......................... 13.84
Average unused bytes per entry.................... 868.57
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 16
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 64274 98.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 64274 98.1%
*** Index ITEMLASTMODIFIEDINDEX of table MOZ_BOOKMARKS ************************
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 433 1.3%
Bytes of metadata................................. 119 0.36%
B-tree depth...................................... 1
Average payload per entry......................... 11.70
Average unused bytes per entry.................... 870.70
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 12
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32216 98.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32216 98.3%
*** Index SQLITE_AUTOINDEX_MOZ_BOOKMARKS_1 of table MOZ_BOOKMARKS *************
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 591 1.8%
Bytes of metadata................................. 119 0.36%
B-tree depth...................................... 1
Average payload per entry......................... 15.97
Average unused bytes per entry.................... 866.43
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 16
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32058 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32058 97.8%
*** Table MOZ_BOOKMARKS_DELETED ***********************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_BOOKMARKS_SYNCED and all its indices ****************************
Percentage of total database...................... 4.9%
Number of entries................................. 112
Bytes of storage consumed......................... 131072
Bytes of payload.................................. 4130 3.2%
Bytes of metadata................................. 410 0.31%
Average payload per entry......................... 36.88
Average unused bytes per entry.................... 1129.75
Average metadata per entry........................ 3.66
Maximum payload per entry......................... 152
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 4
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on primary pages..................... 126532 96.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 126532 96.5%
*** Table MOZ_BOOKMARKS_SYNCED w/o any indices ********************************
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 3360 10.3%
Bytes of metadata................................. 161 0.49%
B-tree depth...................................... 1
Average payload per entry......................... 90.81
Average unused bytes per entry.................... 790.46
Average metadata per entry........................ 4.35
Maximum payload per entry......................... 152
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 29247 89.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 29247 89.3%
*** Indices of table MOZ_BOOKMARKS_SYNCED *************************************
Percentage of total database...................... 3.7%
Number of entries................................. 75
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 770 0.78%
Bytes of metadata................................. 249 0.25%
Average payload per entry......................... 10.27
Average unused bytes per entry.................... 1297.13
Average metadata per entry........................ 3.32
Maximum payload per entry......................... 16
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on primary pages..................... 97285 99.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 97285 99.0%
*** Index MOZ_BOOKMARKS_SYNCED_KEYWORDS of table MOZ_BOOKMARKS_SYNCED *********
Percentage of total database...................... 1.2%
Number of entries................................. 1
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 5 0.015%
Bytes of metadata................................. 11 0.034%
B-tree depth...................................... 1
Average payload per entry......................... 5.00
Average unused bytes per entry.................... 32752.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32752 99.951%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32752 99.951%
*** Index MOZ_BOOKMARKS_SYNCED_URLS of table MOZ_BOOKMARKS_SYNCED *************
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 174 0.53%
Bytes of metadata................................. 119 0.36%
B-tree depth...................................... 1
Average payload per entry......................... 4.70
Average unused bytes per entry.................... 877.70
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32475 99.11%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32475 99.11%
*** Index SQLITE_AUTOINDEX_MOZ_BOOKMARKS_SYNCED_1 of table MOZ_BOOKMARKS_SYNCED
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 591 1.8%
Bytes of metadata................................. 119 0.36%
B-tree depth...................................... 1
Average payload per entry......................... 15.97
Average unused bytes per entry.................... 866.43
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 16
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32058 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32058 97.8%
*** Table MOZ_BOOKMARKS_SYNCED_STRUCTURE **************************************
Percentage of total database...................... 1.2%
Number of entries................................. 37
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 1057 3.2%
Bytes of metadata................................. 119 0.36%
B-tree depth...................................... 1
Average payload per entry......................... 28.57
Average unused bytes per entry.................... 853.84
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 29
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 31592 96.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 31592 96.4%
*** Table MOZ_BOOKMARKS_SYNCED_TAG_RELATION ***********************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_HISTORYVISIT_TOMBSTONES and all its indices *********************
Percentage of total database...................... 2.4%
Number of entries................................. 0
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.024%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 65520 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 65520 99.976%
*** Table MOZ_HISTORYVISIT_TOMBSTONES w/o any indices *************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Index SQLITE_AUTOINDEX_MOZ_HISTORYVISIT_TOMBSTONES_1 of table MOZ_HISTORYVISIT_TOMBSTONES
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_HISTORYVISITS and all its indices *******************************
Percentage of total database...................... 32.9%
Number of entries................................. 48588
Bytes of storage consumed......................... 884736
Bytes of payload.................................. 455056 51.4%
Bytes of metadata................................. 162149 18.3%
Average payload per entry......................... 9.37
Average unused bytes per entry.................... 5.51
Average metadata per entry........................ 3.34
Average fanout.................................... 4.00
Maximum payload per entry......................... 16
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 6
Primary pages used................................ 21
Overflow pages used............................... 0
Total pages used.................................. 27
Unused bytes on index pages....................... 196315 99.85%
Unused bytes on primary pages..................... 71216 10.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 267531 30.2%
*** Table MOZ_HISTORYVISITS w/o any indices ***********************************
Percentage of total database...................... 7.3%
Number of entries................................. 8098
Bytes of storage consumed......................... 196608
Bytes of payload.................................. 122574 62.3%
Bytes of metadata................................. 40447 20.6%
B-tree depth...................................... 2
Average payload per entry......................... 15.14
Average unused bytes per entry.................... 4.15
Average metadata per entry........................ 4.99
Average fanout.................................... 5.00
Non-sequential pages.............................. 4 80.0%
Maximum payload per entry......................... 16
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 5
Overflow pages used............................... 0
Total pages used.................................. 6
Unused bytes on index pages....................... 32724 99.87%
Unused bytes on primary pages..................... 863 0.53%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 33587 17.1%
*** Indices of table MOZ_HISTORYVISITS ****************************************
Percentage of total database...................... 25.6%
Number of entries................................. 40490
Bytes of storage consumed......................... 688128
Bytes of payload.................................. 332482 48.3%
Bytes of metadata................................. 121702 17.7%
Average payload per entry......................... 8.21
Average unused bytes per entry.................... 5.78
Average metadata per entry........................ 3.01
Average fanout.................................... 4.00
Maximum payload per entry......................... 14
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 5
Primary pages used................................ 16
Overflow pages used............................... 0
Total pages used.................................. 21
Unused bytes on index pages....................... 163591 99.85%
Unused bytes on primary pages..................... 70353 13.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 233944 34.0%
*** Index DATEINDEX of table MOZ_HISTORYVISITS ********************************
Percentage of total database...................... 6.1%
Number of entries................................. 8098
Bytes of storage consumed......................... 163840
Bytes of payload.................................. 88950 54.3%
Bytes of metadata................................. 24350 14.9%
B-tree depth...................................... 2
Average payload per entry......................... 10.98
Average unused bytes per entry.................... 6.24
Average metadata per entry........................ 3.01
Average fanout.................................... 5.00
Non-sequential pages.............................. 3 75.0%
Maximum payload per entry......................... 11
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 4
Overflow pages used............................... 0
Total pages used.................................. 5
Unused bytes on index pages....................... 32702 99.80%
Unused bytes on primary pages..................... 17838 13.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 50540 30.8%
*** Index FROMINDEX of table MOZ_HISTORYVISITS ********************************
Percentage of total database...................... 3.7%
Number of entries................................. 8098
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 40362 41.1%
Bytes of metadata................................. 24326 24.7%
B-tree depth...................................... 2
Average payload per entry......................... 4.98
Average unused bytes per entry.................... 4.15
Average metadata per entry........................ 3.00
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 32744 99.927%
Unused bytes on primary pages..................... 872 1.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 33616 34.2%
*** Index ISLOCALINDEX of table MOZ_HISTORYVISITS *****************************
Percentage of total database...................... 3.7%
Number of entries................................. 8098
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 40362 41.1%
Bytes of metadata................................. 24326 24.7%
B-tree depth...................................... 2
Average payload per entry......................... 4.98
Average unused bytes per entry.................... 4.15
Average metadata per entry........................ 3.00
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 32744 99.927%
Unused bytes on primary pages..................... 872 1.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 33616 34.2%
*** Index PLACEDATEINDEX of table MOZ_HISTORYVISITS ***************************
Percentage of total database...................... 7.3%
Number of entries................................. 8098
Bytes of storage consumed......................... 196608
Bytes of payload.................................. 112538 57.2%
Bytes of metadata................................. 24362 12.4%
B-tree depth...................................... 2
Average payload per entry......................... 13.90
Average unused bytes per entry.................... 7.37
Average metadata per entry........................ 3.01
Average fanout.................................... 6.00
Non-sequential pages.............................. 4 80.0%
Maximum payload per entry......................... 14
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 5
Overflow pages used............................... 0
Total pages used.................................. 6
Unused bytes on index pages....................... 32672 99.71%
Unused bytes on primary pages..................... 27036 16.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 59708 30.4%
*** Index VISITS_FROM_TYPE_IDX of table MOZ_HISTORYVISITS *********************
Percentage of total database...................... 4.9%
Number of entries................................. 8098
Bytes of storage consumed......................... 131072
Bytes of payload.................................. 50270 38.4%
Bytes of metadata................................. 24338 18.6%
B-tree depth...................................... 2
Average payload per entry......................... 6.21
Average unused bytes per entry.................... 6.97
Average metadata per entry........................ 3.01
Average fanout.................................... 4.00
Non-sequential pages.............................. 2 66.7%
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 32729 99.88%
Unused bytes on primary pages..................... 23735 24.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 56464 43.1%
*** Table MOZ_INPUTHISTORY and all its indices ********************************
Percentage of total database...................... 2.4%
Number of entries................................. 0
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.024%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 65520 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 65520 99.976%
*** Table MOZ_INPUTHISTORY w/o any indices ************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Index SQLITE_AUTOINDEX_MOZ_INPUTHISTORY_1 of table MOZ_INPUTHISTORY *******
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_KEYWORDS and all its indices ************************************
Percentage of total database...................... 2.4%
Number of entries................................. 2
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 9 0.014%
Bytes of metadata................................. 23 0.035%
Average payload per entry......................... 4.50
Average unused bytes per entry.................... 32752.00
Average metadata per entry........................ 11.50
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 65504 99.951%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 65504 99.951%
*** Table MOZ_KEYWORDS w/o any indices ****************************************
Percentage of total database...................... 1.2%
Number of entries................................. 1
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 4 0.012%
Bytes of metadata................................. 12 0.037%
B-tree depth...................................... 1
Average payload per entry......................... 4.00
Average unused bytes per entry.................... 32752.00
Average metadata per entry........................ 12.00
Maximum payload per entry......................... 4
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32752 99.951%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32752 99.951%
*** Index SQLITE_AUTOINDEX_MOZ_KEYWORDS_1 of table MOZ_KEYWORDS ***************
Percentage of total database...................... 1.2%
Number of entries................................. 1
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 5 0.015%
Bytes of metadata................................. 11 0.034%
B-tree depth...................................... 1
Average payload per entry......................... 5.00
Average unused bytes per entry.................... 32752.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32752 99.951%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32752 99.951%
*** Table MOZ_META ************************************************************
Percentage of total database...................... 1.2%
Number of entries................................. 9
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 291 0.89%
Bytes of metadata................................. 35 0.11%
B-tree depth...................................... 1
Average payload per entry......................... 32.33
Average unused bytes per entry.................... 3604.67
Average metadata per entry........................ 3.89
Maximum payload per entry......................... 39
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32442 99.01%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32442 99.01%
*** Table MOZ_ORIGINS and all its indices *************************************
Percentage of total database...................... 3.7%
Number of entries................................. 252
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 8907 9.1%
Bytes of metadata................................. 864 0.88%
Average payload per entry......................... 35.35
Average unused bytes per entry.................... 351.32
Average metadata per entry........................ 3.43
Maximum payload per entry......................... 85
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on primary pages..................... 88533 90.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 88533 90.1%
*** Table MOZ_ORIGINS w/o any indices *****************************************
Percentage of total database...................... 1.2%
Number of entries................................. 84
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 4414 13.5%
Bytes of metadata................................. 344 1.0%
B-tree depth...................................... 1
Average payload per entry......................... 52.55
Average unused bytes per entry.................... 333.45
Average metadata per entry........................ 4.10
Maximum payload per entry......................... 85
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 28010 85.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 28010 85.5%
*** Indices of table MOZ_ORIGINS **********************************************
Percentage of total database...................... 2.4%
Number of entries................................. 168
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 4493 6.9%
Bytes of metadata................................. 520 0.79%
Average payload per entry......................... 26.74
Average unused bytes per entry.................... 360.26
Average metadata per entry........................ 3.10
Maximum payload per entry......................... 47
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 60523 92.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 60523 92.4%
*** Index HOSTINDEX of table MOZ_ORIGINS **************************************
Percentage of total database...................... 1.2%
Number of entries................................. 84
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 1913 5.8%
Bytes of metadata................................. 260 0.79%
B-tree depth...................................... 1
Average payload per entry......................... 22.77
Average unused bytes per entry.................... 364.23
Average metadata per entry........................ 3.10
Maximum payload per entry......................... 39
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 30595 93.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 30595 93.4%
*** Index SQLITE_AUTOINDEX_MOZ_ORIGINS_1 of table MOZ_ORIGINS *****************
Percentage of total database...................... 1.2%
Number of entries................................. 84
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 2580 7.9%
Bytes of metadata................................. 260 0.79%
B-tree depth...................................... 1
Average payload per entry......................... 30.71
Average unused bytes per entry.................... 356.29
Average metadata per entry........................ 3.10
Maximum payload per entry......................... 47
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 29928 91.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 29928 91.3%
*** Table MOZ_PLACES and all its indices **************************************
Percentage of total database...................... 29.3%
Number of entries................................. 16810
Bytes of storage consumed......................... 786432
Bytes of payload.................................. 414815 52.7%
Bytes of metadata................................. 55199 7.0%
Average payload per entry......................... 24.68
Average unused bytes per entry.................... 18.82
Average metadata per entry........................ 3.28
Average fanout.................................... 7.00
Maximum payload per entry......................... 745
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 3
Primary pages used................................ 21
Overflow pages used............................... 0
Total pages used.................................. 24
Unused bytes on index pages....................... 98148 99.84%
Unused bytes on primary pages..................... 218270 31.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 316418 40.2%
*** Table MOZ_PLACES w/o any indices ******************************************
Percentage of total database...................... 13.4%
Number of entries................................. 1681
Bytes of storage consumed......................... 360448
Bytes of payload.................................. 273908 76.0%
Bytes of metadata................................. 9692 2.7%
B-tree depth...................................... 2
Average payload per entry......................... 162.94
Average unused bytes per entry.................... 45.72
Average metadata per entry........................ 5.77
Average fanout.................................... 10.00
Non-sequential pages.............................. 9 90.0%
Maximum payload per entry......................... 745
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 10
Overflow pages used............................... 0
Total pages used.................................. 11
Unused bytes on index pages....................... 32684 99.74%
Unused bytes on primary pages..................... 44164 13.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 76848 21.3%
*** Indices of table MOZ_PLACES ***********************************************
Percentage of total database...................... 15.9%
Number of entries................................. 15129
Bytes of storage consumed......................... 425984
Bytes of payload.................................. 140907 33.1%
Bytes of metadata................................. 45507 10.7%
Average payload per entry......................... 9.31
Average unused bytes per entry.................... 15.84
Average metadata per entry........................ 3.01
Average fanout.................................... 6.00
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 11
Overflow pages used............................... 0
Total pages used.................................. 13
Unused bytes on index pages....................... 65464 99.89%
Unused bytes on primary pages..................... 174106 48.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 239570 56.2%
*** Index FRECENCYINDEX of table MOZ_PLACES ***********************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 11557 35.3%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 6.88
Average unused bytes per entry.................... 9.61
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 8
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 16160 49.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 16160 49.3%
*** Index GUID_UNIQUEINDEX of table MOZ_PLACES ********************************
Percentage of total database...................... 3.7%
Number of entries................................. 1681
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 28449 28.9%
Bytes of metadata................................. 5075 5.2%
B-tree depth...................................... 2
Average payload per entry......................... 16.92
Average unused bytes per entry.................... 38.54
Average metadata per entry........................ 3.02
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 32732 99.89%
Unused bytes on primary pages..................... 32048 48.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 64780 65.9%
*** Index LASTVISITDATELOCALINDEX of table MOZ_PLACES *************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 8277 25.3%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 4.92
Average unused bytes per entry.................... 11.56
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 19440 59.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 19440 59.3%
*** Index LASTVISITDATEREMOTEINDEX of table MOZ_PLACES ************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 18261 55.7%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 10.86
Average unused bytes per entry.................... 5.63
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 11
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 9456 28.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 9456 28.9%
*** Index ORIGINIDINDEX of table MOZ_PLACES ***********************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 9885 30.2%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 5.88
Average unused bytes per entry.................... 10.61
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 6
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 17832 54.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 17832 54.4%
*** Index SQLITE_AUTOINDEX_MOZ_PLACES_1 of table MOZ_PLACES *******************
Percentage of total database...................... 3.7%
Number of entries................................. 1681
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 28449 28.9%
Bytes of metadata................................. 5075 5.2%
B-tree depth...................................... 2
Average payload per entry......................... 16.92
Average unused bytes per entry.................... 38.54
Average metadata per entry........................ 3.02
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 32732 99.89%
Unused bytes on primary pages..................... 32048 48.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 64780 65.9%
*** Index URL_HASHINDEX of table MOZ_PLACES ***********************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 18363 56.0%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 10.92
Average unused bytes per entry.................... 5.56
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 11
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 9354 28.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 9354 28.5%
*** Index VISITCOUNTLOCAL of table MOZ_PLACES *********************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 8277 25.3%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 4.92
Average unused bytes per entry.................... 11.56
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 19440 59.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 19440 59.3%
*** Index VISITCOUNTREMOTE of table MOZ_PLACES ********************************
Percentage of total database...................... 1.2%
Number of entries................................. 1681
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 9389 28.7%
Bytes of metadata................................. 5051 15.4%
B-tree depth...................................... 1
Average payload per entry......................... 5.59
Average unused bytes per entry.................... 10.90
Average metadata per entry........................ 3.00
Maximum payload per entry......................... 6
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 18328 55.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 18328 55.9%
*** Table MOZ_PLACES_METADATA *************************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_PLACES_METADATA_SEARCH_QUERIES and all its indices **************
Percentage of total database...................... 2.4%
Number of entries................................. 0
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.024%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 65520 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 65520 99.976%
*** Table MOZ_PLACES_METADATA_SEARCH_QUERIES w/o any indices ******************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Index SQLITE_AUTOINDEX_MOZ_PLACES_METADATA_SEARCH_QUERIES_1 of table MOZ_PLACES_METADATA_SEARCH_QUERIES
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_PLACES_STALE_FRECENCIES *****************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_PLACES_TOMBSTONES ***********************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_TAGS and all its indices ****************************************
Percentage of total database...................... 2.4%
Number of entries................................. 0
Bytes of storage consumed......................... 65536
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.024%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 65520 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 65520 99.976%
*** Table MOZ_TAGS w/o any indices ********************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Index SQLITE_AUTOINDEX_MOZ_TAGS_1 of table MOZ_TAGS ***********************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table MOZ_TAGS_RELATION ***************************************************
Percentage of total database...................... 1.2%
Number of entries................................. 0
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.024%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 32760 99.976%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 32760 99.976%
*** Table SQLITE_SCHEMA *******************************************************
Percentage of total database...................... 1.2%
Number of entries................................. 46
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 10244 31.3%
Bytes of metadata................................. 312 0.95%
B-tree depth...................................... 1
Average payload per entry......................... 222.70
Average unused bytes per entry.................... 482.87
Average metadata per entry........................ 6.78
Maximum payload per entry......................... 1301
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 22212 67.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 22212 67.8%
*** Table SQLITE_STAT1 ********************************************************
Percentage of total database...................... 1.2%
Number of entries................................. 20
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 908 2.8%
Bytes of metadata................................. 88 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 45.40
Average unused bytes per entry.................... 1588.60
Average metadata per entry........................ 4.40
Maximum payload per entry......................... 70
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 31772 97.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 31772 97.0%
*** Table SQLITE_STAT4 ********************************************************
Percentage of total database...................... 1.2%
Number of entries................................. 368
Bytes of storage consumed......................... 32768
Bytes of payload.................................. 25798 78.7%
Bytes of metadata................................. 1721 5.3%
B-tree depth...................................... 1
Average payload per entry......................... 70.10
Average unused bytes per entry.................... 14.26
Average metadata per entry........................ 4.68
Maximum payload per entry......................... 107
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 5249 16.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5249 16.0%
*** Definitions ***************************************************************
Page size in bytes
The number of bytes in a single page of the database file.
Usually 1024.
Number of pages in the whole file
The number of 32768-byte pages that go into forming the complete
database
Pages that store data
The number of pages that store data, either as primary B*Tree pages or
as overflow pages. The number at the right is the data pages divided by
the total number of pages in the file.
Pages on the freelist
The number of pages that are not currently in use but are reserved for
future use. The percentage at the right is the number of freelist pages
divided by the total number of pages in the file.
Pages of auto-vacuum overhead
The number of pages that store data used by the database to facilitate
auto-vacuum. This is zero for databases that do not support auto-vacuum.
Number of tables in the database
The number of tables in the database, including the SQLITE_MASTER table
used to store schema information.
Number of indices
The total number of indices in the database.
Number of defined indices
The number of indices created using an explicit CREATE INDEX statement.
Number of implied indices
The number of indices used to implement PRIMARY KEY or UNIQUE constraints
on tables.
Size of the file in bytes
The total amount of disk space used by the entire database files.
Bytes of user payload stored
The total number of bytes of user payload stored in the database. The
schema information in the SQLITE_MASTER table is not counted when
computing this number. The percentage at the right shows the payload
divided by the total file size.
Percentage of total database
The amount of the complete database file that is devoted to storing
information described by this category.
Number of entries
The total number of B-Tree key/value pairs stored under this category.
Bytes of storage consumed
The total amount of disk space required to store all B-Tree entries
under this category. The is the total number of pages used times
the pages size.
Bytes of payload
The amount of payload stored under this category. Payload is the data
part of table entries and the key part of index entries. The percentage
at the right is the bytes of payload divided by the bytes of storage
consumed.
Bytes of metadata
The amount of formatting and structural information stored in the
table or index. Metadata includes the btree page header, the cell pointer
array, the size field for each cell, the left child pointer or non-leaf
cells, the overflow pointers for overflow cells, and the rowid value for
rowid table cells. In other words, metadata is everything that is neither
unused space nor content. The record header in the payload is counted as
content, not metadata.
Average payload per entry
The average amount of payload on each entry. This is just the bytes of
payload divided by the number of entries.
Average unused bytes per entry
The average amount of free space remaining on all pages under this
category on a per-entry basis. This is the number of unused bytes on
all pages divided by the number of entries.
Non-sequential pages
The number of pages in the table or index that are out of sequence.
Many filesystems are optimized for sequential file access so a small
number of non-sequential pages might result in faster queries,
especially for larger database files that do not fit in the disk cache.
Note that after running VACUUM, the root page of each table or index is
at the beginning of the database file and all other pages are in a
separate part of the database file, resulting in a single non-
sequential page.
Maximum payload per entry
The largest payload size of any entry.
Entries that use overflow
The number of entries that user one or more overflow pages.
Total pages used
This is the number of pages used to hold all information in the current
category. This is the sum of index, primary, and overflow pages.
Index pages used
This is the number of pages in a table B-tree that hold only key (rowid)
information and no data.
Primary pages used
This is the number of B-tree pages that hold both key and data.
Overflow pages used
The total number of overflow pages used for this category.
Unused bytes on index pages
The total number of bytes of unused space on all index pages. The
percentage at the right is the number of unused bytes divided by the
total number of bytes on index pages.
Unused bytes on primary pages
The total number of bytes of unused space on all primary pages. The
percentage at the right is the number of unused bytes divided by the
total number of bytes on primary pages.
Unused bytes on overflow pages
The total number of bytes of unused space on all overflow pages. The
percentage at the right is the number of unused bytes divided by the
total number of bytes on overflow pages.
Unused bytes on all pages
The total number of bytes of unused space on all primary and overflow
pages. The percentage at the right is the number of unused bytes
divided by the total number of bytes.
*******************************************************************************
The entire text of this report can be sourced into any SQL database
engine for further analysis. All of the text above is an SQL comment.
The data used to generate this report follows:
*/
BEGIN;
CREATE TABLE space_used(
name clob, -- Name of a table or index in the database file
tblname clob, -- Name of associated table
is_index boolean, -- TRUE if it is an index, false for a table
is_without_rowid boolean, -- TRUE if WITHOUT ROWID table
nentry int, -- Number of entries in the BTree
leaf_entries int, -- Number of leaf entries
depth int, -- Depth of the b-tree
payload int, -- Total amount of data stored in this table or index
ovfl_payload int, -- Total amount of data stored on overflow pages
ovfl_cnt int, -- Number of entries that use overflow
mx_payload int, -- Maximum payload size
int_pages int, -- Number of interior pages used
leaf_pages int, -- Number of leaf pages used
ovfl_pages int, -- Number of overflow pages used
int_unused int, -- Number of unused bytes on interior pages
leaf_unused int, -- Number of unused bytes on primary pages
ovfl_unused int, -- Number of unused bytes on overflow pages
gap_cnt int, -- Number of gaps in the page layout
compressed_size int -- Total bytes stored on disk
);
INSERT INTO space_used VALUES('sqlite_schema','sqlite_schema',0,0,46,46,1,10244,0,0,1301,0,1,0,0,22212,0,0,32768);
INSERT INTO space_used VALUES('moz_places','moz_places',0,0,1690,1681,2,273908,0,0,745,1,10,0,32684,44164,0,9,360448);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_places_1','moz_places',1,0,1681,1680,2,28449,0,0,17,1,2,0,32732,32048,0,1,98304);
INSERT INTO space_used VALUES('url_hashindex','moz_places',1,0,1681,1681,1,18363,0,0,11,0,1,0,0,9354,0,0,32768);
INSERT INTO space_used VALUES('visitcountlocal','moz_places',1,0,1681,1681,1,8277,0,0,5,0,1,0,0,19440,0,0,32768);
INSERT INTO space_used VALUES('visitcountremote','moz_places',1,0,1681,1681,1,9389,0,0,6,0,1,0,0,18328,0,0,32768);
INSERT INTO space_used VALUES('frecencyindex','moz_places',1,0,1681,1681,1,11557,0,0,8,0,1,0,0,16160,0,0,32768);
INSERT INTO space_used VALUES('lastvisitdatelocalindex','moz_places',1,0,1681,1681,1,8277,0,0,5,0,1,0,0,19440,0,0,32768);
INSERT INTO space_used VALUES('lastvisitdateremoteindex','moz_places',1,0,1681,1681,1,18261,0,0,11,0,1,0,0,9456,0,0,32768);
INSERT INTO space_used VALUES('guid_uniqueindex','moz_places',1,0,1681,1680,2,28449,0,0,17,1,2,0,32732,32048,0,1,98304);
INSERT INTO space_used VALUES('originidindex','moz_places',1,0,1681,1681,1,9885,0,0,6,0,1,0,0,17832,0,0,32768);
INSERT INTO space_used VALUES('moz_places_tombstones','moz_places_tombstones',0,1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_places_stale_frecencies','moz_places_stale_frecencies',0,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_historyvisits','moz_historyvisits',0,0,8102,8098,2,122574,0,0,16,1,5,0,32724,863,0,4,196608);
INSERT INTO space_used VALUES('placedateindex','moz_historyvisits',1,0,8098,8094,2,112538,0,0,14,1,5,0,32672,27036,0,4,196608);
INSERT INTO space_used VALUES('fromindex','moz_historyvisits',1,0,8098,8097,2,40362,0,0,5,1,2,0,32744,872,0,1,98304);
INSERT INTO space_used VALUES('dateindex','moz_historyvisits',1,0,8098,8095,2,88950,0,0,11,1,4,0,32702,17838,0,3,163840);
INSERT INTO space_used VALUES('islocalindex','moz_historyvisits',1,0,8098,8097,2,40362,0,0,5,1,2,0,32744,872,0,1,98304);
INSERT INTO space_used VALUES('visits_from_type_idx','moz_historyvisits',1,0,8098,8096,2,50270,0,0,7,1,3,0,32729,23735,0,2,131072);
INSERT INTO space_used VALUES('moz_historyvisit_tombstones','moz_historyvisit_tombstones',0,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_historyvisit_tombstones_1','moz_historyvisit_tombstones',1,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_inputhistory','moz_inputhistory',0,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_inputhistory_1','moz_inputhistory',1,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks','moz_bookmarks',0,0,37,37,1,2798,0,0,137,0,1,0,0,29813,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_bookmarks_1','moz_bookmarks',1,0,37,37,1,591,0,0,16,0,1,0,0,32058,0,0,32768);
INSERT INTO space_used VALUES('itemlastmodifiedindex','moz_bookmarks',1,0,37,37,1,433,0,0,12,0,1,0,0,32216,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks_deleted','moz_bookmarks_deleted',0,1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_origins','moz_origins',0,0,84,84,1,4414,0,0,85,0,1,0,0,28010,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_origins_1','moz_origins',1,0,84,84,1,2580,0,0,47,0,1,0,0,29928,0,0,32768);
INSERT INTO space_used VALUES('hostindex','moz_origins',1,0,84,84,1,1913,0,0,39,0,1,0,0,30595,0,0,32768);
INSERT INTO space_used VALUES('moz_meta','moz_meta',0,1,9,9,1,291,0,0,39,0,1,0,0,32442,0,0,32768);
INSERT INTO space_used VALUES('moz_tags','moz_tags',0,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_tags_1','moz_tags',1,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_tags_relation','moz_tags_relation',0,1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks_synced','moz_bookmarks_synced',0,0,37,37,1,3360,0,0,152,0,1,0,0,29247,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_bookmarks_synced_1','moz_bookmarks_synced',1,0,37,37,1,591,0,0,16,0,1,0,0,32058,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks_synced_urls','moz_bookmarks_synced',1,0,37,37,1,174,0,0,5,0,1,0,0,32475,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks_synced_keywords','moz_bookmarks_synced',1,0,1,1,1,5,0,0,5,0,1,0,0,32752,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks_synced_structure','moz_bookmarks_synced_structure',0,1,37,37,1,1057,0,0,29,0,1,0,0,31592,0,0,32768);
INSERT INTO space_used VALUES('moz_bookmarks_synced_tag_relation','moz_bookmarks_synced_tag_relation',0,1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_keywords','moz_keywords',0,0,1,1,1,4,0,0,4,0,1,0,0,32752,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_keywords_1','moz_keywords',1,0,1,1,1,5,0,0,5,0,1,0,0,32752,0,0,32768);
INSERT INTO space_used VALUES('moz_places_metadata','moz_places_metadata',0,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('moz_places_metadata_search_queries','moz_places_metadata_search_queries',0,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('sqlite_autoindex_moz_places_metadata_search_queries_1','moz_places_metadata_search_queries',1,0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768);
INSERT INTO space_used VALUES('sqlite_stat1','sqlite_stat1',0,0,20,20,1,908,0,0,70,0,1,0,0,31772,0,0,32768);
INSERT INTO space_used VALUES('sqlite_stat4','sqlite_stat4',0,0,368,368,1,25798,0,0,107,0,1,0,0,5249,0,0,32768);
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment