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: 13/05/2025, 00:01:25

Nombre de datou current
('date', 'nombre de datou current')
('2025-05-13 00:01:25', 309)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-05-13 00:01:25', 518203)

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

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

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-13 00:02:06', 4219, 9147, 7163, 1984, 'detection_plaque_valcor_010622', 141.0, '22657070:plaque_val:1064:0,22649834:plaque_val:1064:0,22867784:plaque_val:1064:0', 3)
('2025-05-13 00:02:06', 4433, 259, 105, 154, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 10.0, '22886607:JRM_diff_b:1053:0,22875682:JRM_diff_b:1053:1,22882837:JRM_diff_b:1053:0,22885040:JRM_diff_b:1053:0', 4)
('2025-05-13 00:02:06', 4892, 5441, 5289, 152, 'multi_classification_tapis_dechet', 18.0, '22871503:angers_mon:1017:1', 1)
('2025-05-13 00:02:06', 3804, 237, 125, 112, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 8.25, '22895927:pet_clair_:1042:1,22876410:pet_clair_:1017:0,22877328:pet_clair_:1042:0,22895714:pet_clair_:1017:0', 4)
('2025-05-13 00:02:06', 3993, 166, 60, 106, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 2.0, '22895923:pcnc_diff_:1042:1,22895915:pcnc_diff_:1042:0,22895911:emr_diff_b:1042:0', 3)
('2025-05-13 00:02:06', 4871, 3576, 3480, 96, 'blur_rubbia_live', 18.0, '22870033:arc_en_cie:979:0', 1)
('2025-05-13 00:02:06', 533, 9001, 8973, 28, 'multi_classification_tapis_dechet', 19.5, '22867180:aec_metal_:979:1,22872972:arc_en_cie:979:1', 2)
('2025-05-13 00:02:06', 4926, 37, 20, 17, 'RUBBIA_fluxdev_angers_280325', 12.0, '22880138:flux_dev_d:1017:1', 1)
('2025-05-13 00:02:06', 4877, 37, 27, 10, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '22897959:JRM_diff_b:979:0,22898087:JRM_diff_b:979:0,22898286:JRM_diff_b:979:0,22898570:JRM_diff_b:979:0,22898721:JRM_diff_b:979:1,22899039:JRM_diff_b:979:0,22899096:JRM_diff_b:979:1,22899360:JRM_diff_b:979:0,22899420:JRM_diff_b:979:0,22899473:JRM_diff_b:979:0', 10)
('2025-05-13 00:02:06', 3459, 26, 20, 6, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 3.0, '22894646:JRM_diff_b:979:0', 1)
('2025-05-13 00:02:06', 4310, 6036, 6030, 6, 'classifieur_2camions_valcor_021122_v1', 164.0, '22702626:dechet_val:991:0', 1)
('2025-05-13 00:02:06', 4322, 36, 32, 4, 'RUBBIA_filmPE_151122', 2.0, '22895937:film_pedb_:1042:1,22895917:film_pedb_:1042:1', 2)
('2025-05-13 00:02:06', 3994, 71, 71, 0, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 1.5, '22896424:gm_diff_ba:1017:1,22895926:pcm_diff_b:1042:1', 2)
('2025-05-13 00:02:06', 4234, 109, 109, 0, 'refus_rym_velours_valcor', 2.0, '22896368:truck_diff:991:1,22896367:truck_diff:991:1', 2)

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-13 00:02:08', 3459, 1657, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('6.7586'), '22873139:jrm_diff_b:1017:0,22876411:jrm_diff_b:1017:0,22876669:JRM_diff_b:979:0,22876672:JRM_diff_b:979:0,22876674:JRM_diff_b:979:0,22876676:JRM_diff_b:979:0,22876679:JRM_diff_b:979:0,22877568:JRM_diff_b:979:0,22877569:JRM_diff_b:979:0,22877570:JRM_diff_b:979:0,22877571:JRM_diff_b:979:0,22879056:JRM_diff_b:979:0,22879058:JRM_diff_b:979:0,22879061:JRM_diff_b:979:0,22880134:jrm_diff_b:1017:0,22880750:JRM_diff_b:979:0,22880753:JRM_diff_b:979:0,22880757:JRM_diff_b:979:0,22880758:JRM_diff_b:979:0,22881217:JRM_diff_b:979:0,22886737:JRM_diff_b:979:0,22886740:JRM_diff_b:979:0,22886742:JRM_diff_b:979:0,22886744:JRM_diff_b:979:0,22886747:JRM_diff_b:979:0,22886749:JRM_diff_b:979:0,22886752:JRM_diff_b:979:0,22886754:JRM_diff_b:979:0,22886756:JRM_diff_b:979:0,22886792:jrm_diff_b:1017:0,22889072:JRM_diff_b:979:0,22889075:JRM_diff_b:979:0,22889077:JRM_diff_b:979:0,22891519:jrm_diff_b:1017:0,22893518:jrm_diff_b:1017:0,22893523:jrm_diff_b:1017:0,22894205:JRM_diff_b:979:0,22894208:JRM_diff_b:979:0,22894210:JRM_diff_b:979:0,228', 62)
('2025-05-13 00:02:08', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('1004.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-05-13 00:02:08', 3992, 13, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('1.0000'), '22896423:aluminium_:1017:0', 1)
('2025-05-13 00:02:08', 3996, 28, 'RUBBIA_Refus_add_surclassifier_rapport', Decimal('1.0000'), '22897272:refus_diff:983:0', 1)
('2025-05-13 00:02:08', 4871, 2, 'blur_rubbia_live', Decimal('0.0000'), '22899558:arc_en_cie:979:0', 1)
('2025-05-13 00:02:08', 4876, 2, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '22899558:arc_en_cie:979:0', 1)
('2025-05-13 00:02:08', 4877, 172, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '22897959:JRM_diff_b:979:0,22898087:JRM_diff_b:979:0,22898286:JRM_diff_b:979:0,22898570:JRM_diff_b:979:0,22899039:JRM_diff_b:979:0,22899360:JRM_diff_b:979:0,22899420:JRM_diff_b:979:0,22899473:JRM_diff_b:979:0,22899520:JRM_diff_b:979:0,22899521:JRM_diff_b:979:0,22899522:JRM_diff_b:979:0,22899523:JRM_diff_b:979:0,22899524:JRM_diff_b:979:0,22899525:JRM_diff_b:979:0,22899526:JRM_diff_b:979:0,22899527:JRM_diff_b:979:0,22899528:JRM_diff_b:979:0,22899530:JRM_diff_b:979:0,22899531:JRM_diff_b:979:0,22899532:JRM_diff_b:979:0,22899533:JRM_diff_b:979:0,22899534:JRM_diff_b:979:0,22899535:JRM_diff_b:979:0,22899536:JRM_diff_b:979:0,22899537:JRM_diff_b:979:0,22899538:JRM_diff_b:979:0,22899539:JRM_diff_b:979:0,22899540:JRM_diff_b:979:0,22899541:JRM_diff_b:979:0,22899542:JRM_diff_b:979:0,22899543:JRM_diff_b:979:0,22899544:JRM_diff_b:979:0,22899546:JRM_diff_b:979:0,22899548:JRM_diff_b:979:0,22899549:JRM_diff_b:979:0,22899550:JRM_diff_b:979:0,22899551:JRM_diff_b:979:0,22899553:JRM_diff_b:979:0,22899554:JRM_diff_b:979:0,22899555:J', 41)
('2025-05-13 00:02:08', 4883, 2, 'split_time_score_JRM_Arc_En_Ciel', Decimal('0.0000'), '22899558:arc_en_cie:979:0', 1)
('2025-05-13 00:02:08', 4887, 6554, 'split_time_score_Sevran_test', Decimal('0.0000'), '22872965:sevran_122:1042:0', 1)
('2025-05-13 00:02:08', 4893, 89, 'split_time_score_Sevran_test2', Decimal('0.0000'), '22867192:Test_PRINE:739:0', 1)
('2025-05-13 00:02:08', 4916, 7590, 'split_time_score_Acier_Arc_En_Ciel', Decimal('0.0000'), '22867180:aec_metal_:979:0', 1)
('2025-05-13 00:02:08', 4935, 2, 'split_time_score_JRM_Arc_En_Ciel_merge', Decimal('0.0000'), '22899558:arc_en_cie: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-05-13 00:02:08', 4219, 3104, 'detection_plaque_valcor_010622')
('2025-05-13 00:02:08', 533, 27359, 'multi_classification_tapis_dechet')
('2025-05-13 00:02:08', 4871, 3480, 'blur_rubbia_live')
('2025-05-13 00:02:08', 4892, 14719, 'multi_classification_tapis_dechet')
('2025-05-13 00:02:08', 4433, 855, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-13 00:02:08', 3804, 875, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-05-13 00:02:08', 4926, 20, 'RUBBIA_fluxdev_angers_280325')
('2025-05-13 00:02:08', 3459, 160, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-13 00:02:08', 3993, 480, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-05-13 00:02:08', 4322, 32, 'RUBBIA_filmPE_151122')
('2025-05-13 00:02:08', 3994, 491, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-05-13 00:02:08', 4234, 575, 'refus_rym_velours_valcor')
('2025-05-13 00:02:08', 4877, 208, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 18)
(0, 260)
(-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-13 00:02:18', 4234, 96115, 'refus_rym_velours_valcor')
('2025-05-13 00:02:18', 4876, 54581, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-05-13 00:02:18', 4935, 54561, 'split_time_score_JRM_Arc_En_Ciel_merge')
('2025-05-13 00:02:18', 4883, 52186, 'split_time_score_JRM_Arc_En_Ciel')
('2025-05-13 00:02:18', 533, 32684, 'multi_classification_tapis_dechet')
('2025-05-13 00:02:18', 4892, 31925, 'multi_classification_tapis_dechet')
('2025-05-13 00:02:18', 4893, 26905, 'split_time_score_Sevran_test2')
('2025-05-13 00:02:18', 4310, 23402, 'classifieur_2camions_valcor_021122_v1')
('2025-05-13 00:02:18', 3996, 18197, 'RUBBIA_Refus_add_surclassifier_rapport')
('2025-05-13 00:02:18', 4302, 14196, 'RUBBIA_JRM_consolidate')
('2025-05-13 00:02:18', 4877, 12718, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-05-13 00:02:18', 3385, 12340, 'split_time_score_JRM_Arc_En_Ciel_peu_dense')
('2025-05-13 00:02:18', 4322, 11074, 'RUBBIA_filmPE_151122')
('2025-05-13 00:02:18', 3993, 10465, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-05-13 00:02:18', 4219, 8862, 'detection_plaque_valcor_010622')
('2025-05-13 00:02:18', 3804, 8640, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-05-13 00:02:18', 3994, 8620, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-05-13 00:02:18', 4925, 7065, 'RUBBIA_PEHD_240325_derichebourg')
('2025-05-13 00:02:18', 4311, 4100, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-05-13 00:02:18', 4891, 4000, 'split_time_score_angers_montee_convoyeur')
('2025-05-13 00:02:18', 4916, 3500, 'split_time_score_Acier_Arc_En_Ciel')
('2025-05-13 00:02:18', 4871, 3481, 'blur_rubbia_live')
('2025-05-13 00:02:18', 4433, 2735, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-13 00:02:18', 3995, 2679, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-05-13 00:02:18', 4926, 2140, 'RUBBIA_fluxdev_angers_280325')
('2025-05-13 00:02:18', 3318, 1408, 'RUBBIA_Refus_mask_simple_non_aussi_rle')
('2025-05-13 00:02:18', 4934, 1300, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour')
('2025-05-13 00:02:18', 4189, 1238, 'split_time_score_JRM_Perlen_convoyeur')
('2025-05-13 00:02:18', 3142, 1040, 'STS_refus_Amiens')
('2025-05-13 00:02:18', 3459, 994, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-13 00:02:18', 4742, 847, 'entrant_consolidate')
('2025-05-13 00:02:18', 3991, 763, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-05-13 00:02:18', 3992, 623, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-05-13 00:02:18', 4887, 600, 'split_time_score_Sevran_test')
('2025-05-13 00:02:18', 4220, 543, 'split_time_score_plaque_Valcor')
('2025-05-13 00:02:18', 3789, 464, 'split_time_score_test_multi_matiere')
('2025-05-13 00:02:18', 4741, 401, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-05-13 00:02:18', 4932, 166, 'split_time_score_cod_upm_SyctomXV_Mask_23Q1')
('2025-05-13 00:02:18', 3787, 128, 'split_time_score_urban_fest')
('2025-05-13 00:02:18', 4878, 100, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-05-13 00:02:18', 3181, 66, 'split_time_score_JRM_Arc_En_Ciel')
('2025-05-13 00:02:18', 243, 52, 'prepare_varroa_ellipse_tile_rotate_whiten')
('2025-05-13 00:02:18', 370, 50, 'proportion_papier_qualite_dechets_tri')
('2025-05-13 00:02:18', 4148, 44, 'test_paddle_ocr')
('2025-05-13 00:02:18', 3164, 28, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321')
('2025-05-13 00:02:18', 4621, 21, 'tfhub_18_7_2023')
('2025-05-13 00:02:18', 4567, 21, 'tfhub_19_06_2023')
('2025-05-13 00:02:18', 4209, 20, 'test_acp')
('2025-05-13 00:02:18', 230, 20, 'datou_test_rotate')
('2025-05-13 00:02:18', 4212, 20, 'ACP_from_port_5709