explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FvSR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.851 ↓ 0.0 0 1

Unique (cost=617,882.13..617,882.23 rows=1 width=844) (actual time=0.851..0.851 rows=0 loops=1)

2. 0.002 0.849 ↓ 0.0 0 1

GroupAggregate (cost=617,882.13..617,882.22 rows=1 width=844) (actual time=0.849..0.849 rows=0 loops=1)

  • Group Key: jg.date_emission, j.feuillet, ar.test_id, j.action, j.ip_admin, j.etat, j.message, ar.res, ar.nom_test, ar.message, ar.appli_ko, ar.valeur_reference, j.hostname, ccp.cp, ar.num_su, ar.feu_service, ar.type_service, ar.num_site_satin, ar.site_client, ar.code_etat_sig, ar.nom_reseau, ccp.cellule_pec, ar.code_pays
3. 0.085 0.847 ↓ 0.0 0 1

Sort (cost=617,882.13..617,882.13 rows=1 width=716) (actual time=0.846..0.847 rows=0 loops=1)

  • Sort Key: jg.date_emission DESC, j.feuillet DESC, ar.test_id, j.action, j.ip_admin, j.message, ar.res, ar.nom_test, ar.message, ar.appli_ko, ar.valeur_reference, j.hostname, ccp.cp, ar.num_su, ar.feu_service, ar.type_service, ar.num_site_satin, ar.site_client, ar.code_etat_sig, ar.nom_reseau, ccp.cellule_pec, ar.code_pays
  • Sort Method: quicksort Memory: 25kB
4. 0.001 0.762 ↓ 0.0 0 1

Nested Loop (cost=95,438.96..617,882.12 rows=1 width=716) (actual time=0.762..0.762 rows=0 loops=1)

5. 0.002 0.761 ↓ 0.0 0 1

Hash Join (cost=95,438.82..617,879.76 rows=1 width=706) (actual time=0.761..0.761 rows=0 loops=1)

  • Hash Cond: (((ar.feuillet)::text = (audits_resultats.feuillet)::text) AND (ar.date = (max(audits_resultats.date))) AND (ar.test_id = audits_resultats.test_id))
6. 0.001 0.759 ↓ 0.0 0 1

Nested Loop (cost=23.16..522,455.59 rows=1,081 width=717) (actual time=0.759..0.759 rows=0 loops=1)

7. 0.002 0.758 ↓ 0.0 0 1

Nested Loop (cost=22.73..1,605.28 rows=1,887 width=441) (actual time=0.757..0.758 rows=0 loops=1)

8. 0.659 0.756 ↓ 0.0 0 1

Bitmap Heap Scan on job_group_dq jg (cost=22.30..139.35 rows=1 width=12) (actual time=0.756..0.756 rows=0 loops=1)

  • Recheck Cond: ((resume)::text = 'AuditQuotidien'::text)
  • Filter: (((status)::text = ANY ('{Termine,"En cours de traitement",Expire,Annulé}'::text[])) AND (date_emission >= (now() - '2 mons'::interval)))
  • Rows Removed by Filter: 802
  • Heap Blocks: exact=96
9. 0.097 0.097 ↑ 1.0 802 1

Bitmap Index Scan on job_group_dq_resume (cost=0.00..22.30 rows=802 width=0) (actual time=0.097..0.097 rows=802 loops=1)

  • Index Cond: ((resume)::text = 'AuditQuotidien'::text)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using job_dq_group_job on job_dq j (cost=0.43..1,418.60 rows=4,733 width=437) (never executed)

  • Index Cond: (job_group = jg.jobgroup_id)
  • Filter: ((etat)::text = 'OK'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using audits_resultats_feuillet_key on audits_resultats ar (cost=0.43..276.00 rows=2 width=276) (never executed)

  • Index Cond: ((feuillet)::text = (j.feuillet)::text)
  • Filter: (((res)::text = ANY ('{KO,INF,WARN}'::text[])) AND ((res)::text = ANY ('{KO,INF,WARN}'::text[])) AND (test_id = ANY ('{19537,19538,19539,19540,19541,19542,19544,19545,19546,19547,19548,19549,19550,19551,19552,19553,19554,19555,19556,19557,19702,20022,20023,20024,20025,20026,20027,20028,20029,20030,20031,20032,20033,20034,20041,20128,20129,20131,20132,20431,20432,22190,25892,23099,23098}'::integer[])) AND (ref_id_reseau = ANY ('{37987,37049,29654,7218,42433,28153,9548,36187,43525,42184,12256,43862,34791,28461,9186,38324,43063,12780,39398,16200,39188,7481,42343,43754,7538,8466,17906,10069,7357,30848,43699,42640,42322,35000,42573,42865,5898,27579,42886,1639,8920,1409,28887,22197,35954,34899,42938,39808,27797,28729,7663,43338,8825,36592,29100,38909,39593,39204,41976,29187,36232,20942,27995,10797,42973,9001,42499,41772,25897,38716,41223,34670,40742,34972,17566,17410,14352,28831,40460,17840,39208,1431,4911,8908,8587,27721,22293,35383,35389,42626,28148,43425,42492,28187,37392,15996,38503,42438,28045,40017,42814,10834,42455,43132,5624,41869,14525,24858,41867,27194,25756,36244,9561,39931,43331,2261,43597,42758,15546,40190,43208,25273,43448,18983,17039,43446,43742,42854,41841,41572,38613,42317,30978,2212,20876,29153,29955,18682,41449,29288,26980,41996,43822,42815,43039,16540,43368,42040,27862,29496,38794,36941,7939,37382,28296,25232,43253,25351,42638,30917,9578,22298,1750,37336,42472,1888,1379,3659,16546,7816,40444,35630,42950,30949,37421,25906,7120,40495,25192,16535,17599,39397,37204,41235,41061,28327,40442,40459,1101,28083,17950,3452,28998,40647,36426,39369,28027,1045,1294,1806,35818,35504,1816,40067,36525,9637,43630,38595,18082,9178,34609,39125,40466,30886,37098,41132,34130,41324,41265,16638,39121,1837,28626,15858,37279,6172,37780,16009,3846,39583,8829,29641,42084,42067,28177,30722,17653,36647,41071,25769,665,1893,10349,8607,2776,43716,27856,5022,17581,1938,1794,37360,18492,38961,42399,29010,40181,28707,42917,37175,42262,8469,43644,42004,42428,35501,34218,17938,41673,37046,5328,42391,34465,41637,5345,1951,43065,42798,29793,40610,27435,37223,41480,30771,5569,15960,42021,15929,38270,7931,40907,2112,5376,36543,43420,1805,25408,42977,7290,38377,16165,18261,38347,19122,18639,8475,38308,38314,16257,43775,4437,17685,39197,42387,39304,40602,25499,43884,40224,668,9362,40293,2962,8619,9179,29762,34280,28835,1814,7874,29909,35952,40281,5370,16826,29094,1370,5788,42826,17161,35579,41548,13710,43677,42366,42524,39660,29680,37911,42150,27853,42222,42258,42795,39319,42431,43809,41074,42183,9776,42806,6046,42320,29249,18990,42931,42929,41205,43131,669,42715,16820,38183,43488,35462,42245,29660,42933,6439,42308,26362,37920,28601,26225,41820,39074,26067,41442,18500,43504,25914,38654,3649,9370,12812,38785,39118,38407,27861,28170,7473,26434,43350,27933,16298,36264,30629,42464,39608,17650,9028,17206,36126,34460,26920,13145,13976,11530,37736,5272,36090,42045,42730,43199,37612,43599,28407,42324,1693,28268,29078,43207,29086,43857,42881,40839,42319,17579,26784,36603,17489,40975,27837,42695,27998,5375,9316,39775,17497,40104,25982,28399,35413,34437,15218,39644,1898,29725,8560,36685,7377,1838,1638,2539,39850,25035,42928,42082,43261,36688,43780,43342,43344,42261,2022,36291,43424,7259,26158,34760,41182,15552,39610,5260,43472,34147,7169,36625,1689,28911,28163,7057,40764,28708,36809,25817,7266,1412,28000,40899,38774,34663,27415,28988,1105,42463,18656,1642,28530,43486,1421,37895,14390,37495,27651,42900,41861,39456,9393,29355,38787,26014,41927,41593,689,43058,2706,1185,7856,9321,42030,7641,17639,41926,26970,21986,21495,29729,25380,5957,35196,39331,37678,1062,41968,8538,38393,41698,14716,26840,15424,42281,39844,15412,39148,103,42165,28416,692,27656,39110,6393,23076,24965,20036,38227,1444,42571,40040,19169,23394,34203,1769,1915,39165,37832,43853,29659,1777,41060,43707,27701,39879,40135,7549,27505,28515,26466,38733,40057,18206,24718,41193,31133,2356,27750,42948,43392,41726,43112,7134,28323,37055,43698,26829,1268,6129,27181,5105,27508,42791,25688,35909,38249,42031,43343,6394,16024,36636,41606,41811,700,43352,28388,1395,39724,40512,7287,42345,15757,37301,40520,17478,28668,31159,36787,35892,43076,43443,100,41774,39993,41881,43366,1380,43038,40539,5910,34258,16665,39646,41857,42270,16199,42522,42246,8624,38924,25416,40563,42461,30975,41804,19047,5860,37313,41896,34786,28550,28240,42375,28645,26873,17944,2228,35574,38712,7777,7145,10475,1285,40720,19087,40745,5853,42480,37627,705,38838,43080,5962,38643,8588,43622,40044,15234,34666,31904,42034,34424,42726,17298,3198,1834,28577,41945,42642,31066,27441,37631,39459,41020,38155,28843,42783,6194,28228,710,2418,30246,15579,27411,35324,42866,29926,15489,29835,29237,8449,43116,2161,41477,36207,42808,16336,27962,8472,42425,43048,38304,42959,42486,43404,41474,42032,42650,42452,1408,43412,42041,41638,42022,37234,43336,43328,42421,42932,28894,9562,7683,42321,40222,29853,2667,43623,29064,36566,42497,38483,43478,30535,13643,37243,42400,42354,43073,10220,24962,43371,43867,41022,42649,40596,27602,15848,42476,35177,40695,11342,15252,5771,9421,17726,34564,39965,35271,41933,42563,29595,28871,16348,5085,18630,42970,41104,35555,6125,40562,43308,5437,28771,14022,38384,18232,39122,17237,40477,28935,3322,5480,18998,28670,19002,4422,8996,16422,23642,42052,8807,42494,21423,1376,16127,40435,39475,43307,43511,9208,17646,2407,38232,35700,36380,29314,6161,41596,6257,8491,17030,39317,37696,3716,4165,19091,16977,27053,40456,41689,6291,18481,7071,28960,7050,4926,2377,727,41440,2146,28844,40959,729,36998,25793,22292,7712,25095,23082,3786,17069,16910,1803,16527,9647,26329,2540,10880,27607,27981,732,8368,7129,7558,42996,28828,40123,34871,13503,42788,12490,20038,37779,28453,15708,43659,24743,7105,28348,38415,38934,36877,19060,41900,36124,42099,1367,6184,10713,17651,43304,35452,25201,29227,39155,3409,43249,37978,27612,1924,16395,38828,7892,36049,5845,39889,40734,36379,39768,42212,11870,9673,25582,2363,6343,17700,13011,38982,16969,5786,39306,36800,2066,29671,5508,8501,25710,43091,39945,27130,40150,25240,38752,6239,42192,29375,29196,36167,29216,17225,41752,34187,5441,8739,742,42771,42360,26245,34928,34911,18037,37593,1450,5516,42574,17509,34641,41971,42367,42409,42406,42408,37600,39727,42655,1219,16942,37599,2414,2848,1783,8899,41691,41605,40858,7457,42023,36110,41065,34929,7096,1892,27339,8502,40909,4960,16104,29022,29321,15400,17212,28185,36192,24538,42386,15099,38634,3740,42016,41468,39984,42049,37288,14786,40630,41586,38110,29181,34531,27824,25382,36316,38262,39938,41859,27088,16393,25964,42562,5429,16451,42833,18723,15345,37915,25104,40622,15658,39336,42975,43484,37172,26553,35641,3201,41339,36640,42654,34140,27120,27690,35787,752,5960,25683,38182,29442,38288,36459,15352,2281,41313,12945,34501,7798,16301,28024,42951,41258,9306,28411,18645,39790,16321,28340,43419,6070,29142,39573,40521,40409,30844,24725,25126,43680,16831,35656,9345,30944,43391,42044,759,42817,38493,5798,42036,42080,7360,29526,36337,41421,5070,38932,36309,42684,7522,28766,28111,26783,43037,39948,26044,39841,7332,1610,37673,42848,41214,37045,6028,6033,26587,17365,43627,766,5593,41830,6200,39665,25877,1467,2231,3369,40237,25439,36577,25583,41677,2316,6174,43387,5169,11919,43840,770,7428,17064,25704,35914,16319,42707,39932,41133,3499,5278,42383,38385,40733,43078,8309,39556,28509,16949,28898,25765,19554,43972,8473,7469,6384,6203,27372,26632,9414,27165,42328,29433,43645,5603,25997,43616,18194,17879,39975,12406,27647,42644,39736,5885,35663,38912,24999,39951,10185,39427,25178,42382,42860,5436,39365,782,9068,5961,27346,26789,12646,28008,2204,40885,43535,15013,39305,43911,37626,40723,43103,38009,4958,34910,27727,43665,42490,39301,7725,42901,42774,8728,42314,41153,28614,19017,35011,39214,9566,41284,37735,16677,42750,29736,29217,789,43713,2262,36178,18624,35853,36245,2522,38986,42668,26030,12102,1227,28986,28555,2207,42287,43471,34279,42025,42736,2353,40792,15303,29497,27236,25833,12165,43687,41773,37726,25423,41934,43364,5364,9112,9114,9451,9441,9053,9445,9442,9443,7114,16179,17443,43442,42964,36896,18664,39930,39163,41046,43378,43269,799,38708,37337,41115,5107,1111,36029,1912,16297,29193,2062,41516,25118,37716,37680,17821,43098,15434,42889,42498,41860,42944,42404,5941,1768,1613,9675,39832,42822,17442,37686,38858,41688,36323,42275,6074,41306,839,43303,1077,26716,35847,7893,1120,26934,41257,8771,5023,42241,39332,42359,29191,7159,42217,3441,40231,41019,8765,29268,42501,10559,34295,29453,5812,29458,41903,41345,37893,14794,4278,4280,29152,13227,28999,28208,40020,41952,9557,34567,5830,40903,36112,6195,28801,29937,42779,16859,5659,36900,37083,37060,37079,37076,37078,37077,37071,37070,37069,37068,4555,39120,30830,18187,36099,34574,27896,12207,27541,26291,27366,39339,5620,34240,9400,9163,28335,3532,28472,42104,38680,6037,43482,39548,5600,42230,43684,43451,5608,12787,36215,1071,25278,29160,5846,29438,9667,16007,36001,42393,39154,30775,39597,41456,2154,1584,2293,15117,37537,38198,38153,41121,2299,18584,17679,38914,36408,36499,40141,35844,5932,27545,42539,5799,11744,26557,6109,9375,7171,38755,13826,17050,9177,40692,28273,42101,35282,36283,37371,42468,4934,37606,6159,41958,28805,13702,26819,4298,28100,4255,38062,27294,29808,27016,38223,14187,11171,42877,37584,1542,43036,16760,40901,36246,43248,42257,5415,2402,39321,15988,24821,27144,6117,41609,27327,9335,27265,41995,29598,42284,7929,16564,24730,27561,27169,43607,4258,24755,21426,16470,19155,18025,34549,42277,38406,42087,42283,9547,43438,1084,27313,42789,43181,43887,41008,28788,43074,39797,41594,3832,29049,5344,7121,27281,40284,35407,39972,11261,27333,16484,42954,19468,43055,3153,43539,30720,1056,18045,43361,15657,27714,28195,40758,27220,29059,27767,37294,18616,9676,43838,7438,8408,27780,40101,43042,42072,37891,41763,26880,41645,2108,29528,6242,27239,41941,37047,24900,27670,24969,37003,34474,10139,34971,35972,28758,35719,25500,5931,21213,1623,15431,40638,5274,16183,27503,28752,27812,40889,41623,38252,40576,34211,5444,29207,5484,30746,42916,28052,43115,5555,5507,27089,5209,16467,5781,8967,26657,39847,37548,42727,35975,7401,1919,43810,29198,1817,42909,40955,28937,39811,24447,17380,18121,15877,17187,4244,12428,14273,5170,40162,35466,27456,3067,38683,29943,42089,35213,42543,42226,9254,38596,43314,3184,3815,39387,1459,1398,10842,39540,39795,871,7757,29462,2531,25496,42517,1932,35945,42459,7864,29481,41294,10817,7536,17712,3914,37868,5912,39442,35601,30882,28592,42305,42329,40151,42542,38354,43418,8711,1700,26696,27019,2303,27272,18138,38039,8803,27702,42371,41821,1887,5341,28575,43122,4390,1872,2672,1954,42628,40139,42719,16154,42069,27188,24831,5770,36287,23478,35328,25383,28471,29037,34157,861,35862,28070,1553,1538,2205,1590,1497,2420,5573,36180,5680,1540,1608,1746,42187,40888,41663,28041,6342,42850,41004,24832,28308,41070,10687,43189,1767,43899,34196,35899,29478,42450,43327,37917,29161,6038,7474,41237,17525,26006,15366,17677,1418,29384,5870,29282,29866,830,41156,35662,5936,15525,42885,18076,40116,28874,36140,28814,43777,37517,17731,9289,39034,42813,39677,37532,29644,26347,39818,28333,7555,25809,37040,42551,43635,42748,6044,2320,12828,41325,41844,15362,43333,26109,18084,43335,42751,8608,39402,41341,840,2263,42260,35664,35326,29860,11107,21899,835,41562,9055,43608,37725,43913,36261,17703,9064,42575,25592,16436,40905,26809,34436,43403,37268,38672,27626,42560,42384,43759,43534,27243,43784,41003,42887,14631,42892,19491,15274,8692,40218,8850,9678,15111,25016,39643,6388,35459,37848,25970,36144,25974,25972,25973,25975,5404,5275,10457,27660,42477,27311,27687,28588,842,6140,39212,38889,34970,15290,16967,8577,5509,16773,16606,35897,25758,42968,42766,43059,15678,4967,40062,2031,25558,39417,42834,26962,28173,36544,39891,41044,37338,34735,37956,17435,40122,5446,16378,24626,9146,3857,40632,2419,29076,13492,36402,1123,16089,41364,28010,35671,17619,26752,42911,37221,9674,1304,1853,36448,16377,42570,36755,853,42427,15710,36953,40770,38926,29334,17063,29628,28586,34194,37941,17598,35623,42923,5533,29240,38815,40876,37305,16226,15523,12481,34731,29657,35522,41357,43521,29512,38721,35534,36985,41601,43691,19785,42292,18604,43587,38736,25596,36615,36839,40535,39865,39805,37799,43848,23646,25335,42313,27787,857,40919,1562,6268,24786,26802,11705,38482,41114,43257,1258,28885,43127,36874,2484,27917,25734,6133,41024,28513,37579,42361,39940,41620,36446,42195,34581,16012,38268,42066,43095,6464,41598,43547,43546,36260,34750,25270,29903,4563,19156,8808,29864,37935,28889,28865,43596,34177,42401,29625,28929,28726,43190,39786,40192,37476,35175,25057,34162,24127,41251,2742,42540,35529,29055,29120,34459,38158,17961,31081,41974,42254,24952,36135,42098,37619,27139,27356,27014,41039,5913,27618,37479,38855,1868,43634,17718,27571,7886,9470,9080,7183,41712,41303,6436,43117,29629,16373,41739,6145,38193,42341,9727,1046,5305,36971,35241,41955,8796,7610,6490,26572,38184,25532,36381,30770,43109,43469,29587,29023,5492,43000,36286,42315,2339,24854,11658,1054,40962,1826,34756,29003,5534,36198,6402,41529,10779,5098,16742,40973,42694,43605,7605,36040,17665,17941,25128,6337,42637,42930,8912,37498,11580,42667,8541,35841,9670,38266,42335,38644,8550,40473,40603,867,43262,35708,27486,41344,42793,27033,41911,29491,2285,39219,39218,39226,39230,15216,42544,39216,28589,25481,11356,17683,869,36637,15105,28644,2250,38472,5687,17730,39747,39746,39748,39749,1356,39559,37198,5175,1290,41717,20260,42357,42508,42568,28073,42312,42732,41707,41743,41876,9651,35190,42301,35511,40969,43778,16488,34557,9539,38005,43068,42299,42475,41452,42775,39310,40757,42502,43174,43370,43685,43662,43836,43730,42919,43119,42957,43270,42512,38991,41603,43846,38533,42333,42372,36675,42586,31068,27726,3262,38031,9227,29459,7907,39721,41780,41870,42370,12351,39990,37921,3208,8945,29211,28294,42000,43489,5204,42482,38740,34640,25511,42858,42844,7764,26182,35621,38181,35898,27232,1631,42553,883,6064,6178,26971,36932,3085,40511,8517,28921,29730,37746,39566,43712,43748,7916,41579,38457,1636,17516,41512,41557,42939,9773,43356,43531,40234,43372,40776,1067,25550,43002,42336,9779,889,40153,31042,39617,40687,40429,29414,35791,26602,39130,36622,19786,16320,43585,39314,35244,37095,29183,629,16371,8756,35292,25388,29799,8434,29151,40972,8904,41977,1486,8881,27639,26477,17351,6445,41171,37654,7030,43362,2206,7884,3736,37771,1388,29405,36252,9791,36466,8629,26292,5374,24209,5611,29479,41760,17440,43905,8911,43802,34878,41866,43256,7041,8478,25886,28028,27661,43315,36563,16350,35390,42969,43062,7061,42310,2029,41628,16566,11747,38809,43421,29014,26077,31063,40557,41884,16904,43351,28281,38411,25517,2097,36278,38836,39869,1676,43931,42729,42396,43782,7508,40558,42555,5868,2882,42028,7723,42661,39936,41530,15033,34989,28454,1884,26534,4597,11820,906,28118,9794,34150,1634,41036,2844,7447,37207,42643,34860,42652,38621,25654,7336,42581,1771,7028,25609,41538,2091,2160,1519,25678,1625,8824,11628,41978,25153,8281,1899,17446,27625,14184,41625,43341,913,4119,42515,26955,9818,1891,35419,34231,41993,42491,27234,6057,26400,1305,9645,37144,41742,42033,30801,34434,34433,35187,34547,35590,35996,34825,35373,36664,36668,36670,36666,36663,36673,36672,36669,36671,36662,36665,36667,35789,35757,35797,35794,36047,35717,36138,36134,35715,35713,36136,36139,30920,37010,30864,31118,35513,34435,34300,34432,35512,35013,35435,35388,34824,34823,36656,35756,34822,28291,35493,43494,37563,914,27833,37795,39819,42545,40368,27515,42316,39453,26369,7088,16862,38222,40367,11199,2500,39330,38929,34706,39754,17982,37940,27772,30794,37846,42381,34854,39733,41899,26695,29149,37339,15229,40528,29509,35335,1148,924,39415,5348,21010,38605,1274,7500,24889,41590,42997,4942,37774,39235,42224,40278,15705,36782,43626,41864,42358,15707,13725,1465,11466,8101,43510,5891,42247,17400,17166,36537,3730,38500,41092,41610,43582,38864,5277,38274,923,28286,43266,42754,14056,17895,36884,5520,42437,26655,28287,42388,7345,43114,39150,41021,42541,42936,28456,41846,6451,38522,43935,42577,39937,10841,36163,17189,11150,8328,18596,12594,43386,39581,7852,38386,18004,20551,29199,39788,8370,26301,36416,28371,13025,43414,36004,34850,8800,6215,42907,13938,42811,930,43334,9814,9171,39977,1517,43173,9359,18029,29167,34214,40636,35207,7148,17916,42169,13872,37004,38848,41540,19624,34291,38635,41898,35549,25007,27177,38175,37054,36873,39672,17383,28049,29283,6092,34815,14739,23644,19119,41797,4949,8656,43401,1149,16994,27275,38637,17869,28748,37572,37575,35890,15384,29517,25151,14173,28535,42190,43732,29709,41117,42373,36162,40968,1697,41234,38981,27738,1236,37228,1712,42738,26566,41465,5713,6408,27020,5991,41837,8459,34726,40988,43766,27506,43735,27569,16139,8333,42155,10170,25988,41553,981,16122,37582,41587,27012,34935,1528,15315,37231,30874,21692,5337,2410,1784,19196,41991,39370,41228,41882,6437,4311,41578,17116,16961,2033,17958,43120,16242,26642,34166,42297,37073,34492,42330,28608,5349,37577,6406,29127,28034,29846,24769,38989,15443,9291,28913,38952,1903,42193,3461,42424,6045,41076,42516,42955,42078,42725,42380,42728,2390,42648,42879,9092,22299,1270,17658,27317,1760,10218,34278,27225,18081,4568,28211,38028,5420,28256,2201,26174,17367,38905,5245,17077,42868,37724,37815,41111,34846,15754,27601,16175,41503,42465,43620,28154,1749,27850,27471,42083,42511,37557,27643,34500,40881,8836,40438,36762,1755,35257,43072,40737,16413,43382,6039,21207,26114,6442,37883,29960,12572,18038,40186,40180,39833,43703,37898,41552,38277,38928,39140,39143,39878,38240,39144,37953,37897,37950,37954,41191,39455,39422,37951,40065,40106,42294,37952,37948,38480,38065,35863,42769,27544,42984,28384,38714,37701,42046,1147,28759,40515,42714,41298,23081,28128,43209,42017,35284,946,27809,43621,28643,25052,9048,6202,1378,38003,28144,43758,43129,28823,38688,43728,17369,34746,17922,36697,41037,26748,43533,26686,38453,38564,38568,38563,38562,38561,38565,38567,38566,38574,38569,38572,38571,38570,38575,38573,41770,6400,1666,39500,34236,40450,25894,42549,3856,36182,26527,37244,2226,5360,952,1008,35336,28237,8708,18472,26800,29612,43089,18189,26195,43581,42651,24994,34902,36037,36109,7398,43399,29079,7758,28542,43618,26556,12507,43195,15069,13333,36831,7385,38964,40187,5825,15083,6167,15766,42395,40870,25213,36370,42518,17204,39767,41964,6426,26554,35228,43745,34429,19709,15246,29238,16576,43320,34493,1174,27087,7135,43977,18671,7563,36100,30819,37658,14611,43107,23564,728,21204,17762,43094,41424,27381,12534,27374,39649,5408,36907,1952,42895,34160,43702,5886,40201,25643,39944,1778,34688,7540,24708,2346,15481,8891,39839,41631,19782,40727,42471,16884,17707,43540,15198,1468,27069,37929,35402,18056,38933,36890,39362,17398,40551,6878,41160,36993,7589,42757,43681,30622,13546,42739,36606,28001,29440,37051,16514,2176,2282,1662,968,34671,43313,1150,16933,24717,25107,6236,42546,17761,27517,35695,38592,37717,4061,16817,1470,2554,42897,38317,36820,16852,19116,37926,6429,15257,43740,17357,3470,42439,8683,29424,35807,35808,35821,35824,35826,35827,35828,35829,35831,12924,43168,40754,36277,38990,35410,16170,29110,34288,25017,27793,40904,5154,2409,6091,2209,40729,7197,19034,17954,2493,15931,7905,36241,36240,2616,42243,25087,8593,39988,12974,24738,7523,13756,972,41309,8591,16208,43097,28199,42460,15103,40761,1795,25959,29527,5054,16675,39655,17562,41043,15886,38678,6127,41154,40994,36177,24448,18305,1885,43423,27290,40146,8913,29303,13081,2074,42631,10871,1908,40893,43686,40036,36374,1675,16150,34993,36319,17965,41937,42111,36079,7042,29791,24811,27095,37036,43527,38136,5963,17810,28638,39371,2036,43435,1151,41762,1949,38975,43864,37191,8853,18679,10216,40109,42075,29502,8691,35430,37381,43165,37753,42742,37607,1072,16736,42349,25044,34126,29107,28630,13342,1654,34457,15822,8369,26620,3066,40998,29858,26704,27816,29348,16526,26755,8915,43179,42493,40684,9300,17495,7954,42799,27128,25352,42827,9626,27490,5255,35867,15675,27246,5854,41549,17181,41936,26028,1224,25396,40686,38467,992,40639,42105,42215,34747,6043,7440,29124,40217,42355,7204,25580,17401,38767,9365,5895,5928,24124,16305,38229,42927,20945,28342,5733,42821,1667,1495,8650,35455,1619,25714,36597,42704,2330,1425,35417,17913,5388,36676,42402,4932,38558,1576,998,42552,11201,37659,35311,43655,38702,41592,1526,5421,37854,5938,37487,26118,43760,36493,26621,29893,43694,39503,6105,18594,37910,7883,16160,40204,29778,13560,42669,11773,36314,3728,34841,8776,17045,39670,4328,16836,36769,42864,7971,10205,7516,34748,1720,7417,43259,7166,26931,19553,42872,29881,35889,42102,36384,35467,41725,16718,38089,41289,7603,35021,24768,9052,41110,7857,29710,42830,42759,43606,39544,17281,40804,42146,7252,1928,1934,1929,1930,1931,42430,41948,1740,29739,5558,37506,15258,41195,41559,26947,29162,7783,5582,5736,43252,34998,41786,39498,21694,27410,19272,19437,30786,43330,10814,43590,28653,42676,27872,29113,7235,5675,37839,40330,28521,25871,20414,34978,7254,40519,41253,42234,42559,1939,7796,42211,8883,38910,35256,28934,16685,35739,16964,38724,38614,36179,15888,27803,20803,8377,25009,28785,28207,10813,16334,9025,27163,17425,35931,2229,34864,8496,9312,40207,37255,35678,18126,18129,27956,18131,18128,18135,18134,7189,37289,7151,43739,39957,8481,43265,42307,4235,16797,1543,5144,41467,40282,38661,15158,42456,42781,8665,9200,28018,15388,15331,43598,5776,43210,1567,42743,30749,37214,5541,43473,27928,5612,1715,17132,17786,16966,16838,28169,40887,37860,30884,40964,14523,42239,43519,39966,38201,6163,43750,36921,42688,34744,28312,42915,36121,8308,18600,7751,34662,42700,16888,5740,7542,27086,36401,1461,43747,29545,38291,43452,27002,28560,9159,38696,42679,41850,29721,20735,25635,5930,34285,25141,42446,29189,29614,41126,38259,27070,37805,42875,42289,42986,42177,29434,29724,1397,42449,39659,37399,4353,23876,35816,40056,4962,5617,43851,26341,35460,27814,25832,27124,40580,42079,42469,7974,42590,28180,9320,31046,15196,1995,7147,40716,36003,4980,37823,43264,30818,24712,8724,41338,9488,39443,17163,25585,39543,1389,42790,42056,19858,28103,18017,8725,17820,42340,25565,29766,15100,15374,1038,37886,37488,2454,41607,43410,42639,10642,38267,37149,6148,43609,19120,41416,42509,40548,8831,43306,8809,41101,41363,5427,27056,43637,43516,42403,29242,1042,26321,37596,39976,36624,24735,42893,15815,30753}'::integer[])))
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=92,805.01..92,805.01 rows=149,180 width=23) (never executed)

13. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=89,821.41..91,313.21 rows=149,180 width=23) (never executed)

  • Group Key: audits_resultats.feuillet, audits_resultats.test_id
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on audits_resultats (cost=0.00..78,632.95 rows=1,491,795 width=23) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using correspondance_cp_cellule_pec on correspondance_cp ccp (cost=0.14..2.19 rows=1 width=15) (never executed)

  • Index Cond: ((cellule_pec)::text = (ar.cellule_pec)::text)
  • Filter: (id = ANY ('{35,26,36,32,33,27,28,10,29,4,11,12,16,20,25,2,24,3,9,13,14,19,22}'::integer[]))