SELECT count(*) FROM mra_hashtags; read_nb_lines : (27,) SELECT count(*) FROM sqlite_sequence; read_nb_lines : (3,) SELECT count(*) FROM mra_cache_counter; read_nb_lines : (770,) SELECT count(*) FROM mra_photos; read_nb_lines : (51488,) SELECT count(*) FROM mra_photo_hashtag_ids; read_nb_lines : (0,) SELECT count(*) FROM mra_portfolios; read_nb_lines : (0,) SELECT count(*) FROM mra_portfolio_photos; read_nb_lines : (0,) SELECT count(*) FROM mra_gps; read_nb_lines : (0,) size : 9711616 data_start : {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (770,), 'mra_photos_nb_lines': (51488,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 9711616} Starting time : 1770644822.2917302 NoneElapsed time : 4.0531158447265625e-06 clean mra_photosElapsed time : 0.06359171867370605 VACUUMElapsed time : 9.403650760650635 SELECT count(*) FROM mra_photos; read_nb_lines : (51487,) size : 9703424 data_end : {'mra_photos_nb_lines': (51487,), 'size_file': 9703424} {'start': {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (770,), 'mra_photos_nb_lines': (51488,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 9711616}, 'end': {'mra_photos_nb_lines': (51487,), 'size_file': 9703424}} SELECT count(*) FROM mra_hashtags; read_nb_lines : (27,) SELECT count(*) FROM sqlite_sequence; read_nb_lines : (3,) SELECT count(*) FROM mra_cache_counter; read_nb_lines : (770,) SELECT count(*) FROM mra_photos; read_nb_lines : (59599,) SELECT count(*) FROM mra_photo_hashtag_ids; read_nb_lines : (0,) SELECT count(*) FROM mra_portfolios; read_nb_lines : (0,) SELECT count(*) FROM mra_portfolio_photos; read_nb_lines : (0,) SELECT count(*) FROM mra_gps; read_nb_lines : (0,) size : 11292672 data_start : {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (770,), 'mra_photos_nb_lines': (59599,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 11292672} Starting time : 1770651422.307729 NoneElapsed time : 4.291534423828125e-06 clean mra_photosElapsed time : 0.27551984786987305 VACUUMElapsed time : 1.9588274955749512 SELECT count(*) FROM mra_photos; read_nb_lines : (55068,) size : 10366976 data_end : {'mra_photos_nb_lines': (55068,), 'size_file': 10366976} {'start': {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (770,), 'mra_photos_nb_lines': (59599,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 11292672}, 'end': {'mra_photos_nb_lines': (55068,), 'size_file': 10366976}}