/** Disk-Space Utilization Report For C:\! - Storage\sx\folder.0010-kdrx2nvc.db Page size in bytes................................ 4096 Pages in the whole file (measured)................ 1142414 Pages in the whole file (calculated).............. 1142414 Pages that store data............................. 1142409 100.000% Pages on the freelist (per header)................ 4 0.0% Pages on the freelist (calculated)................ 5 0.0% Pages of auto-vacuum overhead..................... 0 0.0% Number of tables in the database.................. 13 Number of indices................................. 6 Number of defined indices......................... 4 Number of implied indices......................... 2 Size of the file in bytes......................... 4679327744 Bytes of user payload stored...................... 2413985356 51.6% *** Page counts for all tables with their indices ***************************** FILES............................................. 822106 72.0% FILEINFOS......................................... 320262 28.0% BLOCKS............................................ 15 0.001% BLOCKLISTS........................................ 13 0.001% SQLITE_SCHEMA..................................... 3 0.0% DEVICES........................................... 2 0.0% KV................................................ 2 0.0% COUNTS............................................ 1 0.0% INDEXIDS.......................................... 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......................................... 320262 28.0% FILES............................................. 310972 27.2% FILES_DEVICE_NAME................................. 213920 18.7% FILES_NAME_ONLY................................... 208991 18.3% FILES_BLOCKLIST_HASH_ONLY......................... 66372 5.8% FILES_REMOTE_SEQUENCE............................. 21851 1.9% BLOCKS............................................ 15 0.001% BLOCKLISTS........................................ 13 0.001% 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_AUTOINDEX_KV_1............................. 1 0.0% SQLITE_SEQUENCE................................... 1 0.0% SQLITE_STAT1...................................... 1 0.0% *** All tables and indices **************************************************** Percentage of total database...................... 100.000% Number of entries................................. 35937428 Bytes of storage consumed......................... 4679307264 Bytes of payload.................................. 4175923640 89.2% Bytes of metadata................................. 187765362 4.0% Average payload per entry......................... 116.20 Average unused bytes per entry.................... 8.78 Average metadata per entry........................ 5.22 Average fanout.................................... 63.00 Maximum payload per entry......................... 2581 Entries that use overflow......................... 6 0.0% Index pages used.................................. 18031 Primary pages used................................ 1124372 Overflow pages used............................... 6 Total pages used.................................. 1142409 Unused bytes on index pages....................... 9366855 12.7% Unused bytes on primary pages..................... 306238147 6.6% Unused bytes on overflow pages.................... 13260 54.0% Unused bytes on all pages......................... 315618262 6.7% *** All tables **************************************************************** Percentage of total database...................... 55.3% Number of entries................................. 12465863 Bytes of storage consumed......................... 2585694208 Bytes of payload.................................. 2413990437 93.4% Bytes of metadata................................. 106064793 4.1% Average payload per entry......................... 193.65 Average unused bytes per entry.................... 5.27 Average metadata per entry........................ 8.51 Average fanout.................................... 369.00 Maximum payload per entry......................... 2581 Entries that use overflow......................... 6 0.0% Index pages used.................................. 1707 Primary pages used................................ 629560 Overflow pages used............................... 6 Total pages used.................................. 631273 Unused bytes on index pages....................... 889663 12.7% Unused bytes on primary pages..................... 64736055 2.5% Unused bytes on overflow pages.................... 13260 54.0% Unused bytes on all pages......................... 65638978 2.5% *** All indices *************************************************************** Percentage of total database...................... 44.7% Number of entries................................. 23471565 Bytes of storage consumed......................... 2093613056 Bytes of payload.................................. 1761933203 84.2% Bytes of metadata................................. 81700569 3.9% Average payload per entry......................... 75.07 Average unused bytes per entry.................... 10.65 Average metadata per entry........................ 3.48 Average fanout.................................... 31.00 Maximum payload per entry......................... 326 Entries that use overflow......................... 0 0.0% Index pages used.................................. 16324 Primary pages used................................ 494812 Overflow pages used............................... 0 Total pages used.................................. 511136 Unused bytes on index pages....................... 8477192 12.7% Unused bytes on primary pages..................... 241502092 11.9% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 249979284 11.9% *** Table BLOCKLISTS ********************************************************** Percentage of total database...................... 0.001% Number of entries................................. 105 Bytes of storage consumed......................... 53248 Bytes of payload.................................. 32220 60.5% Bytes of metadata................................. 474 0.89% B-tree depth...................................... 2 Average payload per entry......................... 306.86 Average unused bytes per entry.................... 195.75 Average metadata per entry........................ 4.51 Average fanout.................................... 6.00 Non-sequential pages.............................. 5 41.7% Maximum payload per entry......................... 2581 Entries that use overflow......................... 6 5.7% Index pages used.................................. 1 Primary pages used................................ 6 Overflow pages used............................... 6 Total pages used.................................. 13 Unused bytes on index pages....................... 2040 49.8% Unused bytes on primary pages..................... 5254 21.4% Unused bytes on overflow pages.................... 13260 54.0% Unused bytes on all pages......................... 20554 38.6% *** Table BLOCKS ************************************************************** Percentage of total database...................... 0.001% Number of entries................................. 646 Bytes of storage consumed......................... 61440 Bytes of payload.................................. 49260 80.2% Bytes of metadata................................. 2114 3.4% B-tree depth...................................... 2 Average payload per entry......................... 76.25 Average unused bytes per entry.................... 15.58 Average metadata per entry........................ 3.27 Average fanout.................................... 14.00 Non-sequential pages.............................. 12 85.7% Maximum payload per entry......................... 77 Entries that use overflow......................... 0 0.0% Index pages used.................................. 1 Primary pages used................................ 14 Overflow pages used............................... 0 Total pages used.................................. 15 Unused bytes on index pages....................... 3015 73.6% Unused bytes on primary pages..................... 7051 12.3% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 10066 16.4% *** Table COUNTS ************************************************************** Percentage of total database...................... 0.0% Number of entries................................. 48 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 593 14.5% Bytes of metadata................................. 152 3.7% B-tree depth...................................... 1 Average payload per entry......................... 12.35 Average unused bytes per entry.................... 69.81 Average metadata per entry........................ 3.17 Maximum payload per entry......................... 16 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3351 81.8% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3351 81.8% *** Table DEVICES and all its indices ***************************************** Percentage of total database...................... 0.0% Number of entries................................. 16 Bytes of storage consumed......................... 8192 Bytes of payload.................................. 1086 13.3% Bytes of metadata................................. 79 0.96% Average payload per entry......................... 67.88 Average unused bytes per entry.................... 439.19 Average metadata per entry........................ 4.94 Maximum payload per entry......................... 69 Entries that use overflow......................... 0 0.0% Primary pages used................................ 2 Overflow pages used............................... 0 Total pages used.................................. 2 Unused bytes on primary pages..................... 7027 85.8% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 7027 85.8% *** Table DEVICES w/o any indices ********************************************* Percentage of total database...................... 0.0% Number of entries................................. 8 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 536 13.1% Bytes of metadata................................. 47 1.1% B-tree depth...................................... 1 Average payload per entry......................... 67.00 Average unused bytes per entry.................... 439.13 Average metadata per entry........................ 5.88 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..................... 3513 85.8% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3513 85.8% *** Index SQLITE_AUTOINDEX_DEVICES_1 of table DEVICES ************************* Percentage of total database...................... 0.0% Number of entries................................. 8 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 550 13.4% Bytes of metadata................................. 32 0.78% B-tree depth...................................... 1 Average payload per entry......................... 68.75 Average unused bytes per entry.................... 439.25 Average metadata per entry........................ 4.00 Maximum payload per entry......................... 69 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3514 85.8% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3514 85.8% *** Table FILEINFOS *********************************************************** Percentage of total database...................... 28.0% Number of entries................................. 6232505 Bytes of storage consumed......................... 1311793152 Bytes of payload.................................. 1224864642 93.4% Bytes of metadata................................. 53155828 4.1% B-tree depth...................................... 4 Average payload per entry......................... 196.53 Average unused bytes per entry.................... 5.42 Average metadata per entry........................ 8.53 Average fanout.................................... 370.00 Non-sequential pages.............................. 317747 99.22% Maximum payload per entry......................... 407 Entries that use overflow......................... 0 0.0% Index pages used.................................. 865 Primary pages used................................ 319397 Overflow pages used............................... 0 Total pages used.................................. 320262 Unused bytes on index pages....................... 448933 12.7% Unused bytes on primary pages..................... 33323749 2.5% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 33772682 2.6% *** Table FILES and all its indices ******************************************* Percentage of total database...................... 72.0% Number of entries................................. 29704061 Bytes of storage consumed......................... 3367346176 Bytes of payload.................................. 2950969995 87.6% Bytes of metadata................................. 134606330 4.0% Average payload per entry......................... 99.35 Average unused bytes per entry.................... 9.49 Average metadata per entry........................ 4.53 Average fanout.................................... 47.00 Maximum payload per entry......................... 401 Entries that use overflow......................... 0 0.0% Index pages used.................................. 17163 Primary pages used................................ 804943 Overflow pages used............................... 0 Total pages used.................................. 822106 Unused bytes on index pages....................... 8908890 12.7% Unused bytes on primary pages..................... 272860961 8.3% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 281769851 8.4% *** Table FILES w/o any indices *********************************************** Percentage of total database...................... 27.2% Number of entries................................. 6232505 Bytes of storage consumed......................... 1273741312 Bytes of payload.................................. 1189037354 93.3% Bytes of metadata................................. 52905804 4.2% B-tree depth...................................... 4 Average payload per entry......................... 190.78 Average unused bytes per entry.................... 5.10 Average metadata per entry........................ 8.49 Average fanout.................................... 370.00 Non-sequential pages.............................. 310123 99.73% Maximum payload per entry......................... 401 Entries that use overflow......................... 0 0.0% Index pages used.................................. 839 Primary pages used................................ 310133 Overflow pages used............................... 0 Total pages used.................................. 310972 Unused bytes on index pages....................... 431698 12.6% Unused bytes on primary pages..................... 31366456 2.5% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 31798154 2.5% *** Indices of table FILES **************************************************** Percentage of total database...................... 44.7% Number of entries................................. 23471556 Bytes of storage consumed......................... 2093604864 Bytes of payload.................................. 1761932641 84.2% Bytes of metadata................................. 81700526 3.9% Average payload per entry......................... 75.07 Average unused bytes per entry.................... 10.65 Average metadata per entry........................ 3.48 Average fanout.................................... 31.00 Maximum payload per entry......................... 326 Entries that use overflow......................... 0 0.0% Index pages used.................................. 16324 Primary pages used................................ 494810 Overflow pages used............................... 0 Total pages used.................................. 511134 Unused bytes on index pages....................... 8477192 12.7% Unused bytes on primary pages..................... 241494505 11.9% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 249971697 11.9% *** Index FILES_BLOCKLIST_HASH_ONLY of table FILES **************************** Percentage of total database...................... 5.8% Number of entries................................. 5555400 Bytes of storage consumed......................... 271859712 Bytes of payload.................................. 226349709 83.3% Bytes of metadata................................. 17462660 6.4% B-tree depth...................................... 4 Average payload per entry......................... 40.74 Average unused bytes per entry.................... 5.05 Average metadata per entry........................ 3.14 Average fanout.................................... 78.00 Non-sequential pages.............................. 65510 98.7% Maximum payload per entry......................... 41 Entries that use overflow......................... 0 0.0% Index pages used.................................. 848 Primary pages used................................ 65524 Overflow pages used............................... 0 Total pages used.................................. 66372 Unused bytes on index pages....................... 334633 9.6% Unused bytes on primary pages..................... 27712710 10.3% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 28047343 10.3% *** Index FILES_DEVICE_NAME of table FILES ************************************ Percentage of total database...................... 18.7% Number of entries................................. 6232505 Bytes of storage consumed......................... 876216320 Bytes of payload.................................. 743692859 84.9% Bytes of metadata................................. 23956729 2.7% B-tree depth...................................... 5 Average payload per entry......................... 119.32 Average unused bytes per entry.................... 17.42 Average metadata per entry........................ 3.84 Average fanout.................................... 27.00 Non-sequential pages.............................. 183978 86.0% Maximum payload per entry......................... 326 Entries that use overflow......................... 0 0.0% Index pages used.................................. 7824 Primary pages used................................ 206096 Overflow pages used............................... 0 Total pages used.................................. 213920 Unused bytes on index pages....................... 4070603 12.7% Unused bytes on primary pages..................... 104496129 12.4% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 108566732 12.4% *** Index FILES_NAME_ONLY of table FILES ************************************** Percentage of total database...................... 18.3% Number of entries................................. 6232505 Bytes of storage consumed......................... 856027136 Bytes of payload.................................. 726558062 84.9% Bytes of metadata................................. 23665491 2.8% B-tree depth...................................... 5 Average payload per entry......................... 116.58 Average unused bytes per entry.................... 16.98 Average metadata per entry........................ 3.80 Average fanout.................................... 27.00 Non-sequential pages.............................. 179146 85.7% Maximum payload per entry......................... 323 Entries that use overflow......................... 0 0.0% Index pages used.................................. 7538 Primary pages used................................ 201453 Overflow pages used............................... 0 Total pages used.................................. 208991 Unused bytes on index pages....................... 4019068 13.0% Unused bytes on primary pages..................... 101784515 12.3% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 105803583 12.4% *** Index FILES_REMOTE_SEQUENCE of table FILES ******************************** Percentage of total database...................... 1.9% Number of entries................................. 5451146 Bytes of storage consumed......................... 89501696 Bytes of payload.................................. 65332011 73.0% Bytes of metadata................................. 16615646 18.6% B-tree depth...................................... 3 Average payload per entry......................... 11.99 Average unused bytes per entry.................... 1.39 Average metadata per entry........................ 3.05 Average fanout.................................... 191.00 Non-sequential pages.............................. 21736 99.48% Maximum payload per entry......................... 12 Entries that use overflow......................... 0 0.0% Index pages used.................................. 114 Primary pages used................................ 21737 Overflow pages used............................... 0 Total pages used.................................. 21851 Unused bytes on index pages....................... 52888 11.3% Unused bytes on primary pages..................... 7501151 8.4% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 7554039 8.4% *** Table INDEXIDS ************************************************************ Percentage of total database...................... 0.0% Number of entries................................. 8 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 198 4.8% Bytes of metadata................................. 32 0.78% B-tree depth...................................... 1 Average payload per entry......................... 24.75 Average unused bytes per entry.................... 483.25 Average metadata per entry........................ 4.00 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..................... 3866 94.4% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3866 94.4% *** Table KV and all its indices ********************************************** Percentage of total database...................... 0.0% Number of entries................................. 2 Bytes of storage consumed......................... 8192 Bytes of payload.................................. 31 0.38% Bytes of metadata................................. 23 0.28% Average payload per entry......................... 15.50 Average unused bytes per entry.................... 4069.00 Average metadata per entry........................ 11.50 Maximum payload per entry......................... 19 Entries that use overflow......................... 0 0.0% Primary pages used................................ 2 Overflow pages used............................... 0 Total pages used.................................. 2 Unused bytes on primary pages..................... 8138 99.34% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 8138 99.34% *** Table KV w/o any indices ************************************************** Percentage of total database...................... 0.0% Number of entries................................. 1 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 19 0.46% Bytes of metadata................................. 12 0.29% B-tree depth...................................... 1 Average payload per entry......................... 19.00 Average unused bytes per entry.................... 4065.00 Average metadata per entry........................ 12.00 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..................... 4065 99.24% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4065 99.24% *** Index SQLITE_AUTOINDEX_KV_1 of table KV *********************************** Percentage of total database...................... 0.0% Number of entries................................. 1 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 12 0.29% Bytes of metadata................................. 11 0.27% B-tree depth...................................... 1 Average payload per entry......................... 12.00 Average unused bytes per entry.................... 4073.00 Average metadata per entry........................ 11.00 Maximum payload per entry......................... 12 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 4073 99.44% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4073 99.44% *** 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.................................. 124 3.0% Bytes of metadata................................. 12 0.29% B-tree depth...................................... 1 Average payload per entry......................... 124.00 Average unused bytes per entry.................... 3960.00 Average metadata per entry........................ 12.00 Maximum payload per entry......................... 124 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3960 96.7% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3960 96.7% *** Table SQLITE_SCHEMA ******************************************************* Percentage of total database...................... 0.0% Number of entries................................. 22 Bytes of storage consumed......................... 12288 Bytes of payload.................................. 5081 41.3% Bytes of metadata................................. 238 1.9% B-tree depth...................................... 2 Average payload per entry......................... 230.95 Average unused bytes per entry.................... 316.77 Average metadata per entry........................ 10.82 Average fanout.................................... 2.00 Non-sequential pages.............................. 1 50.0% Maximum payload per entry......................... 745 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..................... 2992 36.5% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 6969 56.7% *** Table SQLITE_SEQUENCE ***************************************************** Percentage of total database...................... 0.0% Number of entries................................. 2 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 23 0.56% Bytes of metadata................................. 16 0.39% B-tree depth...................................... 1 Average payload per entry......................... 11.50 Average unused bytes per entry.................... 2028.50 Average metadata per entry........................ 8.00 Maximum payload per entry......................... 12 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 4057 99.05% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 4057 99.05% *** Table SQLITE_STAT1 ******************************************************** Percentage of total database...................... 0.0% Number of entries................................. 12 Bytes of storage consumed......................... 4096 Bytes of payload.................................. 387 9.4% Bytes of metadata................................. 56 1.4% B-tree depth...................................... 1 Average payload per entry......................... 32.25 Average unused bytes per entry.................... 304.42 Average metadata per entry........................ 4.67 Maximum payload per entry......................... 52 Entries that use overflow......................... 0 0.0% Primary pages used................................ 1 Overflow pages used............................... 0 Total pages used.................................. 1 Unused bytes on primary pages..................... 3653 89.2% Unused bytes on overflow pages.................... 0 Unused bytes on all pages......................... 3653 89.2% *** 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,23,22,2,5081,0,0,745,1,2,0,3977,2992,0,1,12288); INSERT INTO space_used VALUES('schemamigrations','schemamigrations',0,0,1,1,1,124,0,0,124,0,1,0,0,3960,0,0,4096); INSERT INTO space_used VALUES('kv','kv',0,0,1,1,1,19,0,0,19,0,1,0,0,4065,0,0,4096); INSERT INTO space_used VALUES('sqlite_autoindex_kv_1','kv',1,0,1,1,1,12,0,0,12,0,1,0,0,4073,0,0,4096); INSERT INTO space_used VALUES('devices','devices',0,0,8,8,1,536,0,0,67,0,1,0,0,3513,0,0,4096); INSERT INTO space_used VALUES('sqlite_autoindex_devices_1','devices',1,0,8,8,1,550,0,0,69,0,1,0,0,3514,0,0,4096); INSERT INTO space_used VALUES('sqlite_sequence','sqlite_sequence',0,0,2,2,1,23,0,0,12,0,1,0,0,4057,0,0,4096); INSERT INTO space_used VALUES('files','files',0,0,6542637,6232505,4,1189037354,0,0,401,839,310133,0,431698,31366456,0,310123,1273741312); INSERT INTO space_used VALUES('fileinfos','fileinfos',0,0,6551901,6232505,4,1224864642,0,0,407,865,319397,0,448933,33323749,0,317747,1311793152); INSERT INTO space_used VALUES('files_remote_sequence','files',1,0,5451146,5429410,3,65332011,0,0,12,114,21737,0,52888,7501151,0,21736,89501696); INSERT INTO space_used VALUES('files_device_name','files',1,0,6232505,6026410,5,743692859,0,0,326,7824,206096,0,4070603,104496129,0,183978,876216320); INSERT INTO space_used VALUES('files_name_only','files',1,0,6232505,6031053,5,726558062,0,0,323,7538,201453,0,4019068,101784515,0,179146,856027136); INSERT INTO space_used VALUES('files_blocklist_hash_only','files',1,0,5555400,5489877,4,226349709,0,0,41,848,65524,0,334633,27712710,0,65510,271859712); INSERT INTO space_used VALUES('indexids','indexids',0,1,8,8,1,198,0,0,25,0,1,0,0,3866,0,0,4096); INSERT INTO space_used VALUES('counts','counts',0,1,48,48,1,593,0,0,16,0,1,0,0,3351,0,0,4096); INSERT INTO space_used VALUES('blocklists','blocklists',0,1,105,100,2,32220,11292,6,2581,1,6,6,2040,5254,13260,5,53248); INSERT INTO space_used VALUES('blocks','blocks',0,1,646,633,2,49260,0,0,77,1,14,0,3015,7051,0,12,61440); 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,12,12,1,387,0,0,52,0,1,0,0,3653,0,0,4096); COMMIT;