Page size in bytes................................ 4096 Pages in the whole file (measured)................ 163283 Pages in the whole file (calculated).............. 163283 Pages that store data............................. 161778 99.08% Pages on the freelist (per header)................ 1305 0.80% Pages on the freelist (calculated)................ 1305 0.80% Pages of auto-vacuum overhead..................... 200 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......................... 668807168 Bytes of user payload stored...................... 448391404 67.0% *** Page counts for all tables with their indices ***************************** ZCOLLECTIONMD..................................... 132958 81.4% ZCOLLECTION....................................... 18362 11.2% Z_3CHILDCOLLECTIONS............................... 10448 6.4% ZCATALOGROOT...................................... 3 0.002% ZCATALOGROOTMD.................................... 3 0.002% Z_METADATA........................................ 1 0.0% Z_MODELCACHE...................................... 1 0.0% Z_PRIMARYKEY...................................... 1 0.0% SQLITE_SCHEMA..................................... 1 0.0% *** Page counts for all tables and indices separately ************************* ZCOLLECTIONMD..................................... 130761 80.1% ZCOLLECTION....................................... 10147 6.2% ZCOLLECTION_ZIDENTIFIER_INDEX..................... 4694 2.9% SQLITE_AUTOINDEX_Z_3CHILDCOLLECTIONS_1............ 4228 2.6% Z_3CHILDCOLLECTIONS_Z_3CHILDCOLLECTIONS_INDEX..... 3237 2.0% Z_3CHILDCOLLECTIONS............................... 2983 1.8% ZCOLLECTION_ZMETADATA_INDEX....................... 1918 1.2% ZCOLLECTION_ZCATALOG_INDEX........................ 1603 0.98% ZCOLLECTIONMD_ZCOLLECTION_INDEX................... 1256 0.77% ZCOLLECTIONMD_ZIDENTIFIER_INDEX................... 941 0.58% ZCATALOGROOT...................................... 1 0.0% ZCATALOGROOTMD.................................... 1 0.0% ZCATALOGROOTMD_ZCATALOG_INDEX..................... 1 0.0% ZCATALOGROOTMD_ZIDENTIFIER_INDEX.................. 1 0.0% ZCATALOGROOT_ZIDENTIFIER_INDEX.................... 1 0.0% ZCATALOGROOT_ZMETADATA_INDEX...................... 1 0.0% Z_METADATA........................................ 1 0.0% Z_MODELCACHE...................................... 1 0.0% Z_PRIMARYKEY...................................... 1 0.0% SQLITE_SCHEMA..................................... 1 0.0%