sqlite-analyzer for @unison/base/main

gistfile1.txt

/** 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;