/** Disk-Space Utilization Report For folder.0002-qioaq2fp.db Page size in bytes................................ 4096 Pages in the whole file (measured)................ 14899399 Pages in the whole file (calculated).............. 14899399 Pages that store data............................. 14889072 99.931% Pages on the freelist (per header)................ 10326 0.069% Pages on the freelist (calculated)................ 10326 0.069% Pages of auto-vacuum overhead..................... 0 0.0% Number of tables in the database.................. 15 Number of WITHOUT ROWID tables.................... 6 Number of indices................................. 8 Number of defined indices......................... 5 Number of implied indices......................... 3 Size of the file in bytes......................... 61027938304 Bytes of user payload stored...................... 40531186579 66.4% *** Page counts for all tables with their indices ***************************** FILES............................................. 4212107 28.3% FILEINFOS......................................... 4204427 28.2% BLOCKS............................................ 2790640 18.7% BLOCKLISTS........................................ 2421143 16.2% FILE_NAMES........................................ 1235339 8.3% FILE_VERSIONS..................................... 25404 0.17% SQLITE_SCHEMA..................................... 3 0.0% DEVICES........................................... 2 0.0% COUNTS............................................ 1 0.0% INDEXIDS.......................................... 1 0.0% KV................................................ 1 0.0% MTIMES............................................ 1 0.0% SCHEMAMIGRATIONS.................................. 1 0.0% SQLITE_SEQUENCE................................... 1 0.0% SQLITE_STAT1...................................... 1 0.0% *** Page counts for all tables and indices separately ************************* FILEINFOS......................................... 4204427 28.2% BLOCKS............................................ 2790640 18.7% BLOCKLISTS........................................ 2421143 16.2% FILES............................................. 1691537 11.4% FILES_BLOCKLIST_HASH_ONLY......................... 1048374 7.0% SQLITE_AUTOINDEX_FILE_NAMES_1..................... 651737 4.4% FILE_NAMES........................................ 583602 3.9% FILES_DEVICE_NAME................................. 433815 2.9% FILES_NAME_IDX_ONLY............................... 377635 2.5% FILES_VERSION_IDX_ONLY............................ 351207 2.4% FILES_REMOTE_SEQUENCE............................. 309539 2.1% SQLITE_AUTOINDEX_FILE_VERSIONS_1.................. 13170 0.088% FILE_VERSIONS..................................... 12234 0.082% SQLITE_SCHEMA..................................... 3 0.0% COUNTS............................................ 1 0.0% DEVICES........................................... 1 0.0% INDEXIDS.......................................... 1 0.0% KV................................................ 1 0.0% MTIMES............................................ 1 0.0% SCHEMAMIGRATIONS.................................. 1 0.0% SQLITE_AUTOINDEX_DEVICES_1........................ 1 0.0% SQLITE_SEQUENCE................................... 1 0.0% SQLITE_STAT1...................................... 1 0.0% *** All tables and indices **************************************************** Percentage of total database...................... 99.931% Number of entries................................. 884978179 Bytes of storage consumed......................... 60985638912 Bytes of payload.................................. 50499667369 82.8% Bytes of metadata................................. 3900964652 6.4% Average payload per entry......................... 57.06 Average unused bytes per entry.................... 7.44 Average metadata per entry........................ 4.41 Average fanout.................................... 71.00 Maximum payload per entry......................... 158463 Entries that use overflow......................... 922711 0.10% Index pages used.................................. 188699 Primary pages used................................ 13237826 Overflow pages used............................... 1462547 Total pages used.................................. 14889072 Unused bytes on index pages....................... 134135764 17.4% Unused bytes on primary pages..................... 4162901204 7.7% Unused bytes on overflow pages.................... 2290129267 38.2% Unused bytes on all pages......................... 6587166235 10.8% *** All tables **************************************************************** Percentage of total database...................... 78.6% Number of entries................................. 391599051 Bytes of storage consumed......................... 47937921024 Bytes of payload.................................. 40531192222 84.5% Bytes of metadata................................. 2382572300 5.0% Average payload per entry......................... 103.50 Average unused bytes per entry.................... 12.84 Average metadata per entry........................ 6.08 Average fanout.................................... 66.00 Maximum payload per entry......................... 158463 Entries that use overflow......................... 922711 0.24% Index pages used.................................. 154557 Primary pages used................................ 10086490 Overflow pages used............................... 1462547 Total pages used.................................. 11703594 Unused bytes on index pages....................... 117176539 18.5% Unused bytes on primary pages..................... 2619010040 6.3% Unused bytes on overflow pages.................... 2290129267 38.2% Unused bytes on all pages......................... 5026315846 10.5% *** All WITHOUT ROWID tables ************************************************** Percentage of total database...................... 35.0% Number of entries................................. 155079241 Bytes of storage consumed......................... 21347479552 Bytes of payload.................................. 16581139024 77.7% Bytes of metadata................................. 524840919 2.5% Average payload per entry......................... 106.92 Average unused bytes per entry.................... 27.36 Average metadata per entry........................ 3.38 Average fanout.................................... 27.00 Maximum payload per entry......................... 158463 Entries that use overflow......................... 922711 0.59% Index pages used.................................. 136001 Primary pages used................................ 3613239 Overflow pages used............................... 1462547 Total pages used.................................. 5211787 Unused bytes on index pages....................... 105995166 19.0% Unused bytes on primary pages..................... 1847534520 12.5% Unused bytes on overflow pages.................... 2290129267 38.2% Unused bytes on all pages......................... 4243658953 19.9% *** ALL rowid tables ********************************************************** Percentage of total database...................... 43.6% Number of entries................................. 236519810 Bytes of storage consumed......................... 26590441472 Bytes of payload.................................. 23950053198 90.1% Bytes of metadata................................. 1857731381 7.0% Average payload per entry......................... 101.26 Average unused bytes per entry.................... 3.31 Average metadata per entry........................ 7.85 Average fanout.................................... 349.00 Maximum payload per entry......................... 843 Entries that use overflow......................... 0 0.0% Index pages used.................................. 18556 Primary pages used................................ 6473251 Overflow pages used............................... 0 Total pages used.................................. 6491807 Unused bytes on index pages....................... 11181373 14.7% Unused bytes on primary pages..................... 771475520 2.9% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 782656893 2.9% *** All indices *************************************************************** Percentage of total database...................... 21.4% Number of entries................................. 493379128 Bytes of storage consumed......................... 13047717888 Bytes of payload.................................. 9968475147 76.4% Bytes of metadata................................. 1518392352 11.6% Average payload per entry......................... 20.20 Average unused bytes per entry.................... 3.16 Average metadata per entry........................ 3.08 Average fanout.................................... 93.00 Maximum payload per entry......................... 317 Entries that use overflow......................... 0 0.0% Index pages used.................................. 34142 Primary pages used................................ 3151336 Overflow pages used............................... 0 Total pages used.................................. 3185478 Unused bytes on index pages....................... 16959225 12.1% Unused bytes on primary pages..................... 1543891164 12.0% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 1560850389 12.0% *** Table BLOCKLISTS ********************************************************** Percentage of total database...................... 16.2% Number of entries................................. 28473540 Bytes of storage consumed......................... 9917001728 Bytes of payload.................................. 6898825597 69.6% Bytes of metadata................................. 111536108 1.1% B-tree depth...................................... 9 Average payload per entry......................... 242.29 Average unused bytes per entry.................... 102.16 Average metadata per entry........................ 3.92 Average fanout.................................... 13.00 Non-sequential pages.............................. 620553 25.6% Maximum payload per entry......................... 158463 Entries that use overflow......................... 922711 3.2% Index pages used.................................. 72392 Primary pages used................................ 886204 Overflow pages used............................... 1462547 Total pages used.................................. 2421143 Unused bytes on index pages....................... 74678726 25.2% Unused bytes on primary pages..................... 543991374 15.0% Unused bytes on overflow pages.................... 2290129267 38.2% Unused bytes on all pages......................... 2908799367 29.3% *** Table BLOCKS ************************************************************** Percentage of total database...................... 18.7% Number of entries................................. 126605643 Bytes of storage consumed......................... 11430461440 Bytes of payload.................................. 9682312693 84.7% Bytes of metadata................................. 413304605 3.6% B-tree depth...................................... 5 Average payload per entry......................... 76.48 Average unused bytes per entry.................... 10.54 Average metadata per entry........................ 3.26 Average fanout.................................... 43.00 Non-sequential pages.............................. 1058411 37.9% Maximum payload per entry......................... 82 Entries that use overflow......................... 0 0.0% Index pages used.................................. 63609 Primary pages used................................ 2727031 Overflow pages used............................... 0 Total pages used.................................. 2790640 Unused bytes on index pages....................... 31316440 12.0% Unused bytes on primary pages..................... 1303527702 11.7% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 1334844142 11.7% *** Table COUNTS ************************************************************** Percentage of total database...................... 0.0% Number of entries................................. 53 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 602 14.7% Bytes of metadata................................. 167 4.1% B-tree depth...................................... 1 Average payload per entry......................... 11.36 Average unused bytes per entry.................... 62.77 Average metadata per entry........................ 3.15 Maximum payload per entry......................... 19 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3327 81.2% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3327 81.2% *** Table DEVICES and all its indices ***************************************** Percentage of total database...................... 0.0% Number of entries................................. 6 Bytes of storage consumed......................... 8192 Bytes of payload.................................. 404 4.9% Bytes of metadata................................. 37 0.45% Average payload per entry......................... 67.33 Average unused bytes per entry.................... 1291.83 Average metadata per entry........................ 6.17 Maximum payload per entry......................... 68 Entries that use overflow......................... 0 0.0% Primary pages used................................ 2 Overflow pages used............................... 0 Total pages used.................................. 2 Unused bytes on primary pages..................... 7751 94.6% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 7751 94.6% *** Table DEVICES w/o any indices ********************************************* Percentage of total database...................... 0.0% Number of entries................................. 3 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 201 4.9% Bytes of metadata................................. 20 0.49% B-tree depth...................................... 1 Average payload per entry......................... 67.00 Average unused bytes per entry.................... 1291.67 Average metadata per entry........................ 6.67 Maximum payload per entry......................... 67 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3875 94.6% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3875 94.6% *** Index SQLITE_AUTOINDEX_DEVICES_1 of table DEVICES ************************* Percentage of total database...................... 0.0% Number of entries................................. 3 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 203 5.0% Bytes of metadata................................. 17 0.42% B-tree depth...................................... 1 Average payload per entry......................... 67.67 Average unused bytes per entry.................... 1292.00 Average metadata per entry........................ 5.67 Maximum payload per entry......................... 68 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3876 94.6% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3876 94.6% *** Table FILE_NAMES and all its indices ************************************** Percentage of total database...................... 8.3% Number of entries................................. 69005010 Bytes of storage consumed......................... 5059948544 Bytes of payload.................................. 4309635894 85.2% Bytes of metadata................................. 361251094 7.1% Average payload per entry......................... 62.45 Average unused bytes per entry.................... 5.64 Average metadata per entry........................ 5.24 Average fanout.................................... 84.00 Maximum payload per entry......................... 317 Entries that use overflow......................... 0 0.0% Index pages used.................................. 14649 Primary pages used................................ 1220690 Overflow pages used............................... 0 Total pages used.................................. 1235339 Unused bytes on index pages....................... 8255253 13.8% Unused bytes on primary pages..................... 380806303 7.6% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 389061556 7.7% *** Table FILE_NAMES w/o any indices ****************************************** Percentage of total database...................... 3.9% Number of entries................................. 34502505 Bytes of storage consumed......................... 2390433792 Bytes of payload.................................. 2090023455 87.4% Bytes of metadata................................. 249893475 10.5% B-tree depth...................................... 4 Average payload per entry......................... 60.58 Average unused bytes per entry.................... 1.46 Average metadata per entry........................ 7.24 Average fanout.................................... 348.00 Non-sequential pages.............................. 577733 99.0% Maximum payload per entry......................... 314 Entries that use overflow......................... 0 0.0% Index pages used.................................. 1677 Primary pages used................................ 581925 Overflow pages used............................... 0 Total pages used.................................. 583602 Unused bytes on index pages....................... 1058612 15.4% Unused bytes on primary pages..................... 49458250 2.1% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 50516862 2.1% *** Index SQLITE_AUTOINDEX_FILE_NAMES_1 of table FILE_NAMES ******************* Percentage of total database...................... 4.4% Number of entries................................. 34502505 Bytes of storage consumed......................... 2669514752 Bytes of payload.................................. 2219612439 83.1% Bytes of metadata................................. 111357619 4.2% B-tree depth...................................... 5 Average payload per entry......................... 64.33 Average unused bytes per entry.................... 9.81 Average metadata per entry........................ 3.23 Average fanout.................................... 50.00 Non-sequential pages.............................. 620908 95.3% Maximum payload per entry......................... 317 Entries that use overflow......................... 0 0.0% Index pages used.................................. 12972 Primary pages used................................ 638765 Overflow pages used............................... 0 Total pages used.................................. 651737 Unused bytes on index pages....................... 7196641 13.5% Unused bytes on primary pages..................... 331348053 12.7% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 338544694 12.7% *** Table FILE_VERSIONS and all its indices *********************************** Percentage of total database...................... 0.17% Number of entries................................. 2480448 Bytes of storage consumed......................... 104054784 Bytes of payload.................................. 78102215 75.1% Bytes of metadata................................. 11511622 11.1% Average payload per entry......................... 31.49 Average unused bytes per entry.................... 5.82 Average metadata per entry........................ 4.64 Average fanout.................................... 141.00 Maximum payload per entry......................... 33 Entries that use overflow......................... 0 0.0% Index pages used.................................. 180 Primary pages used................................ 25224 Overflow pages used............................... 0 Total pages used.................................. 25404 Unused bytes on index pages....................... 104926 14.2% Unused bytes on primary pages..................... 14336021 13.9% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 14440947 13.9% *** Table FILE_VERSIONS w/o any indices *************************************** Percentage of total database...................... 0.082% Number of entries................................. 1240224 Bytes of storage consumed......................... 50110464 Bytes of payload.................................. 37206720 74.2% Bytes of metadata................................. 7632914 15.2% B-tree depth...................................... 3 Average payload per entry......................... 30.00 Average unused bytes per entry.................... 4.25 Average metadata per entry........................ 6.15 Average fanout.................................... 382.00 Non-sequential pages.............................. 12199 99.72% Maximum payload per entry......................... 30 Entries that use overflow......................... 0 0.0% Index pages used.................................. 32 Primary pages used................................ 12202 Overflow pages used............................... 0 Total pages used.................................. 12234 Unused bytes on index pages....................... 21019 16.0% Unused bytes on primary pages..................... 5249811 10.5% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 5270830 10.5% *** Index SQLITE_AUTOINDEX_FILE_VERSIONS_1 of table FILE_VERSIONS ************* Percentage of total database...................... 0.088% Number of entries................................. 1240224 Bytes of storage consumed......................... 53944320 Bytes of payload.................................. 40895495 75.8% Bytes of metadata................................. 3878708 7.2% B-tree depth...................................... 4 Average payload per entry......................... 32.97 Average unused bytes per entry.................... 7.39 Average metadata per entry........................ 3.13 Average fanout.................................... 88.00 Non-sequential pages.............................. 13016 98.8% Maximum payload per entry......................... 33 Entries that use overflow......................... 0 0.0% Index pages used.................................. 148 Primary pages used................................ 13022 Overflow pages used............................... 0 Total pages used.................................. 13170 Unused bytes on index pages....................... 83907 13.8% Unused bytes on primary pages..................... 9086210 17.0% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 9170117 17.0% *** Table FILEINFOS *********************************************************** Percentage of total database...................... 28.2% Number of entries................................. 100388517 Bytes of storage consumed......................... 17221332992 Bytes of payload.................................. 15777561591 91.6% Bytes of metadata................................. 869114786 5.0% B-tree depth...................................... 4 Average payload per entry......................... 157.17 Average unused bytes per entry.................... 5.72 Average metadata per entry........................ 8.66 Average fanout.................................... 349.00 Non-sequential pages.............................. 3294249 78.4% Maximum payload per entry......................... 418 Entries that use overflow......................... 0 0.0% Index pages used.................................. 12013 Primary pages used................................ 4192414 Overflow pages used............................... 0 Total pages used.................................. 4204427 Unused bytes on index pages....................... 7202856 14.6% Unused bytes on primary pages..................... 567453759 3.3% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 574656615 3.3% *** Table FILES and all its indices ******************************************* Percentage of total database...................... 28.3% Number of entries................................. 558024913 Bytes of storage consumed......................... 17252790272 Bytes of payload.................................. 13753221883 79.7% Bytes of metadata................................. 2134245840 12.4% Average payload per entry......................... 24.65 Average unused bytes per entry.................... 2.45 Average metadata per entry........................ 3.82 Average fanout.................................... 162.00 Maximum payload per entry......................... 70 Entries that use overflow......................... 0 0.0% Index pages used.................................. 25855 Primary pages used................................ 4186252 Overflow pages used............................... 0 Total pages used.................................. 4212107 Unused bytes on index pages....................... 12573586 11.9% Unused bytes on primary pages..................... 1352748963 7.9% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 1365322549 7.9% *** Table FILES w/o any indices *********************************************** Percentage of total database...................... 11.4% Number of entries................................. 100388517 Bytes of storage consumed......................... 6928535552 Bytes of payload.................................. 6045254873 87.3% Bytes of metadata................................. 731089832 10.6% B-tree depth...................................... 4 Average payload per entry......................... 60.22 Average unused bytes per entry.................... 1.52 Average metadata per entry........................ 7.28 Average fanout.................................... 349.00 Non-sequential pages.............................. 1668073 98.6% Maximum payload per entry......................... 70 Entries that use overflow......................... 0 0.0% Index pages used.................................. 4833 Primary pages used................................ 1686704 Overflow pages used............................... 0 Total pages used.................................. 1691537 Unused bytes on index pages....................... 2894909 14.6% Unused bytes on primary pages..................... 149295938 2.2% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 152190847 2.2% *** Indices of table FILES **************************************************** Percentage of total database...................... 16.9% Number of entries................................. 457636396 Bytes of storage consumed......................... 10324254720 Bytes of payload.................................. 7707967010 74.7% Bytes of metadata................................. 1403156008 13.6% Average payload per entry......................... 16.84 Average unused bytes per entry.................... 2.65 Average metadata per entry........................ 3.07 Average fanout.................................... 119.00 Maximum payload per entry......................... 41 Entries that use overflow......................... 0 0.0% Index pages used.................................. 21022 Primary pages used................................ 2499548 Overflow pages used............................... 0 Total pages used.................................. 2520570 Unused bytes on index pages....................... 9678677 11.2% Unused bytes on primary pages..................... 1203453025 11.8% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 1213131702 11.8% *** Index FILES_BLOCKLIST_HASH_ONLY of table FILES **************************** Percentage of total database...................... 7.0% Number of entries................................. 87487007 Bytes of storage consumed......................... 4294139904 Bytes of payload.................................. 3551848416 82.7% Bytes of metadata................................. 275041505 6.4% B-tree depth...................................... 5 Average payload per entry......................... 40.60 Average unused bytes per entry.................... 5.34 Average metadata per entry........................ 3.14 Average fanout.................................... 77.00 Non-sequential pages.............................. 949141 90.5% Maximum payload per entry......................... 41 Entries that use overflow......................... 0 0.0% Index pages used.................................. 13550 Primary pages used................................ 1034824 Overflow pages used............................... 0 Total pages used.................................. 1048374 Unused bytes on index pages....................... 6090957 11.0% Unused bytes on primary pages..................... 461159026 10.9% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 467249983 10.9% *** Index FILES_DEVICE_NAME of table FILES ************************************ Percentage of total database...................... 2.9% Number of entries................................. 100388517 Bytes of storage consumed......................... 1776906240 Bytes of payload.................................. 1240271504 69.8% Bytes of metadata................................. 306371327 17.2% B-tree depth...................................... 4 Average payload per entry......................... 12.35 Average unused bytes per entry.................... 2.29 Average metadata per entry........................ 3.05 Average fanout.................................... 186.00 Non-sequential pages.............................. 425273 98.0% Maximum payload per entry......................... 13 Entries that use overflow......................... 0 0.0% Index pages used.................................. 2321 Primary pages used................................ 431494 Overflow pages used............................... 0 Total pages used.................................. 433815 Unused bytes on index pages....................... 1109138 11.7% Unused bytes on primary pages..................... 229154271 13.0% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 230263409 13.0% *** Index FILES_NAME_IDX_ONLY of table FILES ********************************** Percentage of total database...................... 2.5% Number of entries................................. 100388517 Bytes of storage consumed......................... 1546792960 Bytes of payload.................................. 1070899149 69.2% Bytes of metadata................................. 305697167 19.8% B-tree depth...................................... 4 Average payload per entry......................... 10.67 Average unused bytes per entry.................... 1.70 Average metadata per entry........................ 3.05 Average fanout.................................... 208.00 Non-sequential pages.............................. 370552 98.1% Maximum payload per entry......................... 11 Entries that use overflow......................... 0 0.0% Index pages used.................................. 1815 Primary pages used................................ 375820 Overflow pages used............................... 0 Total pages used.................................. 377635 Unused bytes on index pages....................... 762826 10.3% Unused bytes on primary pages..................... 169433818 11.0% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 170196644 11.0% *** Index FILES_REMOTE_SEQUENCE of table FILES ******************************** Percentage of total database...................... 2.1% Number of entries................................. 68983838 Bytes of storage consumed......................... 1267871744 Bytes of payload.................................. 884308972 69.7% Bytes of metadata................................. 210665978 16.6% B-tree depth...................................... 4 Average payload per entry......................... 12.82 Average unused bytes per entry.................... 2.51 Average metadata per entry........................ 3.05 Average fanout.................................... 177.00 Non-sequential pages.............................. 306392 99.0% Maximum payload per entry......................... 13 Entries that use overflow......................... 0 0.0% Index pages used.................................. 1741 Primary pages used................................ 307798 Overflow pages used............................... 0 Total pages used.................................. 309539 Unused bytes on index pages....................... 1004761 14.1% Unused bytes on primary pages..................... 171892033 13.6% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 172896794 13.6% *** Index FILES_VERSION_IDX_ONLY of table FILES ******************************* Percentage of total database...................... 2.4% Number of entries................................. 100388517 Bytes of storage consumed......................... 1438543872 Bytes of payload.................................. 960638969 66.8% Bytes of metadata................................. 305380031 21.2% B-tree depth...................................... 4 Average payload per entry......................... 9.57 Average unused bytes per entry.................... 1.72 Average metadata per entry........................ 3.04 Average fanout.................................... 220.00 Non-sequential pages.............................. 346357 98.6% Maximum payload per entry......................... 10 Entries that use overflow......................... 0 0.0% Index pages used.................................. 1595 Primary pages used................................ 349612 Overflow pages used............................... 0 Total pages used.................................. 351207 Unused bytes on index pages....................... 710995 10.9% Unused bytes on primary pages..................... 171813877 12.0% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 172524872 12.0% *** Table INDEXIDS ************************************************************ Percentage of total database...................... 0.0% Number of entries................................. 3 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 74 1.8% Bytes of metadata................................. 17 0.42% B-tree depth...................................... 1 Average payload per entry......................... 24.67 Average unused bytes per entry.................... 1335.00 Average metadata per entry........................ 5.67 Maximum payload per entry......................... 25 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 4005 97.8% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4005 97.8% *** Table KV ****************************************************************** Percentage of total database...................... 0.0% Number of entries................................. 2 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 58 1.4% Bytes of metadata................................. 14 0.34% B-tree depth...................................... 1 Average payload per entry......................... 29.00 Average unused bytes per entry.................... 2012.00 Average metadata per entry........................ 7.00 Maximum payload per entry......................... 36 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 4024 98.2% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4024 98.2% *** Table MTIMES ************************************************************** Percentage of total database...................... 0.0% Number of entries................................. 0 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 0 0.0% Bytes of metadata................................. 8 0.20% B-tree depth...................................... 1 Average payload per entry......................... 0.0 Average unused bytes per entry.................... 0.0 Average metadata per entry........................ 0.0 Maximum payload per entry......................... 0 Entries that use overflow......................... 0 Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 4088 99.80% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4088 99.80% *** Table SCHEMAMIGRATIONS **************************************************** Percentage of total database...................... 0.0% Number of entries................................. 1 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 147 3.6% Bytes of metadata................................. 13 0.32% B-tree depth...................................... 1 Average payload per entry......................... 147.00 Average unused bytes per entry.................... 3936.00 Average metadata per entry........................ 13.00 Maximum payload per entry......................... 147 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3936 96.1% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3936 96.1% *** Table SQLITE_SCHEMA ******************************************************* Percentage of total database...................... 0.0% Number of entries................................. 26 Bytes of storage consumed......................... 12288 Bytes of payload.................................. 5643 45.9% Bytes of metadata................................. 257 2.1% B-tree depth...................................... 2 Average payload per entry......................... 217.04 Average unused bytes per entry.................... 245.69 Average metadata per entry........................ 9.88 Average fanout.................................... 2.00 Non-sequential pages.............................. 1 50.0% Maximum payload per entry......................... 843 Entries that use overflow......................... 0 0.0% Index pages used.................................. 1 Primary pages used................................ 2 Overflow pages used............................... 0 Total pages used.................................. 3 Unused bytes on index pages....................... 3977 97.1% Unused bytes on primary pages..................... 2411 29.4% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 6388 52.0% *** Table SQLITE_SEQUENCE ***************************************************** Percentage of total database...................... 0.0% Number of entries................................. 2 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 25 0.61% Bytes of metadata................................. 16 0.39% B-tree depth...................................... 1 Average payload per entry......................... 12.50 Average unused bytes per entry.................... 2027.50 Average metadata per entry........................ 8.00 Maximum payload per entry......................... 13 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 4055 99.0% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4055 99.0% *** Table SQLITE_STAT1 ******************************************************** Percentage of total database...................... 0.0% Number of entries................................. 15 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 543 13.3% Bytes of metadata................................. 68 1.7% B-tree depth...................................... 1 Average payload per entry......................... 36.20 Average unused bytes per entry.................... 232.33 Average metadata per entry........................ 4.53 Maximum payload per entry......................... 58 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3485 85.1% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3485 85.1% *** Definitions *************************************************************** Page size in bytes The number of bytes in a single page of the database file. Usually 1024. Number of pages in the whole file The number of 4096-byte pages that go into forming the complete database Pages that store data The number of pages that store data, either as primary B*Tree pages or as overflow pages. The number at the right is the data pages divided by the total number of pages in the file. Pages on the freelist The number of pages that are not currently in use but are reserved for future use. The percentage at the right is the number of freelist pages divided by the total number of pages in the file. Pages of auto-vacuum overhead The number of pages that store data used by the database to facilitate auto-vacuum. This is zero for databases that do not support auto-vacuum. Number of tables in the database The number of tables in the database, including the SQLITE_SCHEMA table used to store schema information. Number of indices The total number of indices in the database. Number of defined indices The number of indices created using an explicit CREATE INDEX statement. Number of implied indices The number of indices used to implement PRIMARY KEY or UNIQUE constraints on tables. Size of the file in bytes The total amount of disk space used by the entire database files. Bytes of user payload stored The total number of bytes of user payload stored in the database. The schema information in the SQLITE_SCHEMA table is not counted when computing this number. The percentage at the right shows the payload divided by the total file size. Percentage of total database The amount of the complete database file that is devoted to storing information described by this category. Number of entries The total number of B-Tree key/value pairs stored under this category. Bytes of storage consumed The total amount of disk space required to store all B-Tree entries under this category. The is the total number of pages used times the pages size. Bytes of payload The amount of payload stored under this category. Payload is the data part of table entries and the key part of index entries. The percentage at the right is the bytes of payload divided by the bytes of storage consumed. Bytes of metadata The amount of formatting and structural information stored in the table or index. Metadata includes the btree page header, the cell pointer array, the size field for each cell, the left child pointer or non-leaf cells, the overflow pointers for overflow cells, and the rowid value for rowid table cells. In other words, metadata is everything that is neither unused space nor content. The record header in the payload is counted as content, not metadata. Average payload per entry The average amount of payload on each entry. This is just the bytes of payload divided by the number of entries. Average unused bytes per entry The average amount of free space remaining on all pages under this category on a per-entry basis. This is the number of unused bytes on all pages divided by the number of entries. Non-sequential pages The number of pages in the table or index that are out of sequence. Many filesystems are optimized for sequential file access so a small number of non-sequential pages might result in faster queries, especially for larger database files that do not fit in the disk cache. Note that after running VACUUM, the root page of each table or index is at the beginning of the database file and all other pages are in a separate part of the database file, resulting in a single non- sequential page. Maximum payload per entry The largest payload size of any entry. Entries that use overflow The number of entries that user one or more overflow pages. Total pages used This is the number of pages used to hold all information in the current category. This is the sum of index, primary, and overflow pages. Index pages used This is the number of pages in a table B-tree that hold only key (rowid) information and no data. Primary pages used This is the number of B-tree pages that hold both key and data. Overflow pages used The total number of overflow pages used for this category. Unused bytes on index pages The total number of bytes of unused space on all index pages. The percentage at the right is the number of unused bytes divided by the total number of bytes on index pages. Unused bytes on primary pages The total number of bytes of unused space on all primary pages. The percentage at the right is the number of unused bytes divided by the total number of bytes on primary pages. Unused bytes on overflow pages The total number of bytes of unused space on all overflow pages. The percentage at the right is the number of unused bytes divided by the total number of bytes on overflow pages. Unused bytes on all pages The total number of bytes of unused space on all primary and overflow pages. The percentage at the right is the number of unused bytes divided by the total number of bytes. ******************************************************************************* The entire text of this report can be sourced into any SQL database engine for further analysis. All of the text above is an SQL comment. The data used to generate this report follows: */ BEGIN; CREATE TABLE space_used( name clob, -- Name of a table or index in the database file tblname clob, -- Name of associated table is_index boolean, -- TRUE if it is an index, false for a table is_without_rowid boolean, -- TRUE if WITHOUT ROWID table nentry int, -- Number of entries in the BTree leaf_entries int, -- Number of leaf entries depth int, -- Depth of the b-tree payload int, -- Total amount of data stored in this table or index ovfl_payload int, -- Total amount of data stored on overflow pages ovfl_cnt int, -- Number of entries that use overflow mx_payload int, -- Maximum payload size int_pages int, -- Number of interior pages used leaf_pages int, -- Number of leaf pages used ovfl_pages int, -- Number of overflow pages used int_unused int, -- Number of unused bytes on interior pages leaf_unused int, -- Number of unused bytes on primary pages ovfl_unused int, -- Number of unused bytes on overflow pages gap_cnt int, -- Number of gaps in the page layout compressed_size int -- Total bytes stored on disk ); INSERT INTO space_used VALUES('sqlite_schema','sqlite_schema',0,0,27,26,2,5643,0,0,843,1,2,0,3977,2411,0,1,12288); INSERT INTO space_used VALUES('schemamigrations','schemamigrations',0,0,1,1,1,147,0,0,147,0,1,0,0,3936,0,0,4096); INSERT INTO space_used VALUES('kv','kv',0,1,2,2,1,58,0,0,36,0,1,0,0,4024,0,0,4096); INSERT INTO space_used VALUES('devices','devices',0,0,3,3,1,201,0,0,67,0,1,0,0,3875,0,0,4096); INSERT INTO space_used VALUES('sqlite_autoindex_devices_1','devices',1,0,3,3,1,203,0,0,68,0,1,0,0,3876,0,0,4096); INSERT INTO space_used VALUES('sqlite_sequence','sqlite_sequence',0,0,2,2,1,25,0,0,13,0,1,0,0,4055,0,0,4096); INSERT INTO space_used VALUES('files','files',0,0,102075220,100388517,4,6045254873,0,0,70,4833,1686704,0,2894909,149295938,0,1668073,6928535552); INSERT INTO space_used VALUES('file_names','file_names',0,0,35084429,34502505,4,2090023455,0,0,314,1677,581925,0,1058612,49458250,0,577733,2390433792); INSERT INTO space_used VALUES('sqlite_autoindex_file_names_1','file_names',1,0,34502505,33863741,5,2219612439,0,0,317,12972,638765,0,7196641,331348053,0,620908,2669514752); INSERT INTO space_used VALUES('file_versions','file_versions',0,0,1252425,1240224,3,37206720,0,0,30,32,12202,0,21019,5249811,0,12199,50110464); INSERT INTO space_used VALUES('sqlite_autoindex_file_versions_1','file_versions',1,0,1240224,1227203,4,40895495,0,0,33,148,13022,0,83907,9086210,0,13016,53944320); INSERT INTO space_used VALUES('fileinfos','fileinfos',0,0,104580930,100388517,4,15777561591,0,0,418,12013,4192414,0,7202856,567453759,0,3294249,17221332992); INSERT INTO space_used VALUES('files_remote_sequence','files',1,0,68983838,68676041,4,884308972,0,0,13,1741,307798,0,1004761,171892033,0,306392,1267871744); INSERT INTO space_used VALUES('files_device_name','files',1,0,100388517,99957024,4,1240271504,0,0,13,2321,431494,0,1109138,229154271,0,425273,1776906240); INSERT INTO space_used VALUES('files_blocklist_hash_only','files',1,0,87487007,86452184,5,3551848416,0,0,41,13550,1034824,0,6090957,461159026,0,949141,4294139904); INSERT INTO space_used VALUES('files_name_idx_only','files',1,0,100388517,100012698,4,1070899149,0,0,11,1815,375820,0,762826,169433818,0,370552,1546792960); INSERT INTO space_used VALUES('files_version_idx_only','files',1,0,100388517,100038906,4,960638969,0,0,10,1595,349612,0,710995,171813877,0,346357,1438543872); INSERT INTO space_used VALUES('indexids','indexids',0,1,3,3,1,74,0,0,25,0,1,0,0,4005,0,0,4096); INSERT INTO space_used VALUES('counts','counts',0,1,53,53,1,602,0,0,19,0,1,0,0,3327,0,0,4096); INSERT INTO space_used VALUES('blocklists','blocklists',0,1,28473540,27587337,9,6898825597,3694613057,922711,158463,72392,886204,1462547,74678726,543991374,2290129267,620553,9917001728); INSERT INTO space_used VALUES('blocks','blocks',0,1,126605643,123878613,5,9682312693,0,0,82,63609,2727031,0,31316440,1303527702,0,1058411,11430461440); INSERT INTO space_used VALUES('mtimes','mtimes',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); INSERT INTO space_used VALUES('sqlite_stat1','sqlite_stat1',0,0,15,15,1,543,0,0,58,0,1,0,0,3485,0,0,4096); COMMIT;