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: 03/02/2025, 00:01:26

Nombre de datou current
('date', 'nombre de datou current')
('2025-02-03 00:01:26', 1283)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-02-03 00:01:26', 326677)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-02-03 00:02:58', 101881)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-02-03 00:02:58', 27488)

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-02-03 00:03:39', 4310, 64306, 45356, 18950, 'classifieur_2camions_valcor_021122_v1', 321.44444444444446, '19559973:dechet_val:991:0,19642969:dechet_val:991:0,19672137:dechet_val:991:0,19698702:dechet_val:991:0,19724275:dechet_val:991:0,19739544:dechet_val:991:0,19747569:dechet_val:991:0,20133372:dechet_val:991:0,20149401:dechet_val:991:0', 9)
('2025-02-03 00:03:39', 3459, 4179, 1200, 2979, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 168.9795918367347, '19753371:jrm_diff_b:1017:0,19754712:jrm_diff_b:1017:0,19761944:jrm_diff_b:739:0,19762412:JRM_diff_b:739:0,19763324:jrm_diff_b:1017:0,19771181:JRM_diff_b:739:0,19772147:JRM_diff_b:739:0,19793493:jrm_diff_b:1017:0,19797272:JRM_diff_b:739:0,19800775:JRM_diff_b:739:0,19804718:JRM_diff_b:739:0,19806030:JRM_diff_b:739:0,19809800:JRM_diff_b:739:0,19814981:jrm_diff_b:1017:0,19816777:jrm_diff_b:739:0,19825957:jrm_diff_b:1017:0,19951810:JRM_diff_b:739:0,19953129:JRM_diff_b:739:0,19954800:JRM_diff_b:739:0,19955913:JRM_diff_b:739:0,19964113:JRM_diff_b:739:0,19980747:JRM_diff_b:739:0,19982144:JRM_diff_b:739:0,20006552:JRM_diff_b:739:0,20013864:JRM_diff_b:739:0,20036572:jrm_diff_b:1017:0,20036989:JRM_diff_b:739:0,20037563:JRM_diff_b:739:0,20037597:JRM_diff_b:739:0,20038647:JRM_diff_b:739:0,20041518:jrm_diff_b:1017:0,20041976:JRM_diff_b:739:0,20042812:JRM_diff_b:739:0,20043551:JRM_diff_b:739:0,20043629:jrm_diff_b:1017:0,20044107:JRM_diff_b:739:0,20068238:JRM_diff_b:739:0,20072387:JRM_diff_b:739:0,20073159:JRM_diff_b:739:0,2', 49)
('2025-02-03 00:03:39', 4322, 4494, 2340, 2154, 'RUBBIA_filmPE_151122', 131.34736842105264, '19783410:film_pedb_:739:0,19816763:film_pedb_:739:0,19816773:film_pedb_:739:0,19844078:film_pedb_:1017:0,19844999:film_pedb_:1017:0,19848348:film_pedb_:1017:0,19862497:film_pedb_:739:0,19884841:film_pedb_:1017:0,19903206:film_pedb_:1017:0,19907038:film_pedb_:1017:0,19907583:film_pedb_:739:0,19914744:film_pedb_:1017:0,19916122:film_pedb_:1017:0,19916144:film_pedb_:739:0,19962211:film_pedb_:739:0,19969293:film_pedb_:1017:0,19972096:film_pedb_:1017:0,19976776:film_pedb_:1017:0,19980608:film_pedb_:739:0,19981976:film_pedb_:739:0,19986015:film_pedb_:739:0,19986017:film_pedb_:739:0,19986404:film_pedb_:739:0,19987519:film_pedb_:739:0,20001205:film_pedb_:739:0,20001286:film_pedb_:739:0,20001294:film_pedb_:739:0,20001302:film_pedb_:739:0,20001310:film_pedb_:739:0,20001320:film_pedb_:739:0,20006222:film_pedb_:1017:0,20006923:film_pedb_:739:0,20009325:film_pedb_:1017:0,20014717:film_pedb_:1017:0,20017063:film_pedb_:1017:0,20021716:film_pedb_:1017:0,20025732:film_pedb_:739:0,20025749:film_pedb_:739:0,20025751:film_pedb_:', 95)
('2025-02-03 00:03:39', 4234, 2772, 1293, 1479, 'refus_rym_velours_valcor', 133.06521739130434, '19846777:truck_diff:991:0,19846779:truck_diff:991:0,19849715:truck_diff:991:0,19852280:truck_diff:991:0,19852327:truck_diff:991:0,19852328:truck_diff:991:0,19855293:truck_diff:991:0,19856547:truck_diff:991:0,19898844:truck_diff:991:0,19954906:truck_diff:991:0,19954920:truck_diff:991:0,19975344:truck_diff:991:1,20005158:truck_diff:991:0,20005189:truck_diff:991:0,20024113:truck_diff:991:0,20024879:truck_diff:991:0,20026816:truck_diff:991:0,20028243:truck_diff:991:0,20028248:truck_diff:991:0,20028262:truck_diff:991:0,20028747:truck_diff:991:0,20028748:truck_diff:991:0,20029335:truck_diff:991:0,20029755:truck_diff:991:0,20029772:truck_diff:991:0,20029775:truck_diff:991:0,20030143:truck_diff:991:0,20030169:truck_diff:991:0,20031197:truck_diff:991:0,19888798:truck_diff:991:0,19897034:truck_diff:991:0,20050443:truck_diff:991:0,20052305:truck_diff:991:0,19954805:truck_diff:991:0,19954857:truck_diff:991:0,20068969:truck_diff:991:0,20070508:truck_diff:991:0,20071883:truck_diff:991:0,20072229:truck_diff:991:0,20072251:t', 46)
('2025-02-03 00:03:39', 4219, 1049, 3, 1046, 'detection_plaque_valcor_010622', 1510.0, '18808289:plaque_val:1064:0', 1)
('2025-02-03 00:03:39', 3994, 840, 120, 720, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 222.0, '19863842:pcm_diff_b:739:0,19909479:pcm_diff_b:739:0,19909480:pcm_diff_b:739:0', 3)
('2025-02-03 00:03:39', 4748, 543, 440, 103, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 127.4090909090909, '19904577:flux_dev_r:739:0,19920404:flux_dev_r:739:0,19921059:flux_dev_r:739:0,19984139:flux_dev_r:739:0,20001207:flux_dev_r:739:0,20001289:flux_dev_r:739:0,20001297:flux_dev_r:739:0,20004720:flux_dev_r:739:0,20004721:flux_dev_r:739:0,20036076:flux_dev_r:739:0,20036096:flux_dev_r:739:0,20036942:flux_dev_r:739:0,20037899:flux_dev_r:739:0,20037902:flux_dev_r:739:0,20037921:flux_dev_r:739:0,20037925:flux_dev_r:739:0,20037978:flux_dev_r:739:0,20037989:flux_dev_r:739:0,20062003:flux_dev_r:739:0,20065065:flux_dev_r:739:0,20067085:flux_dev_r:739:0,20071351:flux_dev_r:739:0', 22)
('2025-02-03 00:03:39', 3991, 173, 120, 53, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 126.83333333333333, '19908554:ela_diff_b:739:0,19984110:ela_diff_b:1017:0,20025651:ela_diff_b:1017:0,20045888:ela_diff_b:1017:0,20063543:ela_diff_b:1017:0,20073268:ela_diff_b:1017:0', 6)
('2025-02-03 00:03:39', 3992, 50, 40, 10, 'RUBBIA_Alu_131221_add_surclassifier_rapport', 118.0, '20001314:aluminium_:739:0,20049554:aluminium_:739:0', 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-02-03 00:03:40', 3459, 18640, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('118.6899'), '19754724:jrm_diff_b:1017:0,19754728:jrm_diff_b:1017:0,19754763:jrm_diff_b:1017:0,19760881:jrm_diff_b:1017:0,19762343:jrm_diff_b:1017:0,19762345:jrm_diff_b:1017:0,19762408:JRM_diff_b:739:0,19762409:JRM_diff_b:739:0,19762410:JRM_diff_b:739:0,19762411:JRM_diff_b:739:0,19763069:JRM_diff_b:739:0,19763070:JRM_diff_b:739:0,19763071:JRM_diff_b:739:0,19763321:jrm_diff_b:1017:0,19764220:JRM_diff_b:739:0,19765801:JRM_diff_b:739:0,19765802:JRM_diff_b:739:0,19765803:JRM_diff_b:739:0,19765804:JRM_diff_b:739:0,19765805:JRM_diff_b:739:0,19765806:JRM_diff_b:739:0,19767302:JRM_diff_b:739:0,19767303:JRM_diff_b:739:0,19767304:JRM_diff_b:739:0,19768592:jrm_diff_b:1017:0,19768736:JRM_diff_b:739:0,19768738:JRM_diff_b:739:0,19770114:JRM_diff_b:739:0,19770115:JRM_diff_b:739:0,19770116:JRM_diff_b:739:0,19771167:JRM_diff_b:739:0,19771180:JRM_diff_b:739:0,19795840:JRM_diff_b:739:0,19795842:JRM_diff_b:739:0,19795857:JRM_diff_b:739:0,19797270:JRM_diff_b:739:0,19798173:jrm_diff_b:1017:0,19798289:JRM_diff_b:739:0,19799584:JRM_diff_b:739:0,1', 285)
('2025-02-03 00:03:40', 3991, 224, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('65.1741'), '20076857:ela_diff_b:739:0,20079100:ela_diff_b:739:0,20080190:ela_diff_b:1017:0,20084950:ela_diff_b:739:0,20101963:ela_diff_b:739:0,20104700:ela_diff_b:1017:0,20108680:ela_diff_b:739:0,20112472:ela_diff_b:739:0,20115134:ela_diff_b:1017:0,20119801:ela_diff_b:1017:0,20119878:ela_diff_b:739:0', 11)
('2025-02-03 00:03:40', 3992, 155, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('66.4129'), '20074722:aluminium_:1017:0,20076786:aluminium_:1017:0,20079075:aluminium_:739:0,20082424:aluminium_:739:0,20084953:aluminium_:739:0,20101945:aluminium_:739:0,20101964:aluminium_:739:0,20102009:aluminium_:739:0,20102661:aluminium_:1017:0,20112473:aluminium_:739:0,20116393:aluminium_:1017:0,20116924:aluminium_:739:0,20116926:aluminium_:739:0,20119803:aluminium_:1017:0,20119876:aluminium_:739:0,20120684:aluminium_:739:0', 16)
('2025-02-03 00:03:40', 3994, 89, 'RUBBIA_proportion_papier_add_surclassifier_rapport', Decimal('59.0000'), '20079103:gm_diff_ba:739:0,20080261:gm_diff_ba:739:0,20084087:gm_diff_ba:739:0,20102735:gm_diff_ba:739:0,20108683:pcm_diff_b:739:0,20116177:pcm_diff_b:739:0,20119875:gm_diff_ba:739:0,20120229:gm_diff_ba:739:0,20120682:gm_diff_ba:739:0,20128152:pcm_diff_b:739:0', 10)
('2025-02-03 00:03:40', 4219, 66247, 'detection_plaque_valcor_010622', Decimal('793.1609'), '18887370:plaque_val:1064:0,18909144:plaque_val:1064:0,18922048:plaque_val:1064:0,18948750:plaque_val:1064:0,18966527:plaque_val:1064:0,18984980:plaque_val:1064:0,18999159:plaque_val:1064:0,19036179:plaque_val:1064:0,19088052:plaque_val:1064:0,19109709:plaque_val:1064:0,19132512:plaque_val:1064:0,19150488:plaque_val:1064:0,19163211:plaque_val:1064:0,19176663:plaque_val:1064:0,19265243:plaque_val:1064:0,19283258:plaque_val:1064:0,19330815:plaque_val:1064:0,19362748:plaque_val:1064:0,19387885:plaque_val:1064:0,19407643:plaque_val:1064:0,19418253:plaque_val:1064:0,19426242:plaque_val:1064:0,19463603:plaque_val:1064:0,19482376:plaque_val:1064:0,19494244:plaque_val:1064:0,19643171:plaque_val:1064:0,19654020:plaque_val:1064:0,19674312:plaque_val:1064:0,19740119:plaque_val:1064:0,19749453:plaque_val:1064:0,19783840:plaque_val:1064:0,19806631:plaque_val:1064:0,19842456:plaque_val:1064:0,19908524:plaque_val:1064:0,19928190:plaque_val:1064:0,19942325:plaque_val:1064:0,19989529:plaque_val:1064:0,20031499:plaque_val:1064:', 40)
('2025-02-03 00:03:40', 4220, 3794, 'split_time_score_plaque_Valcor', Decimal('61.0459'), '20031499:plaque_val:1064:0,20052288:plaque_val:1064:0', 2)
('2025-02-03 00:03:40', 4234, 3303, 'refus_rym_velours_valcor', Decimal('56.5550'), '19844402:truck_diff:991:0,19844407:truck_diff:991:0,19844411:truck_diff:991:0,19845011:truck_diff:991:0,19845402:truck_diff:991:0,19846805:truck_diff:991:0,19847492:truck_diff:991:0,20040819:truck_diff:991:0,20040822:truck_diff:991:0,20040824:truck_diff:991:0,20040825:truck_diff:991:0,20040827:truck_diff:991:0,20040829:truck_diff:991:0,20040843:truck_diff:991:0,20040857:truck_diff:991:0,20040859:truck_diff:991:0,20040861:truck_diff:991:0,20040863:truck_diff:991:0,20040864:truck_diff:991:0,20040865:truck_diff:991:0,20040866:truck_diff:991:0,20040867:truck_diff:991:0,20040868:truck_diff:991:0,20040869:truck_diff:991:0,20040870:truck_diff:991:0,20040871:truck_diff:991:0,20040876:truck_diff:991:0,20041512:truck_diff:991:0,20041516:truck_diff:991:0,20073784:truck_diff:991:0,20073786:truck_diff:991:0,20073787:truck_diff:991:0,20073788:truck_diff:991:0,20073789:truck_diff:991:0,20073790:truck_diff:991:0,20073791:truck_diff:991:0,20073792:truck_diff:991:0,20073793:truck_diff:991:0,20073794:truck_diff:991:0,20073795:t', 552)
('2025-02-03 00:03:40', 4311, 7596, 'sts_dechet_valcor_matching_v2_2022Q3', Decimal('0.0000'), '20149401:dechet_val:991:0', 1)
('2025-02-03 00:03:40', 4322, 1375, 'RUBBIA_filmPE_151122', Decimal('64.3847'), '20076166:film_pedb_:739:0,20076784:film_pedb_:1017:0,20078032:film_pedb_:739:0,20080185:film_pedb_:1017:0,20080192:film_pedb_:1017:0,20080259:film_pedb_:739:0,20082398:film_pedb_:1017:0,20082423:film_pedb_:739:0,20083118:film_pedb_:739:0,20084951:film_pedb_:739:0,20085544:film_pedb_:1017:0,20088458:film_pedb_:739:0,20090333:film_pedb_:739:0,20090345:film_pedb_:739:0,20090346:film_pedb_:739:0,20101949:film_pedb_:739:0,20101956:film_pedb_:739:0,20101965:film_pedb_:739:0,20102008:film_pedb_:739:0,20102734:film_pedb_:739:0,20103638:film_pedb_:739:0,20104703:film_pedb_:1017:0,20108692:film_pedb_:739:0,20108693:film_pedb_:739:0,20108694:film_pedb_:739:0,20108696:film_pedb_:739:0,20110620:film_pedb_:1017:0,20110664:film_pedb_:739:0,20114131:film_pedb_:739:0,20115132:film_pedb_:1017:0,20115466:film_pedb_:1017:0,20116174:film_pedb_:739:0,20116176:film_pedb_:739:0,20116430:film_pedb_:739:0,20116899:film_pedb_:1017:0,20117425:film_pedb_:739:0,20117991:film_pedb_:1017:0,20118089:film_pedb_:1017:0,20118113:film_pedb_:739:', 43)
('2025-02-03 00:03:40', 4748, 464, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('65.2392'), '20076165:flux_dev_r:739:0,20078031:flux_dev_r:739:0,20079077:flux_dev_r:739:0,20081686:flux_dev_r:739:0,20083114:flux_dev_r:739:0,20084088:flux_dev_r:739:0,20085660:flux_dev_r:739:0,20087819:flux_dev_r:739:0,20089569:flux_dev_r:739:0,20101944:flux_dev_r:739:0,20101951:flux_dev_r:739:0,20101959:flux_dev_r:739:0,20101968:flux_dev_r:739:0,20102011:flux_dev_r:739:0,20102738:flux_dev_r:739:0,20104728:flux_dev_r:739:0,20110666:flux_dev_r:739:0,20114135:flux_dev_r:739:0,20116095:flux_dev_r:739:0,20117424:flux_dev_r:739:0,20118111:flux_dev_r:739:0,20120233:flux_dev_r:739:0,20121351:flux_dev_r:739:0,20124692:flux_dev_r:739:0,20127156:flux_dev_r:739:0', 25)

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-02-03 00:03:40', 4322, 5600, 'RUBBIA_filmPE_151122')
('2025-02-03 00:03:40', 4234, 2028, 'refus_rym_velours_valcor')
('2025-02-03 00:03:40', 3991, 480, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-02-03 00:03:40', 3992, 160, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-02-03 00:03:40', 4748, 640, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-02-03 00:03:40', 3459, 160, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-02-03 00:03:40', 4310, 23181, 'classifieur_2camions_valcor_021122_v1')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 4)
(-5, 21)
(0, 1281)

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-02-03 00:03:43', 4234, 211331, 'refus_rym_velours_valcor')
('2025-02-03 00:03:43', 4310, 29799, 'classifieur_2camions_valcor_021122_v1')
('2025-02-03 00:03:43', 3459, 21759, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-02-03 00:03:43', 4322, 16294, 'RUBBIA_filmPE_151122')
('2025-02-03 00:03:43', 4892, 15860, 'multi_classification_tapis_dechet')
('2025-02-03 00:03:43', 4748, 8857, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-02-03 00:03:43', 4302, 8096, 'RUBBIA_JRM_consolidate')
('2025-02-03 00:03:43', 3994, 4860, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-02-03 00:03:43', 3991, 2130, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-02-03 00:03:43', 3992, 1536, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-02-03 00:03:43', 3789, 1392, 'split_time_score_test_multi_matiere')
('2025-02-03 00:03:43', 4311, 1000, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-02-03 00:03:43', 4878, 730, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-02-03 00:03:43', 4220, 619, 'split_time_score_plaque_Valcor')
('2025-02-03 00:03:43', 3787, 384, 'split_time_score_urban_fest')
('2025-02-03 00:03:43', 3181, 198, 'split_time_score_JRM_Arc_En_Ciel')
('2025-02-03 00:03:43', 243, 182, 'prepare_varroa_ellipse_tile_rotate_whiten')
('2025-02-03 00:03:43', 370, 150, 'proportion_papier_qualite_dechets_tri')
('2025-02-03 00:03:43', 3979, 120, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-02-03 00:03:43', 4891, 100, 'split_time_score_angers_montee_convoyeur')
('2025-02-03 00:03:43', 3164, 84, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321')
('2025-02-03 00:03:43', 686, 63, 'copy_argmax_crop')
('2025-02-03 00:03:43', 4212, 60, 'ACP_from_port_5709050_type_5619_size_9')
('2025-02-03 00:03:43', 4208, 60, 'test_acp_fit_transform_20')
('2025-02-03 00:03:43', 4209, 60, 'test_acp')
('2025-02-03 00:03:43', 4567, 45, 'tfhub_19_06_2023')
('2025-02-03 00:03:43', 4621, 45, 'tfhub_18_7_2023')
('2025-02-03 00:03:43', 3781, 42, 'cod_pipeline_Perlen_manuel_sts_test')
('2025-02-03 00:03:43', 230, 32, 'datou_test_rotate')
('2025-02-03 00:03:43', 3070, 30, 'test_ventilate_hashtag_type_3326')
('2025-02-03 00:03:43', 3990, 30, 'test_crop_condition_blur')
('2025-02-03 00:03:43', 2896, 30, 'test_radom_deformation')
('2025-02-03 00:03:43', 533, 30, 'multi_classification_tapis_dechet')
('2025-02-03 00:03:43', 1848, 29, 'Pipeline_upm_photos_blanches')
('2025-02-03 00:03:43', 3856, 24, 'RUBBIA_Carton_050821_extract_RYM')
('2025-02-03 00:03:43', 3385, 20, 'split_time_score_JRM_Arc_En_Ciel_peu_dense')
('2025-02-03 00:03:43', 2719, 18, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-02-03 00:03:43', 40, 17, 'mask_coco_origin')
('2025-02-03 00:03:43', 4184, 16, 'detection_plaque_valcor_010622')
('2025-02-03 00:03:43', 233, 14, 'datou_test_rotate_conditionnel')
('2025-02-03 00:03:43', 4492, 12, 'copie_4387_test_replace')
('2025-02-03 00:03:43', 4553, 12, 'copie_4387_test_replace')
('2025-02-03 00:03:43', 4573, 10, 'test_sam_h')
('2025-02-03 00:03:43', 1026, 9, 'mask_coco_for_test')
('2025-02-03 00:03:43', 2, 8, 'classification_model')
('2025-02-03 00:03:43', 2085, 7, 'train_points_upm_darker')
('2025-02-03 00:03:43', 571, 7, 'datou_test_flip')
('2025-02-03 00:03:43', 2041, 6, 'test_data_aug')
('2025-02-03 00:03:43', 1818, 6, 'blanchir')
('2025-02-03 00:03:43', 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', 7482326)
('PhotoDescForrotata_polygone', 1010814)
('mask_filmsPE_10_8_23', 120458)
('PhotoDescForlabels_result_test_step_tile', 120417)
('d4018_output_rle', 114879)
('varroa_from_ellipse_tiled_rotate_shrink_whiten_ok', 51471)
('merge_pipeline_rubbia_jrm_details_3459', 36298)
('pht_test_rle_unique_nms_output', 29558)
('datou_4322_rle', 28654)
('Mask_tiled_stride_ELA__230223', 10926)
('test_sam', 9274)
('test_non_regreg_generate_new_image', 2959)
('detection_filter_test', 1600)
('mask_coco_origin', 939)

Nombre total de sub photos associees à chaque hashtag type
('hashtag type id', 'hashtag type name', 'Nombre de photos total')
(17, 'photo_tile_type', 2282098)
(311, 'PhotoDescForImmat_307', 9078)
(407, 'PhotoDescForvarroa_2102', 79749)
(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', 126168)
(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', 19701)
(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', 21127336)
(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', 18499734)
(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', 11)
(3528, 'PhotoDescForcopy_perlen_210402', 24472)
(3591, 'PhotoDescForcopie_3590', 1801)
(3594, 'learn_RUBBIA_REFUS_AMIENS_23', 12015032)
(3629, 'PhotoDescForcopie_rle_2747', 2666)
(3642, 'PhotoDescForcorrection_lab_limeil_pht_3457_pet_fonce', 24)
(3663, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 24192780)
(3699, 'PhotoDescFortile_upm_rle', 2163)
(3702, 'merge_pipeline_rubbia_jrm_delete_rle_2', 10)
(3722, 'merge_pipeline_rubbia_jrm_details_3454', 33763)
(3725, '3590_rle_papier_magazine_kmean', 43130)
(3726, 'merge_pipeline_rubbia_jrm_details_3459', 8799495)
(3735, 'learn_mask_qualipapia_nantes_rle_030621', 260)
(3755, 'merge_rubbia_pehd_vs_contaminants_apres_correction', 3768)
(3760, 'Mask_Limeil_Label_PEHD_080621', 16797163)
(3789, 'Mask_Limeil_Label_ELA_160621', 1149183)
(3791, 'PhotoDescForcod_lab_manuelle_pehd', 30169)
(3792, 'PhotoDescForcod_lab_manuelle_aluminium', 141)
(3793, 'PhotoDescForcod_lab_manuelle_pet_fonce', 12)
(3794, 'PhotoDescForcod_lab_manuelle_pet_clair', 417)
(3795, 'PhotoDescForcod_lab_manuelle_qualicollectia', 13251)
(3809, 'output_qualipapia_automatique_cod', 50661)
(3863, 'learn_mask_qualipapia_nantes_rle_060721_1', 45474)
(3870, 'PhotoDescForcoved_liste_dechets_interdits_enfouissement', 492)
(3880, 'Mask_Limeil_pet_fonce_160721_rotate', 334858)
(3886, 'refus_pet_fonce_tiled', 102409)
(3887, 'learn_mask_rubbia_alu', 368075)
(3888, 'copie_3886', 50830)
(3906, 'PhotoDescForsortie_merge_rym_jrm_d3627', 287)
(3907, 'copie_3502_rle', 24357)
(3923, 'learn_mask_rubbia_rle_carton_03_08_21', 7320000)
(3946, 'amiens_170821', 33910)
(3960, 'PhotoDescForchi_manuel_cod__refus', 2115)
(3961, 'rubbia_rle_240821', 200055)
(3963, 'output_mask_d3721', 6820)
(3964, 'PhotoDescForcorrection_cod_9_1er_photos_refus', 1638)
(3983, 'rubbia_rle_010921', 76667)
(3992, 'PhotoDescForcod_lab_manuelle_acier', 411)
(3996, 'mask_filmsPE_polygon_160921', 233509)
(4001, 'test_min_score_pipeline_arcavi_carton', 476)
(4003, 'output_gros_de_magasin_arcavi_d3792', 2634203)
(4004, 'output_mask_d3797', 1139)
(4005, 'output_mask_d3799', 10876)
(4008, 'manual_label_pet_clair_rym_Arcavi', 2305)
(4013, 'outputmask_test_d3817_duplique3543', 385)
(4014, 'output_merge_d3817_debugJRM', 77)
(4016, 'debug_datouRYM_3818', 724)
(4020, 'merge_poly_on_tile_perlen_tile_upm_for_train', 31559)
(4033, 'output_rleuniquenms_d3817_dupl3543', 74)
(4035, 'auto_output_test_rym', 41)
(4038, 'output_rleuniquenms_d3543', 42101)
(4051, 'learn_mask_perlen_upm_tile_refus_021121', 115402)
(4054, 'merge_2462_3083_4056', 130937)
(4055, 'output_type_mask_d3845', 89015)
(4057, 'merge_mask_thcl_d3845', 69316)
(4063, 'output_type_mask_d3855', 3317)
(4067, 'output_type_mask_d3857', 34007)
(4068, 'merge_3083_4067', 136727)
(4069, 'output_rle_unique_d3857', 41902)
(4074, 'output_mask_jrm_d3866', 5407)
(4075, 'intermediaire_datou_3867', 12)
(4076, 'output_copy_chi_d3868', 17333)
(4081, 'PhotoDescForcorrection_manuelle_jrm', 93)
(4092, 'output_d3878', 11)
(4096, 'output_d3882', 21)
(4097, 'output_d3883', 4)
(4114, 'learn_mask_perlen_tile_refus_221121_more_iterations', 10264)
(4128, 'output_type_mask_d3910_perlentest', 5308)
(4129, 'output_merge_mask_thcl_d3910', 5191)
(4130, 'output_rle_uniquenms_d3910', 2559)
(4133, 'output_rleuniquenms_d3912', 39937)
(4135, 'output_merge_mask_thcl_d3913', 77571)
(4136, 'output_rleuniquenms_d3913', 27223)
(4139, 'consolidate_rym_debug_jrm_with_velours', 88)
(4144, 'rym_velours_datou_3927', 5524)
(4145, 'rym_velours_3927_after_rle_nms', 2061)
(4148, 'rym_test_3929', 4629)
(4149, 'rym_test_3929-1', 2909)
(4162, 'output_rle_d3948', 12765)
(4167, 'output_d3955', 8)
(4169, 'output_d3958_2', 11701)
(4170, 'output_d3958_3', 36)
(4171, 'merge_mask_thcl_pold', 125)
(4178, 'output_d3965', 1202)
(4197, 'old_crops_pht3299_but_automatic', 30)
(4199, 'datou_3979_merge', 266358)
(4200, 'datou_3979_rle', 1380921)
(4202, 'datou_3991_merge', 153748)
(4203, 'datou_3991_rle', 1149841)
(4205, 'datou_3992_rle', 267687)
(4206, 'datou_3993_merge', 1628183)
(4207, 'datou_3993_rle', 5361577)
(4208, 'datou_3994_merge', 186849)
(4209, 'datou_3994_rle', 5282270)
(4210, 'datou_3995_merge', 4620045)
(4211, 'datou_3995_rle', 8133868)
(4212, 'datou_3996_merge', 711684)
(4213, 'datou_3996_rle', 7255246)
(4227, 'output_d4016_sotreval_refus', 3150)
(4230, 'd4018_output_rle', 48801197)
(4235, 'output_mask_d4023', 1826)
(4236, 'output_mergemaskthcl_d4023', 975)
(4237, 'output_rleuniquenms_d4023', 1033)
(4239, 'output_copychis_d4025', 457)
(4246, 'd4025_output_rle_unique', 41)
(4247, 'd4016_output_rle_unique', 15845)
(4248, 'd4044_output_rle_unique', 1856)
(4249, 'd4055_output_rle_unique', 495)
(4252, 'd4058_output_rle', 2041)
(4254, 'd4063_output_ventilate', 35)
(4255, 'd4063_output_rle', 35)
(4256, 'd4064_output_rle', 35)
(4258, 'd4065_output_rle_1', 1452)
(4268, 'type_pour_test_ventilate', 260)
(4281, 'PhotoDescForgrand_carton', 2244)
(4286, 'type_final_d4110', 36)
(4289, 'PhotoDescForbroca_pold_set_test_10_03_22', 705)
(4292, 'd4116_1', 412)
(4293, 'd4116_2', 106)
(4316, 'd4143', 321232)
(4328, 'merge_manual_mask_broca_from_type2491_4313', 5374)
(4331, 'learn_entrant_syctomXV_250422', 1599)
(4341, 'Mask_Limeil_pet_fonce_150721_rotate', 2361281)
(4356, 'test_nonreg_cropcondition', 3)
(4357, 'PhotoDescForcrop_plaque_valcor', 2)
(4364, 'detection_plaque_valcor', 52)
(4370, 'detection_plaque_valcor_010622', 565432)
(4391, 'd4198_output_rle', 175861)
(4393, 'd4205_output_copy', 13816)
(4418, 'copy_chi_d4241', 350669)
(4426, 'copy_chi_d4242', 4621)
(4427, 'copy_chi_d4243', 2753)
(4428, 'copy_chi_d4244', 919)
(4429, 'copy_chi_d4245', 4260)
(4430, 'copy_chi_d4246', 176)
(4431, 'copy_chi_d4247', 1142)
(4432, 'copy_chi_d4248', 7017)
(4439, 'pet_clair_romainville_rle', 2927)
(4441, 'pet_fonce_romainville_rle', 5766)
(4446, '4279_test2', 1)
(4453, 'type_entrant_syctom_for_exemple', 849)
(4455, 'tyoe_output_d4304', 785487)
(4457, 'type_output_d4309', 71736)
(4460, 'merge_mask_thcl_filmPE_d4322', 11450)
(4461, 'datou_4322_rle', 1406174)
(4463, 'input_rle_d3459', 4495306)
(4466, 'output_d4335', 956)
(4467, 'output_rle_manual_uve', 18)
(4468, 'output_d4343', 24188)
(4473, 'test_correction_sogetri_d4350', 956)
(4474, 'mask_refus_amiens_281222', 7595090)
(4477, 'output_rle_d4357', 50894)
(4478, 'output_mask_d4362', 33852)
(4479, 'output_merge_d4362', 29074)
(4480, 'output_rle_d4362', 20824)
(4481, 'output_mask_d4380', 242749)
(4482, 'output_rle_d4380', 162953)
(4490, 'output_rle_d4370', 87963)
(4501, 'output_merge_d4380', 170051)
(4543, 'Mask_tiled_stride_ELA__230223', 1202997)
(4549, 'output_rle_unique_d4430', 114522)
(4556, 'output_rleuniquenms_d4436', 96)
(4559, 'PhotoDescFordetourage_bonbonne', 565)
(4630, 'test_sam', 5938)
(4640, 'PhotoDescForcopy_crop_pehd_type4591', 550)
(4670, 'test_sam_h', 77087)
(4673, 'd4566_output_type', 11283)
(4715, 'learn_mask_cont_greencitizen_170723', 5275)
(4724, 'PhotoDescForoutput_merge_d4620', 406)
(4735, 'output_mask_d4631', 5920)
(4736, 'output_merge_d4631', 4019)
(4781, 'PhotoDescFormerger_les_donnees_film_pe', 1795)
(4794, 'mask_filmsPE_10_8_23', 1250352)
(4830, 'output_d4717', 1926)
(4855, 'd4741_final', 644911)
(4857, 'd4742_final', 98003)
(4860, 'PhotoDescFormanual_correction_dib', 22)
(4871, 'PhotoDescForconsildate_gm_d4760', 19837)
(4930, 'output_rle_d4815', 1204)
(4933, 'qr_code', 4)
(4963, 'test_exchange_local2', 1)
(4985, 'copy_chi_d4898', 2004)
0.11user 0.10system 5:04:38elapsed 0%CPU (0avgtext+0avgdata 28356maxresident)k
44504inputs+80outputs (2240major+6708minor)pagefaults 0swaps