summaryrefslogtreecommitdiffstats
path: root/www/sqlanalyze.html
diff options
context:
space:
mode:
Diffstat (limited to 'www/sqlanalyze.html')
-rw-r--r--www/sqlanalyze.html1538
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">&#x25ba;</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 = "&#x25bc;";
+} else {
+sub.style.display = "none";
+mk.innerHTML = "&#x25ba;";
+}
+}
+</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 &#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;/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>
+