explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BFXL

Settings
# exclusive inclusive rows x rows loops node
1. 858.742 57,846.724 ↑ 1.1 34,043 1

Index Scan using inventory_pkey on inventory (cost=0.42..5,476,709.61 rows=38,492 width=30) (actual time=122.079..57,846.724 rows=34,043 loops=1)

  • Index Cond: ((warehousenr = ANY ('{1,500,550,600,601,13,14}'::integer[])) AND (model_id = ANY ('{50807,14127,15177,14155,14563,50542,50082,50838,14779,50959,50861,51171,52438,50989,50241,50018,51453,51725,52238,14915,50496,51167,50868,51850,50475,51902,14445,14285,14581,14529,14776,15048,14728,13785,51249,51789,52488,15120,52458,51505,50616,52542,51258,52348,51792,15106,51037,52456,14685,14283,13784,50302,50733,14756,13940,14514,14192,15047,14745,52178,14109,52480,50012,51986,50799,50728,52033,50153,51036,14974,51206,14611,51615,50340,51935,14757,51773,51671,51745,14452,14273,14349,14561,50506,50507,50498,50724,52463,50645,13982,52055,50524,51942,50719,50526,50716,15084,14797,50958,13927,51203,51561,14816,14668,50079,51681,51403,51851,51176,50961,51163,14211,51818,13556,14716,14680,14317,14698,51417,51002,51798,52452,50969,50539,50666,51928,50372,50008,51438,50366,51476,50577,51434,51181,50911,52639,50549,14231,15164,14443,14486,15089,50690,50547,14395,51791,51626,51411,51477,50170,51222,51772,51339,14789,50572,52439,52440,50306,52486,51989,15191,14560,14121,15064,51226,50643,15049,13790,13968,15190,51185,15112,14787,52052,50973,50509,50362,51691,50379,51017,50739,52035,51625,51245,50311,50675,50131,51385,13704,50991,50646,50512,51342,52173,52469,50086,51905,52056,14300,50641,52175,50525,51027,50791,15103,51685,50555,50196,50786,50784,51659,50697,50054,50672,52629,50198,50669,51526,50297,14981,50732,50808,52167,50735,52057,51410,50184,14997,50276,51187,51667,51644,50684,50146,51097,50640,51650,51031,14637,14926,14545,51089,13729,51674,51331,52027,15096,13741,13959,52457,50334,52030,14975,14271,50331,52453,51161,52174,50629,50805,51064,51061,51251,50202,50595,14724,14309,51200,51746,14771,14739,14774,51033,50393,51843,50686,14858,52016,51957,52372,50852,52492,50866,50303,51154,52199,52395,52010,52172,14646,14287,52393,51035,52353,52397,52339,50843,52081,51587,51817,52137,52401,52384,52285,52666,14072,52142,50977,50822,52177,50358,50849,51570,52642,52135,52328,52332,52337,15176,51590,50817,52319,51680,50364,52286,52326,52398,52279,51502,50476,50840,51357,51389,51406,51395,51062,50148,51520,52168,50993,50997,50021,14794,50160,51025,51238,52450,14899,14883,50859,52631,13596,15104,14483,14900,52222,51847,51683,51783,50902,50298,51619,52624,51380,51740,50970,15085,50963,51797,50167,50041,51612,51555,13685,50635,51839,52473,51728,14812,51159,50556,51572,51788,52180,51329,50356,50221,51660,51514,51603,51006,50443,50072,50145,50685,50139,51157,51405,51640,51614,50529,51688,50738,14990,51475,51450,51620,51221,14921,14159,15124,13809,50055,51756,50118,50109,51837,14917,51824,13630,51507,15105,52628,51690,51430,51527,51944,14769,50128,50901,51622,51370,50513,51663,13888,52169,15128,14513,50448,14557,14676,15054,50797,52632,50968,14889,14504,51921,50391,51344,51793,52633,50612,50309,50427,50218,51731,52239,52637,50048,51642,51194,50717,52448,13977,50941,14115,14525,13794,13887,51655,15070,51383,51384,52347,50908,51679,50518,51247,14989,51092,14995,14784,50809,50185,50681,50966,51908,14913,51909,52444,15100,50508,50352,51244,52635,14892,50122,51063,14925,51211,50165,50917,50287,52049,51816,51648,51259,14267,52059,14674,51263,50546,52054,50348,51227,50664,50541,50259,51624,14791,14683,50678,14682,50091,50431,13841,14000,51515,13693,14550,50530,14526,14265,14117,13932,14107,14568,14613,13706,14577,14325,14602,14217,14347,13731,13783,13736,14386,14128,14125,14435,13860,13609,14371,14290,14929,14801,13836,14715,14955,51738,13632,52630,52455,50194,51039,13791,14846,15138,14114,14432,14488,14712,13546,13531,13985,51366,15010,14390,14307,51833,50062,51433,14788,15181,15082,50649,14661,51255,14718,14268,14516,15060,14201,14199,51205,51799,50502,51560,52634,51937,51054,51892,51390,51494,14752,50940,50019,51156,50205,52403,51778,52378,52089,51997,52022,52359,52475,52140,52085,51757,51706,50440,50850,51954,52202,50068,52470,50789,52122,50679,52356,52141,52208,52181,15113,13686,52051,51048,15087,15102,51665,50374,51877,52477,14777,52166,50552,50663,51784,13737,51223,50201,52443,51379,50162,51558,50731,14604,13716,13889,50798,14977,50217,51177,15108,51618,50501,51750,14954,50447,50154,51992,51220,14719,14195,15093,15101,14751,13819,50355,15007,50714,13824,14340,13796,13628,14360,14487,14713,51508,13965,13832,13681,14612,14932,13583,13722,14962,13800,50014,52002,51435,13788,13526,51971,14760,50499,13850,13866,14804,13953,14507,13540,14517,14069,14551,13593,13602,14320,13536,13708,14366,13547,51993,51609,14843,50255,51689,50505,50520,50688,50504,50103,50117,51264,51675,50540,51152,51397,50987,50000,52459,15020,50135,50277,51658,51796,51402,50187,52163,15132,13840,14763,14571,14489,50992,14068,50544,51927,51815,51202,51770,50947,51422,50865,51501,51687,14859,50188,50557,15051,50034,51269,50144,51753,52487,51647,50709,13825,51094,13885,13931,14679,51821,13561,13657,14675,14508,13649,51848,50155,14998,13728,50114,14296,13749,13636,13912,13696,14396,13613,14258,51682,14860,51641,15016,50024,52254,50186,51316,51805,15099,15136,13999,51573,50289,51517,51645,50097,50964,50532,51165,50831,51771,51940,51676,51394,51812,50912,50680,50550,50069,15137,14569,51420,13553,52481,51053,14953,14782,50350,50281,50363,14786,50642,50360,51279,51733,14389,50851,13833,50053,14778,15130,52032,50157,13815,14659,14387,14585,50869,50369,50152,14588,51643,52479,50538,52484,50093,15127,13688,14326,13951,13550,14567,14032,13826,15000,50081,13955,14711,13962,14022,14400,14535,50168,51392,51801,51777,50723,50156,52460,50736,50338,50560,13534,14506,15135,13683,13797,14328,14733,13637,14902,13991,15005,14353,51634,51232,14603,52267,52404,51965,52472,52209,51137,52360,52435,52159,52133,51946,51990,50178,51735,52188,52091,52127,50083,52370,52640,51752,52092,52146,52333,52667,14226,52300,52653,52201,52096,52068,14970,51234,51436,52268,51510,52312,52020,52465,52189,51994,52011,52491,52434,15066,51998,50833,52261,52379,51158,51509,52152,51207,52034,52190,51807,52084,52331,52266,52390,51460,14957,50671,52187,50406,51231,50439,52203,52193,52156,52280,52536,50633,52165,52074,14225,52321,52014,52097,52277,52366,51910,51919,51964,50195,52310,52381,52338,52259,52086,52369,52162,51155,52351,52471,13679,51009,52186,52399,52375,51911,51593,52076,52095,52400,52069,52242,50308,52468,52354,52270,51953,51038,52316,51759,52204,52364,52136,52009,52334,52341,51095,52194,50829,52394,51032,50860,51589,52083,52382,52371,52245,52340,13678,14278,14431,14229,51414,13634,52050,14170,50988,13617,13979,13595,14562,14552,13867,51070,14380,50027,13743,51412,14803,50209,50408,13713,14324,51143,13984,51838,13615,14578,13694,13557,13603,13551,14818,14905,50473,50127,14923,13559,51930,13692,14259,14111,14647,14050,13738,13580,13829,14093,14427,14319,14437,51396,51265,14272,14684,13963,14102,13560,13941,13727,13886,14515,14770,13712,13926,13966,15122,14213,13641,14358,14344,51825,14253,15022,14291,51754,51748,51669,51049,50945,50098,51354,50367,51571,50102,51977,13721,14609,51617,50342,51272,14799,50346,51915,14743,51948,52638,14920,50206,14960,51260,50307,51209,51055,50727,51088,51613,51429,51635,51519,51518,50711,50803,50359,51638,50207,50960,52048,51018,50087,15117,51060,51071,50016,50659,51162,52454,50183,15015,52461,51528,15088,14332,51445,50151,52313,51707,52063,50654,51369,50792,51371,50954,14746,50636,50811,13673,51179,50639,50533,51575,50974,50996,14928,14228,14927,14113,15129,14587,14203,15139,13563,13597,13650,13827,13697,13576,51512,52170,52018,52430,52008,51584,51800,51918,52070,50412,52389,52327,52023,51987,52284,52087,52474,51755,52258,52145,51920,52207,51008,51153,50432,52314,51790,52067,50133,51673,51741,51189,51853,51774,51607,50112,50174,14922,15119,13539,14558,14312,51606,15017,14795,50310,51632,50523,50299,50559,50900,50537,50290,50265,52447,14052,14235,14173,50814,14348,13718,13624,50040,50061,50047,15009,50084,13572,14652,13812,14277,13711,51521,14238,14118,14393,13687,14252,14651,13582,51808,14570,13599,14276,13600,13849,14919,15175,51340,14958,15180,13588,13549,13623,13837,15050,14768,50380,50657,50330,51365,51338,50171,50365,50264,50946,50361,50376,50193,52485,50804,51262,52636,51686,14758,50558,14772,50497,51478,50531,13986,50166,14897,14885,14665,51525,51240,52668,52053,50236,51353,52431,15133,14643,51845,50270,51637,52441,15178,51184,52483,51393,15134,51668,13828,51760,50063,50108,14906,13918,13786,13916,14200,14667,14026,13934,14645,13682,13589,14753,52449,14914,14996,14875,50231,50695,13575,14559,13975,14598,50066,14862,13745,14670,51639,51811,51677,50910,50357,14978,52445,52446,50516,51831,50510,14606,51213,50090,14988,14842,51693,51956,52150,51004,52537,51834,14136,14956,51144,14482,51427,51356,14369,13644,50662,50284,50123,13823,50378,51151,14605,13642,14579,14051,14781,50951,13545,13792,14049,51254,13939,14196,50638,15118,51183,14264,51084,13562,13857,14908,13577,14339,13578,14029,14089,14548,15143,14023,14610,13822,14861,13627,14053,13571,51459,13725,14999,13969,50810,13998,14844,13890,15140,14351,14292,13942,13538,14666,14454,14274,13799,13594,13684,14345,13742,13950,13558,14669,14365,51504,14824,13945,13993,13947,51229,13842,13801,14608,14126,13924,13820,14401,13675,14158,51694,14234,14717,14233,14589,14333,14119,14402,13835,51522,15162,13544,14316,14193,14174,51250,14764,51739,50837,50943,50994,15142,14433,14103,51086,15006,13744,14375,13780,14133,14741,14091,14262,13739,13952,51633,51409,52482,50701,15019,14918,51343,52478,51182,51767,14972,50707,51471,51382,14301,13921,50033,14376,13967,13978,13528,14546,13643,13707,14597,14284,14814,14343,13884,14322,14142,14583,15021,52451,51005,50023,51651,51594,51388,51452,51073,50658,14904,51629,51216,14952,50962,51252,14202,13813,14071,13724,14959,14893,13591,14002,13680,13750,13751,14120,13787,51174,51447,50377,52225,51907,51218,14847,52442,50190,50124,50189,50543,50438,51424,51423,51579,14447,14210,51261,50052,51582,50545,50593,50002,51193,50956,14984,50553,50415,50677,50222,13795,50025,15012,50823,13754,50304,50734,14455,14566,14580,13638,14582,13972,13793,13653,14197,14969,14374,14636,14723,14329,13622,14878,14806,50044,51785,14527,14005,51820,50856,14224,51809,51826,51233,50834,52344,13782,52547,52131,51970,50622,52251,52518,52182,52026,51742,52329,51782,50848,52019,51924,52126,52415,51562,52073,13858,14194,50150,50703,14993,50191,14263,50132,14270,14028,15098,13723,13988,14132,13891,13862,14436,13818,13629,14394,14863,13607,14299,51271,50031,51814,50099,51781,14815,51950,14845,50548,50204,51253,51656,14895,50291,51684,14992,51377,51332,51186,50017,51758,50320,14379,14282,50674,13925,50056,14898,15107,50076,13677,13789,14266,13541,14868,13726,13690,13859,13631,14244,13621,13779,51794,14575,13676,13847,14024,13674,13935,14564,14430,50694,51072,50392,51386,51829,50208,51399,14896,14754,14930,50437,14734,52176,13543,52264,50077,14175,14576,14356,14802,51969,14671,50806,51786,51096,14392,14485,14536,14104,13717,14070,15141,13618,14555,13804,13838,51425,14108,51769,50517,51225,50725,50628,51929,50409,50247,50092,15001,50003,14986,52058,50030,14765,51565,15116,50147,14994,50141,14530,50073,14134,51016,13705,14484,13851,51257,14428,14106,14635,13753,13848,14209,13710,52248,52346,52383,50435,52373,52396,52272,52195,50815,50813,52183,50788,51099,52386,51407,51595,50621,52158,52244,52276,52363,52205,52352,52005,52260,52377,52088,52171,52269,52252,51421,50863,51947,52125,50867,51968,52037,50835,52256,50858,52345}'::integer[])))
2.          

SubPlan (forIndex Scan)

3. 34.043 56,987.982 ↑ 1.0 1 34,043

Aggregate (cost=141.76..141.77 rows=1 width=4) (actual time=1.674..1.674 rows=1 loops=34,043)

4. 0.000 56,953.939 ↓ 0.0 0 34,043

Nested Loop (cost=1.56..141.76 rows=1 width=4) (actual time=1.663..1.673 rows=0 loops=34,043)

5. 32.843 56,885.853 ↓ 0.0 0 34,043

Nested Loop (cost=1.13..124.50 rows=1 width=4) (actual time=1.662..1.671 rows=0 loops=34,043)

  • Join Filter: (auftraege.customer_id = partner.id)
6. 0.000 56,851.810 ↓ 0.0 0 34,043

Nested Loop (cost=0.85..116.19 rows=1 width=8) (actual time=1.661..1.670 rows=0 loops=34,043)

7. 16,034.253 16,034.253 ↓ 74.9 674 34,043

Index Scan using indentposition_model_id_color_code_index on indentposition auftragspositionen (cost=0.43..40.12 rows=9 width=8) (actual time=0.009..0.471 rows=674 loops=34,043)

  • Index Cond: ((model_id = inventory.model_id) AND ((color_code)::text = (inventory.color_code)::text))
8. 45,888.714 45,888.714 ↓ 0.0 0 22,944,357

Index Scan using indent_pkey on indent auftraege (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=22,944,357)

  • Index Cond: (id = auftragspositionen.indent_id)
  • Filter: ((ordertype)::text = 'B'::text)
  • Rows Removed by Filter: 1
9. 1.200 1.200 ↑ 1.0 1 600

Index Scan using customer_nr_key on customer partner (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=600)

  • Index Cond: (nr = '10027'::bigint)
10. 82.200 82.200 ↑ 1.0 4 600

Index Scan using indentpositionsize_indentposition_id on indentpositionsize auftragspositionsgroessen (cost=0.43..17.22 rows=4 width=8) (actual time=0.040..0.137 rows=4 loops=600)

  • Index Cond: (indentposition_id = auftragspositionen.id)
Planning time : 32.231 ms
Execution time : 57,850.661 ms