Page size in bytes................................ 4096 Pages in the whole file (measured)................ 83233 Pages in the whole file (calculated).............. 83233 Pages that store data............................. 83056 99.79% Pages on the freelist (per header)................ 75 0.090% Pages on the freelist (calculated)................ 75 0.090% Pages of auto-vacuum overhead..................... 102 0.12% Number of tables in the database.................. 9 Number of indices................................. 11 Number of defined indices......................... 10 Number of implied indices......................... 1 Size of the file in bytes......................... 340922368 Bytes of user payload stored...................... 232178959 68.1% *** Page counts for all tables with their indices ***************************** ZCOLLECTIONMD..................................... 66654 80.1% ZCOLLECTION....................................... 10174 12.2% Z_3CHILDCOLLECTIONS............................... 6218 7.5% ZCATALOGROOT...................................... 3 0.004% ZCATALOGROOTMD.................................... 3 0.004% Z_METADATA........................................ 1 0.001% Z_MODELCACHE...................................... 1 0.001% Z_PRIMARYKEY...................................... 1 0.001% SQLITE_SCHEMA..................................... 1 0.001% *** Page counts for all tables and indices separately ************************* ZCOLLECTIONMD..................................... 65555 78.8% ZCOLLECTION....................................... 5641 6.8% ZCOLLECTION_ZIDENTIFIER_INDEX..................... 2444 2.9% SQLITE_AUTOINDEX_Z_3CHILDCOLLECTIONS_1............ 2356 2.8% Z_3CHILDCOLLECTIONS_Z_3CHILDCOLLECTIONS_INDEX..... 2003 2.4% Z_3CHILDCOLLECTIONS............................... 1859 2.2% ZCOLLECTION_ZMETADATA_INDEX....................... 1123 1.3% ZCOLLECTION_ZCATALOG_INDEX........................ 966 1.2% ZCOLLECTIONMD_ZCOLLECTION_INDEX................... 622 0.75% ZCOLLECTIONMD_ZIDENTIFIER_INDEX................... 477 0.57% ZCATALOGROOT...................................... 1 0.001% ZCATALOGROOTMD.................................... 1 0.001% ZCATALOGROOTMD_ZCATALOG_INDEX..................... 1 0.001% ZCATALOGROOTMD_ZIDENTIFIER_INDEX.................. 1 0.001% ZCATALOGROOT_ZIDENTIFIER_INDEX.................... 1 0.001% ZCATALOGROOT_ZMETADATA_INDEX...................... 1 0.001% Z_METADATA........................................ 1 0.001% Z_MODELCACHE...................................... 1 0.001% Z_PRIMARYKEY...................................... 1 0.001% SQLITE_SCHEMA..................................... 1 0.001%