| 1 |
<!DOCTYPE html> |
| 2 |
<html><head> |
| 3 |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| 4 |
<meta http-equiv="content-type" content="text/html; charset=UTF-8"> |
| 5 |
<link href="sqlite.css" rel="stylesheet"> |
| 6 |
<title>The sqlite3_analyzer.exe Utility Program</title> |
| 7 |
<!-- path= --> |
| 8 |
</head> |
| 9 |
<body> |
| 10 |
<div class=nosearch> |
| 11 |
<a href="index.html"> |
| 12 |
<img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0"> |
| 13 |
</a> |
| 14 |
<div><!-- IE hack to prevent disappearing logo --></div> |
| 15 |
<div class="tagline desktoponly"> |
| 16 |
Small. Fast. Reliable.<br>Choose any three. |
| 17 |
</div> |
| 18 |
<div class="menu mainmenu"> |
| 19 |
<ul> |
| 20 |
<li><a href="index.html">Home</a> |
| 21 |
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a> |
| 22 |
<li class='wideonly'><a href='about.html'>About</a> |
| 23 |
<li class='desktoponly'><a href="docs.html">Documentation</a> |
| 24 |
<li class='desktoponly'><a href="download.html">Download</a> |
| 25 |
<li class='wideonly'><a href='copyright.html'>License</a> |
| 26 |
<li class='desktoponly'><a href="support.html">Support</a> |
| 27 |
<li class='desktoponly'><a href="prosupport.html">Purchase</a> |
| 28 |
<li class='search' id='search_menubutton'> |
| 29 |
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a> |
| 30 |
</ul> |
| 31 |
</div> |
| 32 |
<div class="menu submenu" id="submenu"> |
| 33 |
<ul> |
| 34 |
<li><a href='about.html'>About</a> |
| 35 |
<li><a href='docs.html'>Documentation</a> |
| 36 |
<li><a href='download.html'>Download</a> |
| 37 |
<li><a href='support.html'>Support</a> |
| 38 |
<li><a href='prosupport.html'>Purchase</a> |
| 39 |
</ul> |
| 40 |
</div> |
| 41 |
<div class="searchmenu" id="searchmenu"> |
| 42 |
<form method="GET" action="search"> |
| 43 |
<select name="s" id="searchtype"> |
| 44 |
<option value="d">Search Documentation</option> |
| 45 |
<option value="c">Search Changelog</option> |
| 46 |
</select> |
| 47 |
<input type="text" name="q" id="searchbox" value=""> |
| 48 |
<input type="submit" value="Go"> |
| 49 |
</form> |
| 50 |
</div> |
| 51 |
</div> |
| 52 |
<script> |
| 53 |
function toggle_div(nm) { |
| 54 |
var w = document.getElementById(nm); |
| 55 |
if( w.style.display=="block" ){ |
| 56 |
w.style.display = "none"; |
| 57 |
}else{ |
| 58 |
w.style.display = "block"; |
| 59 |
} |
| 60 |
} |
| 61 |
function toggle_search() { |
| 62 |
var w = document.getElementById("searchmenu"); |
| 63 |
if( w.style.display=="block" ){ |
| 64 |
w.style.display = "none"; |
| 65 |
} else { |
| 66 |
w.style.display = "block"; |
| 67 |
setTimeout(function(){ |
| 68 |
document.getElementById("searchbox").focus() |
| 69 |
}, 30); |
| 70 |
} |
| 71 |
} |
| 72 |
function div_off(nm){document.getElementById(nm).style.display="none";} |
| 73 |
window.onbeforeunload = function(e){div_off("submenu");} |
| 74 |
/* Disable the Search feature if we are not operating from CGI, since */ |
| 75 |
/* Search is accomplished using CGI and will not work without it. */ |
| 76 |
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){ |
| 77 |
document.getElementById("search_menubutton").style.display = "none"; |
| 78 |
} |
| 79 |
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */ |
| 80 |
function hideorshow(btn,obj){ |
| 81 |
var x = document.getElementById(obj); |
| 82 |
var b = document.getElementById(btn); |
| 83 |
if( x.style.display!='none' ){ |
| 84 |
x.style.display = 'none'; |
| 85 |
b.innerHTML='show'; |
| 86 |
}else{ |
| 87 |
x.style.display = ''; |
| 88 |
b.innerHTML='hide'; |
| 89 |
} |
| 90 |
return false; |
| 91 |
} |
| 92 |
var antiRobot = 0; |
| 93 |
function antiRobotGo(){ |
| 94 |
if( antiRobot!=3 ) return; |
| 95 |
antiRobot = 7; |
| 96 |
var j = document.getElementById("mtimelink"); |
| 97 |
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href"); |
| 98 |
} |
| 99 |
function antiRobotDefense(){ |
| 100 |
document.body.onmousedown=function(){ |
| 101 |
antiRobot |= 2; |
| 102 |
antiRobotGo(); |
| 103 |
document.body.onmousedown=null; |
| 104 |
} |
| 105 |
document.body.onmousemove=function(){ |
| 106 |
antiRobot |= 2; |
| 107 |
antiRobotGo(); |
| 108 |
document.body.onmousemove=null; |
| 109 |
} |
| 110 |
setTimeout(function(){ |
| 111 |
antiRobot |= 1; |
| 112 |
antiRobotGo(); |
| 113 |
}, 100) |
| 114 |
antiRobotGo(); |
| 115 |
} |
| 116 |
antiRobotDefense(); |
| 117 |
</script> |
| 118 |
<div class=fancy> |
| 119 |
<div class=nosearch> |
| 120 |
<div class="fancy_title"> |
| 121 |
The sqlite3_analyzer.exe Utility Program |
| 122 |
</div> |
| 123 |
<details class="fancy_toc"> |
| 124 |
<summary>Table Of Contents</summary> |
| 125 |
<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> |
| 126 |
<div class="fancy-toc2"><a href="#implementation">1.1. Implementation</a></div> |
| 127 |
<div class="fancy-toc2"><a href="#example_output">1.2. Example Output</a></div> |
| 128 |
</div> |
| 129 |
</details> |
| 130 |
</div> |
| 131 |
|
| 132 |
|
| 133 |
|
| 134 |
<h1 id="the_sqlite3_analyzer_exe_utility_program"><span>1. </span>The sqlite3_analyzer.exe Utility Program</h1> |
| 135 |
|
| 136 |
<p> |
| 137 |
The <tt>sqlite3_analyzer.exe</tt> binary is a command-line utility program |
| 138 |
that measures and displays how much and how efficiently space is used by |
| 139 |
individual tables and indexes with an SQLite database file. |
| 140 |
Example usage: |
| 141 |
|
| 142 |
</p><blockquote><pre> |
| 143 |
sqlite3_analyzer database.sqlite |
| 144 |
</pre></blockquote> |
| 145 |
|
| 146 |
<p> |
| 147 |
The output is a human-readable ASCII text report that provides information |
| 148 |
on the space utilization of the database file. The report is intended to |
| 149 |
be self-explanatory, though there is some |
| 150 |
<a href="sqlanalyze.html#defs">additional explanation</a> of the |
| 151 |
various parameters reported toward the end of the report. |
| 152 |
|
| 153 |
</p><p> |
| 154 |
The output is also valid SQL. Most of the report text is contained within |
| 155 |
a header comment, with various SQL statements that create and initialize |
| 156 |
a database at the |
| 157 |
<a href="sqlanalyze.html#sqlx">end of the report</a>. The constructed database contains |
| 158 |
the raw data from which the report was extracted. Hence the original |
| 159 |
report can be read into an instance of the <a href="cli.html">command-line shell</a> and then |
| 160 |
the raw data can be queried to dig deeper into the space utilization of |
| 161 |
a particular database file. |
| 162 |
|
| 163 |
</p><h2 id="implementation"><span>1.1. </span>Implementation</h2> |
| 164 |
|
| 165 |
<p> |
| 166 |
The <tt>sqlite3_analyzer.exe</tt> program is a |
| 167 |
<a href="http://www.tcl.tk/">TCL</a> program that uses the <a href="dbstat.html">dbstat virtual table</a> |
| 168 |
to gather information about the database file and then format that |
| 169 |
information neatly. |
| 170 |
</p> |
| 171 |
|
| 172 |
|
| 173 |
<h2 id="example_output"><span>1.2. </span>Example Output</h2> |
| 174 |
|
| 175 |
<p>The following is sqlite3_analyzer output for an example |
| 176 |
places.sqlite database used by Firefox. |
| 177 |
|
| 178 |
</p><blockquote><pre> |
| 179 |
/** Disk-Space Utilization Report For ██████████████████/places.sqlite |
| 180 |
|
| 181 |
Page size in bytes................................ 32768 |
| 182 |
Pages in the whole file (measured)................ 221 |
| 183 |
Pages in the whole file (calculated).............. 221 |
| 184 |
Pages that store data............................. 221 100.0% |
| 185 |
Pages on the freelist (per header)................ 0 0.0% |
| 186 |
Pages on the freelist (calculated)................ 0 0.0% |
| 187 |
Pages of auto-vacuum overhead..................... 0 0.0% |
| 188 |
Number of tables in the database.................. 14 |
| 189 |
Number of indices................................. 23 |
| 190 |
Number of defined indices......................... 17 |
| 191 |
Number of implied indices......................... 6 |
| 192 |
Size of the file in bytes......................... 7241728 |
| 193 |
Bytes of user payload stored...................... 2503069 34.6% |
| 194 |
|
| 195 |
*** Page counts for all tables with their indices ***************************** |
| 196 |
|
| 197 |
MOZ_PLACES........................................ 142 64.3% |
| 198 |
MOZ_HISTORYVISITS................................. 41 18.6% |
| 199 |
MOZ_FAVICONS...................................... 15 6.8% |
| 200 |
MOZ_BOOKMARKS..................................... 5 2.3% |
| 201 |
MOZ_KEYWORDS...................................... 3 1.4% |
| 202 |
MOZ_ANNO_ATTRIBUTES............................... 2 0.90% |
| 203 |
MOZ_ANNOS......................................... 2 0.90% |
| 204 |
MOZ_BOOKMARKS_ROOTS............................... 2 0.90% |
| 205 |
MOZ_HOSTS......................................... 2 0.90% |
| 206 |
MOZ_INPUTHISTORY.................................. 2 0.90% |
| 207 |
MOZ_ITEMS_ANNOS................................... 2 0.90% |
| 208 |
SQLITE_SCHEMA..................................... 1 0.45% |
| 209 |
SQLITE_SEQUENCE................................... 1 0.45% |
| 210 |
SQLITE_STAT1...................................... 1 0.45% |
| 211 |
|
| 212 |
*** Page counts for all tables and indices separately ************************* |
| 213 |
|
| 214 |
MOZ_PLACES........................................ 63 28.5% |
| 215 |
MOZ_PLACES_URL_UNIQUEINDEX........................ 37 16.7% |
| 216 |
MOZ_HISTORYVISITS................................. 13 5.9% |
| 217 |
MOZ_FAVICONS...................................... 12 5.4% |
| 218 |
MOZ_HISTORYVISITS_PLACEDATEINDEX.................. 12 5.4% |
| 219 |
MOZ_PLACES_HOSTINDEX.............................. 11 5.0% |
| 220 |
MOZ_HISTORYVISITS_DATEINDEX....................... 10 4.5% |
| 221 |
MOZ_PLACES_GUID_UNIQUEINDEX....................... 9 4.1% |
| 222 |
MOZ_PLACES_LASTVISITDATEINDEX..................... 7 3.2% |
| 223 |
MOZ_HISTORYVISITS_FROMINDEX....................... 6 2.7% |
| 224 |
MOZ_PLACES_FAVICONINDEX........................... 5 2.3% |
| 225 |
MOZ_PLACES_FRECENCYINDEX.......................... 5 2.3% |
| 226 |
MOZ_PLACES_VISITCOUNT............................. 5 2.3% |
| 227 |
SQLITE_AUTOINDEX_MOZ_FAVICONS_1................... 3 1.4% |
| 228 |
MOZ_ANNO_ATTRIBUTES............................... 1 0.45% |
| 229 |
MOZ_ANNOS......................................... 1 0.45% |
| 230 |
MOZ_ANNOS_PLACEATTRIBUTEINDEX..................... 1 0.45% |
| 231 |
MOZ_BOOKMARKS..................................... 1 0.45% |
| 232 |
MOZ_BOOKMARKS_GUID_UNIQUEINDEX.................... 1 0.45% |
| 233 |
MOZ_BOOKMARKS_ITEMINDEX........................... 1 0.45% |
| 234 |
MOZ_BOOKMARKS_ITEMLASTMODIFIEDINDEX............... 1 0.45% |
| 235 |
MOZ_BOOKMARKS_PARENTINDEX......................... 1 0.45% |
| 236 |
MOZ_BOOKMARKS_ROOTS............................... 1 0.45% |
| 237 |
MOZ_HOSTS......................................... 1 0.45% |
| 238 |
MOZ_INPUTHISTORY.................................. 1 0.45% |
| 239 |
MOZ_ITEMS_ANNOS................................... 1 0.45% |
| 240 |
MOZ_ITEMS_ANNOS_ITEMATTRIBUTEINDEX................ 1 0.45% |
| 241 |
MOZ_KEYWORDS...................................... 1 0.45% |
| 242 |
MOZ_KEYWORDS_PLACEPOSTDATA_UNIQUEINDEX............ 1 0.45% |
| 243 |
SQLITE_AUTOINDEX_MOZ_ANNO_ATTRIBUTES_1............ 1 0.45% |
| 244 |
SQLITE_AUTOINDEX_MOZ_BOOKMARKS_ROOTS_1............ 1 0.45% |
| 245 |
SQLITE_AUTOINDEX_MOZ_HOSTS_1...................... 1 0.45% |
| 246 |
SQLITE_AUTOINDEX_MOZ_INPUTHISTORY_1............... 1 0.45% |
| 247 |
SQLITE_AUTOINDEX_MOZ_KEYWORDS_1................... 1 0.45% |
| 248 |
SQLITE_SCHEMA..................................... 1 0.45% |
| 249 |
SQLITE_SEQUENCE................................... 1 0.45% |
| 250 |
SQLITE_STAT1...................................... 1 0.45% |
| 251 |
|
| 252 |
*** All tables and indices **************************************************** |
| 253 |
|
| 254 |
Percentage of total database...................... 100.0% |
| 255 |
Number of entries................................. 154969 |
| 256 |
Bytes of storage consumed......................... 7241728 |
| 257 |
Bytes of payload.................................. 4969404 68.6% |
| 258 |
Average payload per entry......................... 32.07 |
| 259 |
Average unused bytes per entry.................... 11.15 |
| 260 |
Average fanout.................................... 14.00 |
| 261 |
Maximum payload per entry......................... 7640 |
| 262 |
Entries that use overflow......................... 0 0.0% |
| 263 |
Index pages used.................................. 14 |
| 264 |
Primary pages used................................ 207 |
| 265 |
Overflow pages used............................... 0 |
| 266 |
Total pages used.................................. 221 |
| 267 |
Unused bytes on index pages....................... 448010 97.7% |
| 268 |
Unused bytes on primary pages..................... 1280642 18.9% |
| 269 |
Unused bytes on overflow pages.................... 0 |
| 270 |
Unused bytes on all pages......................... 1728652 23.9% |
| 271 |
|
| 272 |
*** All tables **************************************************************** |
| 273 |
|
| 274 |
Percentage of total database...................... 44.8% |
| 275 |
Number of entries................................. 28530 |
| 276 |
Bytes of storage consumed......................... 3244032 |
| 277 |
Bytes of payload.................................. 2508257 77.3% |
| 278 |
Average payload per entry......................... 87.92 |
| 279 |
Average unused bytes per entry.................... 20.13 |
| 280 |
Average fanout.................................... 28.00 |
| 281 |
Maximum payload per entry......................... 7640 |
| 282 |
Entries that use overflow......................... 0 0.0% |
| 283 |
Index pages used.................................. 3 |
| 284 |
Primary pages used................................ 96 |
| 285 |
Overflow pages used............................... 0 |
| 286 |
Total pages used.................................. 99 |
| 287 |
Unused bytes on index pages....................... 97551 99.23% |
| 288 |
Unused bytes on primary pages..................... 476741 15.2% |
| 289 |
Unused bytes on overflow pages.................... 0 |
| 290 |
Unused bytes on all pages......................... 574292 17.7% |
| 291 |
|
| 292 |
*** All indices *************************************************************** |
| 293 |
|
| 294 |
Percentage of total database...................... 55.2% |
| 295 |
Number of entries................................. 126439 |
| 296 |
Bytes of storage consumed......................... 3997696 |
| 297 |
Bytes of payload.................................. 2461147 61.6% |
| 298 |
Average payload per entry......................... 19.47 |
| 299 |
Average unused bytes per entry.................... 9.13 |
| 300 |
Average fanout.................................... 11.00 |
| 301 |
Maximum payload per entry......................... 7259 |
| 302 |
Entries that use overflow......................... 0 0.0% |
| 303 |
Index pages used.................................. 11 |
| 304 |
Primary pages used................................ 111 |
| 305 |
Overflow pages used............................... 0 |
| 306 |
Total pages used.................................. 122 |
| 307 |
Unused bytes on index pages....................... 350459 97.2% |
| 308 |
Unused bytes on primary pages..................... 803901 22.1% |
| 309 |
Unused bytes on overflow pages.................... 0 |
| 310 |
Unused bytes on all pages......................... 1154360 28.9% |
| 311 |
|
| 312 |
*** Table MOZ_ANNO_ATTRIBUTES and all its indices ***************************** |
| 313 |
|
| 314 |
Percentage of total database...................... 0.90% |
| 315 |
Number of entries................................. 24 |
| 316 |
Bytes of storage consumed......................... 65536 |
| 317 |
Bytes of payload.................................. 721 1.1% |
| 318 |
Average payload per entry......................... 30.04 |
| 319 |
Average unused bytes per entry.................... 2696.46 |
| 320 |
Maximum payload per entry......................... 43 |
| 321 |
Entries that use overflow......................... 0 0.0% |
| 322 |
Primary pages used................................ 2 |
| 323 |
Overflow pages used............................... 0 |
| 324 |
Total pages used.................................. 2 |
| 325 |
Unused bytes on primary pages..................... 64715 98.7% |
| 326 |
Unused bytes on overflow pages.................... 0 |
| 327 |
Unused bytes on all pages......................... 64715 98.7% |
| 328 |
|
| 329 |
*** Table MOZ_ANNO_ATTRIBUTES w/o any indices ********************************* |
| 330 |
|
| 331 |
Percentage of total database...................... 0.45% |
| 332 |
Number of entries................................. 12 |
| 333 |
Bytes of storage consumed......................... 32768 |
| 334 |
Bytes of payload.................................. 355 1.1% |
| 335 |
B-tree depth...................................... 1 |
| 336 |
Average payload per entry......................... 29.58 |
| 337 |
Average unused bytes per entry.................... 2696.42 |
| 338 |
Maximum payload per entry......................... 42 |
| 339 |
Entries that use overflow......................... 0 0.0% |
| 340 |
Primary pages used................................ 1 |
| 341 |
Overflow pages used............................... 0 |
| 342 |
Total pages used.................................. 1 |
| 343 |
Unused bytes on primary pages..................... 32357 98.7% |
| 344 |
Unused bytes on overflow pages.................... 0 |
| 345 |
Unused bytes on all pages......................... 32357 98.7% |
| 346 |
|
| 347 |
*** Index SQLITE_AUTOINDEX_MOZ_ANNO_ATTRIBUTES_1 of table MOZ_ANNO_ATTRIBUTES * |
| 348 |
|
| 349 |
Percentage of total database...................... 0.45% |
| 350 |
Number of entries................................. 12 |
| 351 |
Bytes of storage consumed......................... 32768 |
| 352 |
Bytes of payload.................................. 366 1.1% |
| 353 |
B-tree depth...................................... 1 |
| 354 |
Average payload per entry......................... 30.50 |
| 355 |
Average unused bytes per entry.................... 2696.50 |
| 356 |
Maximum payload per entry......................... 43 |
| 357 |
Entries that use overflow......................... 0 0.0% |
| 358 |
Primary pages used................................ 1 |
| 359 |
Overflow pages used............................... 0 |
| 360 |
Total pages used.................................. 1 |
| 361 |
Unused bytes on primary pages..................... 32358 98.7% |
| 362 |
Unused bytes on overflow pages.................... 0 |
| 363 |
Unused bytes on all pages......................... 32358 98.7% |
| 364 |
|
| 365 |
*** Table MOZ_ANNOS and all its indices *************************************** |
| 366 |
|
| 367 |
Percentage of total database...................... 0.90% |
| 368 |
Number of entries................................. 390 |
| 369 |
Bytes of storage consumed......................... 65536 |
| 370 |
Bytes of payload.................................. 13986 21.3% |
| 371 |
Average payload per entry......................... 35.86 |
| 372 |
Average unused bytes per entry.................... 128.22 |
| 373 |
Maximum payload per entry......................... 127 |
| 374 |
Entries that use overflow......................... 0 0.0% |
| 375 |
Primary pages used................................ 2 |
| 376 |
Overflow pages used............................... 0 |
| 377 |
Total pages used.................................. 2 |
| 378 |
Unused bytes on primary pages..................... 50006 76.3% |
| 379 |
Unused bytes on overflow pages.................... 0 |
| 380 |
Unused bytes on all pages......................... 50006 76.3% |
| 381 |
|
| 382 |
*** Table MOZ_ANNOS w/o any indices ******************************************* |
| 383 |
|
| 384 |
Percentage of total database...................... 0.45% |
| 385 |
Number of entries................................. 195 |
| 386 |
Bytes of storage consumed......................... 32768 |
| 387 |
Bytes of payload.................................. 12115 37.0% |
| 388 |
B-tree depth...................................... 1 |
| 389 |
Average payload per entry......................... 62.13 |
| 390 |
Average unused bytes per entry.................... 101.04 |
| 391 |
Maximum payload per entry......................... 127 |
| 392 |
Entries that use overflow......................... 0 0.0% |
| 393 |
Primary pages used................................ 1 |
| 394 |
Overflow pages used............................... 0 |
| 395 |
Total pages used.................................. 1 |
| 396 |
Unused bytes on primary pages..................... 19702 60.1% |
| 397 |
Unused bytes on overflow pages.................... 0 |
| 398 |
Unused bytes on all pages......................... 19702 60.1% |
| 399 |
|
| 400 |
*** Index MOZ_ANNOS_PLACEATTRIBUTEINDEX of table MOZ_ANNOS ******************** |
| 401 |
|
| 402 |
Percentage of total database...................... 0.45% |
| 403 |
Number of entries................................. 195 |
| 404 |
Bytes of storage consumed......................... 32768 |
| 405 |
Bytes of payload.................................. 1871 5.7% |
| 406 |
B-tree depth...................................... 1 |
| 407 |
Average payload per entry......................... 9.59 |
| 408 |
Average unused bytes per entry.................... 155.41 |
| 409 |
Maximum payload per entry......................... 10 |
| 410 |
Entries that use overflow......................... 0 0.0% |
| 411 |
Primary pages used................................ 1 |
| 412 |
Overflow pages used............................... 0 |
| 413 |
Total pages used.................................. 1 |
| 414 |
Unused bytes on primary pages..................... 30304 92.5% |
| 415 |
Unused bytes on overflow pages.................... 0 |
| 416 |
Unused bytes on all pages......................... 30304 92.5% |
| 417 |
|
| 418 |
*** Table MOZ_BOOKMARKS and all its indices *********************************** |
| 419 |
|
| 420 |
Percentage of total database...................... 2.3% |
| 421 |
Number of entries................................. 1565 |
| 422 |
Bytes of storage consumed......................... 163840 |
| 423 |
Bytes of payload.................................. 37104 22.6% |
| 424 |
Average payload per entry......................... 23.71 |
| 425 |
Average unused bytes per entry.................... 77.62 |
| 426 |
Maximum payload per entry......................... 518 |
| 427 |
Entries that use overflow......................... 0 0.0% |
| 428 |
Primary pages used................................ 5 |
| 429 |
Overflow pages used............................... 0 |
| 430 |
Total pages used.................................. 5 |
| 431 |
Unused bytes on primary pages..................... 121475 74.1% |
| 432 |
Unused bytes on overflow pages.................... 0 |
| 433 |
Unused bytes on all pages......................... 121475 74.1% |
| 434 |
|
| 435 |
*** Table MOZ_BOOKMARKS w/o any indices *************************************** |
| 436 |
|
| 437 |
Percentage of total database...................... 0.45% |
| 438 |
Number of entries................................. 313 |
| 439 |
Bytes of storage consumed......................... 32768 |
| 440 |
Bytes of payload.................................. 21937 66.9% |
| 441 |
B-tree depth...................................... 1 |
| 442 |
Average payload per entry......................... 70.09 |
| 443 |
Average unused bytes per entry.................... 29.90 |
| 444 |
Maximum payload per entry......................... 518 |
| 445 |
Entries that use overflow......................... 0 0.0% |
| 446 |
Primary pages used................................ 1 |
| 447 |
Overflow pages used............................... 0 |
| 448 |
Total pages used.................................. 1 |
| 449 |
Unused bytes on primary pages..................... 9358 28.6% |
| 450 |
Unused bytes on overflow pages.................... 0 |
| 451 |
Unused bytes on all pages......................... 9358 28.6% |
| 452 |
|
| 453 |
*** Indices of table MOZ_BOOKMARKS ******************************************** |
| 454 |
|
| 455 |
Percentage of total database...................... 1.8% |
| 456 |
Number of entries................................. 1252 |
| 457 |
Bytes of storage consumed......................... 131072 |
| 458 |
Bytes of payload.................................. 15167 11.6% |
| 459 |
Average payload per entry......................... 12.11 |
| 460 |
Average unused bytes per entry.................... 89.55 |
| 461 |
Maximum payload per entry......................... 17 |
| 462 |
Entries that use overflow......................... 0 0.0% |
| 463 |
Primary pages used................................ 4 |
| 464 |
Overflow pages used............................... 0 |
| 465 |
Total pages used.................................. 4 |
| 466 |
Unused bytes on primary pages..................... 112117 85.5% |
| 467 |
Unused bytes on overflow pages.................... 0 |
| 468 |
Unused bytes on all pages......................... 112117 85.5% |
| 469 |
|
| 470 |
*** Index MOZ_BOOKMARKS_GUID_UNIQUEINDEX of table MOZ_BOOKMARKS *************** |
| 471 |
|
| 472 |
Percentage of total database...................... 0.45% |
| 473 |
Number of entries................................. 313 |
| 474 |
Bytes of storage consumed......................... 32768 |
| 475 |
Bytes of payload.................................. 5207 15.9% |
| 476 |
B-tree depth...................................... 1 |
| 477 |
Average payload per entry......................... 16.64 |
| 478 |
Average unused bytes per entry.................... 85.03 |
| 479 |
Maximum payload per entry......................... 17 |
| 480 |
Entries that use overflow......................... 0 0.0% |
| 481 |
Primary pages used................................ 1 |
| 482 |
Overflow pages used............................... 0 |
| 483 |
Total pages used.................................. 1 |
| 484 |
Unused bytes on primary pages..................... 26614 81.2% |
| 485 |
Unused bytes on overflow pages.................... 0 |
| 486 |
Unused bytes on all pages......................... 26614 81.2% |
| 487 |
|
| 488 |
*** Index MOZ_BOOKMARKS_ITEMINDEX of table MOZ_BOOKMARKS ********************** |
| 489 |
|
| 490 |
Percentage of total database...................... 0.45% |
| 491 |
Number of entries................................. 313 |
| 492 |
Bytes of storage consumed......................... 32768 |
| 493 |
Bytes of payload.................................. 2547 7.8% |
| 494 |
B-tree depth...................................... 1 |
| 495 |
Average payload per entry......................... 8.14 |
| 496 |
Average unused bytes per entry.................... 93.53 |
| 497 |
Maximum payload per entry......................... 9 |
| 498 |
Entries that use overflow......................... 0 0.0% |
| 499 |
Primary pages used................................ 1 |
| 500 |
Overflow pages used............................... 0 |
| 501 |
Total pages used.................................. 1 |
| 502 |
Unused bytes on primary pages..................... 29274 89.3% |
| 503 |
Unused bytes on overflow pages.................... 0 |
| 504 |
Unused bytes on all pages......................... 29274 89.3% |
| 505 |
|
| 506 |
*** Index MOZ_BOOKMARKS_ITEMLASTMODIFIEDINDEX of table MOZ_BOOKMARKS ********** |
| 507 |
|
| 508 |
Percentage of total database...................... 0.45% |
| 509 |
Number of entries................................. 313 |
| 510 |
Bytes of storage consumed......................... 32768 |
| 511 |
Bytes of payload.................................. 5020 15.3% |
| 512 |
B-tree depth...................................... 1 |
| 513 |
Average payload per entry......................... 16.04 |
| 514 |
Average unused bytes per entry.................... 85.63 |
| 515 |
Maximum payload per entry......................... 17 |
| 516 |
Entries that use overflow......................... 0 0.0% |
| 517 |
Primary pages used................................ 1 |
| 518 |
Overflow pages used............................... 0 |
| 519 |
Total pages used.................................. 1 |
| 520 |
Unused bytes on primary pages..................... 26801 81.8% |
| 521 |
Unused bytes on overflow pages.................... 0 |
| 522 |
Unused bytes on all pages......................... 26801 81.8% |
| 523 |
|
| 524 |
*** Index MOZ_BOOKMARKS_PARENTINDEX of table MOZ_BOOKMARKS ******************** |
| 525 |
|
| 526 |
Percentage of total database...................... 0.45% |
| 527 |
Number of entries................................. 313 |
| 528 |
Bytes of storage consumed......................... 32768 |
| 529 |
Bytes of payload.................................. 2393 7.3% |
| 530 |
B-tree depth...................................... 1 |
| 531 |
Average payload per entry......................... 7.65 |
| 532 |
Average unused bytes per entry.................... 94.02 |
| 533 |
Maximum payload per entry......................... 9 |
| 534 |
Entries that use overflow......................... 0 0.0% |
| 535 |
Primary pages used................................ 1 |
| 536 |
Overflow pages used............................... 0 |
| 537 |
Total pages used.................................. 1 |
| 538 |
Unused bytes on primary pages..................... 29428 89.8% |
| 539 |
Unused bytes on overflow pages.................... 0 |
| 540 |
Unused bytes on all pages......................... 29428 89.8% |
| 541 |
|
| 542 |
*** Table MOZ_BOOKMARKS_ROOTS and all its indices ***************************** |
| 543 |
|
| 544 |
Percentage of total database...................... 0.90% |
| 545 |
Number of entries................................. 10 |
| 546 |
Bytes of storage consumed......................... 65536 |
| 547 |
Bytes of payload.................................. 94 0.14% |
| 548 |
Average payload per entry......................... 9.40 |
| 549 |
Average unused bytes per entry.................... 6539.10 |
| 550 |
Maximum payload per entry......................... 11 |
| 551 |
Entries that use overflow......................... 0 0.0% |
| 552 |
Primary pages used................................ 2 |
| 553 |
Overflow pages used............................... 0 |
| 554 |
Total pages used.................................. 2 |
| 555 |
Unused bytes on primary pages..................... 65391 99.78% |
| 556 |
Unused bytes on overflow pages.................... 0 |
| 557 |
Unused bytes on all pages......................... 65391 99.78% |
| 558 |
|
| 559 |
*** Table MOZ_BOOKMARKS_ROOTS w/o any indices ********************************* |
| 560 |
|
| 561 |
Percentage of total database...................... 0.45% |
| 562 |
Number of entries................................. 5 |
| 563 |
Bytes of storage consumed......................... 32768 |
| 564 |
Bytes of payload.................................. 47 0.14% |
| 565 |
B-tree depth...................................... 1 |
| 566 |
Average payload per entry......................... 9.40 |
| 567 |
Average unused bytes per entry.................... 6538.60 |
| 568 |
Maximum payload per entry......................... 11 |
| 569 |
Entries that use overflow......................... 0 0.0% |
| 570 |
Primary pages used................................ 1 |
| 571 |
Overflow pages used............................... 0 |
| 572 |
Total pages used.................................. 1 |
| 573 |
Unused bytes on primary pages..................... 32693 99.77% |
| 574 |
Unused bytes on overflow pages.................... 0 |
| 575 |
Unused bytes on all pages......................... 32693 99.77% |
| 576 |
|
| 577 |
*** Index SQLITE_AUTOINDEX_MOZ_BOOKMARKS_ROOTS_1 of table MOZ_BOOKMARKS_ROOTS * |
| 578 |
|
| 579 |
Percentage of total database...................... 0.45% |
| 580 |
Number of entries................................. 5 |
| 581 |
Bytes of storage consumed......................... 32768 |
| 582 |
Bytes of payload.................................. 47 0.14% |
| 583 |
B-tree depth...................................... 1 |
| 584 |
Average payload per entry......................... 9.40 |
| 585 |
Average unused bytes per entry.................... 6539.60 |
| 586 |
Maximum payload per entry......................... 11 |
| 587 |
Entries that use overflow......................... 0 0.0% |
| 588 |
Primary pages used................................ 1 |
| 589 |
Overflow pages used............................... 0 |
| 590 |
Total pages used.................................. 1 |
| 591 |
Unused bytes on primary pages..................... 32698 99.79% |
| 592 |
Unused bytes on overflow pages.................... 0 |
| 593 |
Unused bytes on all pages......................... 32698 99.79% |
| 594 |
|
| 595 |
*** Table MOZ_FAVICONS and all its indices ************************************ |
| 596 |
|
| 597 |
Percentage of total database...................... 6.8% |
| 598 |
Number of entries................................. 941 |
| 599 |
Bytes of storage consumed......................... 491520 |
| 600 |
Bytes of payload.................................. 332765 67.7% |
| 601 |
Average payload per entry......................... 353.63 |
| 602 |
Average unused bytes per entry.................... 164.00 |
| 603 |
Average fanout.................................... 7.00 |
| 604 |
Maximum payload per entry......................... 7640 |
| 605 |
Entries that use overflow......................... 0 0.0% |
| 606 |
Index pages used.................................. 2 |
| 607 |
Primary pages used................................ 13 |
| 608 |
Overflow pages used............................... 0 |
| 609 |
Total pages used.................................. 15 |
| 610 |
Unused bytes on index pages....................... 65340 99.70% |
| 611 |
Unused bytes on primary pages..................... 88980 20.9% |
| 612 |
Unused bytes on overflow pages.................... 0 |
| 613 |
Unused bytes on all pages......................... 154320 31.4% |
| 614 |
|
| 615 |
*** Table MOZ_FAVICONS w/o any indices **************************************** |
| 616 |
|
| 617 |
Percentage of total database...................... 5.4% |
| 618 |
Number of entries................................. 471 |
| 619 |
Bytes of storage consumed......................... 393216 |
| 620 |
Bytes of payload.................................. 297630 75.7% |
| 621 |
B-tree depth...................................... 2 |
| 622 |
Average payload per entry......................... 631.91 |
| 623 |
Average unused bytes per entry.................... 196.60 |
| 624 |
Average fanout.................................... 11.00 |
| 625 |
Non-sequential pages.............................. 6 54.5% |
| 626 |
Maximum payload per entry......................... 7640 |
| 627 |
Entries that use overflow......................... 0 0.0% |
| 628 |
Index pages used.................................. 1 |
| 629 |
Primary pages used................................ 11 |
| 630 |
Overflow pages used............................... 0 |
| 631 |
Total pages used.................................. 12 |
| 632 |
Unused bytes on index pages....................... 32676 99.72% |
| 633 |
Unused bytes on primary pages..................... 59923 16.6% |
| 634 |
Unused bytes on overflow pages.................... 0 |
| 635 |
Unused bytes on all pages......................... 92599 23.5% |
| 636 |
|
| 637 |
*** Index SQLITE_AUTOINDEX_MOZ_FAVICONS_1 of table MOZ_FAVICONS *************** |
| 638 |
|
| 639 |
Percentage of total database...................... 1.4% |
| 640 |
Number of entries................................. 470 |
| 641 |
Bytes of storage consumed......................... 98304 |
| 642 |
Bytes of payload.................................. 35135 35.7% |
| 643 |
B-tree depth...................................... 2 |
| 644 |
Average payload per entry......................... 74.76 |
| 645 |
Average unused bytes per entry.................... 131.32 |
| 646 |
Average fanout.................................... 3.00 |
| 647 |
Non-sequential pages.............................. 1 50.0% |
| 648 |
Maximum payload per entry......................... 7259 |
| 649 |
Entries that use overflow......................... 0 0.0% |
| 650 |
Index pages used.................................. 1 |
| 651 |
Primary pages used................................ 2 |
| 652 |
Overflow pages used............................... 0 |
| 653 |
Total pages used.................................. 3 |
| 654 |
Unused bytes on index pages....................... 32664 99.68% |
| 655 |
Unused bytes on primary pages..................... 29057 44.3% |
| 656 |
Unused bytes on overflow pages.................... 0 |
| 657 |
Unused bytes on all pages......................... 61721 62.8% |
| 658 |
|
| 659 |
*** Table MOZ_HISTORYVISITS and all its indices ******************************* |
| 660 |
|
| 661 |
Percentage of total database...................... 18.6% |
| 662 |
Number of entries................................. 63470 |
| 663 |
Bytes of storage consumed......................... 1343488 |
| 664 |
Bytes of payload.................................. 882233 65.7% |
| 665 |
Average payload per entry......................... 13.90 |
| 666 |
Average unused bytes per entry.................... 3.76 |
| 667 |
Average fanout.................................... 10.00 |
| 668 |
Maximum payload per entry......................... 21 |
| 669 |
Entries that use overflow......................... 0 0.0% |
| 670 |
Index pages used.................................. 4 |
| 671 |
Primary pages used................................ 37 |
| 672 |
Overflow pages used............................... 0 |
| 673 |
Total pages used.................................. 41 |
| 674 |
Unused bytes on index pages....................... 130482 99.55% |
| 675 |
Unused bytes on primary pages..................... 108158 8.9% |
| 676 |
Unused bytes on overflow pages.................... 0 |
| 677 |
Unused bytes on all pages......................... 238640 17.8% |
| 678 |
|
| 679 |
*** Table MOZ_HISTORYVISITS w/o any indices *********************************** |
| 680 |
|
| 681 |
Percentage of total database...................... 5.9% |
| 682 |
Number of entries................................. 15873 |
| 683 |
Bytes of storage consumed......................... 425984 |
| 684 |
Bytes of payload.................................. 308447 72.4% |
| 685 |
B-tree depth...................................... 2 |
| 686 |
Average payload per entry......................... 19.43 |
| 687 |
Average unused bytes per entry.................... 2.40 |
| 688 |
Average fanout.................................... 12.00 |
| 689 |
Non-sequential pages.............................. 8 66.7% |
| 690 |
Maximum payload per entry......................... 21 |
| 691 |
Entries that use overflow......................... 0 0.0% |
| 692 |
Index pages used.................................. 1 |
| 693 |
Primary pages used................................ 12 |
| 694 |
Overflow pages used............................... 0 |
| 695 |
Total pages used.................................. 13 |
| 696 |
Unused bytes on index pages....................... 32668 99.69% |
| 697 |
Unused bytes on primary pages..................... 5435 1.4% |
| 698 |
Unused bytes on overflow pages.................... 0 |
| 699 |
Unused bytes on all pages......................... 38103 8.9% |
| 700 |
|
| 701 |
*** Indices of table MOZ_HISTORYVISITS **************************************** |
| 702 |
|
| 703 |
Percentage of total database...................... 12.7% |
| 704 |
Number of entries................................. 47597 |
| 705 |
Bytes of storage consumed......................... 917504 |
| 706 |
Bytes of payload.................................. 573786 62.5% |
| 707 |
Average payload per entry......................... 12.06 |
| 708 |
Average unused bytes per entry.................... 4.21 |
| 709 |
Average fanout.................................... 9.00 |
| 710 |
Maximum payload per entry......................... 17 |
| 711 |
Entries that use overflow......................... 0 0.0% |
| 712 |
Index pages used.................................. 3 |
| 713 |
Primary pages used................................ 25 |
| 714 |
Overflow pages used............................... 0 |
| 715 |
Total pages used.................................. 28 |
| 716 |
Unused bytes on index pages....................... 97814 99.50% |
| 717 |
Unused bytes on primary pages..................... 102723 12.5% |
| 718 |
Unused bytes on overflow pages.................... 0 |
| 719 |
Unused bytes on all pages......................... 200537 21.9% |
| 720 |
|
| 721 |
*** Index MOZ_HISTORYVISITS_DATEINDEX of table MOZ_HISTORYVISITS ************** |
| 722 |
|
| 723 |
Percentage of total database...................... 4.5% |
| 724 |
Number of entries................................. 15865 |
| 725 |
Bytes of storage consumed......................... 327680 |
| 726 |
Bytes of payload.................................. 206221 62.9% |
| 727 |
B-tree depth...................................... 2 |
| 728 |
Average payload per entry......................... 13.00 |
| 729 |
Average unused bytes per entry.................... 4.65 |
| 730 |
Average fanout.................................... 10.00 |
| 731 |
Non-sequential pages.............................. 6 66.7% |
| 732 |
Maximum payload per entry......................... 13 |
| 733 |
Entries that use overflow......................... 0 0.0% |
| 734 |
Index pages used.................................. 1 |
| 735 |
Primary pages used................................ 9 |
| 736 |
Overflow pages used............................... 0 |
| 737 |
Total pages used.................................. 10 |
| 738 |
Unused bytes on index pages....................... 32596 99.48% |
| 739 |
Unused bytes on primary pages..................... 41128 13.9% |
| 740 |
Unused bytes on overflow pages.................... 0 |
| 741 |
Unused bytes on all pages......................... 73724 22.5% |
| 742 |
|
| 743 |
*** Index MOZ_HISTORYVISITS_FROMINDEX of table MOZ_HISTORYVISITS ************** |
| 744 |
|
| 745 |
Percentage of total database...................... 2.7% |
| 746 |
Number of entries................................. 15869 |
| 747 |
Bytes of storage consumed......................... 196608 |
| 748 |
Bytes of payload.................................. 100292 51.0% |
| 749 |
B-tree depth...................................... 2 |
| 750 |
Average payload per entry......................... 6.32 |
| 751 |
Average unused bytes per entry.................... 3.06 |
| 752 |
Average fanout.................................... 6.00 |
| 753 |
Non-sequential pages.............................. 4 80.0% |
| 754 |
Maximum payload per entry......................... 7 |
| 755 |
Entries that use overflow......................... 0 0.0% |
| 756 |
Index pages used.................................. 1 |
| 757 |
Primary pages used................................ 5 |
| 758 |
Overflow pages used............................... 0 |
| 759 |
Total pages used.................................. 6 |
| 760 |
Unused bytes on index pages....................... 32702 99.80% |
| 761 |
Unused bytes on primary pages..................... 15927 9.7% |
| 762 |
Unused bytes on overflow pages.................... 0 |
| 763 |
Unused bytes on all pages......................... 48629 24.7% |
| 764 |
|
| 765 |
*** Index MOZ_HISTORYVISITS_PLACEDATEINDEX of table MOZ_HISTORYVISITS ********* |
| 766 |
|
| 767 |
Percentage of total database...................... 5.4% |
| 768 |
Number of entries................................. 15863 |
| 769 |
Bytes of storage consumed......................... 393216 |
| 770 |
Bytes of payload.................................. 267273 68.0% |
| 771 |
B-tree depth...................................... 2 |
| 772 |
Average payload per entry......................... 16.85 |
| 773 |
Average unused bytes per entry.................... 4.93 |
| 774 |
Average fanout.................................... 12.00 |
| 775 |
Non-sequential pages.............................. 8 72.7% |
| 776 |
Maximum payload per entry......................... 17 |
| 777 |
Entries that use overflow......................... 0 0.0% |
| 778 |
Index pages used.................................. 1 |
| 779 |
Primary pages used................................ 11 |
| 780 |
Overflow pages used............................... 0 |
| 781 |
Total pages used.................................. 12 |
| 782 |
Unused bytes on index pages....................... 32516 99.23% |
| 783 |
Unused bytes on primary pages..................... 45668 12.7% |
| 784 |
Unused bytes on overflow pages.................... 0 |
| 785 |
Unused bytes on all pages......................... 78184 19.9% |
| 786 |
|
| 787 |
*** Table MOZ_HOSTS and all its indices *************************************** |
| 788 |
|
| 789 |
Percentage of total database...................... 0.90% |
| 790 |
Number of entries................................. 1256 |
| 791 |
Bytes of storage consumed......................... 65536 |
| 792 |
Bytes of payload.................................. 27640 42.2% |
| 793 |
Average payload per entry......................... 22.01 |
| 794 |
Average unused bytes per entry.................... 26.18 |
| 795 |
Maximum payload per entry......................... 49 |
| 796 |
Entries that use overflow......................... 0 0.0% |
| 797 |
Primary pages used................................ 2 |
| 798 |
Overflow pages used............................... 0 |
| 799 |
Total pages used.................................. 2 |
| 800 |
Unused bytes on primary pages..................... 32888 50.2% |
| 801 |
Unused bytes on overflow pages.................... 0 |
| 802 |
Unused bytes on all pages......................... 32888 50.2% |
| 803 |
|
| 804 |
*** Table MOZ_HOSTS w/o any indices ******************************************* |
| 805 |
|
| 806 |
Percentage of total database...................... 0.45% |
| 807 |
Number of entries................................. 628 |
| 808 |
Bytes of storage consumed......................... 32768 |
| 809 |
Bytes of payload.................................. 14640 44.7% |
| 810 |
B-tree depth...................................... 1 |
| 811 |
Average payload per entry......................... 23.31 |
| 812 |
Average unused bytes per entry.................... 23.90 |
| 813 |
Maximum payload per entry......................... 49 |
| 814 |
Entries that use overflow......................... 0 0.0% |
| 815 |
Primary pages used................................ 1 |
| 816 |
Overflow pages used............................... 0 |
| 817 |
Total pages used.................................. 1 |
| 818 |
Unused bytes on primary pages..................... 15012 45.8% |
| 819 |
Unused bytes on overflow pages.................... 0 |
| 820 |
Unused bytes on all pages......................... 15012 45.8% |
| 821 |
|
| 822 |
*** Index SQLITE_AUTOINDEX_MOZ_HOSTS_1 of table MOZ_HOSTS ********************* |
| 823 |
|
| 824 |
Percentage of total database...................... 0.45% |
| 825 |
Number of entries................................. 628 |
| 826 |
Bytes of storage consumed......................... 32768 |
| 827 |
Bytes of payload.................................. 13000 39.7% |
| 828 |
B-tree depth...................................... 1 |
| 829 |
Average payload per entry......................... 20.70 |
| 830 |
Average unused bytes per entry.................... 28.46 |
| 831 |
Maximum payload per entry......................... 47 |
| 832 |
Entries that use overflow......................... 0 0.0% |
| 833 |
Primary pages used................................ 1 |
| 834 |
Overflow pages used............................... 0 |
| 835 |
Total pages used.................................. 1 |
| 836 |
Unused bytes on primary pages..................... 17876 54.6% |
| 837 |
Unused bytes on overflow pages.................... 0 |
| 838 |
Unused bytes on all pages......................... 17876 54.6% |
| 839 |
|
| 840 |
*** Table MOZ_INPUTHISTORY and all its indices ******************************** |
| 841 |
|
| 842 |
Percentage of total database...................... 0.90% |
| 843 |
Number of entries................................. 16 |
| 844 |
Bytes of storage consumed......................... 65536 |
| 845 |
Bytes of payload.................................. 642 0.98% |
| 846 |
Average payload per entry......................... 40.12 |
| 847 |
Average unused bytes per entry.................... 4050.88 |
| 848 |
Maximum payload per entry......................... 71 |
| 849 |
Entries that use overflow......................... 0 0.0% |
| 850 |
Primary pages used................................ 2 |
| 851 |
Overflow pages used............................... 0 |
| 852 |
Total pages used.................................. 2 |
| 853 |
Unused bytes on primary pages..................... 64814 98.9% |
| 854 |
Unused bytes on overflow pages.................... 0 |
| 855 |
Unused bytes on all pages......................... 64814 98.9% |
| 856 |
|
| 857 |
*** Table MOZ_INPUTHISTORY w/o any indices ************************************ |
| 858 |
|
| 859 |
Percentage of total database...................... 0.45% |
| 860 |
Number of entries................................. 8 |
| 861 |
Bytes of storage consumed......................... 32768 |
| 862 |
Bytes of payload.................................. 341 1.0% |
| 863 |
B-tree depth...................................... 1 |
| 864 |
Average payload per entry......................... 42.62 |
| 865 |
Average unused bytes per entry.................... 4047.38 |
| 866 |
Maximum payload per entry......................... 71 |
| 867 |
Entries that use overflow......................... 0 0.0% |
| 868 |
Primary pages used................................ 1 |
| 869 |
Overflow pages used............................... 0 |
| 870 |
Total pages used.................................. 1 |
| 871 |
Unused bytes on primary pages..................... 32379 98.8% |
| 872 |
Unused bytes on overflow pages.................... 0 |
| 873 |
Unused bytes on all pages......................... 32379 98.8% |
| 874 |
|
| 875 |
*** Index SQLITE_AUTOINDEX_MOZ_INPUTHISTORY_1 of table MOZ_INPUTHISTORY ******* |
| 876 |
|
| 877 |
Percentage of total database...................... 0.45% |
| 878 |
Number of entries................................. 8 |
| 879 |
Bytes of storage consumed......................... 32768 |
| 880 |
Bytes of payload.................................. 301 0.92% |
| 881 |
B-tree depth...................................... 1 |
| 882 |
Average payload per entry......................... 37.62 |
| 883 |
Average unused bytes per entry.................... 4054.38 |
| 884 |
Maximum payload per entry......................... 65 |
| 885 |
Entries that use overflow......................... 0 0.0% |
| 886 |
Primary pages used................................ 1 |
| 887 |
Overflow pages used............................... 0 |
| 888 |
Total pages used.................................. 1 |
| 889 |
Unused bytes on primary pages..................... 32435 99.0% |
| 890 |
Unused bytes on overflow pages.................... 0 |
| 891 |
Unused bytes on all pages......................... 32435 99.0% |
| 892 |
|
| 893 |
*** Table MOZ_ITEMS_ANNOS and all its indices ********************************* |
| 894 |
|
| 895 |
Percentage of total database...................... 0.90% |
| 896 |
Number of entries................................. 158 |
| 897 |
Bytes of storage consumed......................... 65536 |
| 898 |
Bytes of payload.................................. 9211 14.1% |
| 899 |
Average payload per entry......................... 58.30 |
| 900 |
Average unused bytes per entry.................... 352.56 |
| 901 |
Maximum payload per entry......................... 384 |
| 902 |
Entries that use overflow......................... 0 0.0% |
| 903 |
Primary pages used................................ 2 |
| 904 |
Overflow pages used............................... 0 |
| 905 |
Total pages used.................................. 2 |
| 906 |
Unused bytes on primary pages..................... 55704 85.0% |
| 907 |
Unused bytes on overflow pages.................... 0 |
| 908 |
Unused bytes on all pages......................... 55704 85.0% |
| 909 |
|
| 910 |
*** Table MOZ_ITEMS_ANNOS w/o any indices ************************************* |
| 911 |
|
| 912 |
Percentage of total database...................... 0.45% |
| 913 |
Number of entries................................. 79 |
| 914 |
Bytes of storage consumed......................... 32768 |
| 915 |
Bytes of payload.................................. 8649 26.4% |
| 916 |
B-tree depth...................................... 1 |
| 917 |
Average payload per entry......................... 109.48 |
| 918 |
Average unused bytes per entry.................... 300.54 |
| 919 |
Maximum payload per entry......................... 384 |
| 920 |
Entries that use overflow......................... 0 0.0% |
| 921 |
Primary pages used................................ 1 |
| 922 |
Overflow pages used............................... 0 |
| 923 |
Total pages used.................................. 1 |
| 924 |
Unused bytes on primary pages..................... 23743 72.5% |
| 925 |
Unused bytes on overflow pages.................... 0 |
| 926 |
Unused bytes on all pages......................... 23743 72.5% |
| 927 |
|
| 928 |
*** Index MOZ_ITEMS_ANNOS_ITEMATTRIBUTEINDEX of table MOZ_ITEMS_ANNOS ********* |
| 929 |
|
| 930 |
Percentage of total database...................... 0.45% |
| 931 |
Number of entries................................. 79 |
| 932 |
Bytes of storage consumed......................... 32768 |
| 933 |
Bytes of payload.................................. 562 1.7% |
| 934 |
B-tree depth...................................... 1 |
| 935 |
Average payload per entry......................... 7.11 |
| 936 |
Average unused bytes per entry.................... 404.57 |
| 937 |
Maximum payload per entry......................... 9 |
| 938 |
Entries that use overflow......................... 0 0.0% |
| 939 |
Primary pages used................................ 1 |
| 940 |
Overflow pages used............................... 0 |
| 941 |
Total pages used.................................. 1 |
| 942 |
Unused bytes on primary pages..................... 31961 97.5% |
| 943 |
Unused bytes on overflow pages.................... 0 |
| 944 |
Unused bytes on all pages......................... 31961 97.5% |
| 945 |
|
| 946 |
*** Table MOZ_KEYWORDS and all its indices ************************************ |
| 947 |
|
| 948 |
Percentage of total database...................... 1.4% |
| 949 |
Number of entries................................. 0 |
| 950 |
Bytes of storage consumed......................... 98304 |
| 951 |
Bytes of payload.................................. 0 0.0% |
| 952 |
Average payload per entry......................... 0.0 |
| 953 |
Average unused bytes per entry.................... 0.0 |
| 954 |
Maximum payload per entry......................... 0 |
| 955 |
Entries that use overflow......................... 0 |
| 956 |
Primary pages used................................ 3 |
| 957 |
Overflow pages used............................... 0 |
| 958 |
Total pages used.................................. 3 |
| 959 |
Unused bytes on primary pages..................... 98280 99.976% |
| 960 |
Unused bytes on overflow pages.................... 0 |
| 961 |
Unused bytes on all pages......................... 98280 99.976% |
| 962 |
|
| 963 |
*** Table MOZ_KEYWORDS w/o any indices **************************************** |
| 964 |
|
| 965 |
Percentage of total database...................... 0.45% |
| 966 |
Number of entries................................. 0 |
| 967 |
Bytes of storage consumed......................... 32768 |
| 968 |
Bytes of payload.................................. 0 0.0% |
| 969 |
B-tree depth...................................... 1 |
| 970 |
Average payload per entry......................... 0.0 |
| 971 |
Average unused bytes per entry.................... 0.0 |
| 972 |
Maximum payload per entry......................... 0 |
| 973 |
Entries that use overflow......................... 0 |
| 974 |
Primary pages used................................ 1 |
| 975 |
Overflow pages used............................... 0 |
| 976 |
Total pages used.................................. 1 |
| 977 |
Unused bytes on primary pages..................... 32760 99.976% |
| 978 |
Unused bytes on overflow pages.................... 0 |
| 979 |
Unused bytes on all pages......................... 32760 99.976% |
| 980 |
|
| 981 |
*** Indices of table MOZ_KEYWORDS ********************************************* |
| 982 |
|
| 983 |
Percentage of total database...................... 0.90% |
| 984 |
Number of entries................................. 0 |
| 985 |
Bytes of storage consumed......................... 65536 |
| 986 |
Bytes of payload.................................. 0 0.0% |
| 987 |
Average payload per entry......................... 0.0 |
| 988 |
Average unused bytes per entry.................... 0.0 |
| 989 |
Maximum payload per entry......................... 0 |
| 990 |
Entries that use overflow......................... 0 |
| 991 |
Primary pages used................................ 2 |
| 992 |
Overflow pages used............................... 0 |
| 993 |
Total pages used.................................. 2 |
| 994 |
Unused bytes on primary pages..................... 65520 99.976% |
| 995 |
Unused bytes on overflow pages.................... 0 |
| 996 |
Unused bytes on all pages......................... 65520 99.976% |
| 997 |
|
| 998 |
*** Index MOZ_KEYWORDS_PLACEPOSTDATA_UNIQUEINDEX of table MOZ_KEYWORDS ******** |
| 999 |
|
| 1000 |
Percentage of total database...................... 0.45% |
| 1001 |
Number of entries................................. 0 |
| 1002 |
Bytes of storage consumed......................... 32768 |
| 1003 |
Bytes of payload.................................. 0 0.0% |
| 1004 |
B-tree depth...................................... 1 |
| 1005 |
Average payload per entry......................... 0.0 |
| 1006 |
Average unused bytes per entry.................... 0.0 |
| 1007 |
Maximum payload per entry......................... 0 |
| 1008 |
Entries that use overflow......................... 0 |
| 1009 |
Primary pages used................................ 1 |
| 1010 |
Overflow pages used............................... 0 |
| 1011 |
Total pages used.................................. 1 |
| 1012 |
Unused bytes on primary pages..................... 32760 99.976% |
| 1013 |
Unused bytes on overflow pages.................... 0 |
| 1014 |
Unused bytes on all pages......................... 32760 99.976% |
| 1015 |
|
| 1016 |
*** Index SQLITE_AUTOINDEX_MOZ_KEYWORDS_1 of table MOZ_KEYWORDS *************** |
| 1017 |
|
| 1018 |
Percentage of total database...................... 0.45% |
| 1019 |
Number of entries................................. 0 |
| 1020 |
Bytes of storage consumed......................... 32768 |
| 1021 |
Bytes of payload.................................. 0 0.0% |
| 1022 |
B-tree depth...................................... 1 |
| 1023 |
Average payload per entry......................... 0.0 |
| 1024 |
Average unused bytes per entry.................... 0.0 |
| 1025 |
Maximum payload per entry......................... 0 |
| 1026 |
Entries that use overflow......................... 0 |
| 1027 |
Primary pages used................................ 1 |
| 1028 |
Overflow pages used............................... 0 |
| 1029 |
Total pages used.................................. 1 |
| 1030 |
Unused bytes on primary pages..................... 32760 99.976% |
| 1031 |
Unused bytes on overflow pages.................... 0 |
| 1032 |
Unused bytes on all pages......................... 32760 99.976% |
| 1033 |
|
| 1034 |
*** Table MOZ_PLACES and all its indices ************************************** |
| 1035 |
|
| 1036 |
Percentage of total database...................... 64.3% |
| 1037 |
Number of entries................................. 87087 |
| 1038 |
Bytes of storage consumed......................... 4653056 |
| 1039 |
Bytes of payload.................................. 3659043 78.6% |
| 1040 |
Average payload per entry......................... 42.02 |
| 1041 |
Average unused bytes per entry.................... 7.93 |
| 1042 |
Average fanout.................................... 17.00 |
| 1043 |
Maximum payload per entry......................... 1867 |
| 1044 |
Entries that use overflow......................... 0 0.0% |
| 1045 |
Index pages used.................................. 8 |
| 1046 |
Primary pages used................................ 134 |
| 1047 |
Overflow pages used............................... 0 |
| 1048 |
Total pages used.................................. 142 |
| 1049 |
Unused bytes on index pages....................... 252188 96.2% |
| 1050 |
Unused bytes on primary pages..................... 438258 10.0% |
| 1051 |
Unused bytes on overflow pages.................... 0 |
| 1052 |
Unused bytes on all pages......................... 690446 14.8% |
| 1053 |
|
| 1054 |
*** Table MOZ_PLACES w/o any indices ****************************************** |
| 1055 |
|
| 1056 |
Percentage of total database...................... 28.5% |
| 1057 |
Number of entries................................. 10894 |
| 1058 |
Bytes of storage consumed......................... 2064384 |
| 1059 |
Bytes of payload.................................. 1838131 89.0% |
| 1060 |
B-tree depth...................................... 2 |
| 1061 |
Average payload per entry......................... 168.73 |
| 1062 |
Average unused bytes per entry.................... 14.10 |
| 1063 |
Average fanout.................................... 62.00 |
| 1064 |
Non-sequential pages.............................. 30 48.4% |
| 1065 |
Maximum payload per entry......................... 1867 |
| 1066 |
Entries that use overflow......................... 0 0.0% |
| 1067 |
Index pages used.................................. 1 |
| 1068 |
Primary pages used................................ 62 |
| 1069 |
Overflow pages used............................... 0 |
| 1070 |
Total pages used.................................. 63 |
| 1071 |
Unused bytes on index pages....................... 32207 98.3% |
| 1072 |
Unused bytes on primary pages..................... 121406 6.0% |
| 1073 |
Unused bytes on overflow pages.................... 0 |
| 1074 |
Unused bytes on all pages......................... 153613 7.4% |
| 1075 |
|
| 1076 |
*** Indices of table MOZ_PLACES *********************************************** |
| 1077 |
|
| 1078 |
Percentage of total database...................... 35.7% |
| 1079 |
Number of entries................................. 76193 |
| 1080 |
Bytes of storage consumed......................... 2588672 |
| 1081 |
Bytes of payload.................................. 1820912 70.3% |
| 1082 |
Average payload per entry......................... 23.90 |
| 1083 |
Average unused bytes per entry.................... 7.05 |
| 1084 |
Average fanout.................................... 11.00 |
| 1085 |
Maximum payload per entry......................... 1823 |
| 1086 |
Entries that use overflow......................... 0 0.0% |
| 1087 |
Index pages used.................................. 7 |
| 1088 |
Primary pages used................................ 72 |
| 1089 |
Overflow pages used............................... 0 |
| 1090 |
Total pages used.................................. 79 |
| 1091 |
Unused bytes on index pages....................... 219981 95.9% |
| 1092 |
Unused bytes on primary pages..................... 316852 13.4% |
| 1093 |
Unused bytes on overflow pages.................... 0 |
| 1094 |
Unused bytes on all pages......................... 536833 20.7% |
| 1095 |
|
| 1096 |
*** Index MOZ_PLACES_FAVICONINDEX of table MOZ_PLACES ************************* |
| 1097 |
|
| 1098 |
Percentage of total database...................... 2.3% |
| 1099 |
Number of entries................................. 10891 |
| 1100 |
Bytes of storage consumed......................... 163840 |
| 1101 |
Bytes of payload.................................. 83178 50.8% |
| 1102 |
B-tree depth...................................... 2 |
| 1103 |
Average payload per entry......................... 7.64 |
| 1104 |
Average unused bytes per entry.................... 4.40 |
| 1105 |
Average fanout.................................... 5.00 |
| 1106 |
Non-sequential pages.............................. 3 75.0% |
| 1107 |
Maximum payload per entry......................... 8 |
| 1108 |
Entries that use overflow......................... 0 0.0% |
| 1109 |
Index pages used.................................. 1 |
| 1110 |
Primary pages used................................ 4 |
| 1111 |
Overflow pages used............................... 0 |
| 1112 |
Total pages used.................................. 5 |
| 1113 |
Unused bytes on index pages....................... 32711 99.83% |
| 1114 |
Unused bytes on primary pages..................... 15213 11.6% |
| 1115 |
Unused bytes on overflow pages.................... 0 |
| 1116 |
Unused bytes on all pages......................... 47924 29.3% |
| 1117 |
|
| 1118 |
*** Index MOZ_PLACES_FRECENCYINDEX of table MOZ_PLACES ************************ |
| 1119 |
|
| 1120 |
Percentage of total database...................... 2.3% |
| 1121 |
Number of entries................................. 10891 |
| 1122 |
Bytes of storage consumed......................... 163840 |
| 1123 |
Bytes of payload.................................. 76772 46.9% |
| 1124 |
B-tree depth...................................... 2 |
| 1125 |
Average payload per entry......................... 7.05 |
| 1126 |
Average unused bytes per entry.................... 4.99 |
| 1127 |
Average fanout.................................... 5.00 |
| 1128 |
Non-sequential pages.............................. 3 75.0% |
| 1129 |
Maximum payload per entry......................... 9 |
| 1130 |
Entries that use overflow......................... 0 0.0% |
| 1131 |
Index pages used.................................. 1 |
| 1132 |
Primary pages used................................ 4 |
| 1133 |
Overflow pages used............................... 0 |
| 1134 |
Total pages used.................................. 5 |
| 1135 |
Unused bytes on index pages....................... 32714 99.84% |
| 1136 |
Unused bytes on primary pages..................... 21616 16.5% |
| 1137 |
Unused bytes on overflow pages.................... 0 |
| 1138 |
Unused bytes on all pages......................... 54330 33.2% |
| 1139 |
|
| 1140 |
*** Index MOZ_PLACES_GUID_UNIQUEINDEX of table MOZ_PLACES ********************* |
| 1141 |
|
| 1142 |
Percentage of total database...................... 4.1% |
| 1143 |
Number of entries................................. 10887 |
| 1144 |
Bytes of storage consumed......................... 294912 |
| 1145 |
Bytes of payload.................................. 196000 66.5% |
| 1146 |
B-tree depth...................................... 2 |
| 1147 |
Average payload per entry......................... 18.00 |
| 1148 |
Average unused bytes per entry.................... 6.07 |
| 1149 |
Average fanout.................................... 9.00 |
| 1150 |
Non-sequential pages.............................. 5 62.5% |
| 1151 |
Maximum payload per entry......................... 18 |
| 1152 |
Entries that use overflow......................... 0 0.0% |
| 1153 |
Index pages used.................................. 1 |
| 1154 |
Primary pages used................................ 8 |
| 1155 |
Overflow pages used............................... 0 |
| 1156 |
Total pages used.................................. 9 |
| 1157 |
Unused bytes on index pages....................... 32581 99.43% |
| 1158 |
Unused bytes on primary pages..................... 33545 12.8% |
| 1159 |
Unused bytes on overflow pages.................... 0 |
| 1160 |
Unused bytes on all pages......................... 66126 22.4% |
| 1161 |
|
| 1162 |
*** Index MOZ_PLACES_HOSTINDEX of table MOZ_PLACES **************************** |
| 1163 |
|
| 1164 |
Percentage of total database...................... 5.0% |
| 1165 |
Number of entries................................. 10885 |
| 1166 |
Bytes of storage consumed......................... 360448 |
| 1167 |
Bytes of payload.................................. 237383 65.9% |
| 1168 |
B-tree depth...................................... 2 |
| 1169 |
Average payload per entry......................... 21.81 |
| 1170 |
Average unused bytes per entry.................... 8.29 |
| 1171 |
Average fanout.................................... 11.00 |
| 1172 |
Non-sequential pages.............................. 7 70.0% |
| 1173 |
Maximum payload per entry......................... 49 |
| 1174 |
Entries that use overflow......................... 0 0.0% |
| 1175 |
Index pages used.................................. 1 |
| 1176 |
Primary pages used................................ 10 |
| 1177 |
Overflow pages used............................... 0 |
| 1178 |
Total pages used.................................. 11 |
| 1179 |
Unused bytes on index pages....................... 32473 99.10% |
| 1180 |
Unused bytes on primary pages..................... 57782 17.6% |
| 1181 |
Unused bytes on overflow pages.................... 0 |
| 1182 |
Unused bytes on all pages......................... 90255 25.0% |
| 1183 |
|
| 1184 |
*** Index MOZ_PLACES_LASTVISITDATEINDEX of table MOZ_PLACES ******************* |
| 1185 |
|
| 1186 |
Percentage of total database...................... 3.2% |
| 1187 |
Number of entries................................. 10889 |
| 1188 |
Bytes of storage consumed......................... 229376 |
| 1189 |
Bytes of payload.................................. 150784 65.7% |
| 1190 |
B-tree depth...................................... 2 |
| 1191 |
Average payload per entry......................... 13.85 |
| 1192 |
Average unused bytes per entry.................... 4.21 |
| 1193 |
Average fanout.................................... 7.00 |
| 1194 |
Non-sequential pages.............................. 4 66.7% |
| 1195 |
Maximum payload per entry......................... 14 |
| 1196 |
Entries that use overflow......................... 0 0.0% |
| 1197 |
Index pages used.................................. 1 |
| 1198 |
Primary pages used................................ 6 |
| 1199 |
Overflow pages used............................... 0 |
| 1200 |
Total pages used.................................. 7 |
| 1201 |
Unused bytes on index pages....................... 32651 99.64% |
| 1202 |
Unused bytes on primary pages..................... 13179 6.7% |
| 1203 |
Unused bytes on overflow pages.................... 0 |
| 1204 |
Unused bytes on all pages......................... 45830 20.0% |
| 1205 |
|
| 1206 |
*** Index MOZ_PLACES_URL_UNIQUEINDEX of table MOZ_PLACES ********************** |
| 1207 |
|
| 1208 |
Percentage of total database...................... 16.7% |
| 1209 |
Number of entries................................. 10859 |
| 1210 |
Bytes of storage consumed......................... 1212416 |
| 1211 |
Bytes of payload.................................. 1010666 83.4% |
| 1212 |
B-tree depth...................................... 2 |
| 1213 |
Average payload per entry......................... 93.07 |
| 1214 |
Average unused bytes per entry.................... 15.42 |
| 1215 |
Average fanout.................................... 37.00 |
| 1216 |
Non-sequential pages.............................. 16 44.4% |
| 1217 |
Maximum payload per entry......................... 1823 |
| 1218 |
Entries that use overflow......................... 0 0.0% |
| 1219 |
Index pages used.................................. 1 |
| 1220 |
Primary pages used................................ 36 |
| 1221 |
Overflow pages used............................... 0 |
| 1222 |
Total pages used.................................. 37 |
| 1223 |
Unused bytes on index pages....................... 24134 73.7% |
| 1224 |
Unused bytes on primary pages..................... 143261 12.1% |
| 1225 |
Unused bytes on overflow pages.................... 0 |
| 1226 |
Unused bytes on all pages......................... 167395 13.8% |
| 1227 |
|
| 1228 |
*** Index MOZ_PLACES_VISITCOUNT of table MOZ_PLACES *************************** |
| 1229 |
|
| 1230 |
Percentage of total database...................... 2.3% |
| 1231 |
Number of entries................................. 10891 |
| 1232 |
Bytes of storage consumed......................... 163840 |
| 1233 |
Bytes of payload.................................. 66129 40.4% |
| 1234 |
B-tree depth...................................... 2 |
| 1235 |
Average payload per entry......................... 6.07 |
| 1236 |
Average unused bytes per entry.................... 5.97 |
| 1237 |
Average fanout.................................... 5.00 |
| 1238 |
Non-sequential pages.............................. 3 75.0% |
| 1239 |
Maximum payload per entry......................... 8 |
| 1240 |
Entries that use overflow......................... 0 0.0% |
| 1241 |
Index pages used.................................. 1 |
| 1242 |
Primary pages used................................ 4 |
| 1243 |
Overflow pages used............................... 0 |
| 1244 |
Total pages used.................................. 5 |
| 1245 |
Unused bytes on index pages....................... 32717 99.84% |
| 1246 |
Unused bytes on primary pages..................... 32256 24.6% |
| 1247 |
Unused bytes on overflow pages.................... 0 |
| 1248 |
Unused bytes on all pages......................... 64973 39.7% |
| 1249 |
|
| 1250 |
*** Table SQLITE_SCHEMA ******************************************************* |
| 1251 |
|
| 1252 |
Percentage of total database...................... 0.45% |
| 1253 |
Number of entries................................. 36 |
| 1254 |
Bytes of storage consumed......................... 32768 |
| 1255 |
Bytes of payload.................................. 5188 15.8% |
| 1256 |
B-tree depth...................................... 1 |
| 1257 |
Average payload per entry......................... 144.11 |
| 1258 |
Average unused bytes per entry.................... 758.58 |
| 1259 |
Maximum payload per entry......................... 379 |
| 1260 |
Entries that use overflow......................... 0 0.0% |
| 1261 |
Primary pages used................................ 1 |
| 1262 |
Overflow pages used............................... 0 |
| 1263 |
Total pages used.................................. 1 |
| 1264 |
Unused bytes on primary pages..................... 27309 83.3% |
| 1265 |
Unused bytes on overflow pages.................... 0 |
| 1266 |
Unused bytes on all pages......................... 27309 83.3% |
| 1267 |
|
| 1268 |
*** Table SQLITE_SEQUENCE ***************************************************** |
| 1269 |
|
| 1270 |
Percentage of total database...................... 0.45% |
| 1271 |
Number of entries................................. 1 |
| 1272 |
Bytes of storage consumed......................... 32768 |
| 1273 |
Bytes of payload.................................. 15 0.046% |
| 1274 |
B-tree depth...................................... 1 |
| 1275 |
Average payload per entry......................... 15.00 |
| 1276 |
Average unused bytes per entry.................... 32741.00 |
| 1277 |
Maximum payload per entry......................... 15 |
| 1278 |
Entries that use overflow......................... 0 0.0% |
| 1279 |
Primary pages used................................ 1 |
| 1280 |
Overflow pages used............................... 0 |
| 1281 |
Total pages used.................................. 1 |
| 1282 |
Unused bytes on primary pages..................... 32741 99.918% |
| 1283 |
Unused bytes on overflow pages.................... 0 |
| 1284 |
Unused bytes on all pages......................... 32741 99.918% |
| 1285 |
|
| 1286 |
*** Table SQLITE_STAT1 ******************************************************** |
| 1287 |
|
| 1288 |
Percentage of total database...................... 0.45% |
| 1289 |
Number of entries................................. 15 |
| 1290 |
Bytes of storage consumed......................... 32768 |
| 1291 |
Bytes of payload.................................. 762 2.3% |
| 1292 |
B-tree depth...................................... 1 |
| 1293 |
Average payload per entry......................... 50.80 |
| 1294 |
Average unused bytes per entry.................... 2128.20 |
| 1295 |
Maximum payload per entry......................... 62 |
| 1296 |
Entries that use overflow......................... 0 0.0% |
| 1297 |
Primary pages used................................ 1 |
| 1298 |
Overflow pages used............................... 0 |
| 1299 |
Total pages used.................................. 1 |
| 1300 |
Unused bytes on primary pages..................... 31923 97.4% |
| 1301 |
Unused bytes on overflow pages.................... 0 |
| 1302 |
Unused bytes on all pages......................... 31923 97.4% |
| 1303 |
|
| 1304 |
<a name="defs"></a>*** Definitions *************************************************************** |
| 1305 |
|
| 1306 |
Page size in bytes |
| 1307 |
|
| 1308 |
The number of bytes in a single page of the database file. |
| 1309 |
Usually 1024. |
| 1310 |
|
| 1311 |
Number of pages in the whole file |
| 1312 |
|
| 1313 |
The number of 32768-byte pages that go into forming the complete |
| 1314 |
database |
| 1315 |
|
| 1316 |
Pages that store data |
| 1317 |
|
| 1318 |
The number of pages that store data, either as primary B*Tree pages or |
| 1319 |
as overflow pages. The number at the right is the data pages divided by |
| 1320 |
the total number of pages in the file. |
| 1321 |
|
| 1322 |
Pages on the freelist |
| 1323 |
|
| 1324 |
The number of pages that are not currently in use but are reserved for |
| 1325 |
future use. The percentage at the right is the number of freelist pages |
| 1326 |
divided by the total number of pages in the file. |
| 1327 |
|
| 1328 |
Pages of auto-vacuum overhead |
| 1329 |
|
| 1330 |
The number of pages that store data used by the database to facilitate |
| 1331 |
auto-vacuum. This is zero for databases that do not support auto-vacuum. |
| 1332 |
|
| 1333 |
Number of tables in the database |
| 1334 |
|
| 1335 |
The number of tables in the database, including the SQLITE_SCHEMA table |
| 1336 |
used to store schema information. |
| 1337 |
|
| 1338 |
Number of indices |
| 1339 |
|
| 1340 |
The total number of indices in the database. |
| 1341 |
|
| 1342 |
Number of defined indices |
| 1343 |
|
| 1344 |
The number of indices created using an explicit CREATE INDEX statement. |
| 1345 |
|
| 1346 |
Number of implied indices |
| 1347 |
|
| 1348 |
The number of indices used to implement PRIMARY KEY or UNIQUE constraints |
| 1349 |
on tables. |
| 1350 |
|
| 1351 |
Size of the file in bytes |
| 1352 |
|
| 1353 |
The total amount of disk space used by the entire database files. |
| 1354 |
|
| 1355 |
Bytes of user payload stored |
| 1356 |
|
| 1357 |
The total number of bytes of user payload stored in the database. The |
| 1358 |
schema information in the SQLITE_SCHEMA table is not counted when |
| 1359 |
computing this number. The percentage at the right shows the payload |
| 1360 |
divided by the total file size. |
| 1361 |
|
| 1362 |
Percentage of total database |
| 1363 |
|
| 1364 |
The amount of the complete database file that is devoted to storing |
| 1365 |
information described by this category. |
| 1366 |
|
| 1367 |
Number of entries |
| 1368 |
|
| 1369 |
The total number of B-Tree key/value pairs stored under this category. |
| 1370 |
|
| 1371 |
Bytes of storage consumed |
| 1372 |
|
| 1373 |
The total amount of disk space required to store all B-Tree entries |
| 1374 |
under this category. The is the total number of pages used times |
| 1375 |
the pages size. |
| 1376 |
|
| 1377 |
Bytes of payload |
| 1378 |
|
| 1379 |
The amount of payload stored under this category. Payload is the data |
| 1380 |
part of table entries and the key part of index entries. The percentage |
| 1381 |
at the right is the bytes of payload divided by the bytes of storage |
| 1382 |
consumed. |
| 1383 |
|
| 1384 |
Average payload per entry |
| 1385 |
|
| 1386 |
The average amount of payload on each entry. This is just the bytes of |
| 1387 |
payload divided by the number of entries. |
| 1388 |
|
| 1389 |
Average unused bytes per entry |
| 1390 |
|
| 1391 |
The average amount of free space remaining on all pages under this |
| 1392 |
category on a per-entry basis. This is the number of unused bytes on |
| 1393 |
all pages divided by the number of entries. |
| 1394 |
|
| 1395 |
Non-sequential pages |
| 1396 |
|
| 1397 |
The number of pages in the table or index that are out of sequence. |
| 1398 |
Many filesystems are optimized for sequential file access so a small |
| 1399 |
number of non-sequential pages might result in faster queries, |
| 1400 |
especially for larger database files that do not fit in the disk cache. |
| 1401 |
Note that after running VACUUM, the root page of each table or index is |
| 1402 |
at the beginning of the database file and all other pages are in a |
| 1403 |
separate part of the database file, resulting in a single non- |
| 1404 |
sequential page. |
| 1405 |
|
| 1406 |
Maximum payload per entry |
| 1407 |
|
| 1408 |
The largest payload size of any entry. |
| 1409 |
|
| 1410 |
Entries that use overflow |
| 1411 |
|
| 1412 |
The number of entries that user one or more overflow pages. |
| 1413 |
|
| 1414 |
Total pages used |
| 1415 |
|
| 1416 |
This is the number of pages used to hold all information in the current |
| 1417 |
category. This is the sum of index, primary, and overflow pages. |
| 1418 |
|
| 1419 |
Index pages used |
| 1420 |
|
| 1421 |
This is the number of pages in a table B-tree that hold only key (rowid) |
| 1422 |
information and no data. |
| 1423 |
|
| 1424 |
Primary pages used |
| 1425 |
|
| 1426 |
This is the number of B-tree pages that hold both key and data. |
| 1427 |
|
| 1428 |
Overflow pages used |
| 1429 |
|
| 1430 |
The total number of overflow pages used for this category. |
| 1431 |
|
| 1432 |
Unused bytes on index pages |
| 1433 |
|
| 1434 |
The total number of bytes of unused space on all index pages. The |
| 1435 |
percentage at the right is the number of unused bytes divided by the |
| 1436 |
total number of bytes on index pages. |
| 1437 |
|
| 1438 |
Unused bytes on primary pages |
| 1439 |
|
| 1440 |
The total number of bytes of unused space on all primary pages. The |
| 1441 |
percentage at the right is the number of unused bytes divided by the |
| 1442 |
total number of bytes on primary pages. |
| 1443 |
|
| 1444 |
Unused bytes on overflow pages |
| 1445 |
|
| 1446 |
The total number of bytes of unused space on all overflow pages. The |
| 1447 |
percentage at the right is the number of unused bytes divided by the |
| 1448 |
total number of bytes on overflow pages. |
| 1449 |
|
| 1450 |
Unused bytes on all pages |
| 1451 |
|
| 1452 |
The total number of bytes of unused space on all primary and overflow |
| 1453 |
pages. The percentage at the right is the number of unused bytes |
| 1454 |
divided by the total number of bytes. |
| 1455 |
|
| 1456 |
<a name="sqlx"></a>******************************************************************************* |
| 1457 |
The entire text of this report can be sourced into any SQL database |
| 1458 |
engine for further analysis. All of the text above is an SQL comment. |
| 1459 |
The data used to generate this report follows: |
| 1460 |
*/ |
| 1461 |
BEGIN; |
| 1462 |
CREATE TABLE space_used( |
| 1463 |
name clob, -- Name of a table or index in the database file |
| 1464 |
tblname clob, -- Name of associated table |
| 1465 |
is_index boolean, -- TRUE if it is an index, false for a table |
| 1466 |
nentry int, -- Number of entries in the BTree |
| 1467 |
leaf_entries int, -- Number of leaf entries |
| 1468 |
depth int, -- Depth of the b-tree |
| 1469 |
payload int, -- Total amount of data stored in this table or index |
| 1470 |
ovfl_payload int, -- Total amount of data stored on overflow pages |
| 1471 |
ovfl_cnt int, -- Number of entries that use overflow |
| 1472 |
mx_payload int, -- Maximum payload size |
| 1473 |
int_pages int, -- Number of interior pages used |
| 1474 |
leaf_pages int, -- Number of leaf pages used |
| 1475 |
ovfl_pages int, -- Number of overflow pages used |
| 1476 |
int_unused int, -- Number of unused bytes on interior pages |
| 1477 |
leaf_unused int, -- Number of unused bytes on primary pages |
| 1478 |
ovfl_unused int, -- Number of unused bytes on overflow pages |
| 1479 |
gap_cnt int, -- Number of gaps in the page layout |
| 1480 |
compressed_size int -- Total bytes stored on disk |
| 1481 |
); |
| 1482 |
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); |
| 1483 |
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); |
| 1484 |
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); |
| 1485 |
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); |
| 1486 |
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); |
| 1487 |
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); |
| 1488 |
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); |
| 1489 |
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); |
| 1490 |
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); |
| 1491 |
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); |
| 1492 |
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); |
| 1493 |
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); |
| 1494 |
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); |
| 1495 |
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); |
| 1496 |
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); |
| 1497 |
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); |
| 1498 |
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); |
| 1499 |
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); |
| 1500 |
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); |
| 1501 |
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); |
| 1502 |
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); |
| 1503 |
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); |
| 1504 |
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); |
| 1505 |
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); |
| 1506 |
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); |
| 1507 |
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); |
| 1508 |
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); |
| 1509 |
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); |
| 1510 |
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); |
| 1511 |
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); |
| 1512 |
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); |
| 1513 |
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); |
| 1514 |
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); |
| 1515 |
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); |
| 1516 |
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); |
| 1517 |
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); |
| 1518 |
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); |
| 1519 |
COMMIT; |
| 1520 |
</pre></blockquote> |
| 1521 |
|
| 1522 |
|