diff options
Diffstat (limited to 'www/sqlanalyze.html')
| -rw-r--r-- | www/sqlanalyze.html | 1538 |
1 files changed, 1538 insertions, 0 deletions
diff --git a/www/sqlanalyze.html b/www/sqlanalyze.html new file mode 100644 index 0000000..9643f24 --- /dev/null +++ b/www/sqlanalyze.html @@ -0,0 +1,1538 @@ +<!DOCTYPE html> +<html><head> +<meta name="viewport" content="width=device-width, initial-scale=1.0"> +<meta http-equiv="content-type" content="text/html; charset=UTF-8"> +<link href="sqlite.css" rel="stylesheet"> +<title>The sqlite3_analyzer.exe Utility Program</title> +<!-- path= --> +</head> +<body> +<div class=nosearch> +<a href="index.html"> +<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite" border="0"> +</a> +<div><!-- IE hack to prevent disappearing logo --></div> +<div class="tagline desktoponly"> +Small. Fast. Reliable.<br>Choose any three. +</div> +<div class="menu mainmenu"> +<ul> +<li><a href="index.html">Home</a> +<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a> +<li class='wideonly'><a href='about.html'>About</a> +<li class='desktoponly'><a href="docs.html">Documentation</a> +<li class='desktoponly'><a href="download.html">Download</a> +<li class='wideonly'><a href='copyright.html'>License</a> +<li class='desktoponly'><a href="support.html">Support</a> +<li class='desktoponly'><a href="prosupport.html">Purchase</a> +<li class='search' id='search_menubutton'> +<a href="javascript:void(0)" onclick='toggle_search()'>Search</a> +</ul> +</div> +<div class="menu submenu" id="submenu"> +<ul> +<li><a href='about.html'>About</a> +<li><a href='docs.html'>Documentation</a> +<li><a href='download.html'>Download</a> +<li><a href='support.html'>Support</a> +<li><a href='prosupport.html'>Purchase</a> +</ul> +</div> +<div class="searchmenu" id="searchmenu"> +<form method="GET" action="search"> +<select name="s" id="searchtype"> +<option value="d">Search Documentation</option> +<option value="c">Search Changelog</option> +</select> +<input type="text" name="q" id="searchbox" value=""> +<input type="submit" value="Go"> +</form> +</div> +</div> +<script> +function toggle_div(nm) { +var w = document.getElementById(nm); +if( w.style.display=="block" ){ +w.style.display = "none"; +}else{ +w.style.display = "block"; +} +} +function toggle_search() { +var w = document.getElementById("searchmenu"); +if( w.style.display=="block" ){ +w.style.display = "none"; +} else { +w.style.display = "block"; +setTimeout(function(){ +document.getElementById("searchbox").focus() +}, 30); +} +} +function div_off(nm){document.getElementById(nm).style.display="none";} +window.onbeforeunload = function(e){div_off("submenu");} +/* Disable the Search feature if we are not operating from CGI, since */ +/* Search is accomplished using CGI and will not work without it. */ +if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){ +document.getElementById("search_menubutton").style.display = "none"; +} +/* Used by the Hide/Show button beside syntax diagrams, to toggle the */ +function hideorshow(btn,obj){ +var x = document.getElementById(obj); +var b = document.getElementById(btn); +if( x.style.display!='none' ){ +x.style.display = 'none'; +b.innerHTML='show'; +}else{ +x.style.display = ''; +b.innerHTML='hide'; +} +return false; +} +var antiRobot = 0; +function antiRobotGo(){ +if( antiRobot!=3 ) return; +antiRobot = 7; +var j = document.getElementById("mtimelink"); +if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href"); +} +function antiRobotDefense(){ +document.body.onmousedown=function(){ +antiRobot |= 2; +antiRobotGo(); +document.body.onmousedown=null; +} +document.body.onmousemove=function(){ +antiRobot |= 2; +antiRobotGo(); +document.body.onmousemove=null; +} +setTimeout(function(){ +antiRobot |= 1; +antiRobotGo(); +}, 100) +antiRobotGo(); +} +antiRobotDefense(); +</script> +<div class=fancy> +<div class=nosearch> +<div class="fancy_title"> +The sqlite3_analyzer.exe Utility Program +</div> +<div class="fancy_toc"> +<a onclick="toggle_toc()"> +<span class="fancy_toc_mark" id="toc_mk">►</span> +Table Of Contents +</a> +<div id="toc_sub"><div class="fancy-toc1"><a href="#the_sqlite3_analyzer_exe_utility_program">1. The sqlite3_analyzer.exe Utility Program</a></div> +<div class="fancy-toc2"><a href="#implementation">1.1. Implementation</a></div> +<div class="fancy-toc2"><a href="#example_output">1.2. Example Output</a></div> +</div> +</div> +<script> +function toggle_toc(){ +var sub = document.getElementById("toc_sub") +var mk = document.getElementById("toc_mk") +if( sub.style.display!="block" ){ +sub.style.display = "block"; +mk.innerHTML = "▼"; +} else { +sub.style.display = "none"; +mk.innerHTML = "►"; +} +} +</script> +</div> + + + +<h1 id="the_sqlite3_analyzer_exe_utility_program"><span>1. </span>The sqlite3_analyzer.exe Utility Program</h1> + +<p> +The <tt>sqlite3_analyzer.exe</tt> binary is a command-line utility program +that measures and displays how much and how efficiently space is used by +individual tables and indexes with an SQLite database file. +Example usage: + +</p><blockquote><pre> +sqlite3_analyzer database.sqlite +</pre></blockquote> + +<p> +The output is a human-readable ASCII text report that provides information +on the space utilization of the database file. The report is intended to +be self-explanatory, though there is some +<a href="sqlanalyze.html#defs">additional explanation</a> of the +various parameters reported toward the end of the report. + +</p><p> +The output is also valid SQL. Most of the report text is contained within +a header comment, with various SQL statements that create and initialize +a database at the +<a href="sqlanalyze.html#sqlx">end of the report</a>. The constructed database contains +the raw data from which the report was extracted. Hence the original +report can be read into an instance of the <a href="cli.html">command-line shell</a> and then +the raw data can be queried to dig deeper into the space utilization of +a particular database file. + +</p><h2 id="implementation"><span>1.1. </span>Implementation</h2> + +<p> +The <tt>sqlite3_analyzer.exe</tt> program is a +<a href="http://www.tcl.tk/">TCL</a> program that uses the <a href="dbstat.html">dbstat virtual table</a> +to gather information about the database file and then format that +information neatly. +</p> + + +<h2 id="example_output"><span>1.2. </span>Example Output</h2> + +<p>The following is sqlite3_analyzer output for an example +places.sqlite database used by Firefox. + +</p><blockquote><pre> +/** Disk-Space Utilization Report For ██████████████████/places.sqlite + +Page size in bytes................................ 32768 +Pages in the whole file (measured)................ 221 +Pages in the whole file (calculated).............. 221 +Pages that store data............................. 221 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.................. 14 +Number of indices................................. 23 +Number of defined indices......................... 17 +Number of implied indices......................... 6 +Size of the file in bytes......................... 7241728 +Bytes of user payload stored...................... 2503069 34.6% + +*** Page counts for all tables with their indices ***************************** + +MOZ_PLACES........................................ 142 64.3% +MOZ_HISTORYVISITS................................. 41 18.6% +MOZ_FAVICONS...................................... 15 6.8% +MOZ_BOOKMARKS..................................... 5 2.3% +MOZ_KEYWORDS...................................... 3 1.4% +MOZ_ANNO_ATTRIBUTES............................... 2 0.90% +MOZ_ANNOS......................................... 2 0.90% +MOZ_BOOKMARKS_ROOTS............................... 2 0.90% +MOZ_HOSTS......................................... 2 0.90% +MOZ_INPUTHISTORY.................................. 2 0.90% +MOZ_ITEMS_ANNOS................................... 2 0.90% +SQLITE_SCHEMA..................................... 1 0.45% +SQLITE_SEQUENCE................................... 1 0.45% +SQLITE_STAT1...................................... 1 0.45% + +*** Page counts for all tables and indices separately ************************* + +MOZ_PLACES........................................ 63 28.5% +MOZ_PLACES_URL_UNIQUEINDEX........................ 37 16.7% +MOZ_HISTORYVISITS................................. 13 5.9% +MOZ_FAVICONS...................................... 12 5.4% +MOZ_HISTORYVISITS_PLACEDATEINDEX.................. 12 5.4% +MOZ_PLACES_HOSTINDEX.............................. 11 5.0% +MOZ_HISTORYVISITS_DATEINDEX....................... 10 4.5% +MOZ_PLACES_GUID_UNIQUEINDEX....................... 9 4.1% +MOZ_PLACES_LASTVISITDATEINDEX..................... 7 3.2% +MOZ_HISTORYVISITS_FROMINDEX....................... 6 2.7% +MOZ_PLACES_FAVICONINDEX........................... 5 2.3% +MOZ_PLACES_FRECENCYINDEX.......................... 5 2.3% +MOZ_PLACES_VISITCOUNT............................. 5 2.3% +SQLITE_AUTOINDEX_MOZ_FAVICONS_1................... 3 1.4% +MOZ_ANNO_ATTRIBUTES............................... 1 0.45% +MOZ_ANNOS......................................... 1 0.45% +MOZ_ANNOS_PLACEATTRIBUTEINDEX..................... 1 0.45% +MOZ_BOOKMARKS..................................... 1 0.45% +MOZ_BOOKMARKS_GUID_UNIQUEINDEX.................... 1 0.45% +MOZ_BOOKMARKS_ITEMINDEX........................... 1 0.45% +MOZ_BOOKMARKS_ITEMLASTMODIFIEDINDEX............... 1 0.45% +MOZ_BOOKMARKS_PARENTINDEX......................... 1 0.45% +MOZ_BOOKMARKS_ROOTS............................... 1 0.45% +MOZ_HOSTS......................................... 1 0.45% +MOZ_INPUTHISTORY.................................. 1 0.45% +MOZ_ITEMS_ANNOS................................... 1 0.45% +MOZ_ITEMS_ANNOS_ITEMATTRIBUTEINDEX................ 1 0.45% +MOZ_KEYWORDS...................................... 1 0.45% +MOZ_KEYWORDS_PLACEPOSTDATA_UNIQUEINDEX............ 1 0.45% +SQLITE_AUTOINDEX_MOZ_ANNO_ATTRIBUTES_1............ 1 0.45% +SQLITE_AUTOINDEX_MOZ_BOOKMARKS_ROOTS_1............ 1 0.45% +SQLITE_AUTOINDEX_MOZ_HOSTS_1...................... 1 0.45% +SQLITE_AUTOINDEX_MOZ_INPUTHISTORY_1............... 1 0.45% +SQLITE_AUTOINDEX_MOZ_KEYWORDS_1................... 1 0.45% +SQLITE_SCHEMA..................................... 1 0.45% +SQLITE_SEQUENCE................................... 1 0.45% +SQLITE_STAT1...................................... 1 0.45% + +*** All tables and indices **************************************************** + +Percentage of total database...................... 100.0% +Number of entries................................. 154969 +Bytes of storage consumed......................... 7241728 +Bytes of payload.................................. 4969404 68.6% +Average payload per entry......................... 32.07 +Average unused bytes per entry.................... 11.15 +Average fanout.................................... 14.00 +Maximum payload per entry......................... 7640 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 14 +Primary pages used................................ 207 +Overflow pages used............................... 0 +Total pages used.................................. 221 +Unused bytes on index pages....................... 448010 97.7% +Unused bytes on primary pages..................... 1280642 18.9% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 1728652 23.9% + +*** All tables **************************************************************** + +Percentage of total database...................... 44.8% +Number of entries................................. 28530 +Bytes of storage consumed......................... 3244032 +Bytes of payload.................................. 2508257 77.3% +Average payload per entry......................... 87.92 +Average unused bytes per entry.................... 20.13 +Average fanout.................................... 28.00 +Maximum payload per entry......................... 7640 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 3 +Primary pages used................................ 96 +Overflow pages used............................... 0 +Total pages used.................................. 99 +Unused bytes on index pages....................... 97551 99.23% +Unused bytes on primary pages..................... 476741 15.2% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 574292 17.7% + +*** All indices *************************************************************** + +Percentage of total database...................... 55.2% +Number of entries................................. 126439 +Bytes of storage consumed......................... 3997696 +Bytes of payload.................................. 2461147 61.6% +Average payload per entry......................... 19.47 +Average unused bytes per entry.................... 9.13 +Average fanout.................................... 11.00 +Maximum payload per entry......................... 7259 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 11 +Primary pages used................................ 111 +Overflow pages used............................... 0 +Total pages used.................................. 122 +Unused bytes on index pages....................... 350459 97.2% +Unused bytes on primary pages..................... 803901 22.1% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 1154360 28.9% + +*** Table MOZ_ANNO_ATTRIBUTES and all its indices ***************************** + +Percentage of total database...................... 0.90% +Number of entries................................. 24 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 721 1.1% +Average payload per entry......................... 30.04 +Average unused bytes per entry.................... 2696.46 +Maximum payload per entry......................... 43 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 2 +Overflow pages used............................... 0 +Total pages used.................................. 2 +Unused bytes on primary pages..................... 64715 98.7% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 64715 98.7% + +*** Table MOZ_ANNO_ATTRIBUTES w/o any indices ********************************* + +Percentage of total database...................... 0.45% +Number of entries................................. 12 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 355 1.1% +B-tree depth...................................... 1 +Average payload per entry......................... 29.58 +Average unused bytes per entry.................... 2696.42 +Maximum payload per entry......................... 42 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 32357 98.7% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32357 98.7% + +*** Index SQLITE_AUTOINDEX_MOZ_ANNO_ATTRIBUTES_1 of table MOZ_ANNO_ATTRIBUTES * + +Percentage of total database...................... 0.45% +Number of entries................................. 12 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 366 1.1% +B-tree depth...................................... 1 +Average payload per entry......................... 30.50 +Average unused bytes per entry.................... 2696.50 +Maximum payload per entry......................... 43 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 32358 98.7% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32358 98.7% + +*** Table MOZ_ANNOS and all its indices *************************************** + +Percentage of total database...................... 0.90% +Number of entries................................. 390 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 13986 21.3% +Average payload per entry......................... 35.86 +Average unused bytes per entry.................... 128.22 +Maximum payload per entry......................... 127 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 2 +Overflow pages used............................... 0 +Total pages used.................................. 2 +Unused bytes on primary pages..................... 50006 76.3% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 50006 76.3% + +*** Table MOZ_ANNOS w/o any indices ******************************************* + +Percentage of total database...................... 0.45% +Number of entries................................. 195 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 12115 37.0% +B-tree depth...................................... 1 +Average payload per entry......................... 62.13 +Average unused bytes per entry.................... 101.04 +Maximum payload per entry......................... 127 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 19702 60.1% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 19702 60.1% + +*** Index MOZ_ANNOS_PLACEATTRIBUTEINDEX of table MOZ_ANNOS ******************** + +Percentage of total database...................... 0.45% +Number of entries................................. 195 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 1871 5.7% +B-tree depth...................................... 1 +Average payload per entry......................... 9.59 +Average unused bytes per entry.................... 155.41 +Maximum payload per entry......................... 10 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 30304 92.5% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 30304 92.5% + +*** Table MOZ_BOOKMARKS and all its indices *********************************** + +Percentage of total database...................... 2.3% +Number of entries................................. 1565 +Bytes of storage consumed......................... 163840 +Bytes of payload.................................. 37104 22.6% +Average payload per entry......................... 23.71 +Average unused bytes per entry.................... 77.62 +Maximum payload per entry......................... 518 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 5 +Overflow pages used............................... 0 +Total pages used.................................. 5 +Unused bytes on primary pages..................... 121475 74.1% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 121475 74.1% + +*** Table MOZ_BOOKMARKS w/o any indices *************************************** + +Percentage of total database...................... 0.45% +Number of entries................................. 313 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 21937 66.9% +B-tree depth...................................... 1 +Average payload per entry......................... 70.09 +Average unused bytes per entry.................... 29.90 +Maximum payload per entry......................... 518 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 9358 28.6% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 9358 28.6% + +*** Indices of table MOZ_BOOKMARKS ******************************************** + +Percentage of total database...................... 1.8% +Number of entries................................. 1252 +Bytes of storage consumed......................... 131072 +Bytes of payload.................................. 15167 11.6% +Average payload per entry......................... 12.11 +Average unused bytes per entry.................... 89.55 +Maximum payload per entry......................... 17 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 4 +Overflow pages used............................... 0 +Total pages used.................................. 4 +Unused bytes on primary pages..................... 112117 85.5% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 112117 85.5% + +*** Index MOZ_BOOKMARKS_GUID_UNIQUEINDEX of table MOZ_BOOKMARKS *************** + +Percentage of total database...................... 0.45% +Number of entries................................. 313 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 5207 15.9% +B-tree depth...................................... 1 +Average payload per entry......................... 16.64 +Average unused bytes per entry.................... 85.03 +Maximum payload per entry......................... 17 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 26614 81.2% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 26614 81.2% + +*** Index MOZ_BOOKMARKS_ITEMINDEX of table MOZ_BOOKMARKS ********************** + +Percentage of total database...................... 0.45% +Number of entries................................. 313 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 2547 7.8% +B-tree depth...................................... 1 +Average payload per entry......................... 8.14 +Average unused bytes per entry.................... 93.53 +Maximum payload per entry......................... 9 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 29274 89.3% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 29274 89.3% + +*** Index MOZ_BOOKMARKS_ITEMLASTMODIFIEDINDEX of table MOZ_BOOKMARKS ********** + +Percentage of total database...................... 0.45% +Number of entries................................. 313 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 5020 15.3% +B-tree depth...................................... 1 +Average payload per entry......................... 16.04 +Average unused bytes per entry.................... 85.63 +Maximum payload per entry......................... 17 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 26801 81.8% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 26801 81.8% + +*** Index MOZ_BOOKMARKS_PARENTINDEX of table MOZ_BOOKMARKS ******************** + +Percentage of total database...................... 0.45% +Number of entries................................. 313 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 2393 7.3% +B-tree depth...................................... 1 +Average payload per entry......................... 7.65 +Average unused bytes per entry.................... 94.02 +Maximum payload per entry......................... 9 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 29428 89.8% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 29428 89.8% + +*** Table MOZ_BOOKMARKS_ROOTS and all its indices ***************************** + +Percentage of total database...................... 0.90% +Number of entries................................. 10 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 94 0.14% +Average payload per entry......................... 9.40 +Average unused bytes per entry.................... 6539.10 +Maximum payload per entry......................... 11 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 2 +Overflow pages used............................... 0 +Total pages used.................................. 2 +Unused bytes on primary pages..................... 65391 99.78% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 65391 99.78% + +*** Table MOZ_BOOKMARKS_ROOTS w/o any indices ********************************* + +Percentage of total database...................... 0.45% +Number of entries................................. 5 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 47 0.14% +B-tree depth...................................... 1 +Average payload per entry......................... 9.40 +Average unused bytes per entry.................... 6538.60 +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..................... 32693 99.77% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32693 99.77% + +*** Index SQLITE_AUTOINDEX_MOZ_BOOKMARKS_ROOTS_1 of table MOZ_BOOKMARKS_ROOTS * + +Percentage of total database...................... 0.45% +Number of entries................................. 5 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 47 0.14% +B-tree depth...................................... 1 +Average payload per entry......................... 9.40 +Average unused bytes per entry.................... 6539.60 +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..................... 32698 99.79% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32698 99.79% + +*** Table MOZ_FAVICONS and all its indices ************************************ + +Percentage of total database...................... 6.8% +Number of entries................................. 941 +Bytes of storage consumed......................... 491520 +Bytes of payload.................................. 332765 67.7% +Average payload per entry......................... 353.63 +Average unused bytes per entry.................... 164.00 +Average fanout.................................... 7.00 +Maximum payload per entry......................... 7640 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 2 +Primary pages used................................ 13 +Overflow pages used............................... 0 +Total pages used.................................. 15 +Unused bytes on index pages....................... 65340 99.70% +Unused bytes on primary pages..................... 88980 20.9% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 154320 31.4% + +*** Table MOZ_FAVICONS w/o any indices **************************************** + +Percentage of total database...................... 5.4% +Number of entries................................. 471 +Bytes of storage consumed......................... 393216 +Bytes of payload.................................. 297630 75.7% +B-tree depth...................................... 2 +Average payload per entry......................... 631.91 +Average unused bytes per entry.................... 196.60 +Average fanout.................................... 11.00 +Non-sequential pages.............................. 6 54.5% +Maximum payload per entry......................... 7640 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 11 +Overflow pages used............................... 0 +Total pages used.................................. 12 +Unused bytes on index pages....................... 32676 99.72% +Unused bytes on primary pages..................... 59923 16.6% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 92599 23.5% + +*** Index SQLITE_AUTOINDEX_MOZ_FAVICONS_1 of table MOZ_FAVICONS *************** + +Percentage of total database...................... 1.4% +Number of entries................................. 470 +Bytes of storage consumed......................... 98304 +Bytes of payload.................................. 35135 35.7% +B-tree depth...................................... 2 +Average payload per entry......................... 74.76 +Average unused bytes per entry.................... 131.32 +Average fanout.................................... 3.00 +Non-sequential pages.............................. 1 50.0% +Maximum payload per entry......................... 7259 +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....................... 32664 99.68% +Unused bytes on primary pages..................... 29057 44.3% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 61721 62.8% + +*** Table MOZ_HISTORYVISITS and all its indices ******************************* + +Percentage of total database...................... 18.6% +Number of entries................................. 63470 +Bytes of storage consumed......................... 1343488 +Bytes of payload.................................. 882233 65.7% +Average payload per entry......................... 13.90 +Average unused bytes per entry.................... 3.76 +Average fanout.................................... 10.00 +Maximum payload per entry......................... 21 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 4 +Primary pages used................................ 37 +Overflow pages used............................... 0 +Total pages used.................................. 41 +Unused bytes on index pages....................... 130482 99.55% +Unused bytes on primary pages..................... 108158 8.9% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 238640 17.8% + +*** Table MOZ_HISTORYVISITS w/o any indices *********************************** + +Percentage of total database...................... 5.9% +Number of entries................................. 15873 +Bytes of storage consumed......................... 425984 +Bytes of payload.................................. 308447 72.4% +B-tree depth...................................... 2 +Average payload per entry......................... 19.43 +Average unused bytes per entry.................... 2.40 +Average fanout.................................... 12.00 +Non-sequential pages.............................. 8 66.7% +Maximum payload per entry......................... 21 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 12 +Overflow pages used............................... 0 +Total pages used.................................. 13 +Unused bytes on index pages....................... 32668 99.69% +Unused bytes on primary pages..................... 5435 1.4% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 38103 8.9% + +*** Indices of table MOZ_HISTORYVISITS **************************************** + +Percentage of total database...................... 12.7% +Number of entries................................. 47597 +Bytes of storage consumed......................... 917504 +Bytes of payload.................................. 573786 62.5% +Average payload per entry......................... 12.06 +Average unused bytes per entry.................... 4.21 +Average fanout.................................... 9.00 +Maximum payload per entry......................... 17 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 3 +Primary pages used................................ 25 +Overflow pages used............................... 0 +Total pages used.................................. 28 +Unused bytes on index pages....................... 97814 99.50% +Unused bytes on primary pages..................... 102723 12.5% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 200537 21.9% + +*** Index MOZ_HISTORYVISITS_DATEINDEX of table MOZ_HISTORYVISITS ************** + +Percentage of total database...................... 4.5% +Number of entries................................. 15865 +Bytes of storage consumed......................... 327680 +Bytes of payload.................................. 206221 62.9% +B-tree depth...................................... 2 +Average payload per entry......................... 13.00 +Average unused bytes per entry.................... 4.65 +Average fanout.................................... 10.00 +Non-sequential pages.............................. 6 66.7% +Maximum payload per entry......................... 13 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 9 +Overflow pages used............................... 0 +Total pages used.................................. 10 +Unused bytes on index pages....................... 32596 99.48% +Unused bytes on primary pages..................... 41128 13.9% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 73724 22.5% + +*** Index MOZ_HISTORYVISITS_FROMINDEX of table MOZ_HISTORYVISITS ************** + +Percentage of total database...................... 2.7% +Number of entries................................. 15869 +Bytes of storage consumed......................... 196608 +Bytes of payload.................................. 100292 51.0% +B-tree depth...................................... 2 +Average payload per entry......................... 6.32 +Average unused bytes per entry.................... 3.06 +Average fanout.................................... 6.00 +Non-sequential pages.............................. 4 80.0% +Maximum payload per entry......................... 7 +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....................... 32702 99.80% +Unused bytes on primary pages..................... 15927 9.7% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 48629 24.7% + +*** Index MOZ_HISTORYVISITS_PLACEDATEINDEX of table MOZ_HISTORYVISITS ********* + +Percentage of total database...................... 5.4% +Number of entries................................. 15863 +Bytes of storage consumed......................... 393216 +Bytes of payload.................................. 267273 68.0% +B-tree depth...................................... 2 +Average payload per entry......................... 16.85 +Average unused bytes per entry.................... 4.93 +Average fanout.................................... 12.00 +Non-sequential pages.............................. 8 72.7% +Maximum payload per entry......................... 17 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 11 +Overflow pages used............................... 0 +Total pages used.................................. 12 +Unused bytes on index pages....................... 32516 99.23% +Unused bytes on primary pages..................... 45668 12.7% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 78184 19.9% + +*** Table MOZ_HOSTS and all its indices *************************************** + +Percentage of total database...................... 0.90% +Number of entries................................. 1256 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 27640 42.2% +Average payload per entry......................... 22.01 +Average unused bytes per entry.................... 26.18 +Maximum payload per entry......................... 49 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 2 +Overflow pages used............................... 0 +Total pages used.................................. 2 +Unused bytes on primary pages..................... 32888 50.2% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32888 50.2% + +*** Table MOZ_HOSTS w/o any indices ******************************************* + +Percentage of total database...................... 0.45% +Number of entries................................. 628 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 14640 44.7% +B-tree depth...................................... 1 +Average payload per entry......................... 23.31 +Average unused bytes per entry.................... 23.90 +Maximum payload per entry......................... 49 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 15012 45.8% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 15012 45.8% + +*** Index SQLITE_AUTOINDEX_MOZ_HOSTS_1 of table MOZ_HOSTS ********************* + +Percentage of total database...................... 0.45% +Number of entries................................. 628 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 13000 39.7% +B-tree depth...................................... 1 +Average payload per entry......................... 20.70 +Average unused bytes per entry.................... 28.46 +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..................... 17876 54.6% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 17876 54.6% + +*** Table MOZ_INPUTHISTORY and all its indices ******************************** + +Percentage of total database...................... 0.90% +Number of entries................................. 16 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 642 0.98% +Average payload per entry......................... 40.12 +Average unused bytes per entry.................... 4050.88 +Maximum payload per entry......................... 71 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 2 +Overflow pages used............................... 0 +Total pages used.................................. 2 +Unused bytes on primary pages..................... 64814 98.9% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 64814 98.9% + +*** Table MOZ_INPUTHISTORY w/o any indices ************************************ + +Percentage of total database...................... 0.45% +Number of entries................................. 8 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 341 1.0% +B-tree depth...................................... 1 +Average payload per entry......................... 42.62 +Average unused bytes per entry.................... 4047.38 +Maximum payload per entry......................... 71 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 32379 98.8% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32379 98.8% + +*** Index SQLITE_AUTOINDEX_MOZ_INPUTHISTORY_1 of table MOZ_INPUTHISTORY ******* + +Percentage of total database...................... 0.45% +Number of entries................................. 8 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 301 0.92% +B-tree depth...................................... 1 +Average payload per entry......................... 37.62 +Average unused bytes per entry.................... 4054.38 +Maximum payload per entry......................... 65 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 32435 99.0% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32435 99.0% + +*** Table MOZ_ITEMS_ANNOS and all its indices ********************************* + +Percentage of total database...................... 0.90% +Number of entries................................. 158 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 9211 14.1% +Average payload per entry......................... 58.30 +Average unused bytes per entry.................... 352.56 +Maximum payload per entry......................... 384 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 2 +Overflow pages used............................... 0 +Total pages used.................................. 2 +Unused bytes on primary pages..................... 55704 85.0% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 55704 85.0% + +*** Table MOZ_ITEMS_ANNOS w/o any indices ************************************* + +Percentage of total database...................... 0.45% +Number of entries................................. 79 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 8649 26.4% +B-tree depth...................................... 1 +Average payload per entry......................... 109.48 +Average unused bytes per entry.................... 300.54 +Maximum payload per entry......................... 384 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 23743 72.5% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 23743 72.5% + +*** Index MOZ_ITEMS_ANNOS_ITEMATTRIBUTEINDEX of table MOZ_ITEMS_ANNOS ********* + +Percentage of total database...................... 0.45% +Number of entries................................. 79 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 562 1.7% +B-tree depth...................................... 1 +Average payload per entry......................... 7.11 +Average unused bytes per entry.................... 404.57 +Maximum payload per entry......................... 9 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 31961 97.5% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 31961 97.5% + +*** Table MOZ_KEYWORDS and all its indices ************************************ + +Percentage of total database...................... 1.4% +Number of entries................................. 0 +Bytes of storage consumed......................... 98304 +Bytes of payload.................................. 0 0.0% +Average payload per entry......................... 0.0 +Average unused bytes per entry.................... 0.0 +Maximum payload per entry......................... 0 +Entries that use overflow......................... 0 +Primary pages used................................ 3 +Overflow pages used............................... 0 +Total pages used.................................. 3 +Unused bytes on primary pages..................... 98280 99.976% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 98280 99.976% + +*** Table MOZ_KEYWORDS w/o any indices **************************************** + +Percentage of total database...................... 0.45% +Number of entries................................. 0 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 0 0.0% +B-tree depth...................................... 1 +Average payload per entry......................... 0.0 +Average unused bytes 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% + +*** Indices of table MOZ_KEYWORDS ********************************************* + +Percentage of total database...................... 0.90% +Number of entries................................. 0 +Bytes of storage consumed......................... 65536 +Bytes of payload.................................. 0 0.0% +Average payload per entry......................... 0.0 +Average unused bytes 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% + +*** Index MOZ_KEYWORDS_PLACEPOSTDATA_UNIQUEINDEX of table MOZ_KEYWORDS ******** + +Percentage of total database...................... 0.45% +Number of entries................................. 0 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 0 0.0% +B-tree depth...................................... 1 +Average payload per entry......................... 0.0 +Average unused bytes 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_KEYWORDS_1 of table MOZ_KEYWORDS *************** + +Percentage of total database...................... 0.45% +Number of entries................................. 0 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 0 0.0% +B-tree depth...................................... 1 +Average payload per entry......................... 0.0 +Average unused bytes 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 and all its indices ************************************** + +Percentage of total database...................... 64.3% +Number of entries................................. 87087 +Bytes of storage consumed......................... 4653056 +Bytes of payload.................................. 3659043 78.6% +Average payload per entry......................... 42.02 +Average unused bytes per entry.................... 7.93 +Average fanout.................................... 17.00 +Maximum payload per entry......................... 1867 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 8 +Primary pages used................................ 134 +Overflow pages used............................... 0 +Total pages used.................................. 142 +Unused bytes on index pages....................... 252188 96.2% +Unused bytes on primary pages..................... 438258 10.0% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 690446 14.8% + +*** Table MOZ_PLACES w/o any indices ****************************************** + +Percentage of total database...................... 28.5% +Number of entries................................. 10894 +Bytes of storage consumed......................... 2064384 +Bytes of payload.................................. 1838131 89.0% +B-tree depth...................................... 2 +Average payload per entry......................... 168.73 +Average unused bytes per entry.................... 14.10 +Average fanout.................................... 62.00 +Non-sequential pages.............................. 30 48.4% +Maximum payload per entry......................... 1867 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 62 +Overflow pages used............................... 0 +Total pages used.................................. 63 +Unused bytes on index pages....................... 32207 98.3% +Unused bytes on primary pages..................... 121406 6.0% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 153613 7.4% + +*** Indices of table MOZ_PLACES *********************************************** + +Percentage of total database...................... 35.7% +Number of entries................................. 76193 +Bytes of storage consumed......................... 2588672 +Bytes of payload.................................. 1820912 70.3% +Average payload per entry......................... 23.90 +Average unused bytes per entry.................... 7.05 +Average fanout.................................... 11.00 +Maximum payload per entry......................... 1823 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 7 +Primary pages used................................ 72 +Overflow pages used............................... 0 +Total pages used.................................. 79 +Unused bytes on index pages....................... 219981 95.9% +Unused bytes on primary pages..................... 316852 13.4% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 536833 20.7% + +*** Index MOZ_PLACES_FAVICONINDEX of table MOZ_PLACES ************************* + +Percentage of total database...................... 2.3% +Number of entries................................. 10891 +Bytes of storage consumed......................... 163840 +Bytes of payload.................................. 83178 50.8% +B-tree depth...................................... 2 +Average payload per entry......................... 7.64 +Average unused bytes per entry.................... 4.40 +Average fanout.................................... 5.00 +Non-sequential pages.............................. 3 75.0% +Maximum payload per entry......................... 8 +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....................... 32711 99.83% +Unused bytes on primary pages..................... 15213 11.6% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 47924 29.3% + +*** Index MOZ_PLACES_FRECENCYINDEX of table MOZ_PLACES ************************ + +Percentage of total database...................... 2.3% +Number of entries................................. 10891 +Bytes of storage consumed......................... 163840 +Bytes of payload.................................. 76772 46.9% +B-tree depth...................................... 2 +Average payload per entry......................... 7.05 +Average unused bytes per entry.................... 4.99 +Average fanout.................................... 5.00 +Non-sequential pages.............................. 3 75.0% +Maximum payload per entry......................... 9 +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....................... 32714 99.84% +Unused bytes on primary pages..................... 21616 16.5% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 54330 33.2% + +*** Index MOZ_PLACES_GUID_UNIQUEINDEX of table MOZ_PLACES ********************* + +Percentage of total database...................... 4.1% +Number of entries................................. 10887 +Bytes of storage consumed......................... 294912 +Bytes of payload.................................. 196000 66.5% +B-tree depth...................................... 2 +Average payload per entry......................... 18.00 +Average unused bytes per entry.................... 6.07 +Average fanout.................................... 9.00 +Non-sequential pages.............................. 5 62.5% +Maximum payload per entry......................... 18 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 8 +Overflow pages used............................... 0 +Total pages used.................................. 9 +Unused bytes on index pages....................... 32581 99.43% +Unused bytes on primary pages..................... 33545 12.8% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 66126 22.4% + +*** Index MOZ_PLACES_HOSTINDEX of table MOZ_PLACES **************************** + +Percentage of total database...................... 5.0% +Number of entries................................. 10885 +Bytes of storage consumed......................... 360448 +Bytes of payload.................................. 237383 65.9% +B-tree depth...................................... 2 +Average payload per entry......................... 21.81 +Average unused bytes per entry.................... 8.29 +Average fanout.................................... 11.00 +Non-sequential pages.............................. 7 70.0% +Maximum payload per entry......................... 49 +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....................... 32473 99.10% +Unused bytes on primary pages..................... 57782 17.6% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 90255 25.0% + +*** Index MOZ_PLACES_LASTVISITDATEINDEX of table MOZ_PLACES ******************* + +Percentage of total database...................... 3.2% +Number of entries................................. 10889 +Bytes of storage consumed......................... 229376 +Bytes of payload.................................. 150784 65.7% +B-tree depth...................................... 2 +Average payload per entry......................... 13.85 +Average unused bytes per entry.................... 4.21 +Average fanout.................................... 7.00 +Non-sequential pages.............................. 4 66.7% +Maximum payload per entry......................... 14 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 6 +Overflow pages used............................... 0 +Total pages used.................................. 7 +Unused bytes on index pages....................... 32651 99.64% +Unused bytes on primary pages..................... 13179 6.7% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 45830 20.0% + +*** Index MOZ_PLACES_URL_UNIQUEINDEX of table MOZ_PLACES ********************** + +Percentage of total database...................... 16.7% +Number of entries................................. 10859 +Bytes of storage consumed......................... 1212416 +Bytes of payload.................................. 1010666 83.4% +B-tree depth...................................... 2 +Average payload per entry......................... 93.07 +Average unused bytes per entry.................... 15.42 +Average fanout.................................... 37.00 +Non-sequential pages.............................. 16 44.4% +Maximum payload per entry......................... 1823 +Entries that use overflow......................... 0 0.0% +Index pages used.................................. 1 +Primary pages used................................ 36 +Overflow pages used............................... 0 +Total pages used.................................. 37 +Unused bytes on index pages....................... 24134 73.7% +Unused bytes on primary pages..................... 143261 12.1% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 167395 13.8% + +*** Index MOZ_PLACES_VISITCOUNT of table MOZ_PLACES *************************** + +Percentage of total database...................... 2.3% +Number of entries................................. 10891 +Bytes of storage consumed......................... 163840 +Bytes of payload.................................. 66129 40.4% +B-tree depth...................................... 2 +Average payload per entry......................... 6.07 +Average unused bytes per entry.................... 5.97 +Average fanout.................................... 5.00 +Non-sequential pages.............................. 3 75.0% +Maximum payload per entry......................... 8 +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....................... 32717 99.84% +Unused bytes on primary pages..................... 32256 24.6% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 64973 39.7% + +*** Table SQLITE_SCHEMA ******************************************************* + +Percentage of total database...................... 0.45% +Number of entries................................. 36 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 5188 15.8% +B-tree depth...................................... 1 +Average payload per entry......................... 144.11 +Average unused bytes per entry.................... 758.58 +Maximum payload per entry......................... 379 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 27309 83.3% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 27309 83.3% + +*** Table SQLITE_SEQUENCE ***************************************************** + +Percentage of total database...................... 0.45% +Number of entries................................. 1 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 15 0.046% +B-tree depth...................................... 1 +Average payload per entry......................... 15.00 +Average unused bytes per entry.................... 32741.00 +Maximum payload per entry......................... 15 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 32741 99.918% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 32741 99.918% + +*** Table SQLITE_STAT1 ******************************************************** + +Percentage of total database...................... 0.45% +Number of entries................................. 15 +Bytes of storage consumed......................... 32768 +Bytes of payload.................................. 762 2.3% +B-tree depth...................................... 1 +Average payload per entry......................... 50.80 +Average unused bytes per entry.................... 2128.20 +Maximum payload per entry......................... 62 +Entries that use overflow......................... 0 0.0% +Primary pages used................................ 1 +Overflow pages used............................... 0 +Total pages used.................................. 1 +Unused bytes on primary pages..................... 31923 97.4% +Unused bytes on overflow pages.................... 0 +Unused bytes on all pages......................... 31923 97.4% + +<a name="defs"></a>*** 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_SCHEMA 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_SCHEMA 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. + +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. + +<a name="sqlx"></a>******************************************************************************* +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 + 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,36,36,1,5188,0,0,379,0,1,0,0,27309,0,0,32768); +INSERT INTO space_used VALUES('moz_places','moz_places',0,10955,10894,2,1838131,0,0,1867,1,62,0,32207,121406,0,30,2064384); +INSERT INTO space_used VALUES('moz_historyvisits','moz_historyvisits',0,15884,15873,2,308447,0,0,21,1,12,0,32668,5435,0,8,425984); +INSERT INTO space_used VALUES('moz_inputhistory','moz_inputhistory',0,8,8,1,341,0,0,71,0,1,0,0,32379,0,0,32768); +INSERT INTO space_used VALUES('sqlite_autoindex_moz_inputhistory_1','moz_inputhistory',1,8,8,1,301,0,0,65,0,1,0,0,32435,0,0,32768); +INSERT INTO space_used VALUES('moz_hosts','moz_hosts',0,628,628,1,14640,0,0,49,0,1,0,0,15012,0,0,32768); +INSERT INTO space_used VALUES('sqlite_autoindex_moz_hosts_1','moz_hosts',1,628,628,1,13000,0,0,47,0,1,0,0,17876,0,0,32768); +INSERT INTO space_used VALUES('moz_bookmarks','moz_bookmarks',0,313,313,1,21937,0,0,518,0,1,0,0,9358,0,0,32768); +INSERT INTO space_used VALUES('moz_bookmarks_roots','moz_bookmarks_roots',0,5,5,1,47,0,0,11,0,1,0,0,32693,0,0,32768); +INSERT INTO space_used VALUES('sqlite_autoindex_moz_bookmarks_roots_1','moz_bookmarks_roots',1,5,5,1,47,0,0,11,0,1,0,0,32698,0,0,32768); +INSERT INTO space_used VALUES('moz_keywords','moz_keywords',0,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768); +INSERT INTO space_used VALUES('sqlite_autoindex_moz_keywords_1','moz_keywords',1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768); +INSERT INTO space_used VALUES('sqlite_sequence','sqlite_sequence',0,1,1,1,15,0,0,15,0,1,0,0,32741,0,0,32768); +INSERT INTO space_used VALUES('moz_favicons','moz_favicons',0,481,471,2,297630,0,0,7640,1,11,0,32676,59923,0,6,393216); +INSERT INTO space_used VALUES('sqlite_autoindex_moz_favicons_1','moz_favicons',1,471,470,2,35135,0,0,7259,1,2,0,32664,29057,0,1,98304); +INSERT INTO space_used VALUES('moz_anno_attributes','moz_anno_attributes',0,12,12,1,355,0,0,42,0,1,0,0,32357,0,0,32768); +INSERT INTO space_used VALUES('sqlite_autoindex_moz_anno_attributes_1','moz_anno_attributes',1,12,12,1,366,0,0,43,0,1,0,0,32358,0,0,32768); +INSERT INTO space_used VALUES('moz_annos','moz_annos',0,195,195,1,12115,0,0,127,0,1,0,0,19702,0,0,32768); +INSERT INTO space_used VALUES('moz_items_annos','moz_items_annos',0,79,79,1,8649,0,0,384,0,1,0,0,23743,0,0,32768); +INSERT INTO space_used VALUES('sqlite_stat1','sqlite_stat1',0,15,15,1,762,0,0,62,0,1,0,0,31923,0,0,32768); +INSERT INTO space_used VALUES('moz_places_faviconindex','moz_places',1,10894,10891,2,83178,0,0,8,1,4,0,32711,15213,0,3,163840); +INSERT INTO space_used VALUES('moz_places_hostindex','moz_places',1,10894,10885,2,237383,0,0,49,1,10,0,32473,57782,0,7,360448); +INSERT INTO space_used VALUES('moz_places_visitcount','moz_places',1,10894,10891,2,66129,0,0,8,1,4,0,32717,32256,0,3,163840); +INSERT INTO space_used VALUES('moz_places_frecencyindex','moz_places',1,10894,10891,2,76772,0,0,9,1,4,0,32714,21616,0,3,163840); +INSERT INTO space_used VALUES('moz_places_lastvisitdateindex','moz_places',1,10894,10889,2,150784,0,0,14,1,6,0,32651,13179,0,4,229376); +INSERT INTO space_used VALUES('moz_historyvisits_placedateindex','moz_historyvisits',1,15873,15863,2,267273,0,0,17,1,11,0,32516,45668,0,8,393216); +INSERT INTO space_used VALUES('moz_historyvisits_fromindex','moz_historyvisits',1,15873,15869,2,100292,0,0,7,1,5,0,32702,15927,0,4,196608); +INSERT INTO space_used VALUES('moz_historyvisits_dateindex','moz_historyvisits',1,15873,15865,2,206221,0,0,13,1,9,0,32596,41128,0,6,327680); +INSERT INTO space_used VALUES('moz_bookmarks_itemindex','moz_bookmarks',1,313,313,1,2547,0,0,9,0,1,0,0,29274,0,0,32768); +INSERT INTO space_used VALUES('moz_bookmarks_parentindex','moz_bookmarks',1,313,313,1,2393,0,0,9,0,1,0,0,29428,0,0,32768); +INSERT INTO space_used VALUES('moz_bookmarks_itemlastmodifiedindex','moz_bookmarks',1,313,313,1,5020,0,0,17,0,1,0,0,26801,0,0,32768); +INSERT INTO space_used VALUES('moz_places_url_uniqueindex','moz_places',1,10894,10859,2,1010666,0,0,1823,1,36,0,24134,143261,0,16,1212416); +INSERT INTO space_used VALUES('moz_places_guid_uniqueindex','moz_places',1,10894,10887,2,196000,0,0,18,1,8,0,32581,33545,0,5,294912); +INSERT INTO space_used VALUES('moz_bookmarks_guid_uniqueindex','moz_bookmarks',1,313,313,1,5207,0,0,17,0,1,0,0,26614,0,0,32768); +INSERT INTO space_used VALUES('moz_annos_placeattributeindex','moz_annos',1,195,195,1,1871,0,0,10,0,1,0,0,30304,0,0,32768); +INSERT INTO space_used VALUES('moz_items_annos_itemattributeindex','moz_items_annos',1,79,79,1,562,0,0,9,0,1,0,0,31961,0,0,32768); +INSERT INTO space_used VALUES('moz_keywords_placepostdata_uniqueindex','moz_keywords',1,0,0,1,0,0,0,0,0,1,0,0,32760,0,0,32768); +COMMIT; +</pre></blockquote> +<p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/sqlanalyze.in?m=3963fd2c25d51d600">2020-06-18 21:18:56</a> UTC </small></i></p> + |