python /home/admin/mtr/script_for_cron.py -j default -m 30 -a 'python3 ~/workarea/git/Velours/python/mtr/sql_queries.py -j status ' -s monitor_queries -M 0 -S 0 -U 120,120,120
 import MySQLdb succeeded 
Now: 25/04/2025, 07:00:25

Nombre de datou current
('date', 'nombre de datou current')
('2025-04-25 07:00:25', 93)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-04-25 07:00:25', 779329)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-04-25 07:01:05', 22776)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-04-25 07:01:05', 701)

Reste a faire par datou id
('date', 'datou_id', 'total_a_traiter', 'total_traite', 'restant_a_traite', 'datou_nom', 'temps moyens passe des datous a traiter (heures)', 'list_port_ids_mtr_user_ids')
('2025-04-25 07:01:11', 4892, 1326, 1006, 320, 'multi_classification_tapis_dechet', 6.0, '22406772:angers_mon:1017:1', 1)
('2025-04-25 07:01:11', 4310, 1086, 846, 240, 'classifieur_2camions_valcor_021122_v1', 3.0, '22415669:dechet_val:991:1', 1)
('2025-04-25 07:01:11', 533, 5842, 5787, 55, 'multi_classification_tapis_dechet', 54.333333333333336, '22228700:aec_metal_:979:1,22406937:aec_metal_:979:1,22407395:jetson_new:983:1', 3)
('2025-04-25 07:01:11', 4433, 85, 45, 40, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 17.0, '22382412:JRM_diff_b:1053:0', 1)
('2025-04-25 07:01:11', 4219, 57, 26, 31, 'detection_plaque_valcor_010622', 6.0, '22408283:plaque_val:1064:0', 1)
('2025-04-25 07:01:11', 4871, 1426, 1413, 13, 'blur_rubbia_live', 7.0, '22406770:arc_en_cie:979:0', 1)
('2025-04-25 07:01:11', 4877, 19, 16, 3, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '22419536:JRM_diff_b:979:1,22419675:JRM_diff_b:979:1,22420042:JRM_diff_b:979:1,22420068:JRM_diff_b:979:1', 4)
('2025-04-25 07:01:11', 4234, 6, 6, 0, 'refus_rym_velours_valcor', 0.0, '22419937:incinerati:1103:1,22419935:incinerati:1103:1,22419938:incinerati:1103:1', 3)

Reste a faire par datou id non traite
('date', 'datou_id', 'total_a_traiter', 'datou_nom', 'temps moyens passe des datous a traiter (heures)', 'list_port_ids_mtr_user_ids', 'nb_port')
('2025-04-25 07:01:13', 3142, 46, 'STS_refus_Amiens', Decimal('0.0000'), '22407395:jetson_new:983:0', 1)
('2025-04-25 07:01:13', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('579.0000'), '4453926:jrm_diff_b:739:0,4652336:jrm_diff_b:739:0,4756245:jrm_diff_b:739:0,4938484:jrm_diff_b:739:0,4938485:jrm_diff_b:739:0,4938486:jrm_diff_b:739:0,4938487:jrm_diff_b:739:0,4938488:jrm_diff_b:739:0', 8)
('2025-04-25 07:01:13', 4220, 2650, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '22364766:plaque_val:1064:0,22408283:plaque_val:1064:0', 2)
('2025-04-25 07:01:13', 4877, 32, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '22420040:JRM_diff_b:979:0,22420043:JRM_diff_b:979:0,22420121:JRM_diff_b:979:0,22420122:JRM_diff_b:979:0,22420123:JRM_diff_b:979:1,22420124:JRM_diff_b:979:0', 6)
('2025-04-25 07:01:13', 4878, 3390, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '22364229:arc_en_cie:979:0', 1)
('2025-04-25 07:01:13', 4887, 7921, 'split_time_score_Sevran_test', Decimal('0.0000'), '22370575:sevran_122:1042:0', 1)
('2025-04-25 07:01:13', 4891, 6592, 'split_time_score_angers_montee_convoyeur', Decimal('0.0000'), '22364068:angers_mon:1017:0', 1)
('2025-04-25 07:01:13', 4893, 84, 'split_time_score_Sevran_test2', Decimal('0.0000'), '22364476:Test_PRINE:739:0', 1)
('2025-04-25 07:01:13', 4916, 2010, 'split_time_score_Acier_Arc_En_Ciel', Decimal('0.0000'), '22406937:aec_metal_:979:0', 1)

Nombre de photos d'entrees traites par datou dans les dernieres 24 heures pour les traitement (datou_current) en cours
('date', 'datou_id', 'Nombre de photos traitees', 'datou_nom')
('2025-04-25 07:01:13', 533, 7497, 'multi_classification_tapis_dechet')
('2025-04-25 07:01:13', 4433, 405, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-04-25 07:01:13', 4871, 1413, 'blur_rubbia_live')
('2025-04-25 07:01:13', 4892, 2928, 'multi_classification_tapis_dechet')
('2025-04-25 07:01:13', 4219, 52, 'detection_plaque_valcor_010622')
('2025-04-25 07:01:13', 4310, 2122, 'classifieur_2camions_valcor_021122_v1')
('2025-04-25 07:01:13', 4877, 92, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-04-25 07:01:13', 4234, 9, 'refus_rym_velours_valcor')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 14)
(0, 81)
(-5, 9)

Nombre de resultats de type photos par datou dans les dernieres 24 heures (plusieurs photos de sorties par photos d'entree)
('date', 'datou_id', 'Nombre de photos traitees', 'datou_nom')
('2025-04-25 07:01:20', 4234, 230672, 'refus_rym_velours_valcor')
('2025-04-25 07:01:20', 4876, 70993, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-04-25 07:01:20', 4883, 70986, 'split_time_score_JRM_Arc_En_Ciel')
('2025-04-25 07:01:20', 4877, 45478, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-04-25 07:01:20', 4892, 41751, 'multi_classification_tapis_dechet')
('2025-04-25 07:01:20', 4302, 39222, 'RUBBIA_JRM_consolidate')
('2025-04-25 07:01:20', 533, 33868, 'multi_classification_tapis_dechet')
('2025-04-25 07:01:20', 3804, 30911, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-04-25 07:01:20', 4893, 29850, 'split_time_score_Sevran_test2')
('2025-04-25 07:01:20', 4322, 25986, 'RUBBIA_filmPE_151122')
('2025-04-25 07:01:20', 4310, 22920, 'classifieur_2camions_valcor_021122_v1')
('2025-04-25 07:01:20', 3993, 20676, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-04-25 07:01:20', 3459, 15247, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-04-25 07:01:20', 3994, 14842, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-04-25 07:01:20', 3385, 13734, 'split_time_score_JRM_Arc_En_Ciel_peu_dense')
('2025-04-25 07:01:20', 3995, 9438, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-04-25 07:01:20', 4925, 8120, 'RUBBIA_PEHD_240325_derichebourg')
('2025-04-25 07:01:20', 3318, 7531, 'RUBBIA_Refus_mask_simple_non_aussi_rle')
('2025-04-25 07:01:20', 4748, 6941, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-04-25 07:01:20', 4871, 4204, 'blur_rubbia_live')
('2025-04-25 07:01:20', 4311, 4200, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-04-25 07:01:20', 4891, 3900, 'split_time_score_angers_montee_convoyeur')
('2025-04-25 07:01:20', 4887, 2920, 'split_time_score_Sevran_test')
('2025-04-25 07:01:20', 4926, 2804, 'RUBBIA_fluxdev_angers_280325')
('2025-04-25 07:01:20', 4220, 2761, 'split_time_score_plaque_Valcor')
('2025-04-25 07:01:20', 4433, 2615, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-04-25 07:01:20', 3996, 2361, 'RUBBIA_Refus_add_surclassifier_rapport')
('2025-04-25 07:01:20', 4916, 1900, 'split_time_score_Acier_Arc_En_Ciel')
('2025-04-25 07:01:20', 3991, 1894, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-04-25 07:01:20', 4323, 1520, 'split_time_score_arc_en_ciel_mm')
('2025-04-25 07:01:20', 4153, 1462, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-04-25 07:01:20', 3142, 1208, 'STS_refus_Amiens')
('2025-04-25 07:01:20', 3992, 1170, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-04-25 07:01:20', 4189, 1116, 'split_time_score_JRM_Perlen_convoyeur')
('2025-04-25 07:01:20', 4850, 910, 'split_time_score_SCCU_7')
('2025-04-25 07:01:20', 4849, 880, 'split_time_score_SCCU_6')
('2025-04-25 07:01:20', 4851, 794, 'split_time_score_SCCU_8')
('2025-04-25 07:01:20', 4878, 700, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-04-25 07:01:20', 3789, 232, 'split_time_score_test_multi_matiere')
('2025-04-25 07:01:20', 4219, 74, 'detection_plaque_valcor_010622')
('2025-04-25 07:01:20', 3787, 64, 'split_time_score_urban_fest')
('2025-04-25 07:01:20', 3181, 33, 'split_time_score_JRM_Arc_En_Ciel')
('2025-04-25 07:01:20', 243, 26, 'prepare_varroa_ellipse_tile_rotate_whiten')
('2025-04-25 07:01:20', 370, 25, 'proportion_papier_qualite_dechets_tri')
('2025-04-25 07:01:20', 3164, 14, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321')
('2025-04-25 07:01:20', 2719, 12, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-04-25 07:01:20', 40, 11, 'mask_coco_origin')
('2025-04-25 07:01:20', 4212, 10, 'ACP_from_port_5709050_type_5619_size_9')
('2025-04-25 07:01:20', 4209, 10, 'test_acp')
('2025-04-25 07:01:20', 4208, 10, 'test_acp_fit_transform_20')
('2025-04-25 07:01:20', 686, 9, 'copy_argmax_crop')
('2025-04-25 07:01:20', 4573, 9, 'test_sam_h')
('2025-04-25 07:01:20', 3781, 7, 'cod_pipeline_Perlen_manuel_sts_test')
('2025-04-25 07:01:20', 4567, 6, 'tfhub_19_06_2023')
('2025-04-25 07:01:20', 4621, 6, 'tfhub_18_7_2023')
('2025-04-25 07:01:20', 1026, 5, 'mask_coco_for_test')
('2025-04-25 07:01:20', 1848, 5, 'Pipeline_upm_photos_blanches')
('2025-04-25 07:01:20', 3990, 5, 'test_crop_condition_blur')
('2025-04-25 07:01:20', 2896, 5, 'test_radom_deformation')
('2025-04-25 07:01:20', 3070, 5, 'test_ventilate_hashtag_type_3326')
('2025-04-25 07:01:20', 230, 4, 'datou_test_rotate')
('2025-04-25 07:01:20', 3856, 4, 'RUBBIA_Carton_050821_extract_RYM')
('2025-04-25 07:01:20', 4553, 2, 'copie_4387_test_replace')
('2025-04-25 07:01:20', 4492, 2, 'copie_4387_test_replace')
('2025-04-25 07:01:20', 4184, 2, 'detection_plaque_valcor_010622')
('2025-04-25 07:01:20', 233, 2, 'datou_test_rotate_conditionnel')
('2025-04-25 07:01:20', 2085, 1, 'train_points_upm_darker')
('2025-04-25 07:01:20', 2041, 1, 'test_data_aug')
('2025-04-25 07:01:20', 1818, 1, 'blanchir')
('2025-04-25 07:01:20', 571, 1, 'datou_test_flip')
('2025-04-25 07:01:20', 2, 1, 'classification_model')

Nombre de lignes inserees dans la table crop segments depuis une semaine, par hashtag type
('hashtag type id', 'Nombre de ligne dans crop_segments depuis 7 jours')
('d4018_output_mask', 6417139)
('datou_4322_rle', 1116882)
('PhotoDescForrotata_polygone', 788928)
('d4018_output_rle', 755475)
('learn_RUBBIA_REFUS_AMIENS_23', 604238)
('merge_pipeline_rubbia_jrm_details_3459', 562532)
('PhotoDescForlabels_result_test_step_tile', 93984)
('varroa_from_ellipse_tiled_rotate_shrink_whiten_ok', 41895)
('pht_test_rle_unique_nms_output', 29558)
('datou_3993_rle', 14384)
('test_non_regreg_generate_new_image', 2748)
('detection_filter_test', 1600)
('mask_coco_origin', 1530)

Nombre total de sub photos associees à chaque hashtag type
('hashtag type id', 'hashtag type name', 'Nombre de photos total')
(17, 'photo_tile_type', 2289221)
(311, 'PhotoDescForImmat_307', 9078)
(407, 'PhotoDescForvarroa_2102', 80993)
(429, 'crop_varroa_1303_428', 63)
(445, 'mask_coco_origin', 32)
(451, 'mask_voiture_446_2303', 1408)
(611, 'detect_vignette_CG_1805', 108)
(612, 'detect_date_CG_1805', 235)
(654, 'detect_parechoc_av', 16185)
(728, 'automatic_algo_surf', 1612)
(755, 'mask_rayure_reflet0308', 128560)
(757, 'learn_piece_voiture_0808_v2', 5)
(859, 'crop_bca_piece_151018', 19151)
(886, 'faster_filtre_dup_gao_2510', 15)
(894, 'crop_bca_aile_avd_0611', 18632)
(987, 'faster_filtre_0512_datou_990', 3)
(989, 'type_test_datou_991_1', 4)
(1029, 'PhotoDescFordetection_cheval', 2)
(1032, 'cheval_2201', 92)
(1110, 'PhotoDescForphoto_type_tile_lange', 7397)
(1489, 'varroa_tile_prediag', 58450)
(1522, 'tile_bande_upm', 19989)
(1766, 'frcnn_plates_cropper_280819_v3', 120)
(1805, 'frcnn_plates_cropper_09092019_v1', 97)
(1850, 'PhotoDescForPhotoDescForlabelisation_manu_broisaint_v1', 4276)
(1884, 'crops_dechets_jx3', 9085)
(1957, 'PhotoDescFormask_refus_upm', 206)
(2152, 'PhotoDescFormask_upm_photographe_blanches', 75)
(2309, 'Mask_dechet_Plastique_Clair_Rubbia_jx', 309)
(2430, 'type_intermediaire_datou_2175', 9)
(2478, 'PhotoDescFormerge_mask_upm_2394_2368_2152_1957', 19792)
(2491, 'PhotoDescForbroca_mask_manu_v2', 6366)
(2560, 'Mask_dechet_Broca_v3_1', 375)
(2584, 'learn_mask_emballages_circpack', 21258)
(2642, 'PhotoDescForrubbia_pet_clair_vs_contaminants', 364)
(2714, 'Mask_dechet_Plastique_Clair_Rubbia_23072020_2664_kmean_pet_and_error_all_quatro', 248)
(2745, 'Mask_dechet_Plastique_Clair_Rubbia_30072020_2692_kmean_connex_pet_and_error_clean__more_4K', 4512)
(2748, 'PhotoDescFormask_qualipapia_vlg_gravi', 75)
(2758, 'Mask_dechet_Plastique_Clai