/** Disk-Space Utilization Report For C:\Program Files\POPFile\popfile.db *** As of 2006-Jun-07 16:17:28 Pages in the whole file (measured).... 1966 Pages in the whole file (calculated).. 1966 Pages that store data................. 1965 99.949% Pages on the freelist (per header).... 0 0.000% Pages on the freelist (calculated).... 0 0.000% Header pages.......................... 1 0.051% Number of tables in the database...... 13 Number of indices..................... 9 Number of named indices............... 0 0.000% Automatically generated indices....... 9 100.000% Size of the file in bytes............. 2013184 Bytes of payload stored............... 960684 47.7% Bytes of user data stored............. 389087 19.3% *** Page counts for all tables with their indices ******************** MATRIX................................ 1200 61.0% WORDS................................. 726 36.9% SQLITE_MASTER......................... 18 0.92% BUCKET_PARAMS......................... 6 0.31% BUCKET_TEMPLATE....................... 2 0.10% BUCKETS............................... 2 0.10% MAGNET_TYPES.......................... 2 0.10% USER_PARAMS........................... 2 0.10% USER_TEMPLATE......................... 2 0.10% USERS................................. 2 0.10% HISTORY............................... 1 0.051% MAGNETS............................... 1 0.051% POPFILE............................... 1 0.051% *** All tables and indices ******************************************* Percentage of total database.......... 99.949% Number of entries..................... 54612 Bytes of storage consumed............. 2012160 Bytes of payload...................... 960684 47.7% Bytes of data......................... 395791 19.7% Bytes of key.......................... 564893 28.1% Average payload per entry............. 17 Average unused bytes per entry........ 5 Average fanout........................ 27.96 Maximum payload per entry............. 913 Entries that use overflow............. 12 0.022% Total pages used...................... 1965 Primary pages used.................... 1953 Overflow pages used................... 12 Unused bytes on primary pages......... 282328 14.1% Unused bytes on overflow pages........ 9748 79.3% Unused bytes on all pages............. 292076 14.5% *** All tables ******************************************************* Percentage of total database.......... 45.5% Number of entries..................... 27320 Bytes of storage consumed............. 915456 Bytes of payload...................... 505071 55.2% Bytes of data......................... 395791 43.2% Bytes of key.......................... 109280 11.9% Average payload per entry............. 18 Average unused bytes per entry........ 1 Average fanout........................ 30.98 Maximum payload per entry............. 913 Entries that use overflow............. 12 0.044% Total pages used...................... 894 Primary pages used.................... 882 Overflow pages used................... 12 Unused bytes on primary pages......... 32400 3.6% Unused bytes on overflow pages........ 9748 79.3% Unused bytes on all pages............. 42148 4.6% *** All indices ****************************************************** Percentage of total database.......... 54.5% Number of entries..................... 27292 Bytes of storage consumed............. 1096704 Bytes of payload...................... 455613 41.5% Bytes of data......................... 0 0.000% Bytes of key.......................... 455613 41.5% Average payload per entry............. 16 Average unused bytes per entry........ 9 Average fanout........................ 25.48 Maximum payload per entry............. 54 Entries that use overflow............. 0 0.000% Total pages used...................... 1071 Primary pages used.................... 1071 Overflow pages used................... 0 Unused bytes on primary pages......... 249928 22.8% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 249928 22.8% *** Table BUCKET_PARAMS and all its indices ************************** Percentage of total database.......... 0.31% Number of entries..................... 86 Bytes of storage consumed............. 6144 Bytes of payload...................... 1371 22.3% Bytes of data......................... 511 8.3% Bytes of key.......................... 860 14.0% Average payload per entry............. 15 Average unused bytes per entry........ 42 Average fanout........................ 14.33 Maximum payload per entry............. 21 Entries that use overflow............. 0 0.000% Total pages used...................... 6 Primary pages used.................... 6 Overflow pages used................... 0 Unused bytes on primary pages......... 3640 59.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 3640 59.2% *** Table BUCKET_PARAMS w/o any indices ****************************** Percentage of total database.......... 0.15% Number of entries..................... 43 Bytes of storage consumed............. 3072 Bytes of payload...................... 683 22.2% Bytes of data......................... 511 16.6% Bytes of key.......................... 172 5.6% Average payload per entry............. 15 Average unused bytes per entry........ 41 Average fanout........................ 14.33 Maximum payload per entry............. 21 Entries that use overflow............. 0 0.000% Total pages used...................... 3 Primary pages used.................... 3 Overflow pages used................... 0 Unused bytes on primary pages......... 1796 58.5% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1796 58.5% *** Indices of table BUCKET_PARAMS *********************************** Percentage of total database.......... 0.15% Number of entries..................... 43 Bytes of storage consumed............. 3072 Bytes of payload...................... 688 22.4% Bytes of data......................... 0 0.000% Bytes of key.......................... 688 22.4% Average payload per entry............. 16 Average unused bytes per entry........ 42 Average fanout........................ 14.33 Maximum payload per entry............. 16 Entries that use overflow............. 0 0.000% Total pages used...................... 3 Primary pages used.................... 3 Overflow pages used................... 0 Unused bytes on primary pages......... 1844 60.0% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1844 60.0% *** Table BUCKET_TEMPLATE and all its indices ************************ Percentage of total database.......... 0.10% Number of entries..................... 16 Bytes of storage consumed............. 2048 Bytes of payload...................... 234 11.4% Bytes of data......................... 107 5.2% Bytes of key.......................... 127 6.2% Average payload per entry............. 14 Average unused bytes per entry........ 98 Average fanout........................ 8.00 Maximum payload per entry............. 21 Entries that use overflow............. 0 0.000% Total pages used...................... 2 Primary pages used.................... 2 Overflow pages used................... 0 Unused bytes on primary pages......... 1576 77.0% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1576 77.0% *** Table BUCKET_TEMPLATE w/o any indices **************************** Percentage of total database.......... 0.051% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 139 13.6% Bytes of data......................... 107 10.4% Bytes of key.......................... 32 3.1% Average payload per entry............. 17 Average unused bytes per entry........ 96 Average fanout........................ 8.00 Maximum payload per entry............. 21 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 768 75.0% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 768 75.0% *** Indices of table BUCKET_TEMPLATE ********************************* Percentage of total database.......... 0.051% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 95 9.3% Bytes of data......................... 0 0.000% Bytes of key.......................... 95 9.3% Average payload per entry............. 11 Average unused bytes per entry........ 101 Average fanout........................ 8.00 Maximum payload per entry............. 16 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 808 78.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 808 78.9% *** Table BUCKETS and all its indices ******************************** Percentage of total database.......... 0.10% Number of entries..................... 16 Bytes of storage consumed............. 2048 Bytes of payload...................... 358 17.5% Bytes of data......................... 155 7.6% Bytes of key.......................... 203 9.9% Average payload per entry............. 22 Average unused bytes per entry........ 91 Average fanout........................ 8.00 Maximum payload per entry............. 26 Entries that use overflow............. 0 0.000% Total pages used...................... 2 Primary pages used.................... 2 Overflow pages used................... 0 Unused bytes on primary pages......... 1460 71.3% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1460 71.3% *** Table BUCKETS w/o any indices ************************************ Percentage of total database.......... 0.051% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 187 18.3% Bytes of data......................... 155 15.1% Bytes of key.......................... 32 3.1% Average payload per entry............. 23 Average unused bytes per entry........ 89 Average fanout........................ 8.00 Maximum payload per entry............. 26 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 716 69.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 716 69.9% *** Indices of table BUCKETS ***************************************** Percentage of total database.......... 0.051% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 171 16.7% Bytes of data......................... 0 0.000% Bytes of key.......................... 171 16.7% Average payload per entry............. 21 Average unused bytes per entry........ 93 Average fanout........................ 8.00 Maximum payload per entry............. 24 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 744 72.7% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 744 72.7% *** Table HISTORY **************************************************** Percentage of total database.......... 0.051% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 1016 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1016 99.22% *** Table MAGNET_TYPES and all its indices *************************** Percentage of total database.......... 0.10% Number of entries..................... 8 Bytes of storage consumed............. 2048 Bytes of payload...................... 109 5.3% Bytes of data......................... 54 2.6% Bytes of key.......................... 55 2.7% Average payload per entry............. 13 Average unused bytes per entry........ 227 Average fanout........................ 4.00 Maximum payload per entry............. 24 Entries that use overflow............. 0 0.000% Total pages used...................... 2 Primary pages used.................... 2 Overflow pages used................... 0 Unused bytes on primary pages......... 1816 88.7% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1816 88.7% *** Table MAGNET_TYPES w/o any indices ******************************* Percentage of total database.......... 0.051% Number of entries..................... 4 Bytes of storage consumed............. 1024 Bytes of payload...................... 70 6.8% Bytes of data......................... 54 5.3% Bytes of key.......................... 16 1.6% Average payload per entry............. 17 Average unused bytes per entry........ 223 Average fanout........................ 4.00 Maximum payload per entry............. 24 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 892 87.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 892 87.1% *** Indices of table MAGNET_TYPES ************************************ Percentage of total database.......... 0.051% Number of entries..................... 4 Bytes of storage consumed............. 1024 Bytes of payload...................... 39 3.8% Bytes of data......................... 0 0.000% Bytes of key.......................... 39 3.8% Average payload per entry............. 9 Average unused bytes per entry........ 231 Average fanout........................ 4.00 Maximum payload per entry............. 13 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 924 90.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 924 90.2% *** Table MAGNETS **************************************************** Percentage of total database.......... 0.051% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 19 1.9% Bytes of data......................... 15 1.5% Bytes of key.......................... 4 0.39% Average payload per entry............. 19 Average unused bytes per entry........ 984 Average fanout........................ 1.00 Maximum payload per entry............. 19 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 984 96.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 984 96.1% *** Table MATRIX and all its indices ********************************* Percentage of total database.......... 61.0% Number of entries..................... 33094 Bytes of storage consumed............. 1228800 Bytes of payload...................... 605308 49.3% Bytes of data......................... 247035 20.1% Bytes of key.......................... 358273 29.2% Average payload per entry............. 18 Average unused bytes per entry........ 4 Average fanout........................ 27.58 Maximum payload per entry............. 21 Entries that use overflow............. 0 0.000% Total pages used...................... 1200 Primary pages used.................... 1200 Overflow pages used................... 0 Unused bytes on primary pages......... 161024 13.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 161024 13.1% *** Table MATRIX w/o any indices ************************************* Percentage of total database.......... 27.3% Number of entries..................... 16547 Bytes of storage consumed............. 548864 Bytes of payload...................... 313223 57.1% Bytes of data......................... 247035 45.0% Bytes of key.......................... 66188 12.1% Average payload per entry............. 18 Average unused bytes per entry........ 0 Average fanout........................ 30.87 Maximum payload per entry............. 21 Entries that use overflow............. 0 0.000% Total pages used...................... 536 Primary pages used.................... 536 Overflow pages used................... 0 Unused bytes on primary pages......... 15088 2.7% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 15088 2.7% *** Indices of table MATRIX ****************************************** Percentage of total database.......... 33.8% Number of entries..................... 16547 Bytes of storage consumed............. 679936 Bytes of payload...................... 292085 43.0% Bytes of data......................... 0 0.000% Bytes of key.......................... 292085 43.0% Average payload per entry............. 17 Average unused bytes per entry........ 8 Average fanout........................ 24.92 Maximum payload per entry............. 18 Entries that use overflow............. 0 0.000% Total pages used...................... 664 Primary pages used.................... 664 Overflow pages used................... 0 Unused bytes on primary pages......... 145936 21.5% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 145936 21.5% *** Table POPFILE **************************************************** Percentage of total database.......... 0.051% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 9 0.88% Bytes of data......................... 5 0.49% Bytes of key.......................... 4 0.39% Average payload per entry............. 9 Average unused bytes per entry........ 992 Average fanout........................ 1.00 Maximum payload per entry............. 9 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 992 96.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 992 96.9% *** Table SQLITE_MASTER ********************************************** Percentage of total database.......... 0.92% Number of entries..................... 26 Bytes of storage consumed............. 18432 Bytes of payload...................... 6808 36.9% Bytes of data......................... 6704 36.4% Bytes of key.......................... 104 0.56% Average payload per entry............. 261 Average unused bytes per entry........ 428 Average fanout........................ 4.33 Maximum payload per entry............. 913 Entries that use overflow............. 12 46.2% Total pages used...................... 18 Primary pages used.................... 6 Overflow pages used................... 12 Unused bytes on primary pages......... 1400 22.8% Unused bytes on overflow pages........ 9748 79.3% Unused bytes on all pages............. 11148 60.5% *** Table USER_PARAMS and all its indices **************************** Percentage of total database.......... 0.10% Number of entries..................... 0 Bytes of storage consumed............. 2048 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 2 Primary pages used.................... 2 Overflow pages used................... 0 Unused bytes on primary pages......... 2032 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 2032 99.22% *** Table USER_PARAMS w/o any indices ******************************** Percentage of total database.......... 0.051% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 1016 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1016 99.22% *** Indices of table USER_PARAMS ************************************* Percentage of total database.......... 0.051% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 1016 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1016 99.22% *** Table USER_TEMPLATE and all its indices ************************** Percentage of total database.......... 0.10% Number of entries..................... 0 Bytes of storage consumed............. 2048 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 2 Primary pages used.................... 2 Overflow pages used................... 0 Unused bytes on primary pages......... 2032 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 2032 99.22% *** Table USER_TEMPLATE w/o any indices ****************************** Percentage of total database.......... 0.051% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 1016 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1016 99.22% *** Indices of table USER_TEMPLATE *********************************** Percentage of total database.......... 0.051% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.000% Bytes of data......................... 0 0.000% Bytes of key.......................... 0 0.000% Average payload per entry............. 0 Average unused bytes per entry........ 0 Average fanout........................ 0.00 Maximum payload per entry............. 0 Entries that use overflow............. 0 Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 1016 99.22% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1016 99.22% *** Table USERS and all its indices ********************************** Percentage of total database.......... 0.10% Number of entries..................... 2 Bytes of storage consumed............. 2048 Bytes of payload...................... 58 2.8% Bytes of data......................... 43 2.1% Bytes of key.......................... 15 0.73% Average payload per entry............. 29 Average unused bytes per entry........ 974 Average fanout........................ 1.00 Maximum payload per entry............. 47 Entries that use overflow............. 0 0.000% Total pages used...................... 2 Primary pages used.................... 2 Overflow pages used................... 0 Unused bytes on primary pages......... 1948 95.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1948 95.1% *** Table USERS w/o any indices ************************************** Percentage of total database.......... 0.051% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 47 4.6% Bytes of data......................... 43 4.2% Bytes of key.......................... 4 0.39% Average payload per entry............. 47 Average unused bytes per entry........ 956 Average fanout........................ 1.00 Maximum payload per entry............. 47 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 956 93.4% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 956 93.4% *** Indices of table USERS ******************************************* Percentage of total database.......... 0.051% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 11 1.1% Bytes of data......................... 0 0.000% Bytes of key.......................... 11 1.1% Average payload per entry............. 11 Average unused bytes per entry........ 992 Average fanout........................ 1.00 Maximum payload per entry............. 11 Entries that use overflow............. 0 0.000% Total pages used...................... 1 Primary pages used.................... 1 Overflow pages used................... 0 Unused bytes on primary pages......... 992 96.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 992 96.9% *** Table WORDS and all its indices ********************************** Percentage of total database.......... 36.9% Number of entries..................... 21362 Bytes of storage consumed............. 743424 Bytes of payload...................... 346410 46.6% Bytes of data......................... 141162 19.0% Bytes of key.......................... 205248 27.6% Average payload per entry............. 16 Average unused bytes per entry........ 4 Average fanout........................ 29.42 Maximum payload per entry............. 56 Entries that use overflow............. 0 0.000% Total pages used...................... 726 Primary pages used.................... 726 Overflow pages used................... 0 Unused bytes on primary pages......... 102408 13.8% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 102408 13.8% *** Table WORDS w/o any indices ************************************** Percentage of total database.......... 16.7% Number of entries..................... 10681 Bytes of storage consumed............. 335872 Bytes of payload...................... 183886 54.7% Bytes of data......................... 141162 42.0% Bytes of key.......................... 42724 12.7% Average payload per entry............. 17 Average unused bytes per entry........ 0 Average fanout........................ 32.56 Maximum payload per entry............. 56 Entries that use overflow............. 0 0.000% Total pages used...................... 328 Primary pages used.................... 328 Overflow pages used................... 0 Unused bytes on primary pages......... 5760 1.7% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 5760 1.7% *** Indices of table WORDS ******************************************* Percentage of total database.......... 20.2% Number of entries..................... 10681 Bytes of storage consumed............. 407552 Bytes of payload...................... 162524 39.9% Bytes of data......................... 0 0.000% Bytes of key.......................... 162524 39.9% Average payload per entry............. 15 Average unused bytes per entry........ 9 Average fanout........................ 26.84 Maximum payload per entry............. 54 Entries that use overflow............. 0 0.000% Total pages used...................... 398 Primary pages used.................... 398 Overflow pages used................... 0 Unused bytes on primary pages......... 96648 23.7% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 96648 23.7% *** Definitions ****************************************************** Number of pages in the whole file The number of 1024-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. Header pages The number of pages of header overhead in the database. This value is always 1. The percentage at the right is the number of header pages divided by the total number of pages in the file. Number of tables in the database The number of tables in the database, including the SQLITE_MASTER table used to store schema information. Number of indices The total number of indices in the database. Number of named indices The number of indices created using an explicit CREATE INDEX statement. Automatically generated 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 payload stored The total number of bytes of payload stored in the database. Payload includes both key and data. The content of the SQLITE_MASTER table is counted when computing this number. The percentage at the right shows the payload divided by the total file size. Bytes of user data stored The total number of bytes of data stored in the database, not counting the database schema information stored in the SQLITE_MASTER table. The percentage at the right is the user data size 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 (1024). Bytes of payload The amount of payload stored under this category. Payload is the sum of keys and data. Each table entry has 4 bytes of key and an arbitrary amount of data. Each index entry has 4 or more bytes of key and no data. The percentage at the right is the bytes of payload divided by the bytes of storage consumed. Bytes of data The amount of data stored under this category. The data space reported includes formatting information such as nul-terminators and field-lengths that are stored with the data. The percentage at the right is the bytes of data divided by bytes of storage consumed. Bytes of key The sum of the sizes of all keys under this category. The percentage at the right is the bytes of key divided by the bytes of storage consumed. Average payload per entry The average amount of payload on each entry. This is just the bytes of payload divided by the number of entries. Average unused bytes per entry The average amount of free space remaining on all pages under this category on a per-entry basis. This is the number of unused bytes on all pages divided by the number of entries. Maximum payload per entry The largest payload size of any entry. Entries that use overflow Up to 236 bytes of payload for each entry are stored directly in the primary B*Tree page. Any additional payload is stored on a linked list of overflow pages. This is the number of entries that exceed 236 bytes in size. The value to the right is the number of entries that overflow divided by the total number of entries. Total pages used This is the number of 1024 byte pages used to hold all information in the current category. This is the sum of primary and overflow pages. Primary pages used This is the number of primary B*Tree pages used. Overflow pages used The total number of overflow pages used for this category. 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 nentry int, -- Number of entries in the BTree payload int, -- Total amount of data stored in this table or index mx_payload int, -- Maximum payload size n_ovfl int, -- Number of entries that overflow pri_pages int, -- Number of primary pages used ovfl_pages int, -- Number of overflow pages used pri_unused int, -- Number of unused bytes on primary pages ovfl_unused int -- Number of unused bytes on overflow pages ); INSERT INTO space_used VALUES('(bucket_params autoindex 1)','bucket_params',1,43,688,16,0,3,0,1844,0); INSERT INTO space_used VALUES('(bucket_template autoindex 1)','bucket_template',1,8,95,16,0,1,0,808,0); INSERT INTO space_used VALUES('(buckets autoindex 1)','buckets',1,8,171,24,0,1,0,744,0); INSERT INTO space_used VALUES('(magnet_types autoindex 1)','magnet_types',1,4,39,13,0,1,0,924,0); INSERT INTO space_used VALUES('(matrix autoindex 1)','matrix',1,16547,292085,18,0,664,0,145936,0); INSERT INTO space_used VALUES('(user_params autoindex 1)','user_params',1,0,0,0,0,1,0,1016,0); INSERT INTO space_used VALUES('(user_template autoindex 1)','user_template',1,0,0,0,0,1,0,1016,0); INSERT INTO space_used VALUES('(users autoindex 1)','users',1,1,11,11,0,1,0,992,0); INSERT INTO space_used VALUES('(words autoindex 1)','words',1,10681,162524,54,0,398,0,96648,0); INSERT INTO space_used VALUES('bucket_params','bucket_params',0,43,683,21,0,3,0,1796,0); INSERT INTO space_used VALUES('bucket_template','bucket_template',0,8,139,21,0,1,0,768,0); INSERT INTO space_used VALUES('buckets','buckets',0,8,187,26,0,1,0,716,0); INSERT INTO space_used VALUES('history','history',0,0,0,0,0,1,0,1016,0); INSERT INTO space_used VALUES('magnet_types','magnet_types',0,4,70,24,0,1,0,892,0); INSERT INTO space_used VALUES('magnets','magnets',0,1,19,19,0,1,0,984,0); INSERT INTO space_used VALUES('matrix','matrix',0,16547,313223,21,0,536,0,15088,0); INSERT INTO space_used VALUES('popfile','popfile',0,1,9,9,0,1,0,992,0); INSERT INTO space_used VALUES('sqlite_master','sqlite_master',0,26,6808,913,12,6,12,1400,9748); INSERT INTO space_used VALUES('user_params','user_params',0,0,0,0,0,1,0,1016,0); INSERT INTO space_used VALUES('user_template','user_template',0,0,0,0,0,1,0,1016,0); INSERT INTO space_used VALUES('users','users',0,1,47,47,0,1,0,956,0); INSERT INTO space_used VALUES('words','words',0,10681,183886,56,0,328,0,5760,0); COMMIT;