Created
March 4, 2024 15:30
-
-
Save aryairani/f5e404ad603f8d1c61c9b67881e5b25a to your computer and use it in GitHub Desktop.
sqlite-analyzer for @unison/base/main
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** Disk-Space Utilization Report For base-main/.unison/v2/unison.sqlite3 | |
| Page size in bytes................................ 4096 | |
| Pages in the whole file (measured)................ 7809 | |
| Pages in the whole file (calculated).............. 7809 | |
| Pages that store data............................. 7809 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......................... 31985664 | |
| Bytes of user payload stored...................... 17489055 54.7% | |
| *** Page counts for all tables with their indices ***************************** | |
| OBJECT............................................ 3005 38.5% | |
| HASH.............................................. 2435 31.2% | |
| DEPENDENTS_INDEX.................................. 1442 18.5% | |
| FIND_TYPE_MENTIONS_INDEX.......................... 351 4.5% | |
| HASH_OBJECT....................................... 141 1.8% | |
| FIND_TYPE_INDEX................................... 133 1.7% | |
| TEXT.............................................. 92 1.2% | |
| CAUSAL_PARENT..................................... 78 1.00% | |
| CAUSAL............................................ 70 0.90% | |
| NAMESPACE_STATISTICS.............................. 10 0.13% | |
| SQLITE_SCHEMA..................................... 7 0.090% | |
| SCOPED_TERM_NAME_LOOKUP........................... 5 0.064% | |
| SCOPED_TYPE_NAME_LOOKUP........................... 5 0.064% | |
| TEMP_ENTITY_MISSING_DEPENDENCY.................... 4 0.051% | |
| CAUSAL_METADATA................................... 2 0.026% | |
| NAME_LOOKUP_MOUNTS................................ 2 0.026% | |
| OBJECT_TYPE_DESCRIPTION........................... 2 0.026% | |
| PROJECT........................................... 2 0.026% | |
| PROJECT_BRANCH.................................... 2 0.026% | |
| REFLOG............................................ 2 0.026% | |
| TEMP_ENTITY....................................... 2 0.026% | |
| TEMP_ENTITY_TYPE_DESCRIPTION...................... 2 0.026% | |
| WATCH............................................. 2 0.026% | |
| WATCH_KIND_DESCRIPTION............................ 2 0.026% | |
| MOST_RECENT_BRANCH................................ 1 0.013% | |
| MOST_RECENT_NAMESPACE............................. 1 0.013% | |
| NAME_LOOKUPS...................................... 1 0.013% | |
| NAMESPACE_ROOT.................................... 1 0.013% | |
| PROJECT_BRANCH_PARENT............................. 1 0.013% | |
| PROJECT_BRANCH_REMOTE_MAPPING..................... 1 0.013% | |
| REMOTE_PROJECT.................................... 1 0.013% | |
| REMOTE_PROJECT_BRANCH............................. 1 0.013% | |
| SCHEMA_VERSION.................................... 1 0.013% | |
| SQUASH_RESULTS.................................... 1 0.013% | |
| WATCH_RESULT...................................... 1 0.013% | |
| *** Page counts for all tables and indices separately ************************* | |
| OBJECT............................................ 2889 37.0% | |
| HASH.............................................. 1219 15.6% | |
| HASH_BASE32....................................... 1216 15.6% | |
| DEPENDENTS_INDEX.................................. 565 7.2% | |
| DEPENDENTS_BY_DEPENDENCY.......................... 452 5.8% | |
| DEPENDENCIES_BY_DEPENDENT......................... 425 5.4% | |
| FIND_TYPE_MENTIONS_INDEX.......................... 202 2.6% | |
| FIND_TYPE_MENTIONS_INDEX_TYPE..................... 149 1.9% | |
| HASH_OBJECT....................................... 78 1.00% | |
| HASH_OBJECT_OBJECT_ID............................. 63 0.81% | |
| OBJECT_HASH_ID.................................... 63 0.81% | |
| FIND_TYPE_INDEX................................... 53 0.68% | |
| OBJECT_TYPE_ID.................................... 53 0.68% | |
| SQLITE_AUTOINDEX_TEXT_1........................... 46 0.59% | |
| TEXT.............................................. 46 0.59% | |
| FIND_TYPE_INDEX_TYPE.............................. 40 0.51% | |
| SQLITE_AUTOINDEX_FIND_TYPE_INDEX_1................ 40 0.51% | |
| CAUSAL............................................ 36 0.46% | |
| CAUSAL_VALUE_HASH_ID.............................. 34 0.44% | |
| CAUSAL_PARENT..................................... 26 0.33% | |
| CAUSAL_PARENT_CAUSAL_ID........................... 26 0.33% | |
| CAUSAL_PARENT_PARENT_ID........................... 26 0.33% | |
| NAMESPACE_STATISTICS.............................. 10 0.13% | |
| SQLITE_SCHEMA..................................... 7 0.090% | |
| CAUSAL_METADATA................................... 1 0.013% | |
| CAUSAL_METADATA_CAUSAL_ID......................... 1 0.013% | |
| MOST_RECENT_BRANCH................................ 1 0.013% | |
| MOST_RECENT_NAMESPACE............................. 1 0.013% | |
| NAME_LOOKUP_MOUNTS................................ 1 0.013% | |
| NAME_LOOKUPS...................................... 1 0.013% | |
| NAMESPACE_ROOT.................................... 1 0.013% | |
| OBJECT_TYPE_DESCRIPTION........................... 1 0.013% | |
| PROJECT........................................... 1 0.013% | |
| PROJECT_BRANCH.................................... 1 0.013% | |
| PROJECT_BRANCH_PARENT............................. 1 0.013% | |
| PROJECT_BRANCH_REMOTE_MAPPING..................... 1 0.013% | |
| REFLOG............................................ 1 0.013% | |
| REFLOG_TIME_DESC.................................. 1 0.013% | |
| REMOTE_PROJECT.................................... 1 0.013% | |
| REMOTE_PROJECT_BRANCH............................. 1 0.013% | |
| SCHEMA_VERSION.................................... 1 0.013% | |
| SCOPED_TERM_NAME_BY_REFERENT_LOOKUP............... 1 0.013% | |
| SCOPED_TERM_NAME_LOOKUP........................... 1 0.013% | |
| SCOPED_TERM_NAMES_BY_NAMESPACE.................... 1 0.013% | |
| SCOPED_TERM_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT 1 0.013% | |
| SCOPED_TYPE_NAME_BY_REFERENCE_LOOKUP.............. 1 0.013% | |
| SCOPED_TYPE_NAME_LOOKUP........................... 1 0.013% | |
| SCOPED_TYPE_NAMES_BY_NAMESPACE.................... 1 0.013% | |
| SCOPED_TYPE_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT 1 0.013% | |
| SQLITE_AUTOINDEX_NAME_LOOKUP_MOUNTS_1............. 1 0.013% | |
| SQLITE_AUTOINDEX_OBJECT_TYPE_DESCRIPTION_1........ 1 0.013% | |
| SQLITE_AUTOINDEX_PROJECT_2........................ 1 0.013% | |
| SQLITE_AUTOINDEX_PROJECT_BRANCH_2................. 1 0.013% | |
| SQLITE_AUTOINDEX_SCOPED_TERM_NAME_LOOKUP_1........ 1 0.013% | |
| SQLITE_AUTOINDEX_SCOPED_TYPE_NAME_LOOKUP_1........ 1 0.013% | |
| SQLITE_AUTOINDEX_TEMP_ENTITY_1.................... 1 0.013% | |
| SQLITE_AUTOINDEX_TEMP_ENTITY_MISSING_DEPENDENCY_1. 1 0.013% | |
| SQLITE_AUTOINDEX_TEMP_ENTITY_TYPE_DESCRIPTION_1... 1 0.013% | |
| SQLITE_AUTOINDEX_WATCH_KIND_DESCRIPTION_1......... 1 0.013% | |
| SQUASH_RESULTS.................................... 1 0.013% | |
| TEMP_ENTITY....................................... 1 0.013% | |
| TEMP_ENTITY_MISSING_DEPENDENCY.................... 1 0.013% | |
| TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENCY...... 1 0.013% | |
| TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENT....... 1 0.013% | |
| TEMP_ENTITY_TYPE_DESCRIPTION...................... 1 0.013% | |
| WATCH............................................. 1 0.013% | |
| WATCH_KIND........................................ 1 0.013% | |
| WATCH_KIND_DESCRIPTION............................ 1 0.013% | |
| WATCH_RESULT...................................... 1 0.013% | |
| *** All tables and indices **************************************************** | |
| Percentage of total database...................... 100.0% | |
| Number of entries................................. 863389 | |
| Bytes of storage consumed......................... 31985664 | |
| Bytes of payload.................................. 26527849 82.9% | |
| Bytes of metadata................................. 3691849 11.5% | |
| Average payload per entry......................... 30.73 | |
| Average unused bytes per entry.................... 2.05 | |
| Average metadata per entry........................ 4.28 | |
| Average fanout.................................... 103.00 | |
| Maximum payload per entry......................... 17956 | |
| Entries that use overflow......................... 242 0.028% | |
| Index pages used.................................. 72 | |
| Primary pages used................................ 7401 | |
| Overflow pages used............................... 336 | |
| Total pages used.................................. 7809 | |
| Unused bytes on index pages....................... 92530 31.4% | |
| Unused bytes on primary pages..................... 1659654 5.5% | |
| Unused bytes on overflow pages.................... 14158 1.0% | |
| Unused bytes on all pages......................... 1766342 5.5% | |
| *** All tables **************************************************************** | |
| Percentage of total database...................... 66.0% | |
| Number of entries................................. 337054 | |
| Bytes of storage consumed......................... 21114880 | |
| Bytes of payload.................................. 17507942 82.9% | |
| Bytes of metadata................................. 2049277 9.7% | |
| Average payload per entry......................... 51.94 | |
| Average unused bytes per entry.................... 4.62 | |
| Average metadata per entry........................ 6.08 | |
| Average fanout.................................... 217.00 | |
| Maximum payload per entry......................... 17956 | |
| Entries that use overflow......................... 241 0.072% | |
| Index pages used.................................. 22 | |
| Primary pages used................................ 4798 | |
| Overflow pages used............................... 335 | |
| Total pages used.................................. 5155 | |
| Unused bytes on index pages....................... 48630 54.0% | |
| Unused bytes on primary pages..................... 1498786 7.6% | |
| Unused bytes on overflow pages.................... 10621 0.77% | |
| Unused bytes on all pages......................... 1558037 7.4% | |
| *** All indices *************************************************************** | |
| Percentage of total database...................... 34.0% | |
| Number of entries................................. 526335 | |
| Bytes of storage consumed......................... 10870784 | |
| Bytes of payload.................................. 9019907 83.0% | |
| Bytes of metadata................................. 1642572 15.1% | |
| Average payload per entry......................... 17.14 | |
| Average unused bytes per entry.................... 0.40 | |
| Average metadata per entry........................ 3.12 | |
| Average fanout.................................... 53.00 | |
| Maximum payload per entry......................... 1030 | |
| Entries that use overflow......................... 1 0.0% | |
| Index pages used.................................. 50 | |
| Primary pages used................................ 2603 | |
| Overflow pages used............................... 1 | |
| Total pages used.................................. 2654 | |
| Unused bytes on index pages....................... 43900 21.4% | |
| Unused bytes on primary pages..................... 160868 1.5% | |
| Unused bytes on overflow pages.................... 3537 86.4% | |
| Unused bytes on all pages......................... 208305 1.9% | |
| *** Table CAUSAL and all its indices ****************************************** | |
| Percentage of total database...................... 0.90% | |
| Number of entries................................. 25270 | |
| Bytes of storage consumed......................... 286720 | |
| Bytes of payload.................................. 163235 56.9% | |
| Bytes of metadata................................. 113552 39.6% | |
| Average payload per entry......................... 6.46 | |
| Average unused bytes per entry.................... 0.39 | |
| Average metadata per entry........................ 4.49 | |
| Average fanout.................................... 34.00 | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 68 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 70 | |
| Unused bytes on index pages....................... 7371 90.0% | |
| Unused bytes on primary pages..................... 2562 0.92% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 9933 3.5% | |
| *** Table CAUSAL w/o any indices ********************************************** | |
| Percentage of total database...................... 0.46% | |
| Number of entries................................. 12635 | |
| Bytes of storage consumed......................... 147456 | |
| Bytes of payload.................................. 66643 45.2% | |
| Bytes of metadata................................. 74835 50.8% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.27 | |
| Average unused bytes per entry.................... 0.47 | |
| Average metadata per entry........................ 5.92 | |
| Average fanout.................................... 35.00 | |
| Non-sequential pages.............................. 1 2.9% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 35 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 36 | |
| Unused bytes on index pages....................... 3770 92.0% | |
| Unused bytes on primary pages..................... 2208 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5978 4.1% | |
| *** Index CAUSAL_VALUE_HASH_ID of table CAUSAL ******************************** | |
| Percentage of total database...................... 0.44% | |
| Number of entries................................. 12635 | |
| Bytes of storage consumed......................... 139264 | |
| Bytes of payload.................................. 96592 69.4% | |
| Bytes of metadata................................. 38717 27.8% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.64 | |
| Average unused bytes per entry.................... 0.31 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 34.00 | |
| Non-sequential pages.............................. 1 3.0% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 33 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 34 | |
| Unused bytes on index pages....................... 3601 87.9% | |
| Unused bytes on primary pages..................... 354 0.26% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3955 2.8% | |
| *** Table CAUSAL_METADATA and all its indices ********************************* | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 40 0.49% | |
| 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..................... 8152 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8152 99.51% | |
| *** Table CAUSAL_METADATA w/o any indices ************************************* | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index CAUSAL_METADATA_CAUSAL_ID of table CAUSAL_METADATA ****************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table CAUSAL_PARENT and all its indices *********************************** | |
| Percentage of total database...................... 1.00% | |
| Number of entries................................. 27213 | |
| Bytes of storage consumed......................... 319488 | |
| Bytes of payload.................................. 217002 67.9% | |
| Bytes of metadata................................. 83499 26.1% | |
| Average payload per entry......................... 7.97 | |
| Average unused bytes per entry.................... 0.70 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 25.00 | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 75 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 78 | |
| Unused bytes on index pages....................... 11130 90.6% | |
| Unused bytes on primary pages..................... 7857 2.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 18987 5.9% | |
| *** Table CAUSAL_PARENT w/o any indices *************************************** | |
| Percentage of total database...................... 0.33% | |
| Number of entries................................. 9071 | |
| Bytes of storage consumed......................... 106496 | |
| Bytes of payload.................................. 72334 67.9% | |
| Bytes of metadata................................. 27833 26.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.97 | |
| Average unused bytes per entry.................... 0.70 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 25.00 | |
| Non-sequential pages.............................. 1 4.0% | |
| Maximum payload per entry......................... 9 | |
| 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....................... 3710 90.6% | |
| Unused bytes on primary pages..................... 2619 2.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6329 5.9% | |
| *** Indices of table CAUSAL_PARENT ******************************************** | |
| Percentage of total database...................... 0.67% | |
| Number of entries................................. 18142 | |
| Bytes of storage consumed......................... 212992 | |
| Bytes of payload.................................. 144668 67.9% | |
| Bytes of metadata................................. 55666 26.1% | |
| Average payload per entry......................... 7.97 | |
| Average unused bytes per entry.................... 0.70 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 26.00 | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 50 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 52 | |
| Unused bytes on index pages....................... 7420 90.6% | |
| Unused bytes on primary pages..................... 5238 2.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12658 5.9% | |
| *** Index CAUSAL_PARENT_CAUSAL_ID of table CAUSAL_PARENT ********************** | |
| Percentage of total database...................... 0.33% | |
| Number of entries................................. 9071 | |
| Bytes of storage consumed......................... 106496 | |
| Bytes of payload.................................. 72334 67.9% | |
| Bytes of metadata................................. 27833 26.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.97 | |
| Average unused bytes per entry.................... 0.70 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 26.00 | |
| Non-sequential pages.............................. 1 4.0% | |
| Maximum payload per entry......................... 9 | |
| 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....................... 3710 90.6% | |
| Unused bytes on primary pages..................... 2619 2.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6329 5.9% | |
| *** Index CAUSAL_PARENT_PARENT_ID of table CAUSAL_PARENT ********************** | |
| Percentage of total database...................... 0.33% | |
| Number of entries................................. 9071 | |
| Bytes of storage consumed......................... 106496 | |
| Bytes of payload.................................. 72334 67.9% | |
| Bytes of metadata................................. 27833 26.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.97 | |
| Average unused bytes per entry.................... 0.70 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 26.00 | |
| Non-sequential pages.............................. 1 4.0% | |
| Maximum payload per entry......................... 9 | |
| 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....................... 3710 90.6% | |
| Unused bytes on primary pages..................... 2619 2.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6329 5.9% | |
| *** Table DEPENDENTS_INDEX and all its indices ******************************** | |
| Percentage of total database...................... 18.5% | |
| Number of entries................................. 437931 | |
| Bytes of storage consumed......................... 5906432 | |
| Bytes of payload.................................. 4098613 69.4% | |
| Bytes of metadata................................. 1772557 30.0% | |
| Average payload per entry......................... 9.36 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 4.05 | |
| Average fanout.................................... 160.00 | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 1433 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1442 | |
| Unused bytes on index pages....................... 17572 47.7% | |
| Unused bytes on primary pages..................... 17690 0.30% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 35262 0.60% | |
| *** Table DEPENDENTS_INDEX w/o any indices ************************************ | |
| Percentage of total database...................... 7.2% | |
| Number of entries................................. 145977 | |
| Bytes of storage consumed......................... 2314240 | |
| Bytes of payload.................................. 1425305 61.6% | |
| Bytes of metadata................................. 875655 37.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 9.76 | |
| Average unused bytes per entry.................... 0.09 | |
| Average metadata per entry........................ 6.00 | |
| Average fanout.................................... 188.00 | |
| Non-sequential pages.............................. 1 0.18% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 562 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 565 | |
| Unused bytes on index pages....................... 7225 58.8% | |
| Unused bytes on primary pages..................... 6055 0.26% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 13280 0.57% | |
| *** Indices of table DEPENDENTS_INDEX ***************************************** | |
| Percentage of total database...................... 11.2% | |
| Number of entries................................. 291954 | |
| Bytes of storage consumed......................... 3592192 | |
| Bytes of payload.................................. 2673308 74.4% | |
| Bytes of metadata................................. 896902 25.0% | |
| Average payload per entry......................... 9.16 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 146.00 | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 871 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 877 | |
| Unused bytes on index pages....................... 10347 42.1% | |
| Unused bytes on primary pages..................... 11635 0.33% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 21982 0.61% | |
| *** Index DEPENDENCIES_BY_DEPENDENT of table DEPENDENTS_INDEX ***************** | |
| Percentage of total database...................... 5.4% | |
| Number of entries................................. 145977 | |
| Bytes of storage consumed......................... 1740800 | |
| Bytes of payload.................................. 1280600 73.6% | |
| Bytes of metadata................................. 448127 25.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.77 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 141.00 | |
| Non-sequential pages.............................. 1 0.24% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 422 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 425 | |
| Unused bytes on index pages....................... 5568 45.3% | |
| Unused bytes on primary pages..................... 6505 0.38% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12073 0.69% | |
| *** Index DEPENDENTS_BY_DEPENDENCY of table DEPENDENTS_INDEX ****************** | |
| Percentage of total database...................... 5.8% | |
| Number of entries................................. 145977 | |
| Bytes of storage consumed......................... 1851392 | |
| Bytes of payload.................................. 1392708 75.2% | |
| Bytes of metadata................................. 448775 24.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 9.54 | |
| Average unused bytes per entry.................... 0.07 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 150.00 | |
| Non-sequential pages.............................. 1 0.22% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 449 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 452 | |
| Unused bytes on index pages....................... 4779 38.9% | |
| Unused bytes on primary pages..................... 5130 0.28% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 9909 0.54% | |
| *** Table FIND_TYPE_INDEX and all its indices ********************************* | |
| Percentage of total database...................... 1.7% | |
| Number of entries................................. 39030 | |
| Bytes of storage consumed......................... 544768 | |
| Bytes of payload.................................. 378374 69.5% | |
| Bytes of metadata................................. 146367 26.9% | |
| Average payload per entry......................... 9.69 | |
| Average unused bytes per entry.................... 0.51 | |
| Average metadata per entry........................ 3.75 | |
| Average fanout.................................... 44.00 | |
| Maximum payload per entry......................... 13 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 130 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 133 | |
| Unused bytes on index pages....................... 10588 86.2% | |
| Unused bytes on primary pages..................... 9439 1.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 20027 3.7% | |
| *** Table FIND_TYPE_INDEX w/o any indices ************************************* | |
| Percentage of total database...................... 0.68% | |
| Number of entries................................. 13010 | |
| Bytes of storage consumed......................... 217088 | |
| Bytes of payload.................................. 143780 66.2% | |
| Bytes of metadata................................. 66395 30.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 11.05 | |
| Average unused bytes per entry.................... 0.53 | |
| Average metadata per entry........................ 5.10 | |
| Average fanout.................................... 52.00 | |
| Non-sequential pages.............................. 1 1.9% | |
| Maximum payload per entry......................... 13 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 52 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 53 | |
| Unused bytes on index pages....................... 3664 89.5% | |
| Unused bytes on primary pages..................... 3249 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6913 3.2% | |
| *** Indices of table FIND_TYPE_INDEX ****************************************** | |
| Percentage of total database...................... 1.0% | |
| Number of entries................................. 26020 | |
| Bytes of storage consumed......................... 327680 | |
| Bytes of payload.................................. 234594 71.6% | |
| Bytes of metadata................................. 79972 24.4% | |
| Average payload per entry......................... 9.02 | |
| Average unused bytes per entry.................... 0.50 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 40.00 | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 78 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 80 | |
| Unused bytes on index pages....................... 6924 84.5% | |
| Unused bytes on primary pages..................... 6190 1.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 13114 4.0% | |
| *** Index FIND_TYPE_INDEX_TYPE of table FIND_TYPE_INDEX *********************** | |
| Percentage of total database...................... 0.51% | |
| Number of entries................................. 13010 | |
| Bytes of storage consumed......................... 163840 | |
| Bytes of payload.................................. 117633 71.8% | |
| Bytes of metadata................................. 39986 24.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 9.04 | |
| Average unused bytes per entry.................... 0.48 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 40.00 | |
| Non-sequential pages.............................. 1 2.6% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 39 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 40 | |
| Unused bytes on index pages....................... 3461 84.5% | |
| Unused bytes on primary pages..................... 2760 1.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6221 3.8% | |
| *** Index SQLITE_AUTOINDEX_FIND_TYPE_INDEX_1 of table FIND_TYPE_INDEX ********* | |
| Percentage of total database...................... 0.51% | |
| Number of entries................................. 13010 | |
| Bytes of storage consumed......................... 163840 | |
| Bytes of payload.................................. 116961 71.4% | |
| Bytes of metadata................................. 39986 24.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 8.99 | |
| Average unused bytes per entry.................... 0.53 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 40.00 | |
| Non-sequential pages.............................. 1 2.6% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 39 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 40 | |
| Unused bytes on index pages....................... 3463 84.5% | |
| Unused bytes on primary pages..................... 3430 2.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6893 4.2% | |
| *** Table FIND_TYPE_MENTIONS_INDEX and all its indices ************************ | |
| Percentage of total database...................... 4.5% | |
| Number of entries................................. 99196 | |
| Bytes of storage consumed......................... 1437696 | |
| Bytes of payload.................................. 990483 68.9% | |
| Bytes of metadata................................. 439225 30.6% | |
| Average payload per entry......................... 9.99 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 4.43 | |
| Average fanout.................................... 175.00 | |
| Maximum payload per entry......................... 13 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 349 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 351 | |
| Unused bytes on index pages....................... 4026 49.1% | |
| Unused bytes on primary pages..................... 3962 0.28% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7988 0.56% | |
| *** Table FIND_TYPE_MENTIONS_INDEX w/o any indices **************************** | |
| Percentage of total database...................... 2.6% | |
| Number of entries................................. 49598 | |
| Bytes of storage consumed......................... 827392 | |
| Bytes of payload.................................. 536346 64.8% | |
| Bytes of metadata................................. 286859 34.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 10.81 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 5.78 | |
| Average fanout.................................... 201.00 | |
| Non-sequential pages.............................. 1 0.50% | |
| Maximum payload per entry......................... 13 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 201 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 202 | |
| Unused bytes on index pages....................... 2335 57.0% | |
| Unused bytes on primary pages..................... 1852 0.22% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4187 0.51% | |
| *** Index FIND_TYPE_MENTIONS_INDEX_TYPE of table FIND_TYPE_MENTIONS_INDEX ***** | |
| Percentage of total database...................... 1.9% | |
| Number of entries................................. 49598 | |
| Bytes of storage consumed......................... 610304 | |
| Bytes of payload.................................. 454137 74.4% | |
| Bytes of metadata................................. 152366 25.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 9.16 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 149.00 | |
| Non-sequential pages.............................. 1 0.68% | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 148 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 149 | |
| Unused bytes on index pages....................... 1691 41.3% | |
| Unused bytes on primary pages..................... 2110 0.35% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3801 0.62% | |
| *** Table HASH and all its indices ******************************************** | |
| Percentage of total database...................... 31.2% | |
| Number of entries................................. 87426 | |
| Bytes of storage consumed......................... 9973760 | |
| Bytes of payload.................................. 9452826 94.8% | |
| Bytes of metadata................................. 440951 4.4% | |
| Average payload per entry......................... 108.12 | |
| Average unused bytes per entry.................... 0.91 | |
| Average metadata per entry........................ 5.04 | |
| Average fanout.................................... 64.00 | |
| Maximum payload per entry......................... 110 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 38 | |
| Primary pages used................................ 2397 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2435 | |
| Unused bytes on index pages....................... 6964 4.5% | |
| Unused bytes on primary pages..................... 73019 0.74% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 79983 0.80% | |
| *** Table HASH w/o any indices ************************************************ | |
| Percentage of total database...................... 15.6% | |
| Number of entries................................. 43713 | |
| Bytes of storage consumed......................... 4993024 | |
| Bytes of payload.................................. 4677291 93.7% | |
| Bytes of metadata................................. 280632 5.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 107.00 | |
| Average unused bytes per entry.................... 0.80 | |
| Average metadata per entry........................ 6.42 | |
| Average fanout.................................... 304.00 | |
| Non-sequential pages.............................. 1 0.082% | |
| Maximum payload per entry......................... 107 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 1215 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1219 | |
| Unused bytes on index pages....................... 5820 35.5% | |
| Unused bytes on primary pages..................... 29281 0.59% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 35101 0.70% | |
| *** Index HASH_BASE32 of table HASH ******************************************* | |
| Percentage of total database...................... 15.6% | |
| Number of entries................................. 43713 | |
| Bytes of storage consumed......................... 4980736 | |
| Bytes of payload.................................. 4775535 95.9% | |
| Bytes of metadata................................. 160319 3.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 109.25 | |
| Average unused bytes per entry.................... 1.03 | |
| Average metadata per entry........................ 3.67 | |
| Average fanout.................................... 35.00 | |
| Non-sequential pages.............................. 1 0.082% | |
| Maximum payload per entry......................... 110 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 34 | |
| Primary pages used................................ 1182 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1216 | |
| Unused bytes on index pages....................... 1144 0.82% | |
| Unused bytes on primary pages..................... 43738 0.90% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 44882 0.90% | |
| *** Table HASH_OBJECT and all its indices ************************************* | |
| Percentage of total database...................... 1.8% | |
| Number of entries................................. 49428 | |
| Bytes of storage consumed......................... 577536 | |
| Bytes of payload.................................. 350603 60.7% | |
| Bytes of metadata................................. 215939 37.4% | |
| Average payload per entry......................... 7.09 | |
| Average unused bytes per entry.................... 0.22 | |
| Average metadata per entry........................ 4.37 | |
| Average fanout.................................... 70.00 | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 139 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 141 | |
| Unused bytes on index pages....................... 6622 80.8% | |
| Unused bytes on primary pages..................... 4372 0.77% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 10994 1.9% | |
| *** Table HASH_OBJECT w/o any indices ***************************************** | |
| Percentage of total database...................... 1.00% | |
| Number of entries................................. 24714 | |
| Bytes of storage consumed......................... 319488 | |
| Bytes of payload.................................. 172870 54.1% | |
| Bytes of metadata................................. 140289 43.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.99 | |
| Average unused bytes per entry.................... 0.26 | |
| Average metadata per entry........................ 5.68 | |
| Average fanout.................................... 77.00 | |
| Non-sequential pages.............................. 1 1.3% | |
| Maximum payload per entry......................... 7 | |
| 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....................... 3417 83.4% | |
| Unused bytes on primary pages..................... 2912 0.92% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6329 2.0% | |
| *** Index HASH_OBJECT_OBJECT_ID of table HASH_OBJECT ************************** | |
| Percentage of total database...................... 0.81% | |
| Number of entries................................. 24714 | |
| Bytes of storage consumed......................... 258048 | |
| Bytes of payload.................................. 177733 68.9% | |
| Bytes of metadata................................. 75650 29.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.19 | |
| Average unused bytes per entry.................... 0.19 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 63.00 | |
| Non-sequential pages.............................. 1 1.6% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 62 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 63 | |
| Unused bytes on index pages....................... 3205 78.2% | |
| Unused bytes on primary pages..................... 1460 0.57% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4665 1.8% | |
| *** Table MOST_RECENT_BRANCH ************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table MOST_RECENT_NAMESPACE *********************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 108 2.6% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 108.00 | |
| Average unused bytes per entry.................... 3965.00 | |
| Average metadata per entry........................ 23.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..................... 3965 96.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3965 96.8% | |
| *** Table NAME_LOOKUP_MOUNTS and all its indices ****************************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 40 0.49% | |
| 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..................... 8152 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8152 99.51% | |
| *** Table NAME_LOOKUP_MOUNTS w/o any indices ********************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SQLITE_AUTOINDEX_NAME_LOOKUP_MOUNTS_1 of table NAME_LOOKUP_MOUNTS *** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table NAME_LOOKUPS ******************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table NAMESPACE_ROOT ****************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 2 0.049% | |
| Bytes of metadata................................. 26 0.63% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 2.00 | |
| Average unused bytes per entry.................... 4068.00 | |
| Average metadata per entry........................ 26.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..................... 4068 99.32% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4068 99.32% | |
| *** Table NAMESPACE_STATISTICS ************************************************ | |
| Percentage of total database...................... 0.13% | |
| Number of entries................................. 3417 | |
| Bytes of storage consumed......................... 40960 | |
| Bytes of payload.................................. 18135 44.3% | |
| Bytes of metadata................................. 18439 45.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.31 | |
| Average unused bytes per entry.................... 1.28 | |
| Average metadata per entry........................ 5.40 | |
| Average fanout.................................... 9.00 | |
| Non-sequential pages.............................. 1 11.1% | |
| Maximum payload per entry......................... 10 | |
| 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....................... 4005 97.8% | |
| Unused bytes on primary pages..................... 381 1.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4386 10.7% | |
| *** Table OBJECT and all its indices ****************************************** | |
| Percentage of total database...................... 38.5% | |
| Number of entries................................. 74142 | |
| Bytes of storage consumed......................... 12308480 | |
| Bytes of payload.................................. 10558723 85.8% | |
| Bytes of metadata................................. 376504 3.1% | |
| Average payload per entry......................... 142.41 | |
| Average unused bytes per entry.................... 18.53 | |
| Average metadata per entry........................ 5.08 | |
| Average fanout.................................... 296.00 | |
| Maximum payload per entry......................... 17956 | |
| Entries that use overflow......................... 241 0.33% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 2661 | |
| Overflow pages used............................... 335 | |
| Total pages used.................................. 3005 | |
| Unused bytes on index pages....................... 13666 37.1% | |
| Unused bytes on primary pages..................... 1349342 12.4% | |
| Unused bytes on overflow pages.................... 10621 0.77% | |
| Unused bytes on all pages......................... 1373629 11.2% | |
| *** Table OBJECT w/o any indices ********************************************** | |
| Percentage of total database...................... 37.0% | |
| Number of entries................................. 24714 | |
| Bytes of storage consumed......................... 11833344 | |
| Bytes of payload.................................. 10245665 86.6% | |
| Bytes of metadata................................. 225444 1.9% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 414.57 | |
| Average unused bytes per entry.................... 55.14 | |
| Average metadata per entry........................ 9.12 | |
| Average fanout.................................... 364.00 | |
| Non-sequential pages.............................. 1 0.035% | |
| Maximum payload per entry......................... 17956 | |
| Entries that use overflow......................... 241 0.98% | |
| Index pages used.................................. 7 | |
| Primary pages used................................ 2547 | |
| Overflow pages used............................... 335 | |
| Total pages used.................................. 2889 | |
| Unused bytes on index pages....................... 7027 24.5% | |
| Unused bytes on primary pages..................... 1344963 12.9% | |
| Unused bytes on overflow pages.................... 10621 0.77% | |
| Unused bytes on all pages......................... 1362611 11.5% | |
| *** Indices of table OBJECT *************************************************** | |
| Percentage of total database...................... 1.5% | |
| Number of entries................................. 49428 | |
| Bytes of storage consumed......................... 475136 | |
| Bytes of payload.................................. 313058 65.9% | |
| Bytes of metadata................................. 151060 31.8% | |
| Average payload per entry......................... 6.33 | |
| Average unused bytes per entry.................... 0.22 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 58.00 | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 114 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 116 | |
| Unused bytes on index pages....................... 6639 81.0% | |
| Unused bytes on primary pages..................... 4379 0.94% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 11018 2.3% | |
| *** Index OBJECT_HASH_ID of table OBJECT ************************************** | |
| Percentage of total database...................... 0.81% | |
| Number of entries................................. 24714 | |
| Bytes of storage consumed......................... 258048 | |
| Bytes of payload.................................. 177733 68.9% | |
| Bytes of metadata................................. 75650 29.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.19 | |
| Average unused bytes per entry.................... 0.19 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 63.00 | |
| Non-sequential pages.............................. 1 1.6% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 62 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 63 | |
| Unused bytes on index pages....................... 3205 78.2% | |
| Unused bytes on primary pages..................... 1460 0.57% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4665 1.8% | |
| *** Index OBJECT_TYPE_ID of table OBJECT ************************************** | |
| Percentage of total database...................... 0.68% | |
| Number of entries................................. 24714 | |
| Bytes of storage consumed......................... 217088 | |
| Bytes of payload.................................. 135325 62.3% | |
| Bytes of metadata................................. 75410 34.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.48 | |
| Average unused bytes per entry.................... 0.26 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 53.00 | |
| Non-sequential pages.............................. 1 1.9% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 52 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 53 | |
| Unused bytes on index pages....................... 3434 83.8% | |
| Unused bytes on primary pages..................... 2919 1.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6353 2.9% | |
| *** Table OBJECT_TYPE_DESCRIPTION and all its indices ************************* | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 8 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 110 1.3% | |
| Bytes of metadata................................. 68 0.83% | |
| Average payload per entry......................... 13.75 | |
| Average unused bytes per entry.................... 1001.75 | |
| Average metadata per entry........................ 8.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..................... 8014 97.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8014 97.8% | |
| *** Table OBJECT_TYPE_DESCRIPTION w/o any indices ***************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 54 1.3% | |
| Bytes of metadata................................. 36 0.88% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 13.50 | |
| Average unused bytes per entry.................... 1001.50 | |
| Average metadata per entry........................ 9.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..................... 4006 97.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4006 97.8% | |
| *** Index SQLITE_AUTOINDEX_OBJECT_TYPE_DESCRIPTION_1 of table OBJECT_TYPE_DESCRIPTION | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 56 1.4% | |
| Bytes of metadata................................. 32 0.78% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 14.00 | |
| Average unused bytes per entry.................... 1002.00 | |
| Average metadata per entry........................ 8.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..................... 4008 97.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4008 97.9% | |
| *** Table PROJECT and all its indices ***************************************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 102 1.2% | |
| Bytes of metadata................................. 46 0.56% | |
| Average payload per entry......................... 51.00 | |
| Average unused bytes per entry.................... 4022.00 | |
| Average metadata per entry........................ 23.00 | |
| Maximum payload per entry......................... 51 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 8044 98.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8044 98.2% | |
| *** Table PROJECT w/o any indices ********************************************* | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 51 1.2% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 51.00 | |
| Average unused bytes per entry.................... 4022.00 | |
| Average metadata per entry........................ 23.00 | |
| Maximum payload per entry......................... 51 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4022 98.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4022 98.2% | |
| *** Index SQLITE_AUTOINDEX_PROJECT_2 of table PROJECT ************************* | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 51 1.2% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 51.00 | |
| Average unused bytes per entry.................... 4022.00 | |
| Average metadata per entry........................ 23.00 | |
| Maximum payload per entry......................... 51 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4022 98.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4022 98.2% | |
| *** Table PROJECT_BRANCH and all its indices ********************************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 160 2.0% | |
| Bytes of metadata................................. 46 0.56% | |
| Average payload per entry......................... 80.00 | |
| Average unused bytes per entry.................... 3993.00 | |
| Average metadata per entry........................ 23.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..................... 7986 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7986 97.5% | |
| *** Table PROJECT_BRANCH w/o any indices ************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 80 2.0% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 80.00 | |
| Average unused bytes per entry.................... 3993.00 | |
| Average metadata per entry........................ 23.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..................... 3993 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3993 97.5% | |
| *** Index SQLITE_AUTOINDEX_PROJECT_BRANCH_2 of table PROJECT_BRANCH *********** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 80 2.0% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 80.00 | |
| Average unused bytes per entry.................... 3993.00 | |
| Average metadata per entry........................ 23.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..................... 3993 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3993 97.5% | |
| *** Table PROJECT_BRANCH_PARENT *********************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table PROJECT_BRANCH_REMOTE_MAPPING *************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 181 4.4% | |
| Bytes of metadata................................. 24 0.59% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 181.00 | |
| Average unused bytes per entry.................... 3891.00 | |
| Average metadata per entry........................ 24.00 | |
| Maximum payload per entry......................... 181 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3891 95.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3891 95.0% | |
| *** Table REFLOG and all its indices ****************************************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 86 1.0% | |
| Bytes of metadata................................. 47 0.57% | |
| Average payload per entry......................... 43.00 | |
| Average unused bytes per entry.................... 4029.50 | |
| Average metadata per entry........................ 23.50 | |
| 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..................... 8059 98.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8059 98.4% | |
| *** Table REFLOG w/o any indices ********************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 57 1.4% | |
| Bytes of metadata................................. 24 0.59% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 57.00 | |
| Average unused bytes per entry.................... 4015.00 | |
| Average metadata per entry........................ 24.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..................... 4015 98.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4015 98.0% | |
| *** Index REFLOG_TIME_DESC of table REFLOG ************************************ | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 29 0.71% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 29.00 | |
| Average unused bytes per entry.................... 4044.00 | |
| Average metadata per entry........................ 23.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..................... 4044 98.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4044 98.7% | |
| *** Table REMOTE_PROJECT ****************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 81 2.0% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 81.00 | |
| Average unused bytes per entry.................... 3992.00 | |
| Average metadata per entry........................ 23.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..................... 3992 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3992 97.5% | |
| *** Table REMOTE_PROJECT_BRANCH *********************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 112 2.7% | |
| Bytes of metadata................................. 23 0.56% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 112.00 | |
| Average unused bytes per entry.................... 3961.00 | |
| Average metadata per entry........................ 23.00 | |
| Maximum payload per entry......................... 112 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3961 96.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3961 96.7% | |
| *** Table SCHEMA_VERSION ****************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 3 0.073% | |
| Bytes of metadata................................. 24 0.59% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 3.00 | |
| Average unused bytes per entry.................... 4069.00 | |
| Average metadata per entry........................ 24.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..................... 4069 99.34% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4069 99.34% | |
| *** Table SCOPED_TERM_NAME_LOOKUP and all its indices ************************* | |
| Percentage of total database...................... 0.064% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 20480 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 100 0.49% | |
| 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..................... 20380 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 20380 99.51% | |
| *** Table SCOPED_TERM_NAME_LOOKUP w/o any indices ***************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Indices of table SCOPED_TERM_NAME_LOOKUP ********************************** | |
| Percentage of total database...................... 0.051% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 16384 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 80 0.49% | |
| 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..................... 16304 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16304 99.51% | |
| *** Index SCOPED_TERM_NAME_BY_REFERENT_LOOKUP of table SCOPED_TERM_NAME_LOOKUP | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SCOPED_TERM_NAMES_BY_NAMESPACE of table SCOPED_TERM_NAME_LOOKUP ***** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SCOPED_TERM_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT of table SCOPED_TERM_NAME_LOOKUP | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SQLITE_AUTOINDEX_SCOPED_TERM_NAME_LOOKUP_1 of table SCOPED_TERM_NAME_LOOKUP | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table SCOPED_TYPE_NAME_LOOKUP and all its indices ************************* | |
| Percentage of total database...................... 0.064% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 20480 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 100 0.49% | |
| 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..................... 20380 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 20380 99.51% | |
| *** Table SCOPED_TYPE_NAME_LOOKUP w/o any indices ***************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Indices of table SCOPED_TYPE_NAME_LOOKUP ********************************** | |
| Percentage of total database...................... 0.051% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 16384 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 80 0.49% | |
| 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..................... 16304 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16304 99.51% | |
| *** Index SCOPED_TYPE_NAME_BY_REFERENCE_LOOKUP of table SCOPED_TYPE_NAME_LOOKUP | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SCOPED_TYPE_NAMES_BY_NAMESPACE of table SCOPED_TYPE_NAME_LOOKUP ***** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SCOPED_TYPE_NAMES_BY_NAMESPACE_AND_LAST_NAME_SEGMENT of table SCOPED_TYPE_NAME_LOOKUP | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SQLITE_AUTOINDEX_SCOPED_TYPE_NAME_LOOKUP_1 of table SCOPED_TYPE_NAME_LOOKUP | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table SQLITE_SCHEMA ******************************************************* | |
| Percentage of total database...................... 0.090% | |
| Number of entries................................. 68 | |
| Bytes of storage consumed......................... 28672 | |
| Bytes of payload.................................. 18887 65.9% | |
| Bytes of metadata................................. 594 2.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 277.75 | |
| Average unused bytes per entry.................... 135.16 | |
| Average metadata per entry........................ 8.74 | |
| Average fanout.................................... 6.00 | |
| Non-sequential pages.............................. 5 83.3% | |
| Maximum payload per entry......................... 1586 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 6 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 7 | |
| Unused bytes on index pages....................... 3937 96.1% | |
| Unused bytes on primary pages..................... 5254 21.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 9191 32.1% | |
| *** Table SQUASH_RESULTS ****************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table TEMP_ENTITY and all its indices ************************************* | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 40 0.49% | |
| 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..................... 8152 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8152 99.51% | |
| *** Table TEMP_ENTITY w/o any indices ***************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index SQLITE_AUTOINDEX_TEMP_ENTITY_1 of table TEMP_ENTITY ***************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table TEMP_ENTITY_MISSING_DEPENDENCY and all its indices ****************** | |
| Percentage of total database...................... 0.051% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 16384 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 80 0.49% | |
| 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..................... 16304 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16304 99.51% | |
| *** Table TEMP_ENTITY_MISSING_DEPENDENCY w/o any indices ********************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Indices of table TEMP_ENTITY_MISSING_DEPENDENCY *************************** | |
| Percentage of total database...................... 0.038% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 60 0.49% | |
| 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..................... 12228 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12228 99.51% | |
| *** Index SQLITE_AUTOINDEX_TEMP_ENTITY_MISSING_DEPENDENCY_1 of table TEMP_ENTITY_MISSING_DEPENDENCY | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENCY of table TEMP_ENTITY_MISSING_DEPENDENCY | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index TEMP_ENTITY_MISSING_DEPENDENCY_IX_DEPENDENT of table TEMP_ENTITY_MISSING_DEPENDENCY | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table TEMP_ENTITY_TYPE_DESCRIPTION and all its indices ******************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 10 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 129 1.6% | |
| Bytes of metadata................................. 75 0.92% | |
| Average payload per entry......................... 12.90 | |
| Average unused bytes per entry.................... 798.80 | |
| Average metadata per entry........................ 7.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..................... 7988 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7988 97.5% | |
| *** Table TEMP_ENTITY_TYPE_DESCRIPTION w/o any indices ************************ | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 5 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 63 1.5% | |
| Bytes of metadata................................. 40 0.98% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 12.60 | |
| Average unused bytes per entry.................... 798.60 | |
| Average metadata per entry........................ 8.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..................... 3993 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3993 97.5% | |
| *** Index SQLITE_AUTOINDEX_TEMP_ENTITY_TYPE_DESCRIPTION_1 of table TEMP_ENTITY_TYPE_DESCRIPTION | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 5 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 66 1.6% | |
| Bytes of metadata................................. 35 0.85% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 13.20 | |
| Average unused bytes per entry.................... 799.00 | |
| Average metadata per entry........................ 7.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..................... 3995 97.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3995 97.5% | |
| *** Table TEXT and all its indices ******************************************** | |
| Percentage of total database...................... 1.2% | |
| Number of entries................................. 20234 | |
| Bytes of storage consumed......................... 376832 | |
| Bytes of payload.................................. 279860 74.3% | |
| Bytes of metadata................................. 83203 22.1% | |
| Average payload per entry......................... 13.83 | |
| Average unused bytes per entry.................... 0.68 | |
| Average metadata per entry........................ 4.11 | |
| Average fanout.................................... 45.00 | |
| Maximum payload per entry......................... 1030 | |
| Entries that use overflow......................... 1 0.005% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 89 | |
| Overflow pages used............................... 1 | |
| Total pages used.................................. 92 | |
| Unused bytes on index pages....................... 6649 81.2% | |
| Unused bytes on primary pages..................... 3583 0.98% | |
| Unused bytes on overflow pages.................... 3537 86.4% | |
| Unused bytes on all pages......................... 13769 3.7% | |
| *** Table TEXT w/o any indices ************************************************ | |
| Percentage of total database...................... 0.59% | |
| Number of entries................................. 10117 | |
| Bytes of storage consumed......................... 188416 | |
| Bytes of payload.................................. 129877 68.9% | |
| Bytes of metadata................................. 51745 27.5% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 12.84 | |
| Average unused bytes per entry.................... 0.67 | |
| Average metadata per entry........................ 5.11 | |
| Average fanout.................................... 45.00 | |
| Non-sequential pages.............................. 1 2.2% | |
| Maximum payload per entry......................... 1028 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 45 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 46 | |
| Unused bytes on index pages....................... 3720 90.8% | |
| Unused bytes on primary pages..................... 3074 1.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6794 3.6% | |
| *** Index SQLITE_AUTOINDEX_TEXT_1 of table TEXT ******************************* | |
| Percentage of total database...................... 0.59% | |
| Number of entries................................. 10117 | |
| Bytes of storage consumed......................... 188416 | |
| Bytes of payload.................................. 149983 79.6% | |
| Bytes of metadata................................. 31458 16.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 14.82 | |
| Average unused bytes per entry.................... 0.69 | |
| Average metadata per entry........................ 3.11 | |
| Average fanout.................................... 45.00 | |
| Non-sequential pages.............................. 0 0.0% | |
| Maximum payload per entry......................... 1030 | |
| Entries that use overflow......................... 1 0.010% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 44 | |
| Overflow pages used............................... 1 | |
| Total pages used.................................. 46 | |
| Unused bytes on index pages....................... 2929 71.5% | |
| Unused bytes on primary pages..................... 509 0.28% | |
| Unused bytes on overflow pages.................... 3537 86.4% | |
| Unused bytes on all pages......................... 6975 3.7% | |
| *** Table WATCH and all its indices ******************************************* | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 40 0.49% | |
| 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..................... 8152 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8152 99.51% | |
| *** Table WATCH w/o any indices *********************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Index WATCH_KIND of table WATCH ******************************************* | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** Table WATCH_KIND_DESCRIPTION and all its indices ************************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 34 0.42% | |
| Bytes of metadata................................. 54 0.66% | |
| Average payload per entry......................... 8.50 | |
| Average unused bytes per entry.................... 2026.00 | |
| Average metadata per entry........................ 13.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..................... 8104 98.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8104 98.9% | |
| *** Table WATCH_KIND_DESCRIPTION w/o any indices ****************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 17 0.42% | |
| Bytes of metadata................................. 28 0.68% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 8.50 | |
| Average unused bytes per entry.................... 2025.50 | |
| Average metadata per entry........................ 14.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..................... 4051 98.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4051 98.9% | |
| *** Index SQLITE_AUTOINDEX_WATCH_KIND_DESCRIPTION_1 of table WATCH_KIND_DESCRIPTION | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 17 0.42% | |
| Bytes of metadata................................. 26 0.63% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 8.50 | |
| Average unused bytes per entry.................... 2026.50 | |
| Average metadata per entry........................ 13.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..................... 4053 99.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4053 99.0% | |
| *** Table WATCH_RESULT ******************************************************** | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 20 0.49% | |
| 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..................... 4076 99.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4076 99.51% | |
| *** 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,73,68,2,18887,0,0,1586,1,6,0,3937,5254,0,5,28672); | |
| INSERT INTO space_used VALUES('schema_version','schema_version',0,0,1,1,1,3,0,0,3,0,1,0,0,4069,0,0,4096); | |
| INSERT INTO space_used VALUES('hash','hash',0,0,44927,43713,3,4677291,0,0,107,4,1215,0,5820,29281,0,1,4993024); | |
| INSERT INTO space_used VALUES('text','text',0,0,10161,10117,2,129877,0,0,1028,1,45,0,3720,3074,0,1,188416); | |
| INSERT INTO space_used VALUES('sqlite_autoindex_text_1','text',1,0,10117,10074,2,149983,543,1,1030,1,44,1,2929,509,3537,0,188416); | |
| INSERT INTO space_used VALUES('hash_object','hash_object',0,0,24790,24714,2,172870,0,0,7,1,77,0,3417,2912,0,1,319488); | |
| INSERT INTO space_used VALUES('object_type_description','object_type_description',0,0,4,4,1,54,0,0,17,0,1,0,0,4006,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,4008,0,0,4096); | |
| INSERT INTO space_used VALUES('object','object',0,0,27260,24714,3,10245665,1356179,241,17956,7,2547,335,7027,1344963,10621,1,11833344); | |
| INSERT INTO space_used VALUES('causal','causal',0,0,12669,12635,2,66643,0,0,6,1,35,0,3770,2208,0,1,147456); | |
| INSERT INTO space_used VALUES('namespace_root','namespace_root',0,0,1,1,1,2,0,0,2,0,1,0,0,4068,0,0,4096); | |
| INSERT INTO space_used VALUES('causal_parent','causal_parent',0,1,9071,9047,2,72334,0,0,9,1,25,0,3710,2619,0,1,106496); | |
| INSERT INTO space_used VALUES('causal_metadata','causal_metadata',0,1,0,0,1,0,0,0,0,0,1,0,0,4076,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,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('watch','watch',0,1,0,0,1,0,0,0,0,0,1,0,0,4076,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,4051,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,4053,0,0,4096); | |
| INSERT INTO space_used VALUES('find_type_index','find_type_index',0,0,13061,13010,2,143780,0,0,13,1,52,0,3664,3249,0,1,217088); | |
| INSERT INTO space_used VALUES('sqlite_autoindex_find_type_index_1','find_type_index',1,0,13010,12972,2,116961,0,0,10,1,39,0,3463,3430,0,1,163840); | |
| INSERT INTO space_used VALUES('find_type_mentions_index','find_type_mentions_index',0,0,49798,49598,2,536346,0,0,13,1,201,0,2335,1852,0,1,827392); | |
| INSERT INTO space_used VALUES('dependents_index','dependents_index',0,0,146538,145977,3,1425305,0,0,10,3,562,0,7225,6055,0,1,2314240); | |
| INSERT INTO space_used VALUES('name_lookups','name_lookups',0,0,0,0,1,0,0,0,0,0,1,0,0,4076,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,3993,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,3995,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,4076,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,4076,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,4076,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,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('namespace_statistics','namespace_statistics',0,0,3425,3417,2,18135,0,0,10,1,9,0,4005,381,0,1,40960); | |
| INSERT INTO space_used VALUES('reflog','reflog',0,0,1,1,1,57,0,0,57,0,1,0,0,4015,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,4076,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,4076,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,4076,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,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('project','project',0,1,1,1,1,51,0,0,51,0,1,0,0,4022,0,0,4096); | |
| INSERT INTO space_used VALUES('sqlite_autoindex_project_2','project',1,0,1,1,1,51,0,0,51,0,1,0,0,4022,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,3993,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,3993,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,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('project_branch_remote_mapping','project_branch_remote_mapping',0,1,1,1,1,181,0,0,181,0,1,0,0,3891,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,3992,0,0,4096); | |
| INSERT INTO space_used VALUES('remote_project_branch','remote_project_branch',0,1,1,1,1,112,0,0,112,0,1,0,0,3961,0,0,4096); | |
| INSERT INTO space_used VALUES('most_recent_branch','most_recent_branch',0,1,0,0,1,0,0,0,0,0,1,0,0,4076,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,4076,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,4076,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,3965,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,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('hash_base32','hash',1,0,43713,42532,3,4775535,0,0,110,34,1182,0,1144,43738,0,1,4980736); | |
| INSERT INTO space_used VALUES('hash_object_object_id','hash_object',1,0,24714,24653,2,177733,0,0,8,1,62,0,3205,1460,0,1,258048); | |
| INSERT INTO space_used VALUES('object_hash_id','object',1,0,24714,24653,2,177733,0,0,8,1,62,0,3205,1460,0,1,258048); | |
| INSERT INTO space_used VALUES('object_type_id','object',1,0,24714,24663,2,135325,0,0,6,1,52,0,3434,2919,0,1,217088); | |
| INSERT INTO space_used VALUES('causal_value_hash_id','causal',1,0,12635,12603,2,96592,0,0,9,1,33,0,3601,354,0,1,139264); | |
| INSERT INTO space_used VALUES('causal_parent_causal_id','causal_parent',1,0,9071,9047,2,72334,0,0,9,1,25,0,3710,2619,0,1,106496); | |
| INSERT INTO space_used VALUES('causal_parent_parent_id','causal_parent',1,0,9071,9047,2,72334,0,0,9,1,25,0,3710,2619,0,1,106496); | |
| INSERT INTO space_used VALUES('causal_metadata_causal_id','causal_metadata',1,0,0,0,1,0,0,0,0,0,1,0,0,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('watch_kind','watch',1,0,0,0,1,0,0,0,0,0,1,0,0,4076,0,0,4096); | |
| INSERT INTO space_used VALUES('find_type_index_type','find_type_index',1,0,13010,12972,2,117633,0,0,10,1,39,0,3461,2760,0,1,163840); | |
| INSERT INTO space_used VALUES('find_type_mentions_index_type','find_type_mentions_index',1,0,49598,49451,2,454137,0,0,11,1,148,0,1691,2110,0,1,610304); | |
| INSERT INTO space_used VALUES('dependents_by_dependency','dependents_index',1,0,145977,145529,3,1392708,0,0,10,3,449,0,4779,5130,0,1,1851392); | |
| INSERT INTO space_used VALUES('dependencies_by_dependent','dependents_index',1,0,145977,145556,3,1280600,0,0,9,3,422,0,5568,6505,0,1,1740800); | |
| 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,4076,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,4076,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,4044,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,4076,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,4076,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,4076,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,4076,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,4076,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,4076,0,0,4096); | |
| COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment