Posted to tcl by colin at Wed Jan 09 23:32:55 GMT 2013view raw

  1. /** Disk-Space Utilization Report For wikit-test.sqlite
  2.  
  3. Page size in bytes.................... 1024
  4. Pages in the whole file (measured).... 387435
  5. Pages in the whole file (calculated).. 387435
  6. Pages that store data................. 387435 100.0%
  7. Pages on the freelist (per header).... 0 0.0%
  8. Pages on the freelist (calculated).... 0 0.0%
  9. Pages of auto-vacuum overhead......... 0 0.0%
  10. Number of tables in the database...... 14
  11. Number of indices..................... 10
  12. Number of named indices............... 2
  13. Automatically generated indices....... 8
  14. Size of the file in bytes............. 396733440
  15. Bytes of user payload stored.......... 355205915 89.5%
  16.  
  17. *** Page counts for all tables with their indices ********************
  18.  
  19. DIFFS................................. 100429 25.9%
  20. PAGES_BINARY.......................... 80950 20.9%
  21. PAGES_CONTENT_FTS_CONTENT............. 63547 16.4%
  22. PAGES_CONTENT......................... 63286 16.3%
  23. PAGES_CONTENT_FTS_SEGMENTS............ 60752 15.7%
  24. CHANGES............................... 8918 2.3%
  25. REFS.................................. 4483 1.2%
  26. PAGES................................. 3109 0.80%
  27. CHANGES_BINARY........................ 1645 0.42%
  28. PAGES_CONTENT_FTS_DOCSIZE............. 304 0.078%
  29. PAGES_CONTENT_FTS_SEGDIR.............. 6 0.002%
  30. SQLITE_MASTER......................... 5 0.001%
  31. PAGES_CONTENT_FTS_STAT................ 1 0.0%
  32.  
  33. *** All tables and indices *******************************************
  34.  
  35. Percentage of total database.......... 100.0%
  36. Number of entries..................... 1769680
  37. Bytes of storage consumed............. 396733440
  38. Bytes of payload...................... 364722123 91.9%
  39. Average payload per entry............. 206.09
  40. Average unused bytes per entry........ 11.82
  41. Average fanout........................ 99.00
  42. Fragmentation......................... 14.6%
  43. Maximum payload per entry............. 5554783
  44. Entries that use overflow............. 40707 2.3%
  45. Index pages used...................... 1036
  46. Primary pages used.................... 116069
  47. Overflow pages used................... 270330
  48. Total pages used...................... 387435
  49. Unused bytes on index pages........... 142759 13.5%
  50. Unused bytes on primary pages......... 18910693 15.9%
  51. Unused bytes on overflow pages........ 1871402 0.68%
  52. Unused bytes on all pages............. 20924854 5.3%
  53.  
  54. *** All tables *******************************************************
  55.  
  56. Percentage of total database.......... 96.4%
  57. Number of entries..................... 856104
  58. Bytes of storage consumed............. 382562304
  59. Bytes of payload...................... 355209044 92.8%
  60. Average payload per entry............. 414.91
  61. Average unused bytes per entry........ 22.40
  62. Average fanout........................ 99.00
  63. Fragmentation......................... 14.9%
  64. Maximum payload per entry............. 5554783
  65. Entries that use overflow............. 40707 4.8%
  66. Index pages used...................... 1036
  67. Primary pages used.................... 102230
  68. Overflow pages used................... 270330
  69. Total pages used...................... 373596
  70. Unused bytes on index pages........... 142759 13.5%
  71. Unused bytes on primary pages......... 17159392 16.4%
  72. Unused bytes on overflow pages........ 1871402 0.68%
  73. Unused bytes on all pages............. 19173553 5.0%
  74.  
  75. *** All indices ******************************************************
  76.  
  77. Percentage of total database.......... 3.6%
  78. Number of entries..................... 913576
  79. Bytes of storage consumed............. 14171136
  80. Bytes of payload...................... 9513079 67.1%
  81. Average payload per entry............. 10.41
  82. Average unused bytes per entry........ 1.92
  83. Fragmentation......................... 5.7%
  84. Maximum payload per entry............. 14
  85. Entries that use overflow............. 0 0.0%
  86. Primary pages used.................... 13839
  87. Overflow pages used................... 0
  88. Total pages used...................... 13839
  89. Unused bytes on primary pages......... 1751301 12.4%
  90. Unused bytes on overflow pages........ 0
  91. Unused bytes on all pages............. 1751301 12.4%
  92.  
  93. *** Table CHANGES and all its indices ********************************
  94.  
  95. Percentage of total database.......... 2.3%
  96. Number of entries..................... 351864
  97. Bytes of storage consumed............. 9132032
  98. Bytes of payload...................... 7000995 76.7%
  99. Average payload per entry............. 19.90
  100. Average unused bytes per entry........ 1.21
  101. Average fanout........................ 99.00
  102. Fragmentation......................... 3.6%
  103. Maximum payload per entry............. 63
  104. Entries that use overflow............. 0 0.0%
  105. Index pages used...................... 64
  106. Primary pages used.................... 8854
  107. Overflow pages used................... 0
  108. Total pages used...................... 8918
  109. Unused bytes on index pages........... 8463 12.9%
  110. Unused bytes on primary pages......... 417651 4.6%
  111. Unused bytes on overflow pages........ 0
  112. Unused bytes on all pages............. 426114 4.7%
  113.  
  114. *** Table CHANGES w/o any indices ************************************
  115.  
  116. Percentage of total database.......... 1.6%
  117. Number of entries..................... 175932
  118. Bytes of storage consumed............. 6535168
  119. Bytes of payload...................... 5267191 80.6%
  120. Average payload per entry............. 29.94
  121. Average unused bytes per entry........ 0.69
  122. Average fanout........................ 99.00
  123. Fragmentation......................... 2.9%
  124. Maximum payload per entry............. 63
  125. Entries that use overflow............. 0 0.0%
  126. Index pages used...................... 64
  127. Primary pages used.................... 6318
  128. Overflow pages used................... 0
  129. Total pages used...................... 6382
  130. Unused bytes on index pages........... 8463 12.9%
  131. Unused bytes on primary pages......... 112815 1.7%
  132. Unused bytes on overflow pages........ 0
  133. Unused bytes on all pages............. 121278 1.9%
  134.  
  135. *** Indices of table CHANGES *****************************************
  136.  
  137. Percentage of total database.......... 0.65%
  138. Number of entries..................... 175932
  139. Bytes of storage consumed............. 2596864
  140. Bytes of payload...................... 1733804 66.8%
  141. Average payload per entry............. 9.85
  142. Average unused bytes per entry........ 1.73
  143. Fragmentation......................... 5.4%
  144. Maximum payload per entry............. 11
  145. Entries that use overflow............. 0 0.0%
  146. Primary pages used.................... 2536
  147. Overflow pages used................... 0
  148. Total pages used...................... 2536
  149. Unused bytes on primary pages......... 304836 11.7%
  150. Unused bytes on overflow pages........ 0
  151. Unused bytes on all pages............. 304836 11.7%
  152.  
  153. *** Table CHANGES_BINARY and all its indices *************************
  154.  
  155. Percentage of total database.......... 0.42%
  156. Number of entries..................... 48
  157. Bytes of storage consumed............. 1684480
  158. Bytes of payload...................... 1672633 99.30%
  159. Average payload per entry............. 34846.52
  160. Average unused bytes per entry........ 100.06
  161. Average fanout........................ 14.00
  162. Fragmentation......................... 2.1%
  163. Maximum payload per entry............. 241393
  164. Entries that use overflow............. 24 50.0%
  165. Index pages used...................... 1
  166. Primary pages used.................... 15
  167. Overflow pages used................... 1629
  168. Total pages used...................... 1645
  169. Unused bytes on index pages........... 921 89.9%
  170. Unused bytes on primary pages......... 3434 22.4%
  171. Unused bytes on overflow pages........ 448 0.027%
  172. Unused bytes on all pages............. 4803 0.29%
  173.  
  174. *** Table CHANGES_BINARY w/o any indices *****************************
  175.  
  176. Percentage of total database.......... 0.42%
  177. Number of entries..................... 24
  178. Bytes of storage consumed............. 1683456
  179. Bytes of payload...................... 1672441 99.35%
  180. Average payload per entry............. 69685.04
  181. Average unused bytes per entry........ 168.79
  182. Average fanout........................ 14.00
  183. Fragmentation......................... 2.1%
  184. Maximum payload per entry............. 241393
  185. Entries that use overflow............. 24 100.0%
  186. Index pages used...................... 1
  187. Primary pages used.................... 14
  188. Overflow pages used................... 1629
  189. Total pages used...................... 1644
  190. Unused bytes on index pages........... 921 89.9%
  191. Unused bytes on primary pages......... 2682 18.7%
  192. Unused bytes on overflow pages........ 448 0.027%
  193. Unused bytes on all pages............. 4051 0.24%
  194.  
  195. *** Indices of table CHANGES_BINARY **********************************
  196.  
  197. Percentage of total database.......... 0.0%
  198. Number of entries..................... 24
  199. Bytes of storage consumed............. 1024
  200. Bytes of payload...................... 192 18.8%
  201. Average payload per entry............. 8.00
  202. Average unused bytes per entry........ 31.33
  203. Maximum payload per entry............. 8
  204. Entries that use overflow............. 0 0.0%
  205. Primary pages used.................... 1
  206. Overflow pages used................... 0
  207. Total pages used...................... 1
  208. Unused bytes on primary pages......... 752 73.4%
  209. Unused bytes on overflow pages........ 0
  210. Unused bytes on all pages............. 752 73.4%
  211.  
  212. *** Table DIFFS and all its indices **********************************
  213.  
  214. Percentage of total database.......... 25.9%
  215. Number of entries..................... 832484
  216. Bytes of storage consumed............. 102839296
  217. Bytes of payload...................... 88916218 86.5%
  218. Average payload per entry............. 106.81
  219. Average unused bytes per entry........ 10.71
  220. Average fanout........................ 99.00
  221. Fragmentation......................... 10.1%
  222. Maximum payload per entry............. 5554783
  223. Entries that use overflow............. 6332 0.76%
  224. Index pages used...................... 539
  225. Primary pages used.................... 60029
  226. Overflow pages used................... 39861
  227. Total pages used...................... 100429
  228. Unused bytes on index pages........... 70562 12.8%
  229. Unused bytes on primary pages......... 8744582 14.2%
  230. Unused bytes on overflow pages........ 101241 0.25%
  231. Unused bytes on all pages............. 8916385 8.7%
  232.  
  233. *** Table DIFFS w/o any indices **************************************
  234.  
  235. Percentage of total database.......... 24.1%
  236. Number of entries..................... 416242
  237. Bytes of storage consumed............. 95608832
  238. Bytes of payload...................... 83931135 87.8%
  239. Average payload per entry............. 201.64
  240. Average unused bytes per entry........ 19.23
  241. Average fanout........................ 99.00
  242. Fragmentation......................... 10.4%
  243. Maximum payload per entry............. 5554783
  244. Entries that use overflow............. 6332 1.5%
  245. Index pages used...................... 539
  246. Primary pages used.................... 52968
  247. Overflow pages used................... 39861
  248. Total pages used...................... 93368
  249. Unused bytes on index pages........... 70562 12.8%
  250. Unused bytes on primary pages......... 7832655 14.4%
  251. Unused bytes on overflow pages........ 101241 0.25%
  252. Unused bytes on all pages............. 8004458 8.4%
  253.  
  254. *** Indices of table DIFFS *******************************************
  255.  
  256. Percentage of total database.......... 1.8%
  257. Number of entries..................... 416242
  258. Bytes of storage consumed............. 7230464
  259. Bytes of payload...................... 4985083 68.9%
  260. Average payload per entry............. 11.98
  261. Average unused bytes per entry........ 2.19
  262. Fragmentation......................... 6.1%
  263. Maximum payload per entry............. 14
  264. Entries that use overflow............. 0 0.0%
  265. Primary pages used.................... 7061
  266. Overflow pages used................... 0
  267. Total pages used...................... 7061
  268. Unused bytes on primary pages......... 911927 12.6%
  269. Unused bytes on overflow pages........ 0
  270. Unused bytes on all pages............. 911927 12.6%
  271.  
  272. *** Table PAGES and all its indices **********************************
  273.  
  274. Percentage of total database.......... 0.80%
  275. Number of entries..................... 112593
  276. Bytes of storage consumed............. 3183616
  277. Bytes of payload...................... 2481743 78.0%
  278. Average payload per entry............. 22.04
  279. Average unused bytes per entry........ 1.94
  280. Average fanout........................ 100.00
  281. Fragmentation......................... 3.6%
  282. Maximum payload per entry............. 13891
  283. Entries that use overflow............. 9 0.008%
  284. Index pages used...................... 22
  285. Primary pages used.................... 3051
  286. Overflow pages used................... 36
  287. Total pages used...................... 3109
  288. Unused bytes on index pages........... 3423 15.2%
  289. Unused bytes on primary pages......... 215357 6.9%
  290. Unused bytes on overflow pages........ 175 0.47%
  291. Unused bytes on all pages............. 218955 6.9%
  292.  
  293. *** Table PAGES w/o any indices **************************************
  294.  
  295. Percentage of total database.......... 0.58%
  296. Number of entries..................... 37531
  297. Bytes of storage consumed............. 2291712
  298. Bytes of payload...................... 1939044 84.6%
  299. Average payload per entry............. 51.67
  300. Average unused bytes per entry........ 2.81
  301. Average fanout........................ 100.00
  302. Fragmentation......................... 3.3%
  303. Maximum payload per entry............. 13891
  304. Entries that use overflow............. 9 0.024%
  305. Index pages used...................... 22
  306. Primary pages used.................... 2180
  307. Overflow pages used................... 36
  308. Total pages used...................... 2238
  309. Unused bytes on index pages........... 3423 15.2%
  310. Unused bytes on primary pages......... 101782 4.6%
  311. Unused bytes on overflow pages........ 175 0.47%
  312. Unused bytes on all pages............. 105380 4.6%
  313.  
  314. *** Indices of table PAGES *******************************************
  315.  
  316. Percentage of total database.......... 0.22%
  317. Number of entries..................... 75062
  318. Bytes of storage consumed............. 891904
  319. Bytes of payload...................... 542699 60.8%
  320. Average payload per entry............. 7.23
  321. Average unused bytes per entry........ 1.51
  322. Fragmentation......................... 4.6%
  323. Maximum payload per entry............. 10
  324. Entries that use overflow............. 0 0.0%
  325. Primary pages used.................... 871
  326. Overflow pages used................... 0
  327. Total pages used...................... 871
  328. Unused bytes on primary pages......... 113575 12.7%
  329. Unused bytes on overflow pages........ 0
  330. Unused bytes on all pages............. 113575 12.7%
  331.  
  332. *** Table PAGES_BINARY and all its indices ***************************
  333.  
  334. Percentage of total database.......... 20.9%
  335. Number of entries..................... 1686
  336. Bytes of storage consumed............. 82892800
  337. Bytes of payload...................... 82386192 99.39%
  338. Average payload per entry............. 48864.88
  339. Average unused bytes per entry........ 97.58
  340. Average fanout........................ 95.00
  341. Fragmentation......................... 1.7%
  342. Maximum payload per entry............. 2488156
  343. Entries that use overflow............. 838 49.7%
  344. Index pages used...................... 6
  345. Primary pages used.................... 580
  346. Overflow pages used................... 80364
  347. Total pages used...................... 80950
  348. Unused bytes on index pages........... 1611 26.2%
  349. Unused bytes on primary pages......... 155380 26.2%
  350. Unused bytes on overflow pages........ 7535 0.009%
  351. Unused bytes on all pages............. 164526 0.20%
  352.  
  353. *** Table PAGES_BINARY w/o any indices *******************************
  354.  
  355. Percentage of total database.......... 20.9%
  356. Number of entries..................... 843
  357. Bytes of storage consumed............. 82882560
  358. Bytes of payload...................... 82380268 99.39%
  359. Average payload per entry............. 97722.74
  360. Average unused bytes per entry........ 193.19
  361. Average fanout........................ 95.00
  362. Fragmentation......................... 1.7%
  363. Maximum payload per entry............. 2488156
  364. Entries that use overflow............. 838 99.41%
  365. Index pages used...................... 6
  366. Primary pages used.................... 570
  367. Overflow pages used................... 80364
  368. Total pages used...................... 80940
  369. Unused bytes on index pages........... 1611 26.2%
  370. Unused bytes on primary pages......... 153709 26.3%
  371. Unused bytes on overflow pages........ 7535 0.009%
  372. Unused bytes on all pages............. 162855 0.20%
  373.  
  374. *** Indices of table PAGES_BINARY ************************************
  375.  
  376. Percentage of total database.......... 0.003%
  377. Number of entries..................... 843
  378. Bytes of storage consumed............. 10240
  379. Bytes of payload...................... 5924 57.9%
  380. Average payload per entry............. 7.03
  381. Average unused bytes per entry........ 1.98
  382. Fragmentation......................... 11.1%
  383. Maximum payload per entry............. 8
  384. Entries that use overflow............. 0 0.0%
  385. Primary pages used.................... 10
  386. Overflow pages used................... 0
  387. Total pages used...................... 10
  388. Unused bytes on primary pages......... 1671 16.3%
  389. Unused bytes on overflow pages........ 0
  390. Unused bytes on all pages............. 1671 16.3%
  391.  
  392. *** Table PAGES_CONTENT and all its indices **************************
  393.  
  394. Percentage of total database.......... 16.3%
  395. Number of entries..................... 51934
  396. Bytes of storage consumed............. 64804864
  397. Bytes of payload...................... 62351646 96.2%
  398. Average payload per entry............. 1200.59
  399. Average unused bytes per entry........ 35.62
  400. Average fanout........................ 107.00
  401. Fragmentation......................... 18.9%
  402. Maximum payload per entry............. 495178
  403. Entries that use overflow............. 7648 14.7%
  404. Index pages used...................... 67
  405. Primary pages used.................... 7433
  406. Overflow pages used................... 55786
  407. Total pages used...................... 63286
  408. Unused bytes on index pages........... 8652 12.6%
  409. Unused bytes on primary pages......... 1763682 23.2%
  410. Unused bytes on overflow pages........ 77423 0.14%
  411. Unused bytes on all pages............. 1849757 2.9%
  412.  
  413. *** Table PAGES_CONTENT w/o any indices ******************************
  414.  
  415. Percentage of total database.......... 16.3%
  416. Number of entries..................... 25967
  417. Bytes of storage consumed............. 64502784
  418. Bytes of payload...................... 62169834 96.4%
  419. Average payload per entry............. 2394.19
  420. Average unused bytes per entry........ 69.74
  421. Average fanout........................ 107.00
  422. Fragmentation......................... 19.0%
  423. Maximum payload per entry............. 495178
  424. Entries that use overflow............. 7648 29.5%
  425. Index pages used...................... 67
  426. Primary pages used.................... 7138
  427. Overflow pages used................... 55786
  428. Total pages used...................... 62991
  429. Unused bytes on index pages........... 8652 12.6%
  430. Unused bytes on primary pages......... 1724851 23.6%
  431. Unused bytes on overflow pages........ 77423 0.14%
  432. Unused bytes on all pages............. 1810926 2.8%
  433.  
  434. *** Indices of table PAGES_CONTENT ***********************************
  435.  
  436. Percentage of total database.......... 0.076%
  437. Number of entries..................... 25967
  438. Bytes of storage consumed............. 302080
  439. Bytes of payload...................... 181812 60.2%
  440. Average payload per entry............. 7.00
  441. Average unused bytes per entry........ 1.50
  442. Fragmentation......................... 4.8%
  443. Maximum payload per entry............. 8
  444. Entries that use overflow............. 0 0.0%
  445. Primary pages used.................... 295
  446. Overflow pages used................... 0
  447. Total pages used...................... 295
  448. Unused bytes on primary pages......... 38831 12.9%
  449. Unused bytes on overflow pages........ 0
  450. Unused bytes on all pages............. 38831 12.9%
  451.  
  452. *** Table PAGES_CONTENT_FTS_CONTENT **********************************
  453.  
  454. Percentage of total database.......... 16.4%
  455. Number of entries..................... 25967
  456. Bytes of storage consumed............. 65072128
  457. Bytes of payload...................... 62739497 96.4%
  458. Average payload per entry............. 2416.12
  459. Average unused bytes per entry........ 69.46
  460. Average fanout........................ 106.00
  461. Fragmentation......................... 18.6%
  462. Maximum payload per entry............. 495210
  463. Entries that use overflow............. 7691 29.6%
  464. Index pages used...................... 71
  465. Primary pages used.................... 7491
  466. Overflow pages used................... 55985
  467. Total pages used...................... 63547
  468. Unused bytes on index pages........... 9703 13.3%
  469. Unused bytes on primary pages......... 1716161 22.4%
  470. Unused bytes on overflow pages........ 77746 0.14%
  471. Unused bytes on all pages............. 1803610 2.8%
  472.  
  473. *** Table PAGES_CONTENT_FTS_DOCSIZE **********************************
  474.  
  475. Percentage of total database.......... 0.078%
  476. Number of entries..................... 25967
  477. Bytes of storage consumed............. 311296
  478. Bytes of payload...................... 163806 52.6%
  479. Average payload per entry............. 6.31
  480. Average unused bytes per entry........ 0.12
  481. Average fanout........................ 75.00
  482. Fragmentation......................... 2.6%
  483. Maximum payload per entry............. 8
  484. Entries that use overflow............. 0 0.0%
  485. Index pages used...................... 4
  486. Primary pages used.................... 300
  487. Overflow pages used................... 0
  488. Total pages used...................... 304
  489. Unused bytes on index pages........... 1541 37.6%
  490. Unused bytes on primary pages......... 1702 0.55%
  491. Unused bytes on overflow pages........ 0
  492. Unused bytes on all pages............. 3243 1.0%
  493.  
  494. *** Table PAGES_CONTENT_FTS_SEGDIR and all its indices ***************
  495.  
  496. Percentage of total database.......... 0.002%
  497. Number of entries..................... 40
  498. Bytes of storage consumed............. 6144
  499. Bytes of payload...................... 3357 54.6%
  500. Average payload per entry............. 83.92
  501. Average unused bytes per entry........ 63.85
  502. Average fanout........................ 3.00
  503. Fragmentation......................... 60.0%
  504. Maximum payload per entry............. 1402
  505. Entries that use overflow............. 1 2.5%
  506. Index pages used...................... 1
  507. Primary pages used.................... 4
  508. Overflow pages used................... 1
  509. Total pages used...................... 6
  510. Unused bytes on index pages........... 996 97.3%
  511. Unused bytes on primary pages......... 1558 38.0%
  512. Unused bytes on overflow pages........ 0 0.0%
  513. Unused bytes on all pages............. 2554 41.6%
  514.  
  515. *** Table PAGES_CONTENT_FTS_SEGDIR w/o any indices *******************
  516.  
  517. Percentage of total database.......... 0.001%
  518. Number of entries..................... 20
  519. Bytes of storage consumed............. 5120
  520. Bytes of payload...................... 3197 62.4%
  521. Average payload per entry............. 159.85
  522. Average unused bytes per entry........ 87.90
  523. Average fanout........................ 3.00
  524. Fragmentation......................... 75.0%
  525. Maximum payload per entry............. 1402
  526. Entries that use overflow............. 1 5.0%
  527. Index pages used...................... 1
  528. Primary pages used.................... 3
  529. Overflow pages used................... 1
  530. Total pages used...................... 5
  531. Unused bytes on index pages........... 996 97.3%
  532. Unused bytes on primary pages......... 762 24.8%
  533. Unused bytes on overflow pages........ 0 0.0%
  534. Unused bytes on all pages............. 1758 34.3%
  535.  
  536. *** Indices of table PAGES_CONTENT_FTS_SEGDIR ************************
  537.  
  538. Percentage of total database.......... 0.0%
  539. Number of entries..................... 20
  540. Bytes of storage consumed............. 1024
  541. Bytes of payload...................... 160 15.6%
  542. Average payload per entry............. 8.00
  543. Average unused bytes per entry........ 39.80
  544. Maximum payload per entry............. 8
  545. Entries that use overflow............. 0 0.0%
  546. Primary pages used.................... 1
  547. Overflow pages used................... 0
  548. Total pages used...................... 1
  549. Unused bytes on primary pages......... 796 77.7%
  550. Unused bytes on overflow pages........ 0
  551. Unused bytes on all pages............. 796 77.7%
  552.  
  553. *** Table PAGES_CONTENT_FTS_SEGMENTS *********************************
  554.  
  555. Percentage of total database.......... 15.7%
  556. Number of entries..................... 37844
  557. Bytes of storage consumed............. 62210048
  558. Bytes of payload...................... 54173970 87.1%
  559. Average payload per entry............. 1431.51
  560. Average unused bytes per entry........ 188.78
  561. Average fanout........................ 98.00
  562. Fragmentation......................... 33.8%
  563. Maximum payload per entry............. 314952
  564. Entries that use overflow............. 18164 48.0%
  565. Index pages used...................... 245
  566. Primary pages used.................... 23839
  567. Overflow pages used................... 36668
  568. Total pages used...................... 60752
  569. Unused bytes on index pages........... 33398 13.3%
  570. Unused bytes on primary pages......... 5504074 22.5%
  571. Unused bytes on overflow pages........ 1606834 4.3%
  572. Unused bytes on all pages............. 7144306 11.5%
  573.  
  574. *** Table PAGES_CONTENT_FTS_STAT *************************************
  575.  
  576. Percentage of total database.......... 0.0%
  577. Number of entries..................... 1
  578. Bytes of storage consumed............. 1024
  579. Bytes of payload...................... 20 2.0%
  580. Average payload per entry............. 20.00
  581. Average unused bytes per entry........ 992.00
  582. Maximum payload per entry............. 20
  583. Entries that use overflow............. 0 0.0%
  584. Primary pages used.................... 1
  585. Overflow pages used................... 0
  586. Total pages used...................... 1
  587. Unused bytes on primary pages......... 992 96.9%
  588. Unused bytes on overflow pages........ 0
  589. Unused bytes on all pages............. 992 96.9%
  590.  
  591. *** Table REFS and all its indices ***********************************
  592.  
  593. Percentage of total database.......... 1.2%
  594. Number of entries..................... 329229
  595. Bytes of storage consumed............. 4590592
  596. Bytes of payload...................... 2828917 61.6%
  597. Average payload per entry............. 8.59
  598. Average unused bytes per entry........ 1.18
  599. Average fanout........................ 94.00
  600. Fragmentation......................... 4.6%
  601. Maximum payload per entry............. 13
  602. Entries that use overflow............. 0 0.0%
  603. Index pages used...................... 15
  604. Primary pages used.................... 4468
  605. Overflow pages used................... 0
  606. Total pages used...................... 4483
  607. Unused bytes on index pages........... 2598 16.9%
  608. Unused bytes on primary pages......... 385289 8.4%
  609. Unused bytes on overflow pages........ 0
  610. Unused bytes on all pages............. 387887 8.4%
  611.  
  612. *** Table REFS w/o any indices ***************************************
  613.  
  614. Percentage of total database.......... 0.37%
  615. Number of entries..................... 109743
  616. Bytes of storage consumed............. 1453056
  617. Bytes of payload...................... 765512 52.7%
  618. Average payload per entry............. 6.98
  619. Average unused bytes per entry........ 0.08
  620. Average fanout........................ 94.00
  621. Fragmentation......................... 2.9%
  622. Maximum payload per entry............. 9
  623. Entries that use overflow............. 0 0.0%
  624. Index pages used...................... 15
  625. Primary pages used.................... 1404
  626. Overflow pages used................... 0
  627. Total pages used...................... 1419
  628. Unused bytes on index pages........... 2598 16.9%
  629. Unused bytes on primary pages......... 6376 0.44%
  630. Unused bytes on overflow pages........ 0
  631. Unused bytes on all pages............. 8974 0.62%
  632.  
  633. *** Indices of table REFS ********************************************
  634.  
  635. Percentage of total database.......... 0.79%
  636. Number of entries..................... 219486
  637. Bytes of storage consumed............. 3137536
  638. Bytes of payload...................... 2063405 65.8%
  639. Average payload per entry............. 9.40
  640. Average unused bytes per entry........ 1.73
  641. Fragmentation......................... 5.3%
  642. Maximum payload per entry............. 13
  643. Entries that use overflow............. 0 0.0%
  644. Primary pages used.................... 3064
  645. Overflow pages used................... 0
  646. Total pages used...................... 3064
  647. Unused bytes on primary pages......... 378913 12.1%
  648. Unused bytes on overflow pages........ 0
  649. Unused bytes on all pages............. 378913 12.1%
  650.  
  651. *** Table SQLITE_MASTER **********************************************
  652.  
  653. Percentage of total database.......... 0.001%
  654. Number of entries..................... 23
  655. Bytes of storage consumed............. 5120
  656. Bytes of payload...................... 3129 61.1%
  657. Average payload per entry............. 136.04
  658. Average unused bytes per entry........ 74.87
  659. Average fanout........................ 4.00
  660. Fragmentation......................... 75.0%
  661. Maximum payload per entry............. 311
  662. Entries that use overflow............. 0 0.0%
  663. Index pages used...................... 1
  664. Primary pages used.................... 4
  665. Overflow pages used................... 0
  666. Total pages used...................... 5
  667. Unused bytes on index pages........... 891 87.0%
  668. Unused bytes on primary pages......... 831 20.3%
  669. Unused bytes on overflow pages........ 0
  670. Unused bytes on all pages............. 1722 33.6%
  671.  
  672. *** Definitions ******************************************************
  673.  
  674. Page size in bytes
  675.  
  676. The number of bytes in a single page of the database file.
  677. Usually 1024.
  678.  
  679. Number of pages in the whole file
  680.  
  681. The number of 1024-byte pages that go into forming the complete
  682. database
  683.  
  684. Pages that store data
  685.  
  686. The number of pages that store data, either as primary B*Tree pages or
  687. as overflow pages. The number at the right is the data pages divided by
  688. the total number of pages in the file.
  689.  
  690. Pages on the freelist
  691.  
  692. The number of pages that are not currently in use but are reserved for
  693. future use. The percentage at the right is the number of freelist pages
  694. divided by the total number of pages in the file.
  695.  
  696. Pages of auto-vacuum overhead
  697.  
  698. The number of pages that store data used by the database to facilitate
  699. auto-vacuum. This is zero for databases that do not support auto-vacuum.
  700.  
  701. Number of tables in the database
  702.  
  703. The number of tables in the database, including the SQLITE_MASTER table
  704. used to store schema information.
  705.  
  706. Number of indices
  707.  
  708. The total number of indices in the database.
  709.  
  710. Number of named indices
  711.  
  712. The number of indices created using an explicit CREATE INDEX statement.
  713.  
  714. Automatically generated indices
  715.  
  716. The number of indices used to implement PRIMARY KEY or UNIQUE constraints
  717. on tables.
  718.  
  719. Size of the file in bytes
  720.  
  721. The total amount of disk space used by the entire database files.
  722.  
  723. Bytes of user payload stored
  724.  
  725. The total number of bytes of user payload stored in the database. The
  726. schema information in the SQLITE_MASTER table is not counted when
  727. computing this number. The percentage at the right shows the payload
  728. divided by the total file size.
  729.  
  730. Percentage of total database
  731.  
  732. The amount of the complete database file that is devoted to storing
  733. information described by this category.
  734.  
  735. Number of entries
  736.  
  737. The total number of B-Tree key/value pairs stored under this category.
  738.  
  739. Bytes of storage consumed
  740.  
  741. The total amount of disk space required to store all B-Tree entries
  742. under this category. The is the total number of pages used times
  743. the pages size.
  744.  
  745. Bytes of payload
  746.  
  747. The amount of payload stored under this category. Payload is the data
  748. part of table entries and the key part of index entries. The percentage
  749. at the right is the bytes of payload divided by the bytes of storage
  750. consumed.
  751.  
  752. Average payload per entry
  753.  
  754. The average amount of payload on each entry. This is just the bytes of
  755. payload divided by the number of entries.
  756.  
  757. Average unused bytes per entry
  758.  
  759. The average amount of free space remaining on all pages under this
  760. category on a per-entry basis. This is the number of unused bytes on
  761. all pages divided by the number of entries.
  762.  
  763. Fragmentation
  764.  
  765. The percentage of pages in the table or index that are not
  766. consecutive in the disk file. Many filesystems are optimized
  767. for sequential file access so smaller fragmentation numbers
  768. sometimes result in faster queries, especially for larger
  769. database files that do not fit in the disk cache.
  770.  
  771. Maximum payload per entry
  772.  
  773. The largest payload size of any entry.
  774.  
  775. Entries that use overflow
  776.  
  777. The number of entries that user one or more overflow pages.
  778.  
  779. Total pages used
  780.  
  781. This is the number of pages used to hold all information in the current
  782. category. This is the sum of index, primary, and overflow pages.
  783.  
  784. Index pages used
  785.  
  786. This is the number of pages in a table B-tree that hold only key (rowid)
  787. information and no data.
  788.  
  789. Primary pages used
  790.  
  791. This is the number of B-tree pages that hold both key and data.
  792.  
  793. Overflow pages used
  794.  
  795. The total number of overflow pages used for this category.
  796.  
  797. Unused bytes on index pages
  798.  
  799. The total number of bytes of unused space on all index pages. The
  800. percentage at the right is the number of unused bytes divided by the
  801. total number of bytes on index pages.
  802.  
  803. Unused bytes on primary pages
  804.  
  805. The total number of bytes of unused space on all primary pages. The
  806. percentage at the right is the number of unused bytes divided by the
  807. total number of bytes on primary pages.
  808.  
  809. Unused bytes on overflow pages
  810.  
  811. The total number of bytes of unused space on all overflow pages. The
  812. percentage at the right is the number of unused bytes divided by the
  813. total number of bytes on overflow pages.
  814.  
  815. Unused bytes on all pages
  816.  
  817. The total number of bytes of unused space on all primary and overflow
  818. pages. The percentage at the right is the number of unused bytes
  819. divided by the total number of bytes.
  820.  
  821. **********************************************************************
  822. The entire text of this report can be sourced into any SQL database
  823. engine for further analysis. All of the text above is an SQL comment.
  824. The data used to generate this report follows:
  825. */
  826. BEGIN;
  827. CREATE TABLE space_used(
  828. name clob, -- Name of a table or index in the database file
  829. tblname clob, -- Name of associated table
  830. is_index boolean, -- TRUE if it is an index, false for a table
  831. nentry int, -- Number of entries in the BTree
  832. leaf_entries int, -- Number of leaf entries
  833. payload int, -- Total amount of data stored in this table or index
  834. ovfl_payload int, -- Total amount of data stored on overflow pages
  835. ovfl_cnt int, -- Number of entries that use overflow
  836. mx_payload int, -- Maximum payload size
  837. int_pages int, -- Number of interior pages used
  838. leaf_pages int, -- Number of leaf pages used
  839. ovfl_pages int, -- Number of overflow pages used
  840. int_unused int, -- Number of unused bytes on interior pages
  841. leaf_unused int, -- Number of unused bytes on primary pages
  842. ovfl_unused int, -- Number of unused bytes on overflow pages
  843. gap_cnt int, -- Number of gaps in the page layout
  844. compressed_size int -- Total bytes stored on disk
  845. );
  846. INSERT INTO space_used VALUES('sqlite_master','sqlite_master',0,26,23,3129,0,0,311,1,4,0,891,831,0,3,5120);
  847. INSERT INTO space_used VALUES('pages','pages',0,39710,37531,1939044,36545,9,13891,22,2180,36,3423,101782,175,73,2291712);
  848. 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);
  849. INSERT INTO space_used VALUES('pages_content','pages_content',0,33104,25967,62169834,56824297,7648,495178,67,7138,55786,8652,1724851,77423,11966,64502784);
  850. 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);
  851. INSERT INTO space_used VALUES('changes','changes',0,182249,175932,5267191,0,0,63,64,6318,0,8463,112815,0,188,6535168);
  852. 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);
  853. INSERT INTO space_used VALUES('diffs','diffs',0,469209,416242,83931135,40556979,6332,5554783,539,52968,39861,70562,7832655,101241,9719,95608832);
  854. 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);
  855. INSERT INTO space_used VALUES('refs','refs',0,111146,109743,765512,0,0,9,15,1404,0,2598,6376,0,41,1453056);
  856. 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);
  857. INSERT INTO space_used VALUES('pages_binary','pages_binary',0,1412,843,82380268,81963745,838,2488156,6,570,80364,1611,153709,7535,1346,82882560);
  858. 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);
  859. INSERT INTO space_used VALUES('changes_binary','changes_binary',0,37,24,1672441,1661132,24,241393,1,14,1629,921,2682,448,35,1683456);
  860. 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);
  861. 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);
  862. 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);
  863. 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);
  864. 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);
  865. 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);
  866. 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);
  867. INSERT INTO space_used VALUES('refs_toid_index','refs',1,109743,109743,867681,0,0,9,0,1349,0,0,168282,0,65,1381376);
  868. INSERT INTO space_used VALUES('idx_pages_date','pages',1,37531,37531,270710,0,0,10,0,436,0,0,57933,0,20,446464);
  869. COMMIT;
  870.