Posted to tcl by colin at Wed Jan 09 23:32:55 GMT 2013view raw
- /** Disk-Space Utilization Report For wikit-test.sqlite
- Page size in bytes.................... 1024
- Pages in the whole file (measured).... 387435
- Pages in the whole file (calculated).. 387435
- Pages that store data................. 387435 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...... 14
- Number of indices..................... 10
- Number of named indices............... 2
- Automatically generated indices....... 8
- Size of the file in bytes............. 396733440
- Bytes of user payload stored.......... 355205915 89.5%
- *** Page counts for all tables with their indices ********************
- DIFFS................................. 100429 25.9%
- PAGES_BINARY.......................... 80950 20.9%
- PAGES_CONTENT_FTS_CONTENT............. 63547 16.4%
- PAGES_CONTENT......................... 63286 16.3%
- PAGES_CONTENT_FTS_SEGMENTS............ 60752 15.7%
- CHANGES............................... 8918 2.3%
- REFS.................................. 4483 1.2%
- PAGES................................. 3109 0.80%
- CHANGES_BINARY........................ 1645 0.42%
- PAGES_CONTENT_FTS_DOCSIZE............. 304 0.078%
- PAGES_CONTENT_FTS_SEGDIR.............. 6 0.002%
- SQLITE_MASTER......................... 5 0.001%
- PAGES_CONTENT_FTS_STAT................ 1 0.0%
- *** All tables and indices *******************************************
- Percentage of total database.......... 100.0%
- Number of entries..................... 1769680
- Bytes of storage consumed............. 396733440
- Bytes of payload...................... 364722123 91.9%
- Average payload per entry............. 206.09
- Average unused bytes per entry........ 11.82
- Average fanout........................ 99.00
- Fragmentation......................... 14.6%
- Maximum payload per entry............. 5554783
- Entries that use overflow............. 40707 2.3%
- Index pages used...................... 1036
- Primary pages used.................... 116069
- Overflow pages used................... 270330
- Total pages used...................... 387435
- Unused bytes on index pages........... 142759 13.5%
- Unused bytes on primary pages......... 18910693 15.9%
- Unused bytes on overflow pages........ 1871402 0.68%
- Unused bytes on all pages............. 20924854 5.3%
- *** All tables *******************************************************
- Percentage of total database.......... 96.4%
- Number of entries..................... 856104
- Bytes of storage consumed............. 382562304
- Bytes of payload...................... 355209044 92.8%
- Average payload per entry............. 414.91
- Average unused bytes per entry........ 22.40
- Average fanout........................ 99.00
- Fragmentation......................... 14.9%
- Maximum payload per entry............. 5554783
- Entries that use overflow............. 40707 4.8%
- Index pages used...................... 1036
- Primary pages used.................... 102230
- Overflow pages used................... 270330
- Total pages used...................... 373596
- Unused bytes on index pages........... 142759 13.5%
- Unused bytes on primary pages......... 17159392 16.4%
- Unused bytes on overflow pages........ 1871402 0.68%
- Unused bytes on all pages............. 19173553 5.0%
- *** All indices ******************************************************
- Percentage of total database.......... 3.6%
- Number of entries..................... 913576
- Bytes of storage consumed............. 14171136
- Bytes of payload...................... 9513079 67.1%
- Average payload per entry............. 10.41
- Average unused bytes per entry........ 1.92
- Fragmentation......................... 5.7%
- Maximum payload per entry............. 14
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 13839
- Overflow pages used................... 0
- Total pages used...................... 13839
- Unused bytes on primary pages......... 1751301 12.4%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 1751301 12.4%
- *** Table CHANGES and all its indices ********************************
- Percentage of total database.......... 2.3%
- Number of entries..................... 351864
- Bytes of storage consumed............. 9132032
- Bytes of payload...................... 7000995 76.7%
- Average payload per entry............. 19.90
- Average unused bytes per entry........ 1.21
- Average fanout........................ 99.00
- Fragmentation......................... 3.6%
- Maximum payload per entry............. 63
- Entries that use overflow............. 0 0.0%
- Index pages used...................... 64
- Primary pages used.................... 8854
- Overflow pages used................... 0
- Total pages used...................... 8918
- Unused bytes on index pages........... 8463 12.9%
- Unused bytes on primary pages......... 417651 4.6%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 426114 4.7%
- *** Table CHANGES w/o any indices ************************************
- Percentage of total database.......... 1.6%
- Number of entries..................... 175932
- Bytes of storage consumed............. 6535168
- Bytes of payload...................... 5267191 80.6%
- Average payload per entry............. 29.94
- Average unused bytes per entry........ 0.69
- Average fanout........................ 99.00
- Fragmentation......................... 2.9%
- Maximum payload per entry............. 63
- Entries that use overflow............. 0 0.0%
- Index pages used...................... 64
- Primary pages used.................... 6318
- Overflow pages used................... 0
- Total pages used...................... 6382
- Unused bytes on index pages........... 8463 12.9%
- Unused bytes on primary pages......... 112815 1.7%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 121278 1.9%
- *** Indices of table CHANGES *****************************************
- Percentage of total database.......... 0.65%
- Number of entries..................... 175932
- Bytes of storage consumed............. 2596864
- Bytes of payload...................... 1733804 66.8%
- Average payload per entry............. 9.85
- Average unused bytes per entry........ 1.73
- Fragmentation......................... 5.4%
- Maximum payload per entry............. 11
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 2536
- Overflow pages used................... 0
- Total pages used...................... 2536
- Unused bytes on primary pages......... 304836 11.7%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 304836 11.7%
- *** Table CHANGES_BINARY and all its indices *************************
- Percentage of total database.......... 0.42%
- Number of entries..................... 48
- Bytes of storage consumed............. 1684480
- Bytes of payload...................... 1672633 99.30%
- Average payload per entry............. 34846.52
- Average unused bytes per entry........ 100.06
- Average fanout........................ 14.00
- Fragmentation......................... 2.1%
- Maximum payload per entry............. 241393
- Entries that use overflow............. 24 50.0%
- Index pages used...................... 1
- Primary pages used.................... 15
- Overflow pages used................... 1629
- Total pages used...................... 1645
- Unused bytes on index pages........... 921 89.9%
- Unused bytes on primary pages......... 3434 22.4%
- Unused bytes on overflow pages........ 448 0.027%
- Unused bytes on all pages............. 4803 0.29%
- *** Table CHANGES_BINARY w/o any indices *****************************
- Percentage of total database.......... 0.42%
- Number of entries..................... 24
- Bytes of storage consumed............. 1683456
- Bytes of payload...................... 1672441 99.35%
- Average payload per entry............. 69685.04
- Average unused bytes per entry........ 168.79
- Average fanout........................ 14.00
- Fragmentation......................... 2.1%
- Maximum payload per entry............. 241393
- Entries that use overflow............. 24 100.0%
- Index pages used...................... 1
- Primary pages used.................... 14
- Overflow pages used................... 1629
- Total pages used...................... 1644
- Unused bytes on index pages........... 921 89.9%
- Unused bytes on primary pages......... 2682 18.7%
- Unused bytes on overflow pages........ 448 0.027%
- Unused bytes on all pages............. 4051 0.24%
- *** Indices of table CHANGES_BINARY **********************************
- Percentage of total database.......... 0.0%
- Number of entries..................... 24
- Bytes of storage consumed............. 1024
- Bytes of payload...................... 192 18.8%
- Average payload per entry............. 8.00
- Average unused bytes per entry........ 31.33
- Maximum payload per entry............. 8
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 1
- Overflow pages used................... 0
- Total pages used...................... 1
- Unused bytes on primary pages......... 752 73.4%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 752 73.4%
- *** Table DIFFS and all its indices **********************************
- Percentage of total database.......... 25.9%
- Number of entries..................... 832484
- Bytes of storage consumed............. 102839296
- Bytes of payload...................... 88916218 86.5%
- Average payload per entry............. 106.81
- Average unused bytes per entry........ 10.71
- Average fanout........................ 99.00
- Fragmentation......................... 10.1%
- Maximum payload per entry............. 5554783
- Entries that use overflow............. 6332 0.76%
- Index pages used...................... 539
- Primary pages used.................... 60029
- Overflow pages used................... 39861
- Total pages used...................... 100429
- Unused bytes on index pages........... 70562 12.8%
- Unused bytes on primary pages......... 8744582 14.2%
- Unused bytes on overflow pages........ 101241 0.25%
- Unused bytes on all pages............. 8916385 8.7%
- *** Table DIFFS w/o any indices **************************************
- Percentage of total database.......... 24.1%
- Number of entries..................... 416242
- Bytes of storage consumed............. 95608832
- Bytes of payload...................... 83931135 87.8%
- Average payload per entry............. 201.64
- Average unused bytes per entry........ 19.23
- Average fanout........................ 99.00
- Fragmentation......................... 10.4%
- Maximum payload per entry............. 5554783
- Entries that use overflow............. 6332 1.5%
- Index pages used...................... 539
- Primary pages used.................... 52968
- Overflow pages used................... 39861
- Total pages used...................... 93368
- Unused bytes on index pages........... 70562 12.8%
- Unused bytes on primary pages......... 7832655 14.4%
- Unused bytes on overflow pages........ 101241 0.25%
- Unused bytes on all pages............. 8004458 8.4%
- *** Indices of table DIFFS *******************************************
- Percentage of total database.......... 1.8%
- Number of entries..................... 416242
- Bytes of storage consumed............. 7230464
- Bytes of payload...................... 4985083 68.9%
- Average payload per entry............. 11.98
- Average unused bytes per entry........ 2.19
- Fragmentation......................... 6.1%
- Maximum payload per entry............. 14
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 7061
- Overflow pages used................... 0
- Total pages used...................... 7061
- Unused bytes on primary pages......... 911927 12.6%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 911927 12.6%
- *** Table PAGES and all its indices **********************************
- Percentage of total database.......... 0.80%
- Number of entries..................... 112593
- Bytes of storage consumed............. 3183616
- Bytes of payload...................... 2481743 78.0%
- Average payload per entry............. 22.04
- Average unused bytes per entry........ 1.94
- Average fanout........................ 100.00
- Fragmentation......................... 3.6%
- Maximum payload per entry............. 13891
- Entries that use overflow............. 9 0.008%
- Index pages used...................... 22
- Primary pages used.................... 3051
- Overflow pages used................... 36
- Total pages used...................... 3109
- Unused bytes on index pages........... 3423 15.2%
- Unused bytes on primary pages......... 215357 6.9%
- Unused bytes on overflow pages........ 175 0.47%
- Unused bytes on all pages............. 218955 6.9%
- *** Table PAGES w/o any indices **************************************
- Percentage of total database.......... 0.58%
- Number of entries..................... 37531
- Bytes of storage consumed............. 2291712
- Bytes of payload...................... 1939044 84.6%
- Average payload per entry............. 51.67
- Average unused bytes per entry........ 2.81
- Average fanout........................ 100.00
- Fragmentation......................... 3.3%
- Maximum payload per entry............. 13891
- Entries that use overflow............. 9 0.024%
- Index pages used...................... 22
- Primary pages used.................... 2180
- Overflow pages used................... 36
- Total pages used...................... 2238
- Unused bytes on index pages........... 3423 15.2%
- Unused bytes on primary pages......... 101782 4.6%
- Unused bytes on overflow pages........ 175 0.47%
- Unused bytes on all pages............. 105380 4.6%
- *** Indices of table PAGES *******************************************
- Percentage of total database.......... 0.22%
- Number of entries..................... 75062
- Bytes of storage consumed............. 891904
- Bytes of payload...................... 542699 60.8%
- Average payload per entry............. 7.23
- Average unused bytes per entry........ 1.51
- Fragmentation......................... 4.6%
- Maximum payload per entry............. 10
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 871
- Overflow pages used................... 0
- Total pages used...................... 871
- Unused bytes on primary pages......... 113575 12.7%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 113575 12.7%
- *** Table PAGES_BINARY and all its indices ***************************
- Percentage of total database.......... 20.9%
- Number of entries..................... 1686
- Bytes of storage consumed............. 82892800
- Bytes of payload...................... 82386192 99.39%
- Average payload per entry............. 48864.88
- Average unused bytes per entry........ 97.58
- Average fanout........................ 95.00
- Fragmentation......................... 1.7%
- Maximum payload per entry............. 2488156
- Entries that use overflow............. 838 49.7%
- Index pages used...................... 6
- Primary pages used.................... 580
- Overflow pages used................... 80364
- Total pages used...................... 80950
- Unused bytes on index pages........... 1611 26.2%
- Unused bytes on primary pages......... 155380 26.2%
- Unused bytes on overflow pages........ 7535 0.009%
- Unused bytes on all pages............. 164526 0.20%
- *** Table PAGES_BINARY w/o any indices *******************************
- Percentage of total database.......... 20.9%
- Number of entries..................... 843
- Bytes of storage consumed............. 82882560
- Bytes of payload...................... 82380268 99.39%
- Average payload per entry............. 97722.74
- Average unused bytes per entry........ 193.19
- Average fanout........................ 95.00
- Fragmentation......................... 1.7%
- Maximum payload per entry............. 2488156
- Entries that use overflow............. 838 99.41%
- Index pages used...................... 6
- Primary pages used.................... 570
- Overflow pages used................... 80364
- Total pages used...................... 80940
- Unused bytes on index pages........... 1611 26.2%
- Unused bytes on primary pages......... 153709 26.3%
- Unused bytes on overflow pages........ 7535 0.009%
- Unused bytes on all pages............. 162855 0.20%
- *** Indices of table PAGES_BINARY ************************************
- Percentage of total database.......... 0.003%
- Number of entries..................... 843
- Bytes of storage consumed............. 10240
- Bytes of payload...................... 5924 57.9%
- Average payload per entry............. 7.03
- Average unused bytes per entry........ 1.98
- Fragmentation......................... 11.1%
- Maximum payload per entry............. 8
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 10
- Overflow pages used................... 0
- Total pages used...................... 10
- Unused bytes on primary pages......... 1671 16.3%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 1671 16.3%
- *** Table PAGES_CONTENT and all its indices **************************
- Percentage of total database.......... 16.3%
- Number of entries..................... 51934
- Bytes of storage consumed............. 64804864
- Bytes of payload...................... 62351646 96.2%
- Average payload per entry............. 1200.59
- Average unused bytes per entry........ 35.62
- Average fanout........................ 107.00
- Fragmentation......................... 18.9%
- Maximum payload per entry............. 495178
- Entries that use overflow............. 7648 14.7%
- Index pages used...................... 67
- Primary pages used.................... 7433
- Overflow pages used................... 55786
- Total pages used...................... 63286
- Unused bytes on index pages........... 8652 12.6%
- Unused bytes on primary pages......... 1763682 23.2%
- Unused bytes on overflow pages........ 77423 0.14%
- Unused bytes on all pages............. 1849757 2.9%
- *** Table PAGES_CONTENT w/o any indices ******************************
- Percentage of total database.......... 16.3%
- Number of entries..................... 25967
- Bytes of storage consumed............. 64502784
- Bytes of payload...................... 62169834 96.4%
- Average payload per entry............. 2394.19
- Average unused bytes per entry........ 69.74
- Average fanout........................ 107.00
- Fragmentation......................... 19.0%
- Maximum payload per entry............. 495178
- Entries that use overflow............. 7648 29.5%
- Index pages used...................... 67
- Primary pages used.................... 7138
- Overflow pages used................... 55786
- Total pages used...................... 62991
- Unused bytes on index pages........... 8652 12.6%
- Unused bytes on primary pages......... 1724851 23.6%
- Unused bytes on overflow pages........ 77423 0.14%
- Unused bytes on all pages............. 1810926 2.8%
- *** Indices of table PAGES_CONTENT ***********************************
- Percentage of total database.......... 0.076%
- Number of entries..................... 25967
- Bytes of storage consumed............. 302080
- Bytes of payload...................... 181812 60.2%
- Average payload per entry............. 7.00
- Average unused bytes per entry........ 1.50
- Fragmentation......................... 4.8%
- Maximum payload per entry............. 8
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 295
- Overflow pages used................... 0
- Total pages used...................... 295
- Unused bytes on primary pages......... 38831 12.9%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 38831 12.9%
- *** Table PAGES_CONTENT_FTS_CONTENT **********************************
- Percentage of total database.......... 16.4%
- Number of entries..................... 25967
- Bytes of storage consumed............. 65072128
- Bytes of payload...................... 62739497 96.4%
- Average payload per entry............. 2416.12
- Average unused bytes per entry........ 69.46
- Average fanout........................ 106.00
- Fragmentation......................... 18.6%
- Maximum payload per entry............. 495210
- Entries that use overflow............. 7691 29.6%
- Index pages used...................... 71
- Primary pages used.................... 7491
- Overflow pages used................... 55985
- Total pages used...................... 63547
- Unused bytes on index pages........... 9703 13.3%
- Unused bytes on primary pages......... 1716161 22.4%
- Unused bytes on overflow pages........ 77746 0.14%
- Unused bytes on all pages............. 1803610 2.8%
- *** Table PAGES_CONTENT_FTS_DOCSIZE **********************************
- Percentage of total database.......... 0.078%
- Number of entries..................... 25967
- Bytes of storage consumed............. 311296
- Bytes of payload...................... 163806 52.6%
- Average payload per entry............. 6.31
- Average unused bytes per entry........ 0.12
- Average fanout........................ 75.00
- Fragmentation......................... 2.6%
- Maximum payload per entry............. 8
- Entries that use overflow............. 0 0.0%
- Index pages used...................... 4
- Primary pages used.................... 300
- Overflow pages used................... 0
- Total pages used...................... 304
- Unused bytes on index pages........... 1541 37.6%
- Unused bytes on primary pages......... 1702 0.55%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 3243 1.0%
- *** Table PAGES_CONTENT_FTS_SEGDIR and all its indices ***************
- Percentage of total database.......... 0.002%
- Number of entries..................... 40
- Bytes of storage consumed............. 6144
- Bytes of payload...................... 3357 54.6%
- Average payload per entry............. 83.92
- Average unused bytes per entry........ 63.85
- Average fanout........................ 3.00
- Fragmentation......................... 60.0%
- Maximum payload per entry............. 1402
- Entries that use overflow............. 1 2.5%
- Index pages used...................... 1
- Primary pages used.................... 4
- Overflow pages used................... 1
- Total pages used...................... 6
- Unused bytes on index pages........... 996 97.3%
- Unused bytes on primary pages......... 1558 38.0%
- Unused bytes on overflow pages........ 0 0.0%
- Unused bytes on all pages............. 2554 41.6%
- *** Table PAGES_CONTENT_FTS_SEGDIR w/o any indices *******************
- Percentage of total database.......... 0.001%
- Number of entries..................... 20
- Bytes of storage consumed............. 5120
- Bytes of payload...................... 3197 62.4%
- Average payload per entry............. 159.85
- Average unused bytes per entry........ 87.90
- Average fanout........................ 3.00
- Fragmentation......................... 75.0%
- Maximum payload per entry............. 1402
- Entries that use overflow............. 1 5.0%
- Index pages used...................... 1
- Primary pages used.................... 3
- Overflow pages used................... 1
- Total pages used...................... 5
- Unused bytes on index pages........... 996 97.3%
- Unused bytes on primary pages......... 762 24.8%
- Unused bytes on overflow pages........ 0 0.0%
- Unused bytes on all pages............. 1758 34.3%
- *** Indices of table PAGES_CONTENT_FTS_SEGDIR ************************
- Percentage of total database.......... 0.0%
- Number of entries..................... 20
- Bytes of storage consumed............. 1024
- Bytes of payload...................... 160 15.6%
- Average payload per entry............. 8.00
- Average unused bytes per entry........ 39.80
- Maximum payload per entry............. 8
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 1
- Overflow pages used................... 0
- Total pages used...................... 1
- Unused bytes on primary pages......... 796 77.7%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 796 77.7%
- *** Table PAGES_CONTENT_FTS_SEGMENTS *********************************
- Percentage of total database.......... 15.7%
- Number of entries..................... 37844
- Bytes of storage consumed............. 62210048
- Bytes of payload...................... 54173970 87.1%
- Average payload per entry............. 1431.51
- Average unused bytes per entry........ 188.78
- Average fanout........................ 98.00
- Fragmentation......................... 33.8%
- Maximum payload per entry............. 314952
- Entries that use overflow............. 18164 48.0%
- Index pages used...................... 245
- Primary pages used.................... 23839
- Overflow pages used................... 36668
- Total pages used...................... 60752
- Unused bytes on index pages........... 33398 13.3%
- Unused bytes on primary pages......... 5504074 22.5%
- Unused bytes on overflow pages........ 1606834 4.3%
- Unused bytes on all pages............. 7144306 11.5%
- *** Table PAGES_CONTENT_FTS_STAT *************************************
- Percentage of total database.......... 0.0%
- Number of entries..................... 1
- Bytes of storage consumed............. 1024
- Bytes of payload...................... 20 2.0%
- Average payload per entry............. 20.00
- Average unused bytes per entry........ 992.00
- Maximum payload per entry............. 20
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 1
- Overflow pages used................... 0
- Total pages used...................... 1
- Unused bytes on primary pages......... 992 96.9%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 992 96.9%
- *** Table REFS and all its indices ***********************************
- Percentage of total database.......... 1.2%
- Number of entries..................... 329229
- Bytes of storage consumed............. 4590592
- Bytes of payload...................... 2828917 61.6%
- Average payload per entry............. 8.59
- Average unused bytes per entry........ 1.18
- Average fanout........................ 94.00
- Fragmentation......................... 4.6%
- Maximum payload per entry............. 13
- Entries that use overflow............. 0 0.0%
- Index pages used...................... 15
- Primary pages used.................... 4468
- Overflow pages used................... 0
- Total pages used...................... 4483
- Unused bytes on index pages........... 2598 16.9%
- Unused bytes on primary pages......... 385289 8.4%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 387887 8.4%
- *** Table REFS w/o any indices ***************************************
- Percentage of total database.......... 0.37%
- Number of entries..................... 109743
- Bytes of storage consumed............. 1453056
- Bytes of payload...................... 765512 52.7%
- Average payload per entry............. 6.98
- Average unused bytes per entry........ 0.08
- Average fanout........................ 94.00
- Fragmentation......................... 2.9%
- Maximum payload per entry............. 9
- Entries that use overflow............. 0 0.0%
- Index pages used...................... 15
- Primary pages used.................... 1404
- Overflow pages used................... 0
- Total pages used...................... 1419
- Unused bytes on index pages........... 2598 16.9%
- Unused bytes on primary pages......... 6376 0.44%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 8974 0.62%
- *** Indices of table REFS ********************************************
- Percentage of total database.......... 0.79%
- Number of entries..................... 219486
- Bytes of storage consumed............. 3137536
- Bytes of payload...................... 2063405 65.8%
- Average payload per entry............. 9.40
- Average unused bytes per entry........ 1.73
- Fragmentation......................... 5.3%
- Maximum payload per entry............. 13
- Entries that use overflow............. 0 0.0%
- Primary pages used.................... 3064
- Overflow pages used................... 0
- Total pages used...................... 3064
- Unused bytes on primary pages......... 378913 12.1%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 378913 12.1%
- *** Table SQLITE_MASTER **********************************************
- Percentage of total database.......... 0.001%
- Number of entries..................... 23
- Bytes of storage consumed............. 5120
- Bytes of payload...................... 3129 61.1%
- Average payload per entry............. 136.04
- Average unused bytes per entry........ 74.87
- Average fanout........................ 4.00
- Fragmentation......................... 75.0%
- Maximum payload per entry............. 311
- Entries that use overflow............. 0 0.0%
- Index pages used...................... 1
- Primary pages used.................... 4
- Overflow pages used................... 0
- Total pages used...................... 5
- Unused bytes on index pages........... 891 87.0%
- Unused bytes on primary pages......... 831 20.3%
- Unused bytes on overflow pages........ 0
- Unused bytes on all pages............. 1722 33.6%
- *** Definitions ******************************************************
- Page size in bytes
- The number of bytes in a single page of the database file.
- Usually 1024.
- Number of pages in the whole file
- The number of 1024-byte pages that go into forming the complete
- database
- Pages that store data
- The number of pages that store data, either as primary B*Tree pages or
- as overflow pages. The number at the right is the data pages divided by
- the total number of pages in the file.
- Pages on the freelist
- The number of pages that are not currently in use but are reserved for
- future use. The percentage at the right is the number of freelist pages
- divided by the total number of pages in the file.
- Pages of auto-vacuum overhead
- The number of pages that store data used by the database to facilitate
- auto-vacuum. This is zero for databases that do not support auto-vacuum.
- Number of tables in the database
- The number of tables in the database, including the SQLITE_MASTER table
- used to store schema information.
- Number of indices
- The total number of indices in the database.
- Number of named indices
- The number of indices created using an explicit CREATE INDEX statement.
- Automatically generated indices
- The number of indices used to implement PRIMARY KEY or UNIQUE constraints
- on tables.
- Size of the file in bytes
- The total amount of disk space used by the entire database files.
- Bytes of user payload stored
- The total number of bytes of user payload stored in the database. The
- schema information in the SQLITE_MASTER table is not counted when
- computing this number. The percentage at the right shows the payload
- divided by the total file size.
- Percentage of total database
- The amount of the complete database file that is devoted to storing
- information described by this category.
- Number of entries
- The total number of B-Tree key/value pairs stored under this category.
- Bytes of storage consumed
- The total amount of disk space required to store all B-Tree entries
- under this category. The is the total number of pages used times
- the pages size.
- Bytes of payload
- The amount of payload stored under this category. Payload is the data
- part of table entries and the key part of index entries. The percentage
- at the right is the bytes of payload divided by the bytes of storage
- consumed.
- Average payload per entry
- The average amount of payload on each entry. This is just the bytes of
- payload divided by the number of entries.
- Average unused bytes per entry
- The average amount of free space remaining on all pages under this
- category on a per-entry basis. This is the number of unused bytes on
- all pages divided by the number of entries.
- Fragmentation
- The percentage of pages in the table or index that are not
- consecutive in the disk file. Many filesystems are optimized
- for sequential file access so smaller fragmentation numbers
- sometimes result in faster queries, especially for larger
- database files that do not fit in the disk cache.
- Maximum payload per entry
- The largest payload size of any entry.
- Entries that use overflow
- The number of entries that user one or more overflow pages.
- Total pages used
- This is the number of pages used to hold all information in the current
- category. This is the sum of index, primary, and overflow pages.
- Index pages used
- This is the number of pages in a table B-tree that hold only key (rowid)
- information and no data.
- Primary pages used
- This is the number of B-tree pages that hold both key and data.
- Overflow pages used
- The total number of overflow pages used for this category.
- Unused bytes on index pages
- The total number of bytes of unused space on all index pages. The
- percentage at the right is the number of unused bytes divided by the
- total number of bytes on index pages.
- Unused bytes on primary pages
- The total number of bytes of unused space on all primary pages. The
- percentage at the right is the number of unused bytes divided by the
- total number of bytes on primary pages.
- Unused bytes on overflow pages
- The total number of bytes of unused space on all overflow pages. The
- percentage at the right is the number of unused bytes divided by the
- total number of bytes on overflow pages.
- Unused bytes on all pages
- The total number of bytes of unused space on all primary and overflow
- pages. The percentage at the right is the number of unused bytes
- divided by the total number of bytes.
- **********************************************************************
- The entire text of this report can be sourced into any SQL database
- engine for further analysis. All of the text above is an SQL comment.
- The data used to generate this report follows:
- */
- BEGIN;
- CREATE TABLE space_used(
- name clob, -- Name of a table or index in the database file
- tblname clob, -- Name of associated table
- is_index boolean, -- TRUE if it is an index, false for a table
- nentry int, -- Number of entries in the BTree
- leaf_entries int, -- Number of leaf entries
- payload int, -- Total amount of data stored in this table or index
- ovfl_payload int, -- Total amount of data stored on overflow pages
- ovfl_cnt int, -- Number of entries that use overflow
- mx_payload int, -- Maximum payload size
- int_pages int, -- Number of interior pages used
- leaf_pages int, -- Number of leaf pages used
- ovfl_pages int, -- Number of overflow pages used
- int_unused int, -- Number of unused bytes on interior pages
- leaf_unused int, -- Number of unused bytes on primary pages
- ovfl_unused int, -- Number of unused bytes on overflow pages
- gap_cnt int, -- Number of gaps in the page layout
- compressed_size int -- Total bytes stored on disk
- );
- INSERT INTO space_used VALUES('sqlite_master','sqlite_master',0,26,23,3129,0,0,311,1,4,0,891,831,0,3,5120);
- INSERT INTO space_used VALUES('pages','pages',0,39710,37531,1939044,36545,9,13891,22,2180,36,3423,101782,175,73,2291712);
- INSERT INTO space_used VALUES('sqlite_autoindex_pages_1','pages',1,37531,37531,271989,0,0,9,0,435,0,0,55642,0,20,445440);
- INSERT INTO space_used VALUES('pages_content','pages_content',0,33104,25967,62169834,56824297,7648,495178,67,7138,55786,8652,1724851,77423,11966,64502784);
- INSERT INTO space_used VALUES('sqlite_autoindex_pages_content_1','pages_content',1,25967,25967,181812,0,0,8,0,295,0,0,38831,0,14,302080);
- INSERT INTO space_used VALUES('changes','changes',0,182249,175932,5267191,0,0,63,64,6318,0,8463,112815,0,188,6535168);
- INSERT INTO space_used VALUES('sqlite_autoindex_changes_1','changes',1,175932,175932,1733804,0,0,11,0,2536,0,0,304836,0,137,2596864);
- INSERT INTO space_used VALUES('diffs','diffs',0,469209,416242,83931135,40556979,6332,5554783,539,52968,39861,70562,7832655,101241,9719,95608832);
- INSERT INTO space_used VALUES('sqlite_autoindex_diffs_1','diffs',1,416242,416242,4985083,0,0,14,0,7061,0,0,911927,0,434,7230464);
- INSERT INTO space_used VALUES('refs','refs',0,111146,109743,765512,0,0,9,15,1404,0,2598,6376,0,41,1453056);
- INSERT INTO space_used VALUES('sqlite_autoindex_refs_1','refs',1,109743,109743,1195724,0,0,13,0,1715,0,0,210631,0,98,1756160);
- INSERT INTO space_used VALUES('pages_binary','pages_binary',0,1412,843,82380268,81963745,838,2488156,6,570,80364,1611,153709,7535,1346,82882560);
- INSERT INTO space_used VALUES('sqlite_autoindex_pages_binary_1','pages_binary',1,843,843,5924,0,0,8,0,10,0,0,1671,0,1,10240);
- INSERT INTO space_used VALUES('changes_binary','changes_binary',0,37,24,1672441,1661132,24,241393,1,14,1629,921,2682,448,35,1683456);
- INSERT INTO space_used VALUES('sqlite_autoindex_changes_binary_1','changes_binary',1,24,24,192,0,0,8,0,1,0,0,752,0,0,1024);
- INSERT INTO space_used VALUES('pages_content_fts_content','pages_content_fts_content',0,33457,25967,62739497,57026954,7691,495210,71,7491,55985,9703,1716161,77746,11818,65072128);
- INSERT INTO space_used VALUES('pages_content_fts_segments','pages_content_fts_segments',0,61682,37844,54173970,35794526,18164,314952,245,23839,36668,33398,5504074,1606834,20558,62210048);
- INSERT INTO space_used VALUES('pages_content_fts_segdir','pages_content_fts_segdir',0,22,20,3197,1020,1,1402,1,3,1,996,762,0,3,5120);
- INSERT INTO space_used VALUES('sqlite_autoindex_pages_content_fts_segdir_1','pages_content_fts_segdir',1,20,20,160,0,0,8,0,1,0,0,796,0,0,1024);
- INSERT INTO space_used VALUES('pages_content_fts_docsize','pages_content_fts_docsize',0,26266,25967,163806,0,0,8,4,300,0,1541,1702,0,8,311296);
- INSERT INTO space_used VALUES('pages_content_fts_stat','pages_content_fts_stat',0,1,1,20,0,0,20,0,1,0,0,992,0,0,1024);
- INSERT INTO space_used VALUES('refs_toid_index','refs',1,109743,109743,867681,0,0,9,0,1349,0,0,168282,0,65,1381376);
- INSERT INTO space_used VALUES('idx_pages_date','pages',1,37531,37531,270710,0,0,10,0,436,0,0,57933,0,20,446464);
- COMMIT;