Skip to content

Instantly share code, notes, and snippets.

@aryairani
Created March 4, 2024 15:13
Show Gist options
  • Save aryairani/88861dce73c8fd8edad2e79d4b8de96c to your computer and use it in GitHub Desktop.
Save aryairani/88861dce73c8fd8edad2e79d4b8de96c to your computer and use it in GitHub Desktop.
database after project.create (latest is 2.17.0)
/** Disk-Space Utilization Report For base-release/.unison/v2/unison.sqlite3
Page size in bytes................................ 4096
Pages in the whole file (measured)................ 3245
Pages in the whole file (calculated).............. 3245
Pages that store data............................. 3245 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.................. 35
Number of indices................................. 34
Number of defined indices......................... 22
Number of implied indices......................... 12
Size of the file in bytes......................... 13291520
Bytes of user payload stored...................... 6924858 52.1%
*** Page counts for all tables with their indices *****************************
OBJECT............................................ 1083 33.4%
HASH.............................................. 1042 32.1%
DEPENDENTS_INDEX.................................. 633 19.5%
FIND_TYPE_MENTIONS_INDEX.......................... 186 5.7%
TEXT.............................................. 89 2.7%
FIND_TYPE_INDEX................................... 70 2.2%
HASH_OBJECT....................................... 57 1.8%
CAUSAL............................................ 20 0.62%
NAMESPACE_STATISTICS.............................. 11 0.34%
SQLITE_SCHEMA..................................... 6 0.18%
SCOPED_TERM_NAME_LOOKUP........................... 5 0.15%
SCOPED_TYPE_NAME_LOOKUP........................... 5 0.15%
TEMP_ENTITY_MISSING_DEPENDENCY.................... 4 0.12%
CAUSAL_PARENT..................................... 3 0.092%
CAUSAL_METADATA................................... 2 0.062%
NAME_LOOKUP_MOUNTS................................ 2 0.062%
OBJECT_TYPE_DESCRIPTION........................... 2 0.062%
PROJECT........................................... 2 0.062%
PROJECT_BRANCH.................................... 2 0.062%
REFLOG............................................ 2 0.062%
TEMP_ENTITY....................................... 2 0.062%
TEMP_ENTITY_TYPE_DESCRIPTION...................... 2 0.062%
WATCH............................................. 2 0.062%
WATCH_KIND_DESCRIPTION............................ 2 0.062%
MOST_RECENT_BRANCH................................ 1 0.031%
MOST_RECENT_NAMESPACE............................. 1 0.031%
NAME_LOOKUPS...................................... 1 0.031%
NAMESPACE_ROOT.................................... 1 0.031%
PROJECT_BRANCH_PARENT............................. 1 0.031%
PROJECT_BRANCH_REMOTE_MAPPING..................... 1 0.031%
REMOTE_PROJECT.................................... 1 0.031%
REMOTE_PROJECT_BRANCH............................. 1 0.031%
SCHEMA_VERSION.................................... 1 0.031%
SQUASH_RESULTS.................................... 1 0.031%
WATCH_RESULT...................................... 1 0.031%
*** Page counts for all tables and indices separately *************************
OBJECT............................................ 1035 31.9%
HASH_BASE32....................................... 527 16.2%
HASH.............................................. 515 15.9%
DEPENDENTS_INDEX.................................. 250 7.7%
DEPENDENTS_BY_DEPENDENCY.......................... 198 6.1%
DEPENDENCIES_BY_DEPENDENT......................... 185 5.7%
FIND_TYPE_MENTIONS_INDEX.......................... 108 3.3%
FIND_TYPE_MENTIONS_INDEX_TYPE..................... 78 2.4%
SQLITE_AUTOINDEX_TEXT_1........................... 45 1.4%
TEXT.............................................. 44 1.4%
HASH_OBJECT....................................... 31 0.96%
FIND_TYPE_INDEX................................... 28 0.86%
HASH_OBJECT_OBJECT_ID............................. 26 0.80%
OBJECT_HASH_ID.................................... 26 0.80%
OBJECT_TYPE_ID.................................... 22 0.68%
FIND_TYPE_INDEX_TYPE.............................. 21 0.65%
SQLITE_AUTOINDEX_FIND_TYPE_INDEX_1................ 21 0.65%
NAMESPACE_STATISTICS.............................. 11 0.34%
CAUSAL............................................ 10 0.31%
CAUSAL_VALUE_HASH_ID.............................. 10 0.31%
SQLITE_SCHEMA..................................... 6 0.18%
CAUSAL_METADATA................................... 1 0.031%
CAUSAL_METADATA_CAUSAL_ID......................... 1 0.031%
CAUSAL_PARENT..................................... 1 0.031%
CAUSAL_PARENT_CAUSAL_ID........................... 1 0.031%
CAUSAL_PARENT_PARENT_ID........................... 1 0.031%
MOST_RECENT_BRANCH................................ 1 0.031%
MOST_RECENT_NAMESPACE............................. 1 0.031%
NAME_LOOKUP_MOUNTS................................ 1 0.031%
NAME_LOOKUPS...................................... 1 0.031%
NAMESPACE_ROOT.................................... 1 0.031%
OBJECT_TYPE_DESCRIPTION........................... 1 0.031%
PROJECT........................................... 1 0.031%
PROJECT_BRANCH.................................... 1 0.031%
PROJECT_BRANCH_PARENT............................. 1 0.031%
PROJECT_BRANCH_REMOTE_MAPPING..................... 1 0.031%
REFLOG............................................ 1 0.031%
REFLOG_TIME_DESC.................................. 1 0.031%
REMOTE_PROJECT.................................... 1 0.031%
REMOTE_PROJECT_BRANCH............................. 1 0.031%
SCHEMA_VERSION.................................... 1 0.031%
SCOPED_TERM_NAME_BY_REFERENT_LOOKUP............... 1 0.031%
SCOPED_TERM_NAME_LOOKUP........................... 1 0.031%
SCOPED_TERM_NAMES_BY_NAMESPACE.................... 1 0.031%
SCOPED_TERM_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT 1 0.031%
SCOPED_TYPE_NAME_BY_REFERENCE_LOOKUP.............. 1 0.031%
SCOPED_TYPE_NAME_LOOKUP........................... 1 0.031%
SCOPED_TYPE_NAMES_BY_NAMESPACE.................... 1 0.031%
SCOPED_TYPE_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT 1 0.031%
SQLITE_AUTOINDEX_NAME_LOOKUP_MOUNTS_1............. 1 0.031%
SQLITE_AUTOINDEX_OBJECT_TYPE_DESCRIPTION_1........ 1 0.031%
SQLITE_AUTOINDEX_PROJECT_2........................ 1 0.031%
SQLITE_AUTOINDEX_PROJECT_BRANCH_2................. 1 0.031%
SQLITE_AUTOINDEX_SCOPED_TERM_NAME_LOOKUP_1........ 1 0.031%
SQLITE_AUTOINDEX_SCOPED_TYPE_NAME_LOOKUP_1........ 1 0.031%
SQLITE_AUTOINDEX_TEMP_ENTITY_1.................... 1 0.031%
SQLITE_AUTOINDEX_TEMP_ENTITY_MISSING_DEPENDENCY_1. 1 0.031%
SQLITE_AUTOINDEX_TEMP_ENTITY_TYPE_DESCRIPTION_1... 1 0.031%
SQLITE_AUTOINDEX_WATCH_KIND_DESCRIPTION_1......... 1 0.031%
SQUASH_RESULTS.................................... 1 0.031%
TEMP_ENTITY....................................... 1 0.031%
TEMP_ENTITY_MISSING_DEPENDENCY.................... 1 0.031%
TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENCY...... 1 0.031%
TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENT....... 1 0.031%
TEMP_ENTITY_TYPE_DESCRIPTION...................... 1 0.031%
WATCH............................................. 1 0.031%
WATCH_KIND........................................ 1 0.031%
WATCH_KIND_DESCRIPTION............................ 1 0.031%
WATCH_RESULT...................................... 1 0.031%
*** All tables and indices ****************************************************
Percentage of total database...................... 100.0%
Number of entries................................. 387711
Bytes of storage consumed......................... 13291520
Bytes of payload.................................. 10832682 81.5%
Bytes of metadata................................. 1586824 11.9%
Average payload per entry......................... 27.94
Average unused bytes per entry.................... 2.25
Average metadata per entry........................ 4.09
Average fanout.................................... 73.00
Maximum payload per entry......................... 17955
Entries that use overflow......................... 80 0.021%
Index pages used.................................. 42
Primary pages used................................ 3088
Overflow pages used............................... 115
Total pages used.................................. 3245
Unused bytes on index pages....................... 86997 50.6%
Unused bytes on primary pages..................... 780336 6.2%
Unused bytes on overflow pages.................... 4821 1.0%
Unused bytes on all pages......................... 872154 6.6%
*** All tables ****************************************************************
Percentage of total database...................... 63.6%
Number of entries................................. 154462
Bytes of storage consumed......................... 8450048
Bytes of payload.................................. 6943745 82.2%
Bytes of metadata................................. 873019 10.3%
Average payload per entry......................... 44.95
Average unused bytes per entry.................... 4.10
Average metadata per entry........................ 5.65
Average fanout.................................... 136.00
Maximum payload per entry......................... 17955
Entries that use overflow......................... 80 0.052%
Index pages used.................................. 14
Primary pages used................................ 1934
Overflow pages used............................... 115
Total pages used.................................. 2063
Unused bytes on index pages....................... 41601 72.5%
Unused bytes on primary pages..................... 587002 7.4%
Unused bytes on overflow pages.................... 4821 1.0%
Unused bytes on all pages......................... 633424 7.5%
*** All indices ***************************************************************
Percentage of total database...................... 36.4%
Number of entries................................. 233249
Bytes of storage consumed......................... 4841472
Bytes of payload.................................. 3888937 80.3%
Bytes of metadata................................. 713805 14.7%
Average payload per entry......................... 16.67
Average unused bytes per entry.................... 1.02
Average metadata per entry........................ 3.06
Average fanout.................................... 42.00
Maximum payload per entry......................... 232
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 28
Primary pages used................................ 1154
Overflow pages used............................... 0
Total pages used.................................. 1182
Unused bytes on index pages....................... 45396 39.6%
Unused bytes on primary pages..................... 193334 4.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 238730 4.9%
*** Table CAUSAL and all its indices ******************************************
Percentage of total database...................... 0.62%
Number of entries................................. 6882
Bytes of storage consumed......................... 81920
Bytes of payload.................................. 41270 50.4%
Bytes of metadata................................. 28334 34.6%
Average payload per entry......................... 6.00
Average unused bytes per entry.................... 1.79
Average metadata per entry........................ 4.12
Average fanout.................................... 9.00
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 18
Overflow pages used............................... 0
Total pages used.................................. 20
Unused bytes on index pages....................... 7991 97.5%
Unused bytes on primary pages..................... 4325 5.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 12316 15.0%
*** Table CAUSAL w/o any indices **********************************************
Percentage of total database...................... 0.31%
Number of entries................................. 3441
Bytes of storage consumed......................... 40960
Bytes of payload.................................. 17197 42.0%
Bytes of metadata................................. 17895 43.7%
B-tree depth...................................... 2
Average payload per entry......................... 5.00
Average unused bytes per entry.................... 1.71
Average metadata per entry........................ 5.20
Average fanout.................................... 9.00
Non-sequential pages.............................. 1 11.1%
Maximum payload per entry......................... 5
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 9
Overflow pages used............................... 0
Total pages used.................................. 10
Unused bytes on index pages....................... 4019 98.1%
Unused bytes on primary pages..................... 1849 5.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5868 14.3%
*** Index CAUSAL_VALUE_HASH_ID of table CAUSAL ********************************
Percentage of total database...................... 0.31%
Number of entries................................. 3441
Bytes of storage consumed......................... 40960
Bytes of payload.................................. 24073 58.8%
Bytes of metadata................................. 10439 25.5%
B-tree depth...................................... 2
Average payload per entry......................... 7.00
Average unused bytes per entry.................... 1.87
Average metadata per entry........................ 3.03
Average fanout.................................... 10.00
Non-sequential pages.............................. 1 11.1%
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 9
Overflow pages used............................... 0
Total pages used.................................. 10
Unused bytes on index pages....................... 3972 97.0%
Unused bytes on primary pages..................... 2476 6.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6448 15.7%
*** Table CAUSAL_METADATA and all its indices *********************************
Percentage of total database...................... 0.062%
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 CAUSAL_METADATA w/o any indices *************************************
Percentage of total database...................... 0.031%
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 CAUSAL_METADATA_CAUSAL_ID of table CAUSAL_METADATA ******************
Percentage of total database...................... 0.031%
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 CAUSAL_PARENT and all its indices ***********************************
Percentage of total database...................... 0.092%
Number of entries................................. 0
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 24 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................................ 3
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on primary pages..................... 12264 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 12264 99.80%
*** Table CAUSAL_PARENT w/o any indices ***************************************
Percentage of total database...................... 0.031%
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%
*** Indices of table CAUSAL_PARENT ********************************************
Percentage of total database...................... 0.062%
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%
*** Index CAUSAL_PARENT_CAUSAL_ID of table CAUSAL_PARENT **********************
Percentage of total database...................... 0.031%
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 CAUSAL_PARENT_PARENT_ID of table CAUSAL_PARENT **********************
Percentage of total database...................... 0.031%
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 DEPENDENTS_INDEX and all its indices ********************************
Percentage of total database...................... 19.5%
Number of entries................................. 196365
Bytes of storage consumed......................... 2592768
Bytes of payload.................................. 1801327 69.5%
Bytes of metadata................................. 777716 30.0%
Average payload per entry......................... 9.17
Average unused bytes per entry.................... 0.07
Average metadata per entry........................ 3.96
Average fanout.................................... 210.00
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 3
Primary pages used................................ 630
Overflow pages used............................... 0
Total pages used.................................. 633
Unused bytes on index pages....................... 4044 32.9%
Unused bytes on primary pages..................... 9681 0.38%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 13725 0.53%
*** Table DEPENDENTS_INDEX w/o any indices ************************************
Percentage of total database...................... 7.7%
Number of entries................................. 65455
Bytes of storage consumed......................... 1024000
Bytes of payload.................................. 639011 62.4%
Bytes of metadata................................. 380398 37.1%
B-tree depth...................................... 2
Average payload per entry......................... 9.76
Average unused bytes per entry.................... 0.07
Average metadata per entry........................ 5.81
Average fanout.................................... 249.00
Non-sequential pages.............................. 1 0.40%
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 249
Overflow pages used............................... 0
Total pages used.................................. 250
Unused bytes on index pages....................... 1910 46.6%
Unused bytes on primary pages..................... 2681 0.26%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4591 0.45%
*** Indices of table DEPENDENTS_INDEX *****************************************
Percentage of total database...................... 11.8%
Number of entries................................. 130910
Bytes of storage consumed......................... 1568768
Bytes of payload.................................. 1162316 74.1%
Bytes of metadata................................. 397318 25.3%
Average payload per entry......................... 8.88
Average unused bytes per entry.................... 0.07
Average metadata per entry........................ 3.04
Average fanout.................................... 191.00
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 381
Overflow pages used............................... 0
Total pages used.................................. 383
Unused bytes on index pages....................... 2134 26.0%
Unused bytes on primary pages..................... 7000 0.45%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 9134 0.58%
*** Index DEPENDENCIES_BY_DEPENDENT of table DEPENDENTS_INDEX *****************
Percentage of total database...................... 5.7%
Number of entries................................. 65455
Bytes of storage consumed......................... 757760
Bytes of payload.................................. 555831 73.4%
Bytes of metadata................................. 198581 26.2%
B-tree depth...................................... 2
Average payload per entry......................... 8.49
Average unused bytes per entry.................... 0.05
Average metadata per entry........................ 3.03
Average fanout.................................... 185.00
Non-sequential pages.............................. 1 0.54%
Maximum payload per entry......................... 9
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 184
Overflow pages used............................... 0
Total pages used.................................. 185
Unused bytes on index pages....................... 1243 30.3%
Unused bytes on primary pages..................... 2105 0.28%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3348 0.44%
*** Index DEPENDENTS_BY_DEPENDENCY of table DEPENDENTS_INDEX ******************
Percentage of total database...................... 6.1%
Number of entries................................. 65455
Bytes of storage consumed......................... 811008
Bytes of payload.................................. 606485 74.8%
Bytes of metadata................................. 198737 24.5%
B-tree depth...................................... 2
Average payload per entry......................... 9.27
Average unused bytes per entry.................... 0.09
Average metadata per entry........................ 3.04
Average fanout.................................... 198.00
Non-sequential pages.............................. 1 0.51%
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 197
Overflow pages used............................... 0
Total pages used.................................. 198
Unused bytes on index pages....................... 891 21.8%
Unused bytes on primary pages..................... 4895 0.61%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5786 0.71%
*** Table FIND_TYPE_INDEX and all its indices *********************************
Percentage of total database...................... 2.2%
Number of entries................................. 20280
Bytes of storage consumed......................... 286720
Bytes of payload.................................. 195508 68.2%
Bytes of metadata................................. 75165 26.2%
Average payload per entry......................... 9.64
Average unused bytes per entry.................... 0.79
Average metadata per entry........................ 3.71
Average fanout.................................... 23.00
Maximum payload per entry......................... 12
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 3
Primary pages used................................ 67
Overflow pages used............................... 0
Total pages used.................................. 70
Unused bytes on index pages....................... 11436 93.1%
Unused bytes on primary pages..................... 4611 1.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 16047 5.6%
*** Table FIND_TYPE_INDEX w/o any indices *************************************
Percentage of total database...................... 0.86%
Number of entries................................. 6760
Bytes of storage consumed......................... 114688
Bytes of payload.................................. 74222 64.7%
Bytes of metadata................................. 34109 29.7%
B-tree depth...................................... 2
Average payload per entry......................... 10.98
Average unused bytes per entry.................... 0.94
Average metadata per entry........................ 5.05
Average fanout.................................... 27.00
Non-sequential pages.............................. 1 3.7%
Maximum payload per entry......................... 12
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 27
Overflow pages used............................... 0
Total pages used.................................. 28
Unused bytes on index pages....................... 3876 94.6%
Unused bytes on primary pages..................... 2481 2.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6357 5.5%
*** Indices of table FIND_TYPE_INDEX ******************************************
Percentage of total database...................... 1.3%
Number of entries................................. 13520
Bytes of storage consumed......................... 172032
Bytes of payload.................................. 121286 70.5%
Bytes of metadata................................. 41056 23.9%
Average payload per entry......................... 8.97
Average unused bytes per entry.................... 0.72
Average metadata per entry........................ 3.04
Average fanout.................................... 21.00
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 40
Overflow pages used............................... 0
Total pages used.................................. 42
Unused bytes on index pages....................... 7560 92.3%
Unused bytes on primary pages..................... 2130 1.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 9690 5.6%
*** Index FIND_TYPE_INDEX_TYPE of table FIND_TYPE_INDEX ***********************
Percentage of total database...................... 0.65%
Number of entries................................. 6760
Bytes of storage consumed......................... 86016
Bytes of payload.................................. 60599 70.5%
Bytes of metadata................................. 20528 23.9%
B-tree depth...................................... 2
Average payload per entry......................... 8.96
Average unused bytes per entry.................... 0.72
Average metadata per entry........................ 3.04
Average fanout.................................... 21.00
Non-sequential pages.............................. 1 5.0%
Maximum payload per entry......................... 9
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 20
Overflow pages used............................... 0
Total pages used.................................. 21
Unused bytes on index pages....................... 3780 92.3%
Unused bytes on primary pages..................... 1109 1.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4889 5.7%
*** Index SQLITE_AUTOINDEX_FIND_TYPE_INDEX_1 of table FIND_TYPE_INDEX *********
Percentage of total database...................... 0.65%
Number of entries................................. 6760
Bytes of storage consumed......................... 86016
Bytes of payload.................................. 60687 70.6%
Bytes of metadata................................. 20528 23.9%
B-tree depth...................................... 2
Average payload per entry......................... 8.98
Average unused bytes per entry.................... 0.71
Average metadata per entry........................ 3.04
Average fanout.................................... 21.00
Non-sequential pages.............................. 1 5.0%
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 20
Overflow pages used............................... 0
Total pages used.................................. 21
Unused bytes on index pages....................... 3780 92.3%
Unused bytes on primary pages..................... 1021 1.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4801 5.6%
*** Table FIND_TYPE_MENTIONS_INDEX and all its indices ************************
Percentage of total database...................... 5.7%
Number of entries................................. 53738
Bytes of storage consumed......................... 761856
Bytes of payload.................................. 522244 68.5%
Bytes of metadata................................. 228003 29.9%
Average payload per entry......................... 9.72
Average unused bytes per entry.................... 0.22
Average metadata per entry........................ 4.24
Average fanout.................................... 92.00
Maximum payload per entry......................... 12
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 184
Overflow pages used............................... 0
Total pages used.................................. 186
Unused bytes on index pages....................... 6080 74.2%
Unused bytes on primary pages..................... 5529 0.73%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 11609 1.5%
*** Table FIND_TYPE_MENTIONS_INDEX w/o any indices ****************************
Percentage of total database...................... 3.3%
Number of entries................................. 26869
Bytes of storage consumed......................... 442368
Bytes of payload.................................. 287843 65.1%
Bytes of metadata................................. 146464 33.1%
B-tree depth...................................... 2
Average payload per entry......................... 10.71
Average unused bytes per entry.................... 0.30
Average metadata per entry........................ 5.45
Average fanout.................................... 107.00
Non-sequential pages.............................. 1 0.93%
Maximum payload per entry......................... 12
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 107
Overflow pages used............................... 0
Total pages used.................................. 108
Unused bytes on index pages....................... 3192 77.9%
Unused bytes on primary pages..................... 4869 1.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8061 1.8%
*** Index FIND_TYPE_MENTIONS_INDEX_TYPE of table FIND_TYPE_MENTIONS_INDEX *****
Percentage of total database...................... 2.4%
Number of entries................................. 26869
Bytes of storage consumed......................... 319488
Bytes of payload.................................. 234401 73.4%
Bytes of metadata................................. 81539 25.5%
B-tree depth...................................... 2
Average payload per entry......................... 8.72
Average unused bytes per entry.................... 0.13
Average metadata per entry........................ 3.03
Average fanout.................................... 78.00
Non-sequential pages.............................. 1 1.3%
Maximum payload per entry......................... 9
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 77
Overflow pages used............................... 0
Total pages used.................................. 78
Unused bytes on index pages....................... 2888 70.5%
Unused bytes on primary pages..................... 660 0.21%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3548 1.1%
*** Table HASH and all its indices ********************************************
Percentage of total database...................... 32.1%
Number of entries................................. 36854
Bytes of storage consumed......................... 4268032
Bytes of payload.................................. 3980104 93.3%
Bytes of metadata................................. 163926 3.8%
Average payload per entry......................... 108.00
Average unused bytes per entry.................... 3.36
Average metadata per entry........................ 4.45
Average fanout.................................... 49.00
Maximum payload per entry......................... 109
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 21
Primary pages used................................ 1021
Overflow pages used............................... 0
Total pages used.................................. 1042
Unused bytes on index pages....................... 22698 26.4%
Unused bytes on primary pages..................... 101304 2.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 124002 2.9%
*** Table HASH w/o any indices ************************************************
Percentage of total database...................... 15.9%
Number of entries................................. 18427
Bytes of storage consumed......................... 2109440
Bytes of payload.................................. 1971689 93.5%
Bytes of metadata................................. 102325 4.9%
B-tree depth...................................... 3
Average payload per entry......................... 107.00
Average unused bytes per entry.................... 1.92
Average metadata per entry........................ 5.55
Average fanout.................................... 171.00
Non-sequential pages.............................. 1 0.19%
Maximum payload per entry......................... 107
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 3
Primary pages used................................ 512
Overflow pages used............................... 0
Total pages used.................................. 515
Unused bytes on index pages....................... 8111 66.0%
Unused bytes on primary pages..................... 27315 1.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 35426 1.7%
*** Index HASH_BASE32 of table HASH *******************************************
Percentage of total database...................... 16.2%
Number of entries................................. 18427
Bytes of storage consumed......................... 2158592
Bytes of payload.................................. 2008415 93.0%
Bytes of metadata................................. 61601 2.9%
B-tree depth...................................... 3
Average payload per entry......................... 108.99
Average unused bytes per entry.................... 4.81
Average metadata per entry........................ 3.34
Average fanout.................................... 29.00
Non-sequential pages.............................. 3 0.57%
Maximum payload per entry......................... 109
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 18
Primary pages used................................ 509
Overflow pages used............................... 0
Total pages used.................................. 527
Unused bytes on index pages....................... 14587 19.8%
Unused bytes on primary pages..................... 73989 3.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 88576 4.1%
*** Table HASH_OBJECT and all its indices *************************************
Percentage of total database...................... 1.8%
Number of entries................................. 20174
Bytes of storage consumed......................... 233472
Bytes of payload.................................. 140931 60.4%
Bytes of metadata................................. 82431 35.3%
Average payload per entry......................... 6.99
Average unused bytes per entry.................... 0.50
Average metadata per entry........................ 4.09
Average fanout.................................... 28.00
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 55
Overflow pages used............................... 0
Total pages used.................................. 57
Unused bytes on index pages....................... 7597 92.7%
Unused bytes on primary pages..................... 2513 1.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 10110 4.3%
*** Table HASH_OBJECT w/o any indices *****************************************
Percentage of total database...................... 0.96%
Number of entries................................. 10087
Bytes of storage consumed......................... 126976
Bytes of payload.................................. 70481 55.5%
Bytes of metadata................................. 51862 40.8%
B-tree depth...................................... 2
Average payload per entry......................... 6.99
Average unused bytes per entry.................... 0.46
Average metadata per entry........................ 5.14
Average fanout.................................... 30.00
Non-sequential pages.............................. 1 3.3%
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 30
Overflow pages used............................... 0
Total pages used.................................. 31
Unused bytes on index pages....................... 3849 94.0%
Unused bytes on primary pages..................... 784 0.64%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4633 3.6%
*** Index HASH_OBJECT_OBJECT_ID of table HASH_OBJECT **************************
Percentage of total database...................... 0.80%
Number of entries................................. 10087
Bytes of storage consumed......................... 106496
Bytes of payload.................................. 70450 66.2%
Bytes of metadata................................. 30569 28.7%
B-tree depth...................................... 2
Average payload per entry......................... 6.98
Average unused bytes per entry.................... 0.54
Average metadata per entry........................ 3.03
Average fanout.................................... 26.00
Non-sequential pages.............................. 1 4.0%
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 25
Overflow pages used............................... 0
Total pages used.................................. 26
Unused bytes on index pages....................... 3748 91.5%
Unused bytes on primary pages..................... 1729 1.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5477 5.1%
*** Table MOST_RECENT_BRANCH **************************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 75 1.8%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 75.00
Average unused bytes per entry.................... 4010.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 75
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4010 97.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4010 97.9%
*** Table MOST_RECENT_NAMESPACE ***********************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 108 2.6%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 108.00
Average unused bytes per entry.................... 3977.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 108
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3977 97.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3977 97.1%
*** Table NAME_LOOKUP_MOUNTS and all its indices ******************************
Percentage of total database...................... 0.062%
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 NAME_LOOKUP_MOUNTS w/o any indices **********************************
Percentage of total database...................... 0.031%
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_NAME_LOOKUP_MOUNTS_1 of table NAME_LOOKUP_MOUNTS ***
Percentage of total database...................... 0.031%
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 NAME_LOOKUPS ********************************************************
Percentage of total database...................... 0.031%
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 NAMESPACE_ROOT ******************************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 2 0.049%
Bytes of metadata................................. 14 0.34%
B-tree depth...................................... 1
Average payload per entry......................... 2.00
Average unused bytes per entry.................... 4080.00
Average metadata per entry........................ 14.00
Maximum payload per entry......................... 2
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4080 99.61%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4080 99.61%
*** Table NAMESPACE_STATISTICS ************************************************
Percentage of total database...................... 0.34%
Number of entries................................. 3441
Bytes of storage consumed......................... 45056
Bytes of payload.................................. 18265 40.5%
Bytes of metadata................................. 17908 39.7%
B-tree depth...................................... 2
Average payload per entry......................... 5.31
Average unused bytes per entry.................... 2.58
Average metadata per entry........................ 5.20
Average fanout.................................... 10.00
Non-sequential pages.............................. 1 10.0%
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 10
Overflow pages used............................... 0
Total pages used.................................. 11
Unused bytes on index pages....................... 4011 97.9%
Unused bytes on primary pages..................... 4872 11.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8883 19.7%
*** Table OBJECT and all its indices ******************************************
Percentage of total database...................... 33.4%
Number of entries................................. 30261
Bytes of storage consumed......................... 4435968
Bytes of payload.................................. 3845645 86.7%
Bytes of metadata................................. 132767 3.0%
Average payload per entry......................... 127.08
Average unused bytes per entry.................... 15.12
Average metadata per entry........................ 4.39
Average fanout.................................... 193.00
Maximum payload per entry......................... 17955
Entries that use overflow......................... 80 0.26%
Index pages used.................................. 5
Primary pages used................................ 963
Overflow pages used............................... 115
Total pages used.................................. 1083
Unused bytes on index pages....................... 12513 61.1%
Unused bytes on primary pages..................... 440362 11.2%
Unused bytes on overflow pages.................... 4821 1.0%
Unused bytes on all pages......................... 457696 10.3%
*** Table OBJECT w/o any indices **********************************************
Percentage of total database...................... 31.9%
Number of entries................................. 10087
Bytes of storage consumed......................... 4239360
Bytes of payload.................................. 3721440 87.8%
Bytes of metadata................................. 71677 1.7%
B-tree depth...................................... 3
Average payload per entry......................... 368.93
Average unused bytes per entry.................... 44.25
Average metadata per entry........................ 7.11
Average fanout.................................... 306.00
Non-sequential pages.............................. 1 0.097%
Maximum payload per entry......................... 17955
Entries that use overflow......................... 80 0.79%
Index pages used.................................. 3
Primary pages used................................ 917
Overflow pages used............................... 115
Total pages used.................................. 1035
Unused bytes on index pages....................... 4929 40.1%
Unused bytes on primary pages..................... 436633 11.6%
Unused bytes on overflow pages.................... 4821 1.0%
Unused bytes on all pages......................... 446383 10.5%
*** Indices of table OBJECT ***************************************************
Percentage of total database...................... 1.5%
Number of entries................................. 20174
Bytes of storage consumed......................... 196608
Bytes of payload.................................. 124205 63.2%
Bytes of metadata................................. 61090 31.1%
Average payload per entry......................... 6.16
Average unused bytes per entry.................... 0.56
Average metadata per entry........................ 3.03
Average fanout.................................... 24.00
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 46
Overflow pages used............................... 0
Total pages used.................................. 48
Unused bytes on index pages....................... 7584 92.6%
Unused bytes on primary pages..................... 3729 2.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 11313 5.8%
*** Index OBJECT_HASH_ID of table OBJECT **************************************
Percentage of total database...................... 0.80%
Number of entries................................. 10087
Bytes of storage consumed......................... 106496
Bytes of payload.................................. 70450 66.2%
Bytes of metadata................................. 30569 28.7%
B-tree depth...................................... 2
Average payload per entry......................... 6.98
Average unused bytes per entry.................... 0.54
Average metadata per entry........................ 3.03
Average fanout.................................... 26.00
Non-sequential pages.............................. 1 4.0%
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 25
Overflow pages used............................... 0
Total pages used.................................. 26
Unused bytes on index pages....................... 3748 91.5%
Unused bytes on primary pages..................... 1729 1.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5477 5.1%
*** Index OBJECT_TYPE_ID of table OBJECT **************************************
Percentage of total database...................... 0.68%
Number of entries................................. 10087
Bytes of storage consumed......................... 90112
Bytes of payload.................................. 53755 59.7%
Bytes of metadata................................. 30521 33.9%
B-tree depth...................................... 2
Average payload per entry......................... 5.33
Average unused bytes per entry.................... 0.58
Average metadata per entry........................ 3.03
Average fanout.................................... 22.00
Non-sequential pages.............................. 1 4.8%
Maximum payload per entry......................... 6
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 21
Overflow pages used............................... 0
Total pages used.................................. 22
Unused bytes on index pages....................... 3836 93.7%
Unused bytes on primary pages..................... 2000 2.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5836 6.5%
*** Table OBJECT_TYPE_DESCRIPTION and all its indices *************************
Percentage of total database...................... 0.062%
Number of entries................................. 8
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 110 1.3%
Bytes of metadata................................. 44 0.54%
Average payload per entry......................... 13.75
Average unused bytes per entry.................... 1004.75
Average metadata per entry........................ 5.50
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8038 98.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8038 98.1%
*** Table OBJECT_TYPE_DESCRIPTION w/o any indices *****************************
Percentage of total database...................... 0.031%
Number of entries................................. 4
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 54 1.3%
Bytes of metadata................................. 24 0.59%
B-tree depth...................................... 1
Average payload per entry......................... 13.50
Average unused bytes per entry.................... 1004.50
Average metadata per entry........................ 6.00
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4018 98.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4018 98.1%
*** Index SQLITE_AUTOINDEX_OBJECT_TYPE_DESCRIPTION_1 of table OBJECT_TYPE_DESCRIPTION
Percentage of total database...................... 0.031%
Number of entries................................. 4
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 56 1.4%
Bytes of metadata................................. 20 0.49%
B-tree depth...................................... 1
Average payload per entry......................... 14.00
Average unused bytes per entry.................... 1005.00
Average metadata per entry........................ 5.00
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4020 98.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4020 98.1%
*** Table PROJECT and all its indices *****************************************
Percentage of total database...................... 0.062%
Number of entries................................. 2
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 114 1.4%
Bytes of metadata................................. 22 0.27%
Average payload per entry......................... 57.00
Average unused bytes per entry.................... 4028.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 57
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8056 98.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8056 98.3%
*** Table PROJECT w/o any indices *********************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 57 1.4%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 57.00
Average unused bytes per entry.................... 4028.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 57
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4028 98.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4028 98.3%
*** Index SQLITE_AUTOINDEX_PROJECT_2 of table PROJECT *************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 57 1.4%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 57.00
Average unused bytes per entry.................... 4028.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 57
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4028 98.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4028 98.3%
*** Table PROJECT_BRANCH and all its indices **********************************
Percentage of total database...................... 0.062%
Number of entries................................. 2
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 160 2.0%
Bytes of metadata................................. 22 0.27%
Average payload per entry......................... 80.00
Average unused bytes per entry.................... 4005.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 80
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8010 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8010 97.8%
*** Table PROJECT_BRANCH w/o any indices **************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 80 2.0%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 80.00
Average unused bytes per entry.................... 4005.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 80
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4005 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4005 97.8%
*** Index SQLITE_AUTOINDEX_PROJECT_BRANCH_2 of table PROJECT_BRANCH ***********
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 80 2.0%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 80.00
Average unused bytes per entry.................... 4005.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 80
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4005 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4005 97.8%
*** Table PROJECT_BRANCH_PARENT ***********************************************
Percentage of total database...................... 0.031%
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 PROJECT_BRANCH_REMOTE_MAPPING ***************************************
Percentage of total database...................... 0.031%
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 REFLOG and all its indices ******************************************
Percentage of total database...................... 0.062%
Number of entries................................. 2
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 76 0.93%
Bytes of metadata................................. 23 0.28%
Average payload per entry......................... 38.00
Average unused bytes per entry.................... 4046.50
Average metadata per entry........................ 11.50
Maximum payload per entry......................... 47
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8093 98.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8093 98.8%
*** Table REFLOG w/o any indices **********************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 47 1.1%
Bytes of metadata................................. 12 0.29%
B-tree depth...................................... 1
Average payload per entry......................... 47.00
Average unused bytes per entry.................... 4037.00
Average metadata per entry........................ 12.00
Maximum payload per entry......................... 47
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4037 98.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4037 98.6%
*** Index REFLOG_TIME_DESC of table REFLOG ************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 29 0.71%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 29.00
Average unused bytes per entry.................... 4056.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 29
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4056 99.02%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4056 99.02%
*** Table REMOTE_PROJECT ******************************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 81 2.0%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 81.00
Average unused bytes per entry.................... 4004.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 81
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4004 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4004 97.8%
*** Table REMOTE_PROJECT_BRANCH ***********************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 123 3.0%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 123.00
Average unused bytes per entry.................... 3962.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 123
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3962 96.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3962 96.7%
*** Table SCHEMA_VERSION ******************************************************
Percentage of total database...................... 0.031%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 3 0.073%
Bytes of metadata................................. 12 0.29%
B-tree depth...................................... 1
Average payload per entry......................... 3.00
Average unused bytes per entry.................... 4081.00
Average metadata per entry........................ 12.00
Maximum payload per entry......................... 3
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4081 99.63%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4081 99.63%
*** Table SCOPED_TERM_NAME_LOOKUP and all its indices *************************
Percentage of total database...................... 0.15%
Number of entries................................. 0
Bytes of storage consumed......................... 20480
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 40 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................................ 5
Overflow pages used............................... 0
Total pages used.................................. 5
Unused bytes on primary pages..................... 20440 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 20440 99.80%
*** Table SCOPED_TERM_NAME_LOOKUP w/o any indices *****************************
Percentage of total database...................... 0.031%
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%
*** Indices of table SCOPED_TERM_NAME_LOOKUP **********************************
Percentage of total database...................... 0.12%
Number of entries................................. 0
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 32 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................................ 4
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on primary pages..................... 16352 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 16352 99.80%
*** Index SCOPED_TERM_NAME_BY_REFERENT_LOOKUP of table SCOPED_TERM_NAME_LOOKUP
Percentage of total database...................... 0.031%
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 SCOPED_TERM_NAMES_BY_NAMESPACE of table SCOPED_TERM_NAME_LOOKUP *****
Percentage of total database...................... 0.031%
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 SCOPED_TERM_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT of table SCOPED_TERM_NAME_LOOKUP
Percentage of total database...................... 0.031%
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_SCOPED_TERM_NAME_LOOKUP_1 of table SCOPED_TERM_NAME_LOOKUP
Percentage of total database...................... 0.031%
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 SCOPED_TYPE_NAME_LOOKUP and all its indices *************************
Percentage of total database...................... 0.15%
Number of entries................................. 0
Bytes of storage consumed......................... 20480
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 40 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................................ 5
Overflow pages used............................... 0
Total pages used.................................. 5
Unused bytes on primary pages..................... 20440 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 20440 99.80%
*** Table SCOPED_TYPE_NAME_LOOKUP w/o any indices *****************************
Percentage of total database...................... 0.031%
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%
*** Indices of table SCOPED_TYPE_NAME_LOOKUP **********************************
Percentage of total database...................... 0.12%
Number of entries................................. 0
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 32 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................................ 4
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on primary pages..................... 16352 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 16352 99.80%
*** Index SCOPED_TYPE_NAME_BY_REFERENCE_LOOKUP of table SCOPED_TYPE_NAME_LOOKUP
Percentage of total database...................... 0.031%
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 SCOPED_TYPE_NAMES_BY_NAMESPACE of table SCOPED_TYPE_NAME_LOOKUP *****
Percentage of total database...................... 0.031%
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 SCOPED_TYPE_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT of table SCOPED_TYPE_NAME_LOOKUP
Percentage of total database...................... 0.031%
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_SCOPED_TYPE_NAME_LOOKUP_1 of table SCOPED_TYPE_NAME_LOOKUP
Percentage of total database...................... 0.031%
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.18%
Number of entries................................. 68
Bytes of storage consumed......................... 24576
Bytes of payload.................................. 18887 76.9%
Bytes of metadata................................. 495 2.0%
B-tree depth...................................... 2
Average payload per entry......................... 277.75
Average unused bytes per entry.................... 76.38
Average metadata per entry........................ 7.28
Average fanout.................................... 5.00
Non-sequential pages.............................. 4 80.0%
Maximum payload per entry......................... 1586
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 5
Overflow pages used............................... 0
Total pages used.................................. 6
Unused bytes on index pages....................... 3956 96.6%
Unused bytes on primary pages..................... 1238 6.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5194 21.1%
*** Table SQUASH_RESULTS ******************************************************
Percentage of total database...................... 0.031%
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 TEMP_ENTITY and all its indices *************************************
Percentage of total database...................... 0.062%
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 TEMP_ENTITY w/o any indices *****************************************
Percentage of total database...................... 0.031%
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_TEMP_ENTITY_1 of table TEMP_ENTITY *****************
Percentage of total database...................... 0.031%
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 TEMP_ENTITY_MISSING_DEPENDENCY and all its indices ******************
Percentage of total database...................... 0.12%
Number of entries................................. 0
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 32 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................................ 4
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on primary pages..................... 16352 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 16352 99.80%
*** Table TEMP_ENTITY_MISSING_DEPENDENCY w/o any indices **********************
Percentage of total database...................... 0.031%
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%
*** Indices of table TEMP_ENTITY_MISSING_DEPENDENCY ***************************
Percentage of total database...................... 0.092%
Number of entries................................. 0
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 24 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................................ 3
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on primary pages..................... 12264 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 12264 99.80%
*** Index SQLITE_AUTOINDEX_TEMP_ENTITY_MISSING_DEPENDENCY_1 of table TEMP_ENTITY_MISSING_DEPENDENCY
Percentage of total database...................... 0.031%
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 TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENCY of table TEMP_ENTITY_MISSING_DEPENDENCY
Percentage of total database...................... 0.031%
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 TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENT of table TEMP_ENTITY_MISSING_DEPENDENCY
Percentage of total database...................... 0.031%
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 TEMP_ENTITY_TYPE_DESCRIPTION and all its indices ********************
Percentage of total database...................... 0.062%
Number of entries................................. 10
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 129 1.6%
Bytes of metadata................................. 51 0.62%
Average payload per entry......................... 12.90
Average unused bytes per entry.................... 801.20
Average metadata per entry........................ 5.10
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8012 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8012 97.8%
*** Table TEMP_ENTITY_TYPE_DESCRIPTION w/o any indices ************************
Percentage of total database...................... 0.031%
Number of entries................................. 5
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 63 1.5%
Bytes of metadata................................. 28 0.68%
B-tree depth...................................... 1
Average payload per entry......................... 12.60
Average unused bytes per entry.................... 801.00
Average metadata per entry........................ 5.60
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4005 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4005 97.8%
*** Index SQLITE_AUTOINDEX_TEMP_ENTITY_TYPE_DESCRIPTION_1 of table TEMP_ENTITY_TYPE_DESCRIPTION
Percentage of total database...................... 0.031%
Number of entries................................. 5
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 66 1.6%
Bytes of metadata................................. 23 0.56%
B-tree depth...................................... 1
Average payload per entry......................... 13.20
Average unused bytes per entry.................... 801.40
Average metadata per entry........................ 4.60
Maximum payload per entry......................... 17
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4007 97.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4007 97.8%
*** Table TEXT and all its indices ********************************************
Percentage of total database...................... 2.7%
Number of entries................................. 19614
Bytes of storage consumed......................... 364544
Bytes of payload.................................. 267486 73.4%
Bytes of metadata................................. 79577 21.8%
Average payload per entry......................... 13.64
Average unused bytes per entry.................... 0.89
Average metadata per entry........................ 4.06
Average fanout.................................... 44.00
Maximum payload per entry......................... 232
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 2
Primary pages used................................ 87
Overflow pages used............................... 0
Total pages used.................................. 89
Unused bytes on index pages....................... 6671 81.4%
Unused bytes on primary pages..................... 10810 3.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 17481 4.8%
*** Table TEXT w/o any indices ************************************************
Percentage of total database...................... 1.4%
Number of entries................................. 9807
Bytes of storage consumed......................... 180224
Bytes of payload.................................. 124000 68.8%
Bytes of metadata................................. 49610 27.5%
B-tree depth...................................... 2
Average payload per entry......................... 12.64
Average unused bytes per entry.................... 0.67
Average metadata per entry........................ 5.06
Average fanout.................................... 43.00
Non-sequential pages.............................. 1 2.3%
Maximum payload per entry......................... 230
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 43
Overflow pages used............................... 0
Total pages used.................................. 44
Unused bytes on index pages....................... 3748 91.5%
Unused bytes on primary pages..................... 2866 1.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6614 3.7%
*** Index SQLITE_AUTOINDEX_TEXT_1 of table TEXT *******************************
Percentage of total database...................... 1.4%
Number of entries................................. 9807
Bytes of storage consumed......................... 184320
Bytes of payload.................................. 143486 77.8%
Bytes of metadata................................. 29967 16.3%
B-tree depth...................................... 2
Average payload per entry......................... 14.63
Average unused bytes per entry.................... 1.11
Average metadata per entry........................ 3.06
Average fanout.................................... 45.00
Non-sequential pages.............................. 2 4.5%
Maximum payload per entry......................... 232
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 44
Overflow pages used............................... 0
Total pages used.................................. 45
Unused bytes on index pages....................... 2923 71.4%
Unused bytes on primary pages..................... 7944 4.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 10867 5.9%
*** Table WATCH and all its indices *******************************************
Percentage of total database...................... 0.062%
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 WATCH w/o any indices ***********************************************
Percentage of total database...................... 0.031%
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 WATCH_KIND of table WATCH *******************************************
Percentage of total database...................... 0.031%
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 WATCH_KIND_DESCRIPTION and all its indices **************************
Percentage of total database...................... 0.062%
Number of entries................................. 4
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 34 0.42%
Bytes of metadata................................. 30 0.37%
Average payload per entry......................... 8.50
Average unused bytes per entry.................... 2032.00
Average metadata per entry........................ 7.50
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8128 99.22%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8128 99.22%
*** Table WATCH_KIND_DESCRIPTION w/o any indices ******************************
Percentage of total database...................... 0.031%
Number of entries................................. 2
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 17 0.42%
Bytes of metadata................................. 16 0.39%
B-tree depth...................................... 1
Average payload per entry......................... 8.50
Average unused bytes per entry.................... 2031.50
Average metadata per entry........................ 8.00
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4063 99.19%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4063 99.19%
*** Index SQLITE_AUTOINDEX_WATCH_KIND_DESCRIPTION_1 of table WATCH_KIND_DESCRIPTION
Percentage of total database...................... 0.031%
Number of entries................................. 2
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 17 0.42%
Bytes of metadata................................. 14 0.34%
B-tree depth...................................... 1
Average payload per entry......................... 8.50
Average unused bytes per entry.................... 2032.50
Average metadata per entry........................ 7.00
Maximum payload per entry......................... 10
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4065 99.24%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4065 99.24%
*** Table WATCH_RESULT ********************************************************
Percentage of total database...................... 0.031%
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%
*** 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 4096-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_SCHEMA table
used to store schema information.
Number of indices
The total number of indices in the database.
Number of defined indices
The number of indices created using an explicit CREATE INDEX statement.
Number of implied 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_SCHEMA 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.
Bytes of metadata
The amount of formatting and structural information stored in the
table or index. Metadata includes the btree page header, the cell pointer
array, the size field for each cell, the left child pointer or non-leaf
cells, the overflow pointers for overflow cells, and the rowid value for
rowid table cells. In other words, metadata is everything that is neither
unused space nor content. The record header in the payload is counted as
content, not metadata.
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.
Non-sequential pages
The number of pages in the table or index that are out of sequence.
Many filesystems are optimized for sequential file access so a small
number of non-sequential pages might result in faster queries,
especially for larger database files that do not fit in the disk cache.
Note that after running VACUUM, the root page of each table or index is
at the beginning of the database file and all other pages are in a
separate part of the database file, resulting in a single non-
sequential page.
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
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,72,68,2,18887,0,0,1586,1,5,0,3956,1238,0,4,24576);
INSERT INTO space_used VALUES('schema_version','schema_version',0,0,1,1,1,3,0,0,3,0,1,0,0,4081,0,0,4096);
INSERT INTO space_used VALUES('hash','hash',0,0,18938,18427,3,1971689,0,0,107,3,512,0,8111,27315,0,1,2109440);
INSERT INTO space_used VALUES('text','text',0,0,9849,9807,2,124000,0,0,230,1,43,0,3748,2866,0,1,180224);
INSERT INTO space_used VALUES('sqlite_autoindex_text_1','text',1,0,9807,9764,2,143486,0,0,232,1,44,0,2923,7944,0,2,184320);
INSERT INTO space_used VALUES('hash_object','hash_object',0,0,10116,10087,2,70481,0,0,7,1,30,0,3849,784,0,1,126976);
INSERT INTO space_used VALUES('object_type_description','object_type_description',0,0,4,4,1,54,0,0,17,0,1,0,0,4018,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_object_type_description_1','object_type_description',1,0,4,4,1,56,0,0,17,0,1,0,0,4020,0,0,4096);
INSERT INTO space_used VALUES('object','object',0,0,11003,10087,3,3721440,465759,80,17955,3,917,115,4929,436633,4821,1,4239360);
INSERT INTO space_used VALUES('causal','causal',0,0,3449,3441,2,17197,0,0,5,1,9,0,4019,1849,0,1,40960);
INSERT INTO space_used VALUES('namespace_root','namespace_root',0,0,1,1,1,2,0,0,2,0,1,0,0,4080,0,0,4096);
INSERT INTO space_used VALUES('causal_parent','causal_parent',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('causal_metadata','causal_metadata',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('watch_result','watch_result',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('watch','watch',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('watch_kind_description','watch_kind_description',0,0,2,2,1,17,0,0,10,0,1,0,0,4063,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_watch_kind_description_1','watch_kind_description',1,0,2,2,1,17,0,0,10,0,1,0,0,4065,0,0,4096);
INSERT INTO space_used VALUES('find_type_index','find_type_index',0,0,6786,6760,2,74222,0,0,12,1,27,0,3876,2481,0,1,114688);
INSERT INTO space_used VALUES('sqlite_autoindex_find_type_index_1','find_type_index',1,0,6760,6741,2,60687,0,0,10,1,20,0,3780,1021,0,1,86016);
INSERT INTO space_used VALUES('find_type_mentions_index','find_type_mentions_index',0,0,26975,26869,2,287843,0,0,12,1,107,0,3192,4869,0,1,442368);
INSERT INTO space_used VALUES('dependents_index','dependents_index',0,0,65703,65455,2,639011,0,0,10,1,249,0,1910,2681,0,1,1024000);
INSERT INTO space_used VALUES('name_lookups','name_lookups',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('temp_entity_type_description','temp_entity_type_description',0,0,5,5,1,63,0,0,17,0,1,0,0,4005,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_temp_entity_type_description_1','temp_entity_type_description',1,0,5,5,1,66,0,0,17,0,1,0,0,4007,0,0,4096);
INSERT INTO space_used VALUES('temp_entity','temp_entity',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_temp_entity_1','temp_entity',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('temp_entity_missing_dependency','temp_entity_missing_dependency',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_temp_entity_missing_dependency_1','temp_entity_missing_dependency',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('namespace_statistics','namespace_statistics',0,0,3450,3441,2,18265,0,0,10,1,10,0,4011,4872,0,1,45056);
INSERT INTO space_used VALUES('reflog','reflog',0,0,1,1,1,47,0,0,47,0,1,0,0,4037,0,0,4096);
INSERT INTO space_used VALUES('scoped_term_name_lookup','scoped_term_name_lookup',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_scoped_term_name_lookup_1','scoped_term_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('scoped_type_name_lookup','scoped_type_name_lookup',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_scoped_type_name_lookup_1','scoped_type_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('project','project',0,1,1,1,1,57,0,0,57,0,1,0,0,4028,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_project_2','project',1,0,1,1,1,57,0,0,57,0,1,0,0,4028,0,0,4096);
INSERT INTO space_used VALUES('project_branch','project_branch',0,1,1,1,1,80,0,0,80,0,1,0,0,4005,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_project_branch_2','project_branch',1,0,1,1,1,80,0,0,80,0,1,0,0,4005,0,0,4096);
INSERT INTO space_used VALUES('project_branch_parent','project_branch_parent',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('project_branch_remote_mapping','project_branch_remote_mapping',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('remote_project','remote_project',0,1,1,1,1,81,0,0,81,0,1,0,0,4004,0,0,4096);
INSERT INTO space_used VALUES('remote_project_branch','remote_project_branch',0,1,1,1,1,123,0,0,123,0,1,0,0,3962,0,0,4096);
INSERT INTO space_used VALUES('most_recent_branch','most_recent_branch',0,1,1,1,1,75,0,0,75,0,1,0,0,4010,0,0,4096);
INSERT INTO space_used VALUES('name_lookup_mounts','name_lookup_mounts',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_name_lookup_mounts_1','name_lookup_mounts',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('most_recent_namespace','most_recent_namespace',0,1,1,1,1,108,0,0,108,0,1,0,0,3977,0,0,4096);
INSERT INTO space_used VALUES('squash_results','squash_results',0,1,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('hash_base32','hash',1,0,18427,17919,3,2008415,0,0,109,18,509,0,14587,73989,0,3,2158592);
INSERT INTO space_used VALUES('hash_object_object_id','hash_object',1,0,10087,10063,2,70450,0,0,7,1,25,0,3748,1729,0,1,106496);
INSERT INTO space_used VALUES('object_hash_id','object',1,0,10087,10063,2,70450,0,0,7,1,25,0,3748,1729,0,1,106496);
INSERT INTO space_used VALUES('object_type_id','object',1,0,10087,10067,2,53755,0,0,6,1,21,0,3836,2000,0,1,90112);
INSERT INTO space_used VALUES('causal_value_hash_id','causal',1,0,3441,3433,2,24073,0,0,7,1,9,0,3972,2476,0,1,40960);
INSERT INTO space_used VALUES('causal_parent_causal_id','causal_parent',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('causal_parent_parent_id','causal_parent',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('causal_metadata_causal_id','causal_metadata',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('watch_kind','watch',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('find_type_index_type','find_type_index',1,0,6760,6741,2,60599,0,0,9,1,20,0,3780,1109,0,1,86016);
INSERT INTO space_used VALUES('find_type_mentions_index_type','find_type_mentions_index',1,0,26869,26793,2,234401,0,0,9,1,77,0,2888,660,0,1,319488);
INSERT INTO space_used VALUES('dependents_by_dependency','dependents_index',1,0,65455,65259,2,606485,0,0,10,1,197,0,891,4895,0,1,811008);
INSERT INTO space_used VALUES('dependencies_by_dependent','dependents_index',1,0,65455,65272,2,555831,0,0,9,1,184,0,1243,2105,0,1,757760);
INSERT INTO space_used VALUES('temp_entity_missing_dependency_ix_dependent','temp_entity_missing_dependency',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('temp_entity_missing_dependency_ix_dependency','temp_entity_missing_dependency',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('reflog_time_desc','reflog',1,0,1,1,1,29,0,0,29,0,1,0,0,4056,0,0,4096);
INSERT INTO space_used VALUES('scoped_term_names_by_namespace_and_last_name_segment','scoped_term_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('scoped_term_name_by_referent_lookup','scoped_term_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('scoped_term_names_by_namespace','scoped_term_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('scoped_type_names_by_namespace_and_last_name_segment','scoped_type_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('scoped_type_name_by_reference_lookup','scoped_type_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('scoped_type_names_by_namespace','scoped_type_name_lookup',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment