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: 06/05/2025, 00:01:26

Nombre de datou current
('date', 'nombre de datou current')
('2025-05-06 00:01:26', 113)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-05-06 00:01:26', 757566)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-05-06 00:02:02', 66)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-05-06 00:02:02', 3455)

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-05-06 00:02:04', 4219, 6643, 3415, 3228, 'detection_plaque_valcor_010622', 32.0, '22649834:plaque_val:1064:0,22657070:plaque_val:1064:0', 2)
('2025-05-06 00:02:04', 4892, 6017, 5873, 144, 'multi_classification_tapis_dechet', 18.0, '22657876:angers_mon:1017:1', 1)
('2025-05-06 00:02:04', 3804, 125, 80, 45, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 1.0, '22697096:pet_clair_:1042:1', 1)
('2025-05-06 00:02:04', 533, 8071, 8039, 32, 'multi_classification_tapis_dechet', 18.0, '22656387:aec_metal_:979:1,22656417:aec_metal_:979:0,22659820:arc_en_cie:979:0', 3)
('2025-05-06 00:02:04', 4310, 7206, 7200, 6, 'classifieur_2camions_valcor_021122_v1', 164.0, '22483834:dechet_val:991:0', 1)
('2025-05-06 00:02:04', 4234, 4, 4, 0, 'refus_rym_velours_valcor', 0.0, '22700218:incinerati:1103:1', 1)

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-05-06 00:02:05', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('836.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)

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-05-06 00:02:05', 4219, 4992, 'detection_plaque_valcor_010622')
('2025-05-06 00:02:05', 533, 24105, 'multi_classification_tapis_dechet')
('2025-05-06 00:02:05', 4892, 16429, 'multi_classification_tapis_dechet')
('2025-05-06 00:02:05', 3804, 640, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-05-06 00:02:05', 4234, 4, 'refus_rym_velours_valcor')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 9)
(0, 105)
(-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-05-06 00:02:13', 4234, 244435, 'refus_rym_velours_valcor')
('2025-05-06 00:02:13', 4883, 55364, 'split_time_score_JRM_Arc_En_Ciel')
('2025-05-06 00:02:13', 4876, 54665, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-05-06 00:02:13', 4935, 54462, 'split_time_score_JRM_Arc_En_Ciel_merge')
('2025-05-06 00:02:13', 4892, 36172, 'multi_classification_tapis_dechet')
('2025-05-06 00:02:13', 533, 33159, 'multi_classification_tapis_dechet')
('2025-05-06 00:02:13', 4877, 31824, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-05-06 00:02:13', 4893, 29755, 'split_time_score_Sevran_test2')
('2025-05-06 00:02:13', 4310, 25848, 'classifieur_2camions_valcor_021122_v1')
('2025-05-06 00:02:13', 3996, 22542, 'RUBBIA_Refus_add_surclassifier_rapport')
('2025-05-06 00:02:13', 3993, 20671, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-05-06 00:02:13', 4322, 15878, 'RUBBIA_filmPE_151122')
('2025-05-06 00:02:13', 3804, 15462, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-05-06 00:02:13', 3459, 15225, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-06 00:02:13', 3385, 13418, 'split_time_score_JRM_Arc_En_Ciel_peu_dense')
('2025-05-06 00:02:13', 4302, 12836, 'RUBBIA_JRM_consolidate')
('2025-05-06 00:02:13', 3994, 12827, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-05-06 00:02:13', 4219, 7630, 'detection_plaque_valcor_010622')
('2025-05-06 00:02:13', 4925, 7119, 'RUBBIA_PEHD_240325_derichebourg')
('2025-05-06 00:02:13', 4433, 6474, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-06 00:02:13', 3318, 5631, 'RUBBIA_Refus_mask_simple_non_aussi_rle')
('2025-05-06 00:02:13', 3995, 5030, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-05-06 00:02:13', 4891, 4000, 'split_time_score_angers_montee_convoyeur')
('2025-05-06 00:02:13', 4311, 4000, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-05-06 00:02:13', 4871, 3197, 'blur_rubbia_live')
('2025-05-06 00:02:13', 4926, 2989, 'RUBBIA_fluxdev_angers_280325')
('2025-05-06 00:02:13', 4887, 2440, 'split_time_score_Sevran_test')
('2025-05-06 00:02:13', 3142, 1720, 'STS_refus_Amiens')
('2025-05-06 00:02:13', 4934, 1600, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour')
('2025-05-06 00:02:13', 3991, 1504, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-05-06 00:02:13', 3789, 1392, 'split_time_score_test_multi_matiere')
('2025-05-06 00:02:13', 4916, 1300, 'split_time_score_Acier_Arc_En_Ciel')
('2025-05-06 00:02:13', 4189, 1200, 'split_time_score_JRM_Perlen_convoyeur')
('2025-05-06 00:02:13', 4851, 1021, 'split_time_score_SCCU_8')
('2025-05-06 00:02:13', 4850, 891, 'split_time_score_SCCU_7')
('2025-05-06 00:02:13', 3992, 796, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-05-06 00:02:13', 4849, 765, 'split_time_score_SCCU_6')
('2025-05-06 00:02:13', 4220, 600, 'split_time_score_plaque_Valcor')
('2025-05-06 00:02:13', 3787, 384, 'split_time_score_urban_fest')
('2025-05-06 00:02:13', 3181, 198, 'split_time_score_JRM_Arc_En_Ciel')
('2025-05-06 00:02:13', 370, 137, 'proportion_papier_qualite_dechets_tri')
('2025-05-06 00:02:13', 243, 131, 'prepare_varroa_ellipse_tile_rotate_whiten')
('2025-05-06 00:02:13', 4878, 100, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-05-06 00:02:13', 3164, 98, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321')
('2025-05-06 00:02:13', 4208, 60, 'test_acp_fit_transform_20')
('2025-05-06 00:02:13', 4209, 60, 'test_acp')
('2025-05-06 00:02:13', 4212, 60, 'ACP_from_port_5709050_type_5619_size_9')
('2025-05-06 00:02:13', 686, 54, 'copy_argmax_crop')
('2025-05-06 00:02:13', 3781, 42, 'cod_pipeline_Perlen_manuel_sts_test')
('2025-05-06 00:02:13', 4621, 39, 'tfhub_18_7_2023')
('2025-05-06 00:02:13', 4567, 36, 'tfhub_19_06_2023')
('2025-05-06 00:02:13', 2896, 30, 'test_radom_deformation')
('2025-05-06 00:02:13', 3070, 30, 'test_ventilate_hashtag_type_3326')
('2025-05-06 00:02:13', 3990, 30, 'test_crop_condition_blur')
('2025-05-06 00:02:13', 230, 28, 'datou_test_rotate')
('2025-05-06 00:02:13', 1848, 27, 'Pipeline_upm_photos_blanches')
('2025-05-06 00:02:13', 3856, 24, 'RUBBIA_Carton_050821_extract_RYM')
('2025-05-06 00:02:13', 2719, 20, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-05-06 00:02:13', 40, 20, 'mask_coco_origin')
('2025-05-06 00:02:13', 4184, 14, 'detection_plaque_valcor_010622')
('2025-05-06 00:02:13', 4553, 12, 'copie_4387_test_replace')
('2025-05-06 00:02:13', 4492, 12, 'copie_4387_test_replace')
('2025-05-06 00:02:13', 233, 12, 'datou_test_rotate_conditionnel')
('2025-05-06 00:02:13', 4573, 10, 'test_sam_h')
('2025-05-06 00:02:13', 1026, 10, 'mask_coco_for_test')
('2025-05-06 00:02:13', 2, 7, 'classification_model')
('2025-05-06 00:02:13', 571, 6, 'datou_test_flip')
('2025-05-06 00:02:13', 2085, 6, 'train_points_upm_darker')
('2025-05-06 00:02:13', 2041, 6, 'test_data_aug')
('2025-05-06 00:02:13', 1818, 6, 'blanchir')
('2025-05-06 00:02:13', 2665, 2, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920')

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', 5167090)
('learn_RUBBIA_REFUS_AMIENS_23', 1304346)
('d4018_output_rle', 887868)
('PhotoDescForrotata_polygone', 641004)
('type_merge_mask_detect_2486_2499', 378719)
('datou_3993_rle', 332325)
('datou_4322_rle', 224880)
('Mask_Limeil_Label_PEHD_080621', 206000)
('merge_pipeline_rubbia_jrm_details_3459', 177837)
('PhotoDescForlabels_result_test_step_tile', 76362)
('varroa_from_ellipse_tiled_rotate_shrink_whiten_ok', 31122)
('pht_test_rle_unique_nms_output', 29558)
('test_sam', 9458)
('test_non_regreg_generate_new_image', 2274)
('mask_coco_origin', 2053)
('detection_filter_test', 1600)

Nombre total de sub photos associees à chaque hashtag type
('hashtag type id', 'hashtag type name', 'Nombre de photos total')
(17, 'photo_tile_type', 2289946)
(311, 'PhotoDescForImmat_307', 9078)
(407, 'PhotoDescForvarroa_2102', 81117)
(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', 128808)
(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', 20017)
(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_Clair_Rubbia_30072020_2692_kmean_connex_pet_and_error_and_environement_clean__more_6K', 1114)
(2800, 'Mask_dechet_Plastique_Clair_Rubbia_30072020_2692_kmean_connex_pet_and_error_and_environement_clean__more_30K', 246367)
(2858, 'learn_mask_refus_qualipapia_vlg', 37929)
(2913, 'output_type_inter_datou_2665', 2293)
(2987, 'learn_mask_emballages_circpack_2209', 6534)
(3062, 'PhotoDescFormerge_mask_and_thcl_datou_2822', 17)
(3064, 'test_half_segments', 10)
(3069, 'type_merge_mask_detect_2260_2463', 3009)
(3079, 'type_merge_mask_detect_2260_2471', 599)
(3086, 'PhotoDescFortest_labellisation_qualipapia_limeil', 1)
(3109, 'Mask_dechet_Plastique_Clair_Rubbia_30112020_2692_pet_and_error', 3894)
(3132, 'type_merge_mask_detect_2486_2499', 2807960)
(3187, 'type_merge_mask_detect_2486_2499_bis', 526)
(3241, 'output_type_fusion_2_detecter_datou_2986', 819)
(3299, 'PhotoDescForlab_manuelle_perlen_vrac', 53186)
(3302, 'merge_pipeline_rubbia_jrm_cabine_AEC', 2948)
(3326, 'output_type_inter_datou_3068', 3976826)
(3327, 'output_type_final_datou_3068', 19664178)
(3328, 'PhotoDescForamiens_lab_refus', 12069)
(3336, 'learn_convoyeur_qualipapia_polygon_210129', 11360)
(3348, 'PhotoDescForcorrection_perlen_lab_pht_3299', 767)
(3403, 'PhotoDescFormerge_mask_thcl_qualipapia_d3150', 13523)
(3418, 'type_inter_3613', 11048)
(3423, 'learn_convoyeur_qualipapia_polygon_765_210307_1', 2948)
(3462, 'PhotoDescForcopy_2478', 19746)
(3465, 'PhotoDescForcopy_3462', 19761)
(3476, 'test_consolidate_JRM_Nantes', 297)
(3493, 'learn_mask_emballages_circpack_PP_230321