/** Disk-Space Utilization Report For C:\Users\Test\AppData\Roaming\POPFile\popfile.db *** As of 2011-Nov-10 16:24:37 Page size in bytes.................... 1024 Pages in the whole file (measured).... 2831 Pages in the whole file (calculated).. 2831 Pages that store data................. 2821 99.65% Pages on the freelist (per header).... 10 0.35% Pages on the freelist (calculated).... 10 0.35% Pages of auto-vacuum overhead......... 0 0.0% Number of tables in the database...... 13 Number of indices..................... 9 Number of named indices............... 0 Automatically generated indices....... 9 Size of the file in bytes............. 2898944 Bytes of user payload stored.......... 927972 32.0% *** Page counts for all tables with their indices ******************** MATRIX................................ 1492 52.7% WORDS................................. 1302 46.0% SQLITE_MASTER......................... 10 0.35% BUCKET_PARAMS......................... 2 0.071% BUCKET_TEMPLATE....................... 2 0.071% BUCKETS............................... 2 0.071% MAGNET_TYPES.......................... 2 0.071% USER_PARAMS........................... 2 0.071% USER_TEMPLATE......................... 2 0.071% USERS................................. 2 0.071% HISTORY............................... 1 0.035% MAGNETS............................... 1 0.035% POPFILE............................... 1 0.035% *** All tables and indices ******************************************* Percentage of total database.......... 99.65% Number of entries..................... 165520 Bytes of storage consumed............. 2888704 Bytes of payload...................... 1922313 66.5% Average payload per entry............. 11.61 Average unused bytes per entry........ 1.22 Average fanout........................ 83.00 Fragmentation......................... 4.8% Maximum payload per entry............. 898 Entries that use overflow............. 0 0.0% Index pages used...................... 17 Primary pages used.................... 2804 Overflow pages used................... 0 Total pages used...................... 2821 Unused bytes on index pages........... 4856 27.9% Unused bytes on primary pages......... 196530 6.8% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 201386 7.0% *** All tables ******************************************************* Percentage of total database.......... 50.5% Number of entries..................... 82774 Bytes of storage consumed............. 1464320 Bytes of payload...................... 934514 63.8% Average payload per entry............. 11.29 Average unused bytes per entry........ 0.36 Average fanout........................ 83.00 Fragmentation......................... 3.3% Maximum payload per entry............. 898 Entries that use overflow............. 0 0.0% Index pages used...................... 17 Primary pages used.................... 1413 Overflow pages used................... 0 Total pages used...................... 1430 Unused bytes on index pages........... 4856 27.9% Unused bytes on primary pages......... 24839 1.7% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 29695 2.0% *** All indices ****************************************************** Percentage of total database.......... 49.1% Number of entries..................... 82746 Bytes of storage consumed............. 1424384 Bytes of payload...................... 987799 69.3% Average payload per entry............. 11.94 Average unused bytes per entry........ 2.07 Fragmentation......................... 6.3% Maximum payload per entry............. 54 Entries that use overflow............. 0 0.0% Primary pages used.................... 1391 Overflow pages used................... 0 Total pages used...................... 1391 Unused bytes on primary pages......... 171691 12.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 171691 12.1% *** Table BUCKET_PARAMS and all its indices ************************** Percentage of total database.......... 0.071% Number of entries..................... 86 Bytes of storage consumed............. 2048 Bytes of payload...................... 744 36.3% Average payload per entry............. 8.65 Average unused bytes per entry........ 10.86 Fragmentation......................... 0.0% Maximum payload per entry............. 14 Entries that use overflow............. 0 0.0% Primary pages used.................... 2 Overflow pages used................... 0 Total pages used...................... 2 Unused bytes on primary pages......... 934 45.6% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 934 45.6% *** Table BUCKET_PARAMS w/o any indices ****************************** Percentage of total database.......... 0.035% Number of entries..................... 43 Bytes of storage consumed............. 1024 Bytes of payload...................... 390 38.1% Average payload per entry............. 9.07 Average unused bytes per entry........ 9.33 Maximum payload per entry............. 14 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 401 39.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 401 39.2% *** Indices of table BUCKET_PARAMS *********************************** Percentage of total database.......... 0.035% Number of entries..................... 43 Bytes of storage consumed............. 1024 Bytes of payload...................... 354 34.6% Average payload per entry............. 8.23 Average unused bytes per entry........ 12.40 Maximum payload per entry............. 9 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 533 52.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 533 52.1% *** Table BUCKET_TEMPLATE and all its indices ************************ Percentage of total database.......... 0.071% Number of entries..................... 16 Bytes of storage consumed............. 2048 Bytes of payload...................... 170 8.3% Average payload per entry............. 10.63 Average unused bytes per entry........ 112.88 Fragmentation......................... 0.0% Maximum payload per entry............. 15 Entries that use overflow............. 0 0.0% Primary pages used.................... 2 Overflow pages used................... 0 Total pages used...................... 2 Unused bytes on primary pages......... 1806 88.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1806 88.2% *** Table BUCKET_TEMPLATE w/o any indices **************************** Percentage of total database.......... 0.035% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 91 8.9% Average payload per entry............. 11.38 Average unused bytes per entry........ 111.63 Maximum payload per entry............. 15 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 893 87.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 893 87.2% *** Indices of table BUCKET_TEMPLATE ********************************* Percentage of total database.......... 0.035% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 79 7.7% Average payload per entry............. 9.88 Average unused bytes per entry........ 114.13 Maximum payload per entry............. 14 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 913 89.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 913 89.2% *** Table BUCKETS and all its indices ******************************** Percentage of total database.......... 0.071% Number of entries..................... 16 Bytes of storage consumed............. 2048 Bytes of payload...................... 254 12.4% Average payload per entry............. 15.88 Average unused bytes per entry........ 107.63 Fragmentation......................... 0.0% 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......... 1722 84.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1722 84.1% *** Table BUCKETS w/o any indices ************************************ Percentage of total database.......... 0.035% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 131 12.8% Average payload per entry............. 16.38 Average unused bytes per entry........ 106.63 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......... 853 83.3% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 853 83.3% *** Indices of table BUCKETS ***************************************** Percentage of total database.......... 0.035% Number of entries..................... 8 Bytes of storage consumed............. 1024 Bytes of payload...................... 123 12.0% Average payload per entry............. 15.38 Average unused bytes per entry........ 108.63 Maximum payload per entry............. 18 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 869 84.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 869 84.9% *** Table HISTORY **************************************************** Percentage of total database.......... 0.035% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes 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......... 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.071% Number of entries..................... 8 Bytes of storage consumed............. 2048 Bytes of payload...................... 77 3.8% Average payload per entry............. 9.63 Average unused bytes per entry........ 240.88 Fragmentation......................... 0.0% Maximum payload per entry............. 18 Entries that use overflow............. 0 0.0% Primary pages used.................... 2 Overflow pages used................... 0 Total pages used...................... 2 Unused bytes on primary pages......... 1927 94.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1927 94.1% *** Table MAGNET_TYPES w/o any indices ******************************* Percentage of total database.......... 0.035% Number of entries..................... 4 Bytes of storage consumed............. 1024 Bytes of payload...................... 46 4.5% Average payload per entry............. 11.50 Average unused bytes per entry........ 238.50 Maximum payload per entry............. 18 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 954 93.2% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 954 93.2% *** Indices of table MAGNET_TYPES ************************************ Percentage of total database.......... 0.035% Number of entries..................... 4 Bytes of storage consumed............. 1024 Bytes of payload...................... 31 3.0% Average payload per entry............. 7.75 Average unused bytes per entry........ 243.25 Maximum payload per entry............. 11 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 973 95.0% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 973 95.0% *** Table MAGNETS **************************************************** Percentage of total database.......... 0.035% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 10 0.98% Average payload per entry............. 10.00 Average unused bytes per entry........ 1002.00 Maximum payload per entry............. 10 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 1002 97.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1002 97.9% *** Table MATRIX and all its indices ********************************* Percentage of total database.......... 52.7% Number of entries..................... 98066 Bytes of storage consumed............. 1527808 Bytes of payload...................... 973769 63.7% Average payload per entry............. 9.93 Average unused bytes per entry........ 0.97 Average fanout........................ 87.00 Fragmentation......................... 4.1% Maximum payload per entry............. 12 Entries that use overflow............. 0 0.0% Index pages used...................... 9 Primary pages used.................... 1483 Overflow pages used................... 0 Total pages used...................... 1492 Unused bytes on index pages........... 2188 23.7% Unused bytes on primary pages......... 92603 6.1% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 94791 6.2% *** Table MATRIX w/o any indices ************************************* Percentage of total database.......... 27.7% Number of entries..................... 49033 Bytes of storage consumed............. 803840 Bytes of payload...................... 490939 61.1% Average payload per entry............. 10.01 Average unused bytes per entry........ 0.19 Average fanout........................ 87.00 Fragmentation......................... 2.9% Maximum payload per entry............. 12 Entries that use overflow............. 0 0.0% Index pages used...................... 9 Primary pages used.................... 776 Overflow pages used................... 0 Total pages used...................... 785 Unused bytes on index pages........... 2188 23.7% Unused bytes on primary pages......... 7044 0.89% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 9232 1.1% *** Indices of table MATRIX ****************************************** Percentage of total database.......... 25.0% Number of entries..................... 49033 Bytes of storage consumed............. 723968 Bytes of payload...................... 482830 66.7% Average payload per entry............. 9.85 Average unused bytes per entry........ 1.74 Fragmentation......................... 5.4% Maximum payload per entry............. 11 Entries that use overflow............. 0 0.0% Primary pages used.................... 707 Overflow pages used................... 0 Total pages used...................... 707 Unused bytes on primary pages......... 85559 11.8% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 85559 11.8% *** Table POPFILE **************************************************** Percentage of total database.......... 0.035% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 4 0.39% Average payload per entry............. 4.00 Average unused bytes per entry........ 1008.00 Maximum payload per entry............. 4 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 1008 98.4% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1008 98.4% *** Table SQLITE_MASTER ********************************************** Percentage of total database.......... 0.35% Number of entries..................... 26 Bytes of storage consumed............. 10240 Bytes of payload...................... 6542 63.9% Average payload per entry............. 251.62 Average unused bytes per entry........ 128.35 Average fanout........................ 9.00 Fragmentation......................... 77.8% Maximum payload per entry............. 898 Entries that use overflow............. 0 0.0% Index pages used...................... 1 Primary pages used.................... 9 Overflow pages used................... 0 Total pages used...................... 10 Unused bytes on index pages........... 856 83.6% Unused bytes on primary pages......... 2481 26.9% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 3337 32.6% *** Table USER_PARAMS and all its indices **************************** Percentage of total database.......... 0.071% Number of entries..................... 0 Bytes of storage consumed............. 2048 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes per entry........ 0.0 Fragmentation......................... 0.0% Maximum payload per entry............. 0 Entries that use overflow............. 0 Primary pages used.................... 2 Overflow pages used................... 0 Total pages used...................... 2 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.035% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes 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......... 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.035% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes 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......... 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.071% Number of entries..................... 0 Bytes of storage consumed............. 2048 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes per entry........ 0.0 Fragmentation......................... 0.0% Maximum payload per entry............. 0 Entries that use overflow............. 0 Primary pages used.................... 2 Overflow pages used................... 0 Total pages used...................... 2 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.035% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes 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......... 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.035% Number of entries..................... 0 Bytes of storage consumed............. 1024 Bytes of payload...................... 0 0.0% Average payload per entry............. 0.0 Average unused bytes 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......... 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.071% Number of entries..................... 2 Bytes of storage consumed............. 2048 Bytes of payload...................... 50 2.4% Average payload per entry............. 25.00 Average unused bytes per entry........ 987.50 Fragmentation......................... 0.0% Maximum payload per entry............. 41 Entries that use overflow............. 0 0.0% Primary pages used.................... 2 Overflow pages used................... 0 Total pages used...................... 2 Unused bytes on primary pages......... 1975 96.4% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1975 96.4% *** Table USERS w/o any indices ************************************** Percentage of total database.......... 0.035% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 41 4.0% Average payload per entry............. 41.00 Average unused bytes per entry........ 971.00 Maximum payload per entry............. 41 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 971 94.8% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 971 94.8% *** Indices of table USERS ******************************************* Percentage of total database.......... 0.035% Number of entries..................... 1 Bytes of storage consumed............. 1024 Bytes of payload...................... 9 0.88% Average payload per entry............. 9.00 Average unused bytes per entry........ 1004.00 Maximum payload per entry............. 9 Entries that use overflow............. 0 0.0% Primary pages used.................... 1 Overflow pages used................... 0 Total pages used...................... 1 Unused bytes on primary pages......... 1004 98.0% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 1004 98.0% *** Table WORDS and all its indices ********************************** Percentage of total database.......... 46.0% Number of entries..................... 67298 Bytes of storage consumed............. 1333248 Bytes of payload...................... 940693 70.6% Average payload per entry............. 13.98 Average unused bytes per entry........ 1.30 Average fanout........................ 89.00 Fragmentation......................... 5.1% Maximum payload per entry............. 54 Entries that use overflow............. 0 0.0% Index pages used...................... 7 Primary pages used.................... 1295 Overflow pages used................... 0 Total pages used...................... 1302 Unused bytes on index pages........... 1812 25.3% Unused bytes on primary pages......... 85992 6.5% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 87804 6.6% *** Table WORDS w/o any indices ************************************** Percentage of total database.......... 22.1% Number of entries..................... 33649 Bytes of storage consumed............. 640000 Bytes of payload...................... 436320 68.2% Average payload per entry............. 12.97 Average unused bytes per entry........ 0.24 Average fanout........................ 89.00 Fragmentation......................... 2.7% Maximum payload per entry............. 52 Entries that use overflow............. 0 0.0% Index pages used...................... 7 Primary pages used.................... 618 Overflow pages used................... 0 Total pages used...................... 625 Unused bytes on index pages........... 1812 25.3% Unused bytes on primary pages......... 6184 0.98% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 7996 1.2% *** Indices of table WORDS ******************************************* Percentage of total database.......... 23.9% Number of entries..................... 33649 Bytes of storage consumed............. 693248 Bytes of payload...................... 504373 72.8% Average payload per entry............. 14.99 Average unused bytes per entry........ 2.37 Fragmentation......................... 7.4% Maximum payload per entry............. 54 Entries that use overflow............. 0 0.0% Primary pages used.................... 677 Overflow pages used................... 0 Total pages used...................... 677 Unused bytes on primary pages......... 79808 11.5% Unused bytes on overflow pages........ 0 Unused bytes on all pages............. 79808 11.5% *** 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 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. 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_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 user payload stored The total number of bytes of user payload stored in the database. The schema information in the SQLITE_MASTER 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. 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. Fragmentation The percentage of pages in the table or index that are not consecutive in the disk file. Many filesystems are optimized for sequential file access so smaller fragmentation numbers sometimes result in faster queries, especially for larger database files that do not fit in the disk cache. 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 nentry int, -- Number of entries in the BTree leaf_entries int, -- Number of leaf entries 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 ); INSERT INTO space_used VALUES('sqlite_master','sqlite_master',0,34,26,6542,0,0,898,1,9,0,856,2481,0,7); INSERT INTO space_used VALUES('popfile','popfile',0,1,1,4,0,0,4,0,1,0,0,1008,0,0); INSERT INTO space_used VALUES('users','users',0,1,1,41,0,0,41,0,1,0,0,971,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_users_1','users',1,1,1,9,0,0,9,0,1,0,0,1004,0,0); INSERT INTO space_used VALUES('buckets','buckets',0,8,8,131,0,0,19,0,1,0,0,853,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_buckets_1','buckets',1,8,8,123,0,0,18,0,1,0,0,869,0,0); INSERT INTO space_used VALUES('words','words',0,34266,33649,436320,0,0,52,7,618,0,1812,6184,0,17); INSERT INTO space_used VALUES('sqlite_autoindex_words_1','words',1,33649,33649,504373,0,0,54,0,677,0,0,79808,0,50); INSERT INTO space_used VALUES('matrix','matrix',0,49808,49033,490939,0,0,12,9,776,0,2188,7044,0,23); INSERT INTO space_used VALUES('sqlite_autoindex_matrix_1','matrix',1,49033,49033,482830,0,0,11,0,707,0,0,85559,0,38); INSERT INTO space_used VALUES('user_template','user_template',0,0,0,0,0,0,0,0,1,0,0,1016,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_user_template_1','user_template',1,0,0,0,0,0,0,0,1,0,0,1016,0,0); INSERT INTO space_used VALUES('user_params','user_params',0,0,0,0,0,0,0,0,1,0,0,1016,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_user_params_1','user_params',1,0,0,0,0,0,0,0,1,0,0,1016,0,0); INSERT INTO space_used VALUES('bucket_template','bucket_template',0,8,8,91,0,0,15,0,1,0,0,893,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_bucket_template_1','bucket_template',1,8,8,79,0,0,14,0,1,0,0,913,0,0); INSERT INTO space_used VALUES('bucket_params','bucket_params',0,43,43,390,0,0,14,0,1,0,0,401,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_bucket_params_1','bucket_params',1,43,43,354,0,0,9,0,1,0,0,533,0,0); INSERT INTO space_used VALUES('magnet_types','magnet_types',0,4,4,46,0,0,18,0,1,0,0,954,0,0); INSERT INTO space_used VALUES('sqlite_autoindex_magnet_types_1','magnet_types',1,4,4,31,0,0,11,0,1,0,0,973,0,0); INSERT INTO space_used VALUES('magnets','magnets',0,1,1,10,0,0,10,0,1,0,0,1002,0,0); INSERT INTO space_used VALUES('history','history',0,0,0,0,0,0,0,0,1,0,0,1016,0,0); COMMIT;