Debian Codegraph @

www/sqlanalyze.html

raw
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 &#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;&#9608;/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