Post by gentlish » Sat Jan 29, 2022 7:59 pm
Hi,
Below, I have pasted the file that was generated from following your steps.
NOTE: It was 9000 characters over the permitted limit, so I cut out the following 4 sections, which stated 0% of total database: (1) the definitions section; (2) "Table TAGS"; (3) "Index SQLITE_AUTOINDEX_SSLCERTIFICATES_1 of table SSLCERTIFICATES"; and (4) "Table SSLCERTIFICATES w/o any indices" and "Table SSLCERTIFICATES and all its indices"
- [+] Disk-Space Utilization Report For db.sqlite
- Page size in bytes................................ 4096
Pages in the whole file (measured)................ 124873
Pages in the whole file (calculated).............. 124873
Pages that store data............................. 124873 100.0%
Pages on the freelist (per header)................ 0 0.0%
Pages on the freelist (calculated)................ 0 0.0%
Pages of auto-vacuum overhead..................... 0 0.0%
Number of tables in the database.................. 24
Number of indices................................. 9
Number of defined indices......................... 0
Number of implied indices......................... 9
Size of the file in bytes......................... 511479808
Bytes of user payload stored...................... 509450436 99.60%
*** Page counts for all tables with their indices *****************************
PREVIEWS.......................................... 124446 99.66%
DOWNLOADS......................................... 391 0.31%
DOWNLOADSPREVIEWS................................. 4 0.003%
SQLITE_SCHEMA..................................... 3 0.002%
SETTINGS.......................................... 2 0.002%
UPDATES........................................... 2 0.002%
UPDATESMANAGERS................................... 2 0.002%
DOWNLOADSMODULES.................................. 2 0.002%
MISCDATA.......................................... 2 0.002%
NETWORKPASSWORDS.................................. 2 0.002%
PATHBYURLHASH..................................... 2 0.002%
SOUNDNOTIFICATIONS................................ 2 0.002%
SSLCERTIFICATES................................... 2 0.002%
DOWNLOADSAUTORETRIES.............................. 1 0.0%
DOWNLOADSLOCKS.................................... 1 0.0%
DOWNLOADSMISCFLAGS................................ 1 0.0%
DOWNLOADSSCHEDULERECORDS.......................... 1 0.0%
DOWNLOADSTAGS..................................... 1 0.0%
DOWNLOADSTAGSDETAILS.............................. 1 0.0%
DOWNLOADSWITHMISSINGFILESSTATS.................... 1 0.0%
MOVEDOWNLOADSFILESTASKS........................... 1 0.0%
MOVEFILESTASKS.................................... 1 0.0%
PATHBYFILETYPE.................................... 1 0.0%
TAGS.............................................. 1 0.0%
*** Page counts for all tables and indices separately *************************
PREVIEWS.......................................... 124446 99.66%
DOWNLOADS......................................... 391 0.31%
DOWNLOADSPREVIEWS................................. 4 0.003%
SQLITE_SCHEMA..................................... 3 0.002%
SETTINGS.......................................... 1 0.0%
UPDATES........................................... 1 0.0%
UPDATESMANAGERS................................... 1 0.0%
DOWNLOADSAUTORETRIES.............................. 1 0.0%
DOWNLOADSLOCKS.................................... 1 0.0%
DOWNLOADSMISCFLAGS................................ 1 0.0%
DOWNLOADSMODULES.................................. 1 0.0%
DOWNLOADSSCHEDULERECORDS.......................... 1 0.0%
DOWNLOADSTAGS..................................... 1 0.0%
DOWNLOADSTAGSDETAILS.............................. 1 0.0%
DOWNLOADSWITHMISSINGFILESSTATS.................... 1 0.0%
MISCDATA.......................................... 1 0.0%
MOVEDOWNLOADSFILESTASKS........................... 1 0.0%
MOVEFILESTASKS.................................... 1 0.0%
NETWORKPASSWORDS.................................. 1 0.0%
PATHBYFILETYPE.................................... 1 0.0%
PATHBYURLHASH..................................... 1 0.0%
SOUNDNOTIFICATIONS................................ 1 0.0%
SQLITE_AUTOINDEX_SETTINGS_1....................... 1 0.0%
SQLITE_AUTOINDEX_UPDATESMANAGERS_1................ 1 0.0%
SQLITE_AUTOINDEX_UPDATES_1........................ 1 0.0%
SQLITE_AUTOINDEX_DOWNLOADSMODULES_1............... 1 0.0%
SQLITE_AUTOINDEX_MISCDATA_1....................... 1 0.0%
SQLITE_AUTOINDEX_NETWORKPASSWORDS_1............... 1 0.0%
SQLITE_AUTOINDEX_PATHBYURLHASH_1.................. 1 0.0%
SQLITE_AUTOINDEX_SOUNDNOTIFICATIONS_1............. 1 0.0%
SQLITE_AUTOINDEX_SSLCERTIFICATES_1................ 1 0.0%
SSLCERTIFICATES................................... 1 0.0%
TAGS.............................................. 1 0.0%
*** All tables and indices ****************************************************
Percentage of total database...................... 100.0%
Number of entries................................. 3172
Bytes of storage consumed......................... 511479808
Bytes of payload.................................. 509456446 99.60%
Bytes of metadata................................. 1028431 0.20%
Average payload per entry......................... 160610.48
Average unused bytes per entry.................... 467.61
Average metadata per entry........................ 324.22
Average fanout.................................... 222.00
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1436 45.3%
Index pages used.................................. 6
Primary pages used................................ 1351
Overflow pages used............................... 123516
Total pages used.................................. 124873
Unused bytes on index pages....................... 13861 56.4%
Unused bytes on primary pages..................... 1423035 25.7%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 1483251 0.29%
*** All tables ****************************************************************
Percentage of total database...................... 99.993%
Number of entries................................. 3122
Bytes of storage consumed......................... 511442944
Bytes of payload.................................. 509455196 99.61%
Bytes of metadata................................. 1028209 0.20%
Average payload per entry......................... 163182.32
Average unused bytes per entry.................... 463.76
Average metadata per entry........................ 329.34
Average fanout.................................... 220.00
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1436 46.0%
Index pages used.................................. 6
Primary pages used................................ 1342
Overflow pages used............................... 123516
Total pages used.................................. 124864
Unused bytes on index pages....................... 13861 56.4%
Unused bytes on primary pages..................... 1387643 25.2%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 1447859 0.28%
*** All indices ***************************************************************
Percentage of total database...................... 0.007%
Number of entries................................. 50
Bytes of storage consumed......................... 36864
Bytes of payload.................................. 1250 3.4%
Bytes of metadata................................. 222 0.60%
Average payload per entry......................... 25.00
Average unused bytes per entry.................... 707.84
Average metadata per entry........................ 4.44
Maximum payload per entry......................... 48
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 9
Overflow pages used............................... 0
Total pages used.................................. 9
Unused bytes on primary pages..................... 35392 96.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 35392 96.0%
*** Table SETTINGS and all its indices ****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 72
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 2008 24.5%
Bytes of metadata................................. 268 3.3%
Average payload per entry......................... 27.89
Average unused bytes per entry.................... 82.17
Average metadata per entry........................ 3.72
Maximum payload per entry......................... 53
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 5916 72.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5916 72.2%
*** Table SETTINGS w/o any indices ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 36
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 1065 26.0%
Bytes of metadata................................. 152 3.7%
B-tree depth...................................... 1
Average payload per entry......................... 29.58
Average unused bytes per entry.................... 79.97
Average metadata per entry........................ 4.22
Maximum payload per entry......................... 53
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 2879 70.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 2879 70.3%
*** Index SQLITE_AUTOINDEX_SETTINGS_1 of table SETTINGS ***********************
Percentage of total database...................... 0.0%
Number of entries................................. 36
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 943 23.0%
Bytes of metadata................................. 116 2.8%
B-tree depth...................................... 1
Average payload per entry......................... 26.19
Average unused bytes per entry.................... 84.36
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 48
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3037 74.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3037 74.1%
*** Table UPDATES and all its indices *****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 2
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 70 0.85%
Bytes of metadata................................. 23 0.28%
Average payload per entry......................... 35.00
Average unused bytes per entry.................... 4049.50
Average metadata per entry........................ 11.50
Maximum payload per entry......................... 45
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8099 98.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8099 98.9%
*** Table UPDATES w/o any indices *********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 45 1.1%
Bytes of metadata................................. 12 0.29%
B-tree depth...................................... 1
Average payload per entry......................... 45.00
Average unused bytes per entry.................... 4039.00
Average metadata per entry........................ 12.00
Maximum payload per entry......................... 45
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4039 98.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4039 98.6%
*** Index SQLITE_AUTOINDEX_UPDATES_1 of table UPDATES *************************
Percentage of total database...................... 0.0%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 25 0.61%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 25.00
Average unused bytes per entry.................... 4060.00
Average metadata per entry........................ 11.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..................... 4060 99.12%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4060 99.12%
*** Table UPDATESMANAGERS and all its indices *********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table UPDATESMANAGERS w/o any indices *************************************
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%
*** Index SQLITE_AUTOINDEX_UPDATESMANAGERS_1 of table UPDATESMANAGERS *********
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 DOWNLOADS ***********************************************************
Percentage of total database...................... 0.31%
Number of entries................................. 774
Bytes of storage consumed......................... 1601536
Bytes of payload.................................. 1234761 77.1%
Bytes of metadata................................. 10856 0.68%
B-tree depth...................................... 2
Average payload per entry......................... 1595.30
Average unused bytes per entry.................... 459.84
Average metadata per entry........................ 14.03
Average fanout.................................... 386.00
Non-sequential pages.............................. 1 0.26%
Maximum payload per entry......................... 5441
Entries that use overflow......................... 4 0.52%
Index pages used.................................. 1
Primary pages used................................ 386
Overflow pages used............................... 4
Total pages used.................................. 391
Unused bytes on index pages....................... 1004 24.5%
Unused bytes on primary pages..................... 354915 22.4%
Unused bytes on overflow pages.................... 0 0.0%
Unused bytes on all pages......................... 355919 22.2%
*** Table DOWNLOADSAUTORETRIES ************************************************
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 DOWNLOADSLOCKS ******************************************************
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 DOWNLOADSMISCFLAGS **************************************************
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 DOWNLOADSMODULES and all its indices ********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table DOWNLOADSMODULES w/o any indices ************************************
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%
*** Index SQLITE_AUTOINDEX_DOWNLOADSMODULES_1 of table DOWNLOADSMODULES *******
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 DOWNLOADSPREVIEWS ***************************************************
Percentage of total database...................... 0.003%
Number of entries................................. 773
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 6847 41.8%
Bytes of metadata................................. 3917 23.9%
B-tree depth...................................... 2
Average payload per entry......................... 8.86
Average unused bytes per entry.................... 7.27
Average metadata per entry........................ 5.07
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 33.3%
Maximum payload per entry......................... 9
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 4068 99.32%
Unused bytes on primary pages..................... 1552 12.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5620 34.3%
*** Table DOWNLOADSSCHEDULERECORDS ********************************************
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 DOWNLOADSTAGS *******************************************************
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 DOWNLOADSTAGSDETAILS ************************************************
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 DOWNLOADSWITHMISSINGFILESSTATS **************************************
Percentage of total database...................... 0.0%
Number of entries................................. 57
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 399 9.7%
Bytes of metadata................................. 293 7.2%
B-tree depth...................................... 1
Average payload per entry......................... 7.00
Average unused bytes per entry.................... 59.72
Average metadata per entry........................ 5.14
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3404 83.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3404 83.1%
*** Table MISCDATA and all its indices ****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 26
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 902 11.0%
Bytes of metadata................................. 113 1.4%
Average payload per entry......................... 34.69
Average unused bytes per entry.................... 276.04
Average metadata per entry........................ 4.35
Maximum payload per entry......................... 141
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 7177 87.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7177 87.6%
*** Table MISCDATA w/o any indices ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 13
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 620 15.1%
Bytes of metadata................................. 66 1.6%
B-tree depth...................................... 1
Average payload per entry......................... 47.69
Average unused bytes per entry.................... 262.31
Average metadata per entry........................ 5.08
Maximum payload per entry......................... 141
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3410 83.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3410 83.3%
*** Index SQLITE_AUTOINDEX_MISCDATA_1 of table MISCDATA ***********************
Percentage of total database...................... 0.0%
Number of entries................................. 13
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 282 6.9%
Bytes of metadata................................. 47 1.1%
B-tree depth...................................... 1
Average payload per entry......................... 21.69
Average unused bytes per entry.................... 289.77
Average metadata per entry........................ 3.62
Maximum payload per entry......................... 30
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3767 92.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3767 92.0%
*** Table MOVEDOWNLOADSFILESTASKS *********************************************
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 MOVEFILESTASKS ******************************************************
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 NETWORKPASSWORDS and all its indices ********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table NETWORKPASSWORDS w/o any indices ************************************
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%
*** Index SQLITE_AUTOINDEX_NETWORKPASSWORDS_1 of table NETWORKPASSWORDS *******
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 PATHBYFILETYPE ******************************************************
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 PATHBYURLHASH and all its indices ***********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table PATHBYURLHASH w/o any indices ***************************************
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%
*** Index SQLITE_AUTOINDEX_PATHBYURLHASH_1 of table PATHBYURLHASH *************
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 PREVIEWS ************************************************************
Percentage of total database...................... 99.66%
Number of entries................................. 1436
Bytes of storage consumed......................... 509730816
Bytes of payload.................................. 508206699 99.70%
Bytes of metadata................................. 1012506 0.20%
B-tree depth...................................... 3
Average payload per entry......................... 353904.39
Average unused bytes per entry.................... 696.33
Average metadata per entry........................ 705.09
Average fanout.................................... 311.00
Non-sequential pages.............................. 0 0.0%
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1432 99.72%
Index pages used.................................. 3
Primary pages used................................ 931
Overflow pages used............................... 123512
Total pages used.................................. 124446
Unused bytes on index pages....................... 4812 39.2%
Unused bytes on primary pages..................... 948764 24.9%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 999931 0.20%
*** Table SOUNDNOTIFICATIONS and all its indices ******************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table SOUNDNOTIFICATIONS w/o any indices **********************************
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%
*** Index SQLITE_AUTOINDEX_SOUNDNOTIFICATIONS_1 of table SOUNDNOTIFICATIONS ***
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 SQLITE_SCHEMA *******************************************************
Percentage of total database...................... 0.002%
Number of entries................................. 32
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 4760 38.7%
Bytes of metadata................................. 279 2.3%
B-tree depth...................................... 2
Average payload per entry......................... 148.75
Average unused bytes per entry.................... 226.53
Average metadata per entry........................ 8.72
Average fanout.................................... 2.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 753
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..................... 3272 39.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7249 59.0%
*/
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,33,32,2,4760,0,0,753,1,2,0,3977,3272,0,1,12288);
INSERT INTO space_used VALUES('miscData','miscData',0,0,13,13,1,620,0,0,141,0,1,0,0,3410,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_miscData_1','miscData',1,0,13,13,1,282,0,0,30,0,1,0,0,3767,0,0,4096);
INSERT INTO space_used VALUES('Settings','Settings',0,0,36,36,1,1065,0,0,53,0,1,0,0,2879,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_Settings_1','Settings',1,0,36,36,1,943,0,0,48,0,1,0,0,3037,0,0,4096);
INSERT INTO space_used VALUES('previews','previews',0,0,2366,1436,3,508206699,505364749,1432,3467918,3,931,123512,4812,948764,46355,0,509730816);
INSERT INTO space_used VALUES('networkPasswords','networkPasswords',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_networkPasswords_1','networkPasswords',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sslCertificates','sslCertificates',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_sslCertificates_1','sslCertificates',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsModules','downloadsModules',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_downloadsModules_1','downloadsModules',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsLocks','downloadsLocks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloads','downloads',0,0,1159,774,2,1234761,16368,4,5441,1,386,4,1004,354915,0,1,1601536);
INSERT INTO space_used VALUES('pathByUrlHash','pathByUrlHash',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_pathByUrlHash_1','pathByUrlHash',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('pathByFileType','pathByFileType',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('tags','tags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsTags','downloadsTags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsTagsDetails','downloadsTagsDetails',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsScheduleRecords','downloadsScheduleRecords',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsAutoRetries','downloadsAutoRetries',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsMiscFlags','downloadsMiscFlags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsWithMissingFilesStats','downloadsWithMissingFilesStats',0,0,57,57,1,399,0,0,7,0,1,0,0,3404,0,0,4096);
INSERT INTO space_used VALUES('downloadsPreviews','downloadsPreviews',0,0,775,773,2,6847,0,0,9,1,3,0,4068,1552,0,1,16384);
INSERT INTO space_used VALUES('moveFilesTasks','moveFilesTasks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('moveDownloadsFilesTasks','moveDownloadsFilesTasks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('soundNotifications','soundNotifications',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_soundNotifications_1','soundNotifications',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('UpdatesManagers','UpdatesManagers',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_UpdatesManagers_1','UpdatesManagers',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('Updates','Updates',0,0,1,1,1,45,0,0,45,0,1,0,0,4039,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_Updates_1','Updates',1,0,1,1,1,25,0,0,25,0,1,0,0,4060,0,0,4096);
COMMIT;
Hi,
Below, I have pasted the file that was generated from following your steps. [b]NOTE[/b]: It was 9000 characters over the permitted limit, so I cut out the following 4 sections, which stated 0% of total database: (1) the definitions section; (2) "Table TAGS"; (3) "Index SQLITE_AUTOINDEX_SSLCERTIFICATES_1 of table SSLCERTIFICATES"; and (4) "Table SSLCERTIFICATES w/o any indices" and "Table SSLCERTIFICATES and all its indices"
[spoiler title="Disk-Space Utilization Report For db.sqlite"]Page size in bytes................................ 4096
Pages in the whole file (measured)................ 124873
Pages in the whole file (calculated).............. 124873
Pages that store data............................. 124873 100.0%
Pages on the freelist (per header)................ 0 0.0%
Pages on the freelist (calculated)................ 0 0.0%
Pages of auto-vacuum overhead..................... 0 0.0%
Number of tables in the database.................. 24
Number of indices................................. 9
Number of defined indices......................... 0
Number of implied indices......................... 9
Size of the file in bytes......................... 511479808
Bytes of user payload stored...................... 509450436 99.60%
*** Page counts for all tables with their indices *****************************
PREVIEWS.......................................... 124446 99.66%
DOWNLOADS......................................... 391 0.31%
DOWNLOADSPREVIEWS................................. 4 0.003%
SQLITE_SCHEMA..................................... 3 0.002%
SETTINGS.......................................... 2 0.002%
UPDATES........................................... 2 0.002%
UPDATESMANAGERS................................... 2 0.002%
DOWNLOADSMODULES.................................. 2 0.002%
MISCDATA.......................................... 2 0.002%
NETWORKPASSWORDS.................................. 2 0.002%
PATHBYURLHASH..................................... 2 0.002%
SOUNDNOTIFICATIONS................................ 2 0.002%
SSLCERTIFICATES................................... 2 0.002%
DOWNLOADSAUTORETRIES.............................. 1 0.0%
DOWNLOADSLOCKS.................................... 1 0.0%
DOWNLOADSMISCFLAGS................................ 1 0.0%
DOWNLOADSSCHEDULERECORDS.......................... 1 0.0%
DOWNLOADSTAGS..................................... 1 0.0%
DOWNLOADSTAGSDETAILS.............................. 1 0.0%
DOWNLOADSWITHMISSINGFILESSTATS.................... 1 0.0%
MOVEDOWNLOADSFILESTASKS........................... 1 0.0%
MOVEFILESTASKS.................................... 1 0.0%
PATHBYFILETYPE.................................... 1 0.0%
TAGS.............................................. 1 0.0%
*** Page counts for all tables and indices separately *************************
PREVIEWS.......................................... 124446 99.66%
DOWNLOADS......................................... 391 0.31%
DOWNLOADSPREVIEWS................................. 4 0.003%
SQLITE_SCHEMA..................................... 3 0.002%
SETTINGS.......................................... 1 0.0%
UPDATES........................................... 1 0.0%
UPDATESMANAGERS................................... 1 0.0%
DOWNLOADSAUTORETRIES.............................. 1 0.0%
DOWNLOADSLOCKS.................................... 1 0.0%
DOWNLOADSMISCFLAGS................................ 1 0.0%
DOWNLOADSMODULES.................................. 1 0.0%
DOWNLOADSSCHEDULERECORDS.......................... 1 0.0%
DOWNLOADSTAGS..................................... 1 0.0%
DOWNLOADSTAGSDETAILS.............................. 1 0.0%
DOWNLOADSWITHMISSINGFILESSTATS.................... 1 0.0%
MISCDATA.......................................... 1 0.0%
MOVEDOWNLOADSFILESTASKS........................... 1 0.0%
MOVEFILESTASKS.................................... 1 0.0%
NETWORKPASSWORDS.................................. 1 0.0%
PATHBYFILETYPE.................................... 1 0.0%
PATHBYURLHASH..................................... 1 0.0%
SOUNDNOTIFICATIONS................................ 1 0.0%
SQLITE_AUTOINDEX_SETTINGS_1....................... 1 0.0%
SQLITE_AUTOINDEX_UPDATESMANAGERS_1................ 1 0.0%
SQLITE_AUTOINDEX_UPDATES_1........................ 1 0.0%
SQLITE_AUTOINDEX_DOWNLOADSMODULES_1............... 1 0.0%
SQLITE_AUTOINDEX_MISCDATA_1....................... 1 0.0%
SQLITE_AUTOINDEX_NETWORKPASSWORDS_1............... 1 0.0%
SQLITE_AUTOINDEX_PATHBYURLHASH_1.................. 1 0.0%
SQLITE_AUTOINDEX_SOUNDNOTIFICATIONS_1............. 1 0.0%
SQLITE_AUTOINDEX_SSLCERTIFICATES_1................ 1 0.0%
SSLCERTIFICATES................................... 1 0.0%
TAGS.............................................. 1 0.0%
*** All tables and indices ****************************************************
Percentage of total database...................... 100.0%
Number of entries................................. 3172
Bytes of storage consumed......................... 511479808
Bytes of payload.................................. 509456446 99.60%
Bytes of metadata................................. 1028431 0.20%
Average payload per entry......................... 160610.48
Average unused bytes per entry.................... 467.61
Average metadata per entry........................ 324.22
Average fanout.................................... 222.00
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1436 45.3%
Index pages used.................................. 6
Primary pages used................................ 1351
Overflow pages used............................... 123516
Total pages used.................................. 124873
Unused bytes on index pages....................... 13861 56.4%
Unused bytes on primary pages..................... 1423035 25.7%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 1483251 0.29%
*** All tables ****************************************************************
Percentage of total database...................... 99.993%
Number of entries................................. 3122
Bytes of storage consumed......................... 511442944
Bytes of payload.................................. 509455196 99.61%
Bytes of metadata................................. 1028209 0.20%
Average payload per entry......................... 163182.32
Average unused bytes per entry.................... 463.76
Average metadata per entry........................ 329.34
Average fanout.................................... 220.00
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1436 46.0%
Index pages used.................................. 6
Primary pages used................................ 1342
Overflow pages used............................... 123516
Total pages used.................................. 124864
Unused bytes on index pages....................... 13861 56.4%
Unused bytes on primary pages..................... 1387643 25.2%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 1447859 0.28%
*** All indices ***************************************************************
Percentage of total database...................... 0.007%
Number of entries................................. 50
Bytes of storage consumed......................... 36864
Bytes of payload.................................. 1250 3.4%
Bytes of metadata................................. 222 0.60%
Average payload per entry......................... 25.00
Average unused bytes per entry.................... 707.84
Average metadata per entry........................ 4.44
Maximum payload per entry......................... 48
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 9
Overflow pages used............................... 0
Total pages used.................................. 9
Unused bytes on primary pages..................... 35392 96.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 35392 96.0%
*** Table SETTINGS and all its indices ****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 72
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 2008 24.5%
Bytes of metadata................................. 268 3.3%
Average payload per entry......................... 27.89
Average unused bytes per entry.................... 82.17
Average metadata per entry........................ 3.72
Maximum payload per entry......................... 53
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 5916 72.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5916 72.2%
*** Table SETTINGS w/o any indices ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 36
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 1065 26.0%
Bytes of metadata................................. 152 3.7%
B-tree depth...................................... 1
Average payload per entry......................... 29.58
Average unused bytes per entry.................... 79.97
Average metadata per entry........................ 4.22
Maximum payload per entry......................... 53
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 2879 70.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 2879 70.3%
*** Index SQLITE_AUTOINDEX_SETTINGS_1 of table SETTINGS ***********************
Percentage of total database...................... 0.0%
Number of entries................................. 36
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 943 23.0%
Bytes of metadata................................. 116 2.8%
B-tree depth...................................... 1
Average payload per entry......................... 26.19
Average unused bytes per entry.................... 84.36
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 48
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3037 74.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3037 74.1%
*** Table UPDATES and all its indices *****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 2
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 70 0.85%
Bytes of metadata................................. 23 0.28%
Average payload per entry......................... 35.00
Average unused bytes per entry.................... 4049.50
Average metadata per entry........................ 11.50
Maximum payload per entry......................... 45
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8099 98.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8099 98.9%
*** Table UPDATES w/o any indices *********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 45 1.1%
Bytes of metadata................................. 12 0.29%
B-tree depth...................................... 1
Average payload per entry......................... 45.00
Average unused bytes per entry.................... 4039.00
Average metadata per entry........................ 12.00
Maximum payload per entry......................... 45
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4039 98.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4039 98.6%
*** Index SQLITE_AUTOINDEX_UPDATES_1 of table UPDATES *************************
Percentage of total database...................... 0.0%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 25 0.61%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 25.00
Average unused bytes per entry.................... 4060.00
Average metadata per entry........................ 11.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..................... 4060 99.12%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4060 99.12%
*** Table UPDATESMANAGERS and all its indices *********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table UPDATESMANAGERS w/o any indices *************************************
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%
*** Index SQLITE_AUTOINDEX_UPDATESMANAGERS_1 of table UPDATESMANAGERS *********
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 DOWNLOADS ***********************************************************
Percentage of total database...................... 0.31%
Number of entries................................. 774
Bytes of storage consumed......................... 1601536
Bytes of payload.................................. 1234761 77.1%
Bytes of metadata................................. 10856 0.68%
B-tree depth...................................... 2
Average payload per entry......................... 1595.30
Average unused bytes per entry.................... 459.84
Average metadata per entry........................ 14.03
Average fanout.................................... 386.00
Non-sequential pages.............................. 1 0.26%
Maximum payload per entry......................... 5441
Entries that use overflow......................... 4 0.52%
Index pages used.................................. 1
Primary pages used................................ 386
Overflow pages used............................... 4
Total pages used.................................. 391
Unused bytes on index pages....................... 1004 24.5%
Unused bytes on primary pages..................... 354915 22.4%
Unused bytes on overflow pages.................... 0 0.0%
Unused bytes on all pages......................... 355919 22.2%
*** Table DOWNLOADSAUTORETRIES ************************************************
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 DOWNLOADSLOCKS ******************************************************
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 DOWNLOADSMISCFLAGS **************************************************
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 DOWNLOADSMODULES and all its indices ********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table DOWNLOADSMODULES w/o any indices ************************************
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%
*** Index SQLITE_AUTOINDEX_DOWNLOADSMODULES_1 of table DOWNLOADSMODULES *******
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 DOWNLOADSPREVIEWS ***************************************************
Percentage of total database...................... 0.003%
Number of entries................................. 773
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 6847 41.8%
Bytes of metadata................................. 3917 23.9%
B-tree depth...................................... 2
Average payload per entry......................... 8.86
Average unused bytes per entry.................... 7.27
Average metadata per entry........................ 5.07
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 33.3%
Maximum payload per entry......................... 9
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 4068 99.32%
Unused bytes on primary pages..................... 1552 12.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5620 34.3%
*** Table DOWNLOADSSCHEDULERECORDS ********************************************
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 DOWNLOADSTAGS *******************************************************
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 DOWNLOADSTAGSDETAILS ************************************************
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 DOWNLOADSWITHMISSINGFILESSTATS **************************************
Percentage of total database...................... 0.0%
Number of entries................................. 57
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 399 9.7%
Bytes of metadata................................. 293 7.2%
B-tree depth...................................... 1
Average payload per entry......................... 7.00
Average unused bytes per entry.................... 59.72
Average metadata per entry........................ 5.14
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3404 83.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3404 83.1%
*** Table MISCDATA and all its indices ****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 26
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 902 11.0%
Bytes of metadata................................. 113 1.4%
Average payload per entry......................... 34.69
Average unused bytes per entry.................... 276.04
Average metadata per entry........................ 4.35
Maximum payload per entry......................... 141
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 7177 87.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7177 87.6%
*** Table MISCDATA w/o any indices ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 13
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 620 15.1%
Bytes of metadata................................. 66 1.6%
B-tree depth...................................... 1
Average payload per entry......................... 47.69
Average unused bytes per entry.................... 262.31
Average metadata per entry........................ 5.08
Maximum payload per entry......................... 141
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3410 83.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3410 83.3%
*** Index SQLITE_AUTOINDEX_MISCDATA_1 of table MISCDATA ***********************
Percentage of total database...................... 0.0%
Number of entries................................. 13
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 282 6.9%
Bytes of metadata................................. 47 1.1%
B-tree depth...................................... 1
Average payload per entry......................... 21.69
Average unused bytes per entry.................... 289.77
Average metadata per entry........................ 3.62
Maximum payload per entry......................... 30
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3767 92.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3767 92.0%
*** Table MOVEDOWNLOADSFILESTASKS *********************************************
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 MOVEFILESTASKS ******************************************************
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 NETWORKPASSWORDS and all its indices ********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table NETWORKPASSWORDS w/o any indices ************************************
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%
*** Index SQLITE_AUTOINDEX_NETWORKPASSWORDS_1 of table NETWORKPASSWORDS *******
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 PATHBYFILETYPE ******************************************************
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 PATHBYURLHASH and all its indices ***********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table PATHBYURLHASH w/o any indices ***************************************
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%
*** Index SQLITE_AUTOINDEX_PATHBYURLHASH_1 of table PATHBYURLHASH *************
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 PREVIEWS ************************************************************
Percentage of total database...................... 99.66%
Number of entries................................. 1436
Bytes of storage consumed......................... 509730816
Bytes of payload.................................. 508206699 99.70%
Bytes of metadata................................. 1012506 0.20%
B-tree depth...................................... 3
Average payload per entry......................... 353904.39
Average unused bytes per entry.................... 696.33
Average metadata per entry........................ 705.09
Average fanout.................................... 311.00
Non-sequential pages.............................. 0 0.0%
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1432 99.72%
Index pages used.................................. 3
Primary pages used................................ 931
Overflow pages used............................... 123512
Total pages used.................................. 124446
Unused bytes on index pages....................... 4812 39.2%
Unused bytes on primary pages..................... 948764 24.9%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 999931 0.20%
*** Table SOUNDNOTIFICATIONS and all its indices ******************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
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................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table SOUNDNOTIFICATIONS w/o any indices **********************************
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%
*** Index SQLITE_AUTOINDEX_SOUNDNOTIFICATIONS_1 of table SOUNDNOTIFICATIONS ***
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 SQLITE_SCHEMA *******************************************************
Percentage of total database...................... 0.002%
Number of entries................................. 32
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 4760 38.7%
Bytes of metadata................................. 279 2.3%
B-tree depth...................................... 2
Average payload per entry......................... 148.75
Average unused bytes per entry.................... 226.53
Average metadata per entry........................ 8.72
Average fanout.................................... 2.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 753
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..................... 3272 39.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7249 59.0%
*/
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,33,32,2,4760,0,0,753,1,2,0,3977,3272,0,1,12288);
INSERT INTO space_used VALUES('miscData','miscData',0,0,13,13,1,620,0,0,141,0,1,0,0,3410,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_miscData_1','miscData',1,0,13,13,1,282,0,0,30,0,1,0,0,3767,0,0,4096);
INSERT INTO space_used VALUES('Settings','Settings',0,0,36,36,1,1065,0,0,53,0,1,0,0,2879,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_Settings_1','Settings',1,0,36,36,1,943,0,0,48,0,1,0,0,3037,0,0,4096);
INSERT INTO space_used VALUES('previews','previews',0,0,2366,1436,3,508206699,505364749,1432,3467918,3,931,123512,4812,948764,46355,0,509730816);
INSERT INTO space_used VALUES('networkPasswords','networkPasswords',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_networkPasswords_1','networkPasswords',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sslCertificates','sslCertificates',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_sslCertificates_1','sslCertificates',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsModules','downloadsModules',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_downloadsModules_1','downloadsModules',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsLocks','downloadsLocks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloads','downloads',0,0,1159,774,2,1234761,16368,4,5441,1,386,4,1004,354915,0,1,1601536);
INSERT INTO space_used VALUES('pathByUrlHash','pathByUrlHash',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_pathByUrlHash_1','pathByUrlHash',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('pathByFileType','pathByFileType',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('tags','tags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsTags','downloadsTags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsTagsDetails','downloadsTagsDetails',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsScheduleRecords','downloadsScheduleRecords',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsAutoRetries','downloadsAutoRetries',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsMiscFlags','downloadsMiscFlags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsWithMissingFilesStats','downloadsWithMissingFilesStats',0,0,57,57,1,399,0,0,7,0,1,0,0,3404,0,0,4096);
INSERT INTO space_used VALUES('downloadsPreviews','downloadsPreviews',0,0,775,773,2,6847,0,0,9,1,3,0,4068,1552,0,1,16384);
INSERT INTO space_used VALUES('moveFilesTasks','moveFilesTasks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('moveDownloadsFilesTasks','moveDownloadsFilesTasks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('soundNotifications','soundNotifications',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_soundNotifications_1','soundNotifications',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('UpdatesManagers','UpdatesManagers',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_UpdatesManagers_1','UpdatesManagers',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('Updates','Updates',0,0,1,1,1,45,0,0,45,0,1,0,0,4039,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_Updates_1','Updates',1,0,1,1,1,25,0,0,25,0,1,0,0,4060,0,0,4096);
COMMIT;[/spoiler]