explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wCBd

Settings
# exclusive inclusive rows x rows loops node
1. 524.776 30,341.308 ↑ 2.5 10,768 1

GroupAggregate (cost=166,605.61..168,592.81 rows=26,945 width=287) (actual time=28,444.908..30,341.308 rows=10,768 loops=1)

  • Group Key: (CASE WHEN ((suppliers.name)::text = 'Asmin Drink Food & more GmbH'::text) THEN 'HAM'::text WHEN ((suppliers.name)::text = ANY ('{"Getränke ADO GmbH","Getränke Fachhandel Pape","Getränke Weber GmbH & Co KG","Getränke Yücel Horoz","H. Lomberg GmbH & Co. KG","Hall Tabakwaren e.K. (Hilden)","Lekkerland Köln (Frechen)",Qtrado,"Selgros C&C (Köln)"}'::text[])) THEN 'NRW'::text ELSE 'BER'::text END), stock_items.description, stock_items.ean, stock_items.level_1, stock_items.level_2, stock_items.level_3, supplier_stores.name, stock_items.title
2. 5,222.666 29,816.532 ↓ 11.9 321,727 1

Sort (cost=166,605.61..166,672.97 rows=26,945 width=195) (actual time=28,444.800..29,816.532 rows=321,727 loops=1)

  • Sort Key: (CASE WHEN ((suppliers.name)::text = 'Asmin Drink Food & more GmbH'::text) THEN 'HAM'::text WHEN ((suppliers.name)::text = ANY ('{"Getränke ADO GmbH","Getränke Fachhandel Pape","Getränke Weber GmbH & Co KG","Getränke Yücel Horoz","H. Lomberg GmbH & Co. KG","Hall Tabakwaren e.K. (Hilden)","Lekkerland Köln (Frechen)",Qtrado,"Selgros C&C (Köln)"}'::text[])) THEN 'NRW'::text ELSE 'BER'::text END), stock_items.description, stock_items.ean, stock_items.level_1, stock_items.level_2, stock_items.level_3, supplier_stores.name, stock_items.title
  • Sort Method: external merge Disk: 47,728kB
3. 20,188.098 24,593.866 ↓ 11.9 321,727 1

Nested Loop Left Join (cost=17,769.39..162,043.27 rows=26,945 width=195) (actual time=1,505.796..24,593.866 rows=321,727 loops=1)

  • Filter: (((stock_items.ean)::text <> ALL ('{ASMIN-2015,ASMIN-2284,ASMIN-1802,ean-case_pack-32332,ASMIN-4310,ASMIN-219,SOMMER-129091,SOMMER-125029,SOMMER-105033,SOMMER-113050,ML-VIL-OSKU-229100,SOMMER-125126,ASMIN-681,SOMMER-122050,ASMIN-503,SOMMER-110091,4260158884839,ASMIN-4593,SOMMER-105006,ASMIN-856,SOMMER-121002,SOMMER-129048,ASMIN-2269,ean-case_pack-36985,SOMMER-125020,SOMMER-107001,MISSING-10004,4014400914269,ASMIN-1038,SOMMER-114017,8714100563274,ML-B-TEAM-OSKU-72780,SOMMER-145087,ASMIN-3014,SOMMER-209016,SOMMER-120001,SOMMER-130005,ASMIN-3002,ASMIN-1320,SOMMER-142019,SOMMER-134075,SOMMER-141045,ean-case_pack-40203,ASMIN-107,SOMMER-144214,ean-case_pack-36743,SOMMER-105075,SOMMER-141058,ASMIN-223,ean-case_pack-27663,SOMMER-114051,SOMMER-204048,SOMMER-140022,SOMMER-122196,4054184054379,SOMMER-108010,SOMMER-202036,SOMMER-143015,ASMIN-1128,ASMIN-4365,ASMIN-4544,MISSING-10039,SOMMER-410025,ASMIN-9840,3024480007356,ML-VIL-OSKU-230100,SOMMER-125191,SOMMER-134009,8710622523925,ASMIN-373,ASMIN-233,MISSING-10048,SOMMER-101040,4002524930449,MISSING-10051,ASMIN-326,8000500290897,SOMMER-410039,SOMMER-202043,ASMIN-348,ASMIN-677,ean-case_pack-39313,SOMMER-114081,4014086010361,ML-VIL-OSKU-7653230,MISSING-10022,ean-case_pack-36825,ASMIN-576,ASMIN-3019,ASMIN-488,SOMMER-107022,ean-case_pack-31985,SOMMER-118039,ASMIN-3036,SOMMER-144068,ASMIN-1666,SOMMER-121124,SOMMER-114106,ML-B-TEAM-OSKU-79749,SOMMER-144128,ean-case_pack-40598,ean-case_pack-39775,ASMIN-961,SOMMER-125066,SOMMER-112120,4031063014594,ASMIN-4598,SOMMER-206065,ASMIN-4588,42253075-FREE,ASMIN-594,SOMMER-144024,90357350,ML-B-TEAM-OSKU-990270,SOMMER-124023,42253112-FREE,ean-case_pack-37104,ASMIN-2005,SOMMER-127081,ASMIN-314,SOMMER-141031,SOMMER-127095,ASMIN-486,ASMIN-9639,SOMMER-125055,ean-case_pack-32597,ASMIN-2166,SOMMER-130023,SOMMER-145068,4250691100459,SOMMER-145056,ASMIN-4576,ASMIN-228,SOMMER-144230,SOMMER-202007,SOMMER-124104,SOMMER-105029,ASMIN-942,ASMIN-4579,SOMMER-145004,ASMIN-2030,ASMIN-902,SOMMER-129066,SOMMER-100053,ean-case_pack-27827,SOMMER-110046,SOMMER-124047,SOMMER-112184,SOMMER-124030,SOMMER-134168,SOMMER-125041,SOMMER-209006,ASMIN-350,SOMMER-410015,ASMIN-9707,MISSING-10014,4260158881036,ASMIN-919,SOMMER-124072,ean-case_pack-39514,ean-case_pack-38922,ASMIN-316,SOMMER-204005,SOMMER-125010,ASMIN-2210,SOMMER-134076,8410337000086,ean-case_pack-36697,ASMIN-534,ASMIN-5388,SOMMER-410088,ASMIN-946,4006989406266,SOMMER-129051,SOMMER-145077,MISSING-10031,SOMMER-125013,SOMMER-206083,ean-case_pack-31282,MISSING-10029,ASMIN-4517,ASMIN-1324,ASMIN-392,SOMMER-125265,SOMMER-134087,MISSING-10049,SOMMER-114045,SOMMER-144127,ASMIN-650,ASMIN-363,SOMMER-134038,SOMMER-144216,5000267115245,4260158880237,ASMIN-4584,ASMIN-266,SOMMER-124070,ASMIN-960,SOMMER-111040,ASMIN-4577,4260158881319,ML-VIL-HUMIDOR,ASMIN-1028,SOMMER-204050,SOMMER-410041,SOMMER-410065,SOMMER-141011,SOMMER-125003,SOMMER-125117,ASMIN-5001,SOMMER-125228,SOMMER-402038,SOMMER-100010,ean-case_pack-36983,ean-case_pack-39283,SOMMER-144021,SOMMER-144228,ean-case_pack-28024,SOMMER-208008,ean-case_pack-45966,ASMIN-333,ASMIN-9731,SOMMER-121105,SOMMER-125254,ASMIN-2125,ML-B-TEAM-OSKU-75427,SOMMER-131037,7622210635396,ASMIN-4573,ean-case_pack-40346,SOMMER-131036,ASMIN-4356,ML-B-TEAM-OSKU-63377,SOMMER-144152,ASMIN-1426,ASMIN-3009,SOMMER-122074,ASMIN-342,4004018944499,ASMIN-1424,ean-case_pack-40556,SOMMER-122146,8714100587645,SOMMER-145029,ASMIN-1434,SOMMER-134029,ASMIN-254,4032800063516,4054184054416,SOMMER-105031,ean-case_pack-45567,ASMIN-1228,SOMMER-121078,SOMMER-144052,ML-B-TEAM-OSKU-70765,SOMMER-206035,SOMMER-141061,SOMMER-127032,SOMMER-112067,ean-case_pack-27631,SOMMER-141062,42116455,SOMMER-115035,ASMIN-622,ASMIN-550,4054184054317,4260158880336,ICE-AGE-001,SOMMER-206006,SOMMER-141025,ean-case_pack-30435,SOMMER-129042,MISSING-10017,ASMIN-4725,SOMMER-308026,SOMMER-125202,SOMMER-206030,SOMMER-100056,MISSING-10001,ML-B-TEAM-OSKU-70441,SOMMER-144155,ean-case_pack-27374,SOMMER-100015,ean-case_pack-39673,ASMIN-575,SOMMER-202025,ean-case_pack-44945,SOMMER-120040,SOMMER-112172,ASMIN-4528,SOMMER-105109,ASMIN-2277,SOMMER-206100,SOMMER-122228,SOMMER-114021,ML-WEBER-2309,ean-case_pack-45933,ASMIN-2010,SOMMER-112190,ean-case_pack-40547,ASMIN-262,ASMIN-762,SOMMER-105055,SOMMER-120002,SOMMER-128034,SOMMER-129095,SOMMER-111011,4054184054331,MISSING-10006,ean-case_pack-27734,9120068030113,MISSING-10009,SOMMER-107033,ML-VIL-OSKU-7439100,ASMIN-9780,ASMIN-397,4008948194016,SOMMER-127045,SOMMER-127157,ASMIN-1075,SOMMER-125086,100003,ASMIN-2057,SOMMER-130025,SOMMER-124032,SOMMER-129047,ean-case_pack-40699,ASMIN-4439,ASMIN-1356,4260158883313,ASMIN-9677,ASMIN-287,SOMMER-141034,ASMIN-4491,SOMMER-125057,ASMIN-979,SOMMER-145022,ASMIN-119,ASMIN-4232,SOMMER-105036,ASMIN-2272,ASMIN-4246,SOMMER-106023,ean-case_pack-32762,SOMMER-144219,ASMIN-5003,SOMMER-114011,ASMIN-4006,ASMIN-1481,5000267163987,ASMIN-9742,ASMIN-4001,4014086010330,SOMMER-128031,SOMMER-107021,ean-case_pack-39696,SOMMER-141020,SOMMER-110032,SOMMER-129109,SOMMER-204044,ASMIN-4578,SOMMER-144059,4054184050500,SOMMER-125060,MISSING-10021,SOMMER-122111,42303268,SOMMER-127029,ASMIN-2058,SOMMER-127133,SOMMER-118095,ML-B-TEAM-OSKU-63437,ean-case_pack-37084,SOMMER-410085,ASMIN-617,ASMIN-393,ML-FREE-AD-4260107222262,ML-VIL-OSKU-810050,SOMMER-145064,ASMIN-3044,SOMMER-102001,ASMIN-1676,ASMIN-855,SOMMER-114036,ASMIN-1687,SOMMER-101011,ASMIN-9730,ean-case_pack-27989,SOMMER-129017,MISSING-10041,SOMMER-121044,ASMIN-1255,ML-WEBER-333,ASMIN-3010,ASMIN-428,ASMIN-338,8416000703087,SOMMER-134159,SOMMER-127107,SOMMER-118048,SOMMER-209007,SOMMER-107056,ASMIN-161,SOMMER-125179,SOMMER-128035,ASMIN-1797,SOMMER-100035,SOMMER-290034,SOMMER-116037,SOMMER-105044,ean-case_pack-43178,SOMMER-114033,ASMIN-9620,ASMIN-535,SOMMER-105097,ASMIN-4259,ASMIN-145,ASMIN-2006,SOMMER-134092,SOMMER-144032,SOMMER-114046,SOMMER-125212,42303725,ean-case_pack-27773,SOMMER-114004,SOMMER-145066,SOMMER-144035,SOMMER-122130,SOMMER-110043,ASMIN-938,SOMMER-401257,SOMMER-122020,ASMIN-216,MISSING-10054,SOMMER-125147,SOMMER-101058,4004752554640,SOMMER-125082,ASMIN-556,ASMIN-345,SOMMER-302135,ASMIN-336,SOMMER-410045,SOMMER-125074,ean-case_pack-45020,SOMMER-105030,SOMMER-112150,SOMMER-125107,ASMIN-909,ASMIN-2344,SOMMER-122170,MISSING-10042,SOMMER-404003,SOMMER-125096,ASMIN-4574,SOMMER-127076,ASMIN-418,ASMIN-312,SOMMER-114037,SOMMER-100052,ASMIN-608,ASMIN-1392,SOMMER-102004,ASMIN-4345,SOMMER-112079,SOMMER-407139,SOMMER-134101,ML-VIL-OSKU-7746200,ASMIN-331,ASMIN-286,SOMMER-125118,AS-848,ASMIN-1078,4011372602002,ASMIN-1362,SOMMER-111057,SOMMER-202081,ASMIN-264,SOMMER-122037,ASMIN-4498,SOMMER-201015,ASMIN-578,ASMIN-4556,ASMIN-875,DEWI-2068,SOMMER-107032,88076162648,ean-case_pack-35630,ean-case_pack-40554,ML-VIL-OSKU-228100,ASMIN-5004,ASMIN-5211,SOMMER-117025,ASMIN-487,ML-QTRADO-SKU-1006,SOMMER-211001,SOMMER-204032,ML-B-TEAM-OSKU-63379,SOMMER-140013,ASMIN-2411,ASMIN-85,ean-case_pack-40551,SOMMER-410006,SOMMER-142040,SOMMER-105091,ASMIN-557,SOMMER-304003,SOMMER-144206,SOMMER-142011,ean-case_pack-40687,SOMMER-122035,SOMMER-115013,4251039402976,SOMMER-144115,MISSING-EAN-SOLI-01,ASMIN-570,SOMMER-112018,ASMIN-4000,4260158883016,MISSING-10015,SOMMER-127070,SOMMER-111036,ML-B-TEAM-OSKU-71947,SOMMER-209020,SOMMER-122092,SOMMER-131022,SOMMER-209024,ASMIN-4499,SOMMER-122072,SOMMER-129086,SOMMER-130022,MISSING-10024,SOMMER-207001,ASMIN-1323,SOMMER-200009,ASMIN-568,ASMIN-9841,SOMMER-101021,SOMMER-124012,ASMIN-536,SOMMER-122206,SOMMER-302133,SOMMER-140024,SOMMER-122032,SOMMER-122136,SOMMER-122052,ASMIN-387,ML-VIL-OSKU-7436100,SOMMER-141069,MISSING-EAN-24450,ASMIN-692,ean-case_pack-27588,ean-case_pack-39223,SOMMER-402026,ASMIN-630,ASMIN-485,SOMMER-201005,ASMIN-225,SOMMER-402164,ML-VIL-OSKU-7731200,ean-case_pack-31529,3057067269205,SOMMER-144089,SOMMER-144012,ean-case_pack-31522,SOMMER-101041,SOMMER-114088,ASMIN-1167,SOMMER-105011,ASMIN-4495,ean-case_pack-27843,ML-FREE-AD-4260107220015,SOMMER-141040,ASMIN-169,SOMMER-410022,ASMIN-2270,SOMMER-204008,ean-case_pack-39221,SOMMER-114078,ean-case_pack-40557,MISSING-10013,SOMMER-110023,SOMMER-129080,ean-case_pack-44369,ean-case_pack-39156,SOMMER-201000,MISSING-10034,ASMIN-4525,SOMMER-105107,MISSING-10012,SOMMER-122195,SOMMER-112085,ASMIN-610,ean-case_pack-35643,ean-case_pack-28170,SOMMER-145073,SOMMER-142030,SOMMER-121075,ASMIN-177,SOMMER-125270,SOMMER-134154,MISSING-10008,ean-case_pack-36759,SOMMER-125089,ICE-AGE-002,ASMIN-1301,SOMMER-145078,ASMIN-918,SOMMER-114029,5410316265164,MISSING-10036,4260158882910,ean-case_pack-27499,SOMMER-122054,4008669511956,ASMIN-1353,SOMMER-124212,ASMIN-95,ean-case_pack-36980,ean-case_pack-29176,SOMMER-144040,ASMIN-4595,SOMMER-144207,SOMMER-100011,SOMMER-122001,ML-VIL-OSKU-813050,SOMMER-114040,MISSING-10032,ASMIN-100,SOMMER-125081,SOMMER-129058,SOMMER-121088,SOMMER-202032,ASMIN-1429,ASMIN-9629,8500001541226,SOMMER-204009,SOMMER-412024,SOMMER-105103,SOMMER-290032,SOMMER-125110,SOMMER-141029,SOMMER-117017,SOMMER-134005,4054184053365,ASMIN-185,ASMIN-4553,SOMMER-114035,ASMIN-4445,SOMMER-206034,SOMMER-410036,ean-case_pack-36992,SOMMER-122013,ASMIN-4594,SOMMER-103009,ASMIN-603,SOMMER-122041,SOMMER-306025,ASMIN-1351,SOMMER-127125,ean-case_pack-27565,SOMMER-127043,ean-case_pack-27607,ean-case_pack-38071,ean-case_pack-40555,SOMMER-122024,ASMIN-4586,SOMMER-129062,4260158881333,SOMMER-124112,ean-case_pack-33012,SOMMER-100032,SOMMER-144020,ASMIN-972,SOMMER-209010,ASMIN-236,MISSING-10018,ean-case_pack-37155,SOMMER-204021,SOMMER-114030,SOMMER-129087,ASMIN-558,ean-case_pack-33025,SOMMER-144217,ASMIN-686,ean-case_pack-35654,SOMMER-127005,SOMMER-120037,ASMIN-376,10001,ASMIN-612,MISSING-10058,8059145105271,SOMMER-144080,ASMIN-967,SOMMER-122212,ASMIN-4596,SOMMER-114063,SOMMER-122019,SOMMER-130079,SOMMER-124038,ASMIN-433,SOMMER-134153,SOMMER-145001,3057067199502,SOMMER-127067,ASMIN-9741,42140962-FREE,ASMIN-2303,SOMMER-118002,SOMMER-129018,SOMMER-118035,ASMIN-311,100002,MISSING-EAN-26819,4260243040485,SOMMER-206007,SOMMER-118025,SOMMER-116047,SOMMER-209001,ean-case_pack-35657,SOMMER-125225,SOMMER-144250,MISSING-EAN-14058,SOMMER-122007,SOMMER-118001,SOMMER-141070,8697423130852,ASMIN-9732,ean-case_pack-27112,ASMIN-4566,SOMMER-125011,4002186002041,SOMMER-134025,ean-case_pack-35648,SOMMER-122011,ASMIN-1889,ASMIN-1548,SOMMER-407065,ASMIN-115,ASMIN-191,5000291022458,SOMMER-141043,SOMMER-141052,ASMIN-194,ean-case_pack-27930,SOMMER-410017,ean-case_pack-37089,SOMMER-206016,SOMMER-134020,SOMMER-141019,ASMIN-4599,SOMMER-125100,SOMMER-410032,ean-case_pack-35516,SOMMER-120054,SOMMER-121115,ASMIN-239,ean-case_pack-33070,SOMMER-202030,MISSING-10002,ean-case_pack-32585,ASMIN-4462,ML-VIL-OSKU-809050,SOMMER-114084,ean-case_pack-29490,SOMMER-114019,ML-VIL-OSKU-7437100,ASMIN-4492,ASMIN-957,7310290002176,4052426207248,SOMMER-120005,ML-VIL-OSKU-857060,SOMMER-129010,ASMIN-878,ean-case_pack-27587,ASMIN-9635,5202795120054,ASMIN-903,ICE-AGE-003,4260158880831,ean-case_pack-27672,ean-case_pack-34850,SOMMER-144231,SOMMER-114058,ASMIN-987,MGL-TEST-HIDDEN1,ean-case_pack-39756,SOMMER-131035,SOMMER-206019,SOMMER-127080,ASMIN-246,SOMMER-141010,ASMIN-9627,ASMIN-2032,5710840174742,SOMMER-105005,ML-FREE-AD-4260107222514,SOMMER-129006,ASMIN-3015,ASMIN-268,4069400358094,MISSING-EAN-QTRADO-44110,SOMMER-145037,ASMIN-1355,4052426407143,ASMIN-9608,SOMMER-129067,ASMIN-1094,ML-BST-hash3,SOMMER-121025,SOMMER-116041,ML-VIL-OSKU-7438100,ASMIN-887,SOMMER-112080,SOMMER-114102,SOMMER-125043,SOMMER-125150,ML-WEBER-10064,SOMMER-130031,ASMIN-9712,ean-case_pack-45060,ean-case_pack-37175,ASMIN-533,SOMMER-141046,ASMIN-971,SOMMER-144226,SOMMER-129020,ean-case_pack-27937,SOMMER-107060,SOMMER-127139,ASMIN-1361,ASMIN-4459,SOMMER-122038,ASMIN-1419,ean-case_pack-40552,SOMMER-118093,ASMIN-4437,SOMMER-125103,4251032601154,ASMIN-324,SOMMER-122031,ASMIN-150,ASMIN-5005,MISSING-EAN-SOLI-04,SOMMER-125052,SOMMER-128021,SOMMER-107016,SOMMER-209025,SOMMER-114003,SOMMER-114111,8714100581322,ASMIN-3035,ean-case_pack-37106,ASMIN-3030,SOMMER-410076,SOMMER-144130,MISSING-10043,ASMIN-86,SOMMER-122030,SOMMER-112167,SOMMER-111052,4060594002312,DEWI-2058,ean-case_pack-45016,ean-case_pack-38917,SOMMER-105032,SOMMER-122012,ean-case_pack-27928,SOMMER-122057,ASMIN-207,SOMMER-120015,SOMMER-207003,ean-case_pack-35656,ean-case_pack-35967,ASMIN-814,SOMMER-410069,5000267165783,MISSING-10046,SOMMER-111033,SOMMER-142009,SOMMER-209022,SOMMER-107058,ASMIN-2317,ASMIN-501,SOMMER-127031,SOMMER-122132,1000001,SOMMER-128016,ASMIN-3142,SOMMER-145065,ML-WEBER-8819,4260158882033,5000112548167,ASMIN-4214,SOMMER-131024,SOMMER-120046,SOMMER-122080,ML-B-TEAM-OSKU-71300,ASMIN-2342,ASMIN-4443,SOMMER-124024,SOMMER-140023,ASMIN-318,ean-case_pack-30433,ML-VIL-OSKU-231100,SOMMER-142017,4260158881937,ASMIN-1322,SOMMER-100033,ASMIN-950,ASMIN-1189,SOMMER-142001,ASMIN-354,SOMMER-105035,ASMIN-569,4067800001756,SOMMER-107012,ASMIN-618,ASMIN-232,ASMIN-1467,ASMIN-631,SOMMER-114062,ASMIN-1311,SOMMER-144249,ASMIN-2209,ean-case_pack-27933,SOMMER-124093,ean-case_pack-31523,ASMIN-2225,SOMMER-125068,ASMIN-9709,SOMMER-131025,SOMMER-103015,SOMMER-410081,SOMMER-131019,SOMMER-114061,ean-case_pack-27828,MISSING-10003,SOMMER-110065,MISSING-EAN-QTRADO-44111,8710622514701,MISSING-10011,ASMIN-929,10002,ean-case_pack-27979,ean-case_pack-27500,ASMIN-531,SOMMER-102006,SOMMER-121120,ean-case_pack-45898,SOMMER-124019,ASMIN-2345,ASMIN-9733,SOMMER-125028,ean-case_pack-45188,SOMMER-410026,SOMMER-113002,ML-B-TEAM-OSKU-990307,SOMMER-101047,ASMIN-835,SOMMER-110026,ASMIN-9766,ASMIN-2075,4052426962215,ASMIN-3020,SOMMER-206103,SOMMER-202077,SOMMER-144090,SOMMER-124117,ML-B-TEAM-OSKU-70447,SOMMER-410027,ASMIN-567,SOMMER-125269,SOMMER-127019,SOMMER-122039,ean-case_pack-27835,SOMMER-124227,MISSING-10019,SOMMER-134024,SOMMER-105105,SOMMER-100002,ASMIN-1264,ean-case_pack-45991,ASMIN-197,ASMIN-837,SOMMER-122144,SOMMER-142036,SOMMER-402037,MISSING-10038,ASMIN-983,SOMMER-129007,SOMMER-122114,SOMMER-114112,ASMIN-619,ean-case_pack-40038,SOMMER-107050,ASMIN-1391,ASMIN-4590,SOMMER-112177,SOMMER-125152,SOMMER-125053,SOMMER-141064,SOMMER-124022,ASMIN-500,SOMMER-142012,SOMMER-130081,SOMMER-105119,ASMIN-3048,SOMMER-127007,SOMMER-110057,ASMIN-436,ean-case_pack-27608,ASMIN-2229,SOMMER-144030,5410316442862,SOMMER-120017,ean-case_pack-28040,SOMMER-410040,ean-case_pack-39175,SOMMER-122045,SOMMER-202022,SOMMER-114039,SOMMER-122078,ASMIN-4583,SOMMER-114070,SOMMER-107003,ASMIN-1199,SOMMER-106002,SOMMER-143020,ASMIN-816,ML-VIL-OSKU-7578120,SOMMER-124025,SOMMER-120063,SOMMER-144003,ASMIN-634,SOMMER-143005,ASMIN-1298,SOMMER-118010,SOMMER-125261,SOMMER-134124,ean-case_pack-27564,SOMMER-141066,ASMIN-9634,SOMMER-118041,SOMMER-122188,SOMMER-116023,SOMMER-114023,ASMIN-4451,ean-case_pack-27111,SOMMER-141054,4030486816983,SOMMER-121123,ASMIN-4442,SOMMER-125093,ean-case_pack-27993,MISSING-10028,SOMMER-129105,NO-EAN-24511,SOMMER-134125,ean-case_pack-36869,SOMMER-116048,ASMIN-2025,SOMMER-208005,SOMMER-129012,ASMIN-375,8000920780510,4019586130359,SOMMER-410009,ean-case_pack-31525,SOMMER-410066,SOMMER-120045,SOMMER-131030,ASMIN-941,ASMIN-986,SOMMER-100041,4002450015463,SOMMER-141012,SOMMER-206081,ean-case_pack-27875,ML-B-TEAM-OSKU-63378,SOMMER-127035,ASMIN-4354,SOMMER-118090,ASMIN-154,ASMIN-1316,SOMMER-125062,SOMMER-125051,SOMMER-124020,ean-case_pack-39777,ASMIN-620,SOMMER-125264,SOMMER-142041,SOMMER-206095,SOMMER-127030,ASMIN-334,MISSING-10050,ML-VIL-OSKU-7652230,SOMMER-145079,ASMIN-4501,SOMMER-144110,ASMIN-3029,ASMIN-865,SOMMER-121118,SOMMER-144203,SOMMER-103011,SOMMER-118040,SOMMER-127088,8714100645161,SOMMER-105063,SOMMER-128032,ASMIN-962,ean-case_pack-28328,ean-case_pack-45030,ASMIN-939,ASMIN-346,ASMIN-9605,SOMMER-134042,SOMMER-114055,ASMIN-468,SOMMER-105077,ean-case_pack-36867,SOMMER-129072,4031063014600,ASMIN-989,4260158887137,MISSING-EAN-SOLI-03,ean-case_pack-36870,MISSING-10044,ML-VIL-OSKU-7430100,SOMMER-125005,SOMMER-125094,SOMMER-142034,SOMMER-105106,SOMMER-112178,SOMMER-410078,MISSING-10030,MISSING-10005,ASMIN-195,ASMIN-93,ASMIN-2041,5740600020767,SOMMER-134035,SOMMER-105110,ASMIN-3293,SOMMER-110040,ASMIN-693,ASMIN-532,SOMMER-120065,SOMMER-122145,SOMMER-134018,SOMMER-127158,ASMIN-4237,SOMMER-112122,SOMMER-124052,ASMIN-1310,ASMIN-399,ASMIN-1870,SOMMER-204004,SOMMER-122193,ean-case_pack-40549,ean-case_pack-39475,SOMMER-134071,42116417,7312040552054,ASMIN-353,SOMMER-122215,4002650006919,SOMMER-112121,ASMIN-2063,SOMMER-124091,ASMIN-4567,ASMIN-4542,ASMIN-3291,SOMMER-124035,10012,SOMMER-105043,MISSING-10010,4054184054355,8714100634271,ML-WEBER-2310,SOMMER-114068,4004210000634,ASMIN-4279,SOMMER-206024,ASMIN-4220,SOMMER-124067,SOMMER-116029,SOMMER-114012,8690526064789,SOMMER-410112,4002650006957,SOMMER-101032,SOMMER-144041,SOMMER-105123,ASMIN-1262,ean-case_pack-32583,ASMIN-420,ean-case_pack-45943,SOMMER-410031,SOMMER-208002,4101010008133,SOMMER-127071,SOMMER-140010,SOMMER-106025,ASMIN-9575,ASMIN-988,ean-case_pack-40550,ASMIN-4581,ean-case_pack-40553,ASMIN-149,ean-case_pack-37082,SOMMER-125140,SOMMER-134022,ML-VIL-OSKU-7745200,SOMMER-105124,ML-WEBER-5309,SOMMER-102007,4060594001032,ASMIN-1306,8712100858970,ean-case_pack-39244,SOMMER-122034,SOMMER-125172,SOMMER-128003,SOMMER-106011,SOMMER-125038,ML-WEBER-2308,ASMIN-652,ASMIN-857,ean-case_pack-45841,SOMMER-101046,SOMMER-200508,SOMMER-125027,ASMIN-9735,SOMMER-144096,SOMMER-209021,SOMMER-307001,SOMMER-202075,SOMMER-113023,ML-WEBER-2311,8690526016139,ASMIN-2495,SOMMER-114110,ML-B-TEAM-OSKU-990306,SOMMER-110045,SOMMER-105104,4052426916133,SOMMER-112204,ASMIN-1851,ASMIN-218,ASMIN-2214,ASMIN-1390,SOMMER-117015,ASMIN-678,SOMMER-145044,8712100694868,ASMIN-168,ASMIN-3000,SOMMER-129098,4260402631448,ASMIN-2287,SOMMER-125040,SOMMER-144007,ASMIN-817,SOMMER-144120,SOMMER-122017,SOMMER-134085,8714100371169,4260158883511,SOMMER-125196,SOMMER-129035,ASMIN-92,SOMMER-102013,SOMMER-114007,SOMMER-114050,4008210181973,SOMMER-101002,SOMMER-101012,5060335635228,5000357107686,ASMIN-815,SOMMER-206080,MISSING-10052,SOMMER-120019,SOMMER-145040,SOMMER-101016,ASMIN-193,ASMIN-143,ASMIN-696,SOMMER-122113,SOMMER-101004,ASMIN-427,4011100042681,ASMIN-4450,SOMMER-122210,SOMMER-100034,80686816072,SOMMER-141015,ASMIN-174,ASMIN-819,SOMMER-116005,ASMIN-489,4260471457024,SOMMER-141035,SOMMER-114069,ASMIN-4257,SOMMER-134028,SOMMER-125260,SOMMER-129093,ASMIN-4589,SOMMER-141018,SOMMER-124204,ASMIN-9574,SOMMER-118049,MISSING-EAN-SOLI-02,ASMIN-3012,SOMMER-124103,SOMMER-142005,SOMMER-115021,SOMMER-404126,SOMMER-129011,4002650006926,SOMMER-127101,ASMIN-198,SOMMER-110088,SOMMER-106027,5000112630329,SOMMER-114034,SOMMER-135015,4260158885737,ASMIN-9637,ASMIN-4250,4001686423394,SOMMER-112049,SOMMER-206018,SOMMER-206031,ASMIN-932,4000512994558,SOMMER-145034,SOMMER-112091,ASMIN-4307,ASMIN-2060,ASMIN-611,SOMMER-127108,7613035930650,ean-case_pack-40542,ASMIN-502,ASMIN-4564,SOMMER-202092,9040400001161,4032800025781,ASMIN-9621,ASMIN-9641,SOMMER-144092,ean-case_pack-45022,SOMMER-117011,SOMMER-124015,SOMMER-134013,ASMIN-1484,SOMMER-125104,ASMIN-330,4260212182123,ASMIN-4575,SOMMER-111050,SOMMER-100042,ASMIN-9593,SOMMER-144074,SOMMER-202064,SOMMER-129022,SOMMER-124087,MISSING-10053,ASMIN-543,SOMMER-103001,SOMMER-110021,SOMMER-112101,SOMMER-129005,ASMIN-4477,SOMMER-127110,SOMMER-125223,ASMIN-9775,5998900518259,ASMIN-374,SOMMER-122010,5450021005792,ASMIN-2059,ASMIN-694,SOMMER-142002,4067800007581,5000299622049,SOMMER-140014,ean-case_pack-36791,SOMMER-107015,SOMMER-125036,SOMMER-110081,ASMIN-359,SOMMER-114020,ASMIN-4427,SOMMER-144066,ASMIN-4425,SOMMER-128025,SOMMER-113011,SOMMER-202045,42278177-FREE,SOMMER-127075,MISSING-10027,ASMIN-9736,SOMMER-127042,ASMIN-394,SOMMER-125158,SOMMER-213009,SOMMER-410087,ASMIN-504,ean-case_pack-40226,ASMIN-2013,ASMIN-181,SOMMER-120050,SOMMER-114059,42116431,SOMMER-102012,ML-WEBER-10068,SOMMER-144086,ASMIN-4292,SOMMER-122148,ASMIN-4347,ML-VIL-OSKU-227100,SOMMER-103003,MISSING-10057,SOMMER-125243,ean-case_pack-36812,SOMMER-144016,ASMIN-954,SOMMER-125139,SOMMER-144247,SOMMER-201016,SOMMER-204052,SOMMER-118013,SOMMER-130002,SOMMER-112083,ean-case_pack-28242,4260158881234,SOMMER-113027,SOMMER-130055,ASMIN-472,ASMIN-2009,SOMMER-112170,ean-case_pack-40546,SOMMER-122090,ML-VIL-OSKU-7735200,MISSING-10045,SOMMER-112208,ean-case_pack-27498,ASMIN-836,ASMIN-4367,SOMMER-113010,3057067253501,SOMMER-145032,SOMMER-121060,SOMMER-144131,SOMMER-114025,ASMIN-687,SOMMER-121004,MISSING-EAN-QTRADO-44112,SOMMER-142025,4069400845532,ASMIN-3003,4054184054294,ML-B-TEAM-OSKU-990181,ASMIN-4568,ML-FREE-AD-4260107226987,ASMIN-9594,MISSING-10023,SOMMER-116001,SOMMER-122079,custom-345306904,SOMMER-142044,SOMMER-122025,SOMMER-124202,SOMMER-118092,ASMIN-1125,ean-case_pack-39439,5000112548129,SOMMER-144019,SOMMER-142014,4013060003306,SOMMER-115032,ean-case_pack-34739,ean-case_pack-33403,ASMIN-9348,ASMIN-9824,MISSING-10047,ASMIN-555,ASMIN-4591,SOMMER-100020,SOMMER-131017,SOMMER-145020,ean-case_pack-37020,SOMMER-116050,4067800005273,ean-case_pack-40146,SOMMER-127099,ASMIN-4562,ean-case_pack-45839,MISSING-10033,ASMIN-2271,SOMMER-121001,ASMIN-1530,SOMMER-125109,ASMIN-36,ASMIN-4481,SOMMER-129068,SOMMER-130074,SOMMER-130007,SOMMER-206020,SOMMER-125102,SOMMER-125088,SOMMER-202074,ASMIN-495,ASMIN-2346,ASMIN-1462,ASMIN-256,SOMMER-112144,SOMMER-120020,SOMMER-114047,ASMIN-1268,SOMMER-124058,ean-case_pack-32596,SOMMER-125219,SOMMER-120030,4260243040270,ean-case_pack-36981,SOMMER-116025,ASMIN-2149,SOMMER-125108,SOMMER-118038,4069400659078,SOMMER-110055,ASMIN-4585,SOMMER-134104,SOMMER-129107,ean-case_pack-36036,SOMMER-125026,SOMMER-202017,SOMMER-201001,MISSING-10020,ean-case_pack-44443,ASMIN-574,SOMMER-120008,SOMMER-112048,ASMIN-247,ASMIN-382,ASMIN-1358,MISSING-10025,10005,SOMMER-107040,SOMMER-144202,ean-case_pack-41989,ASMIN-355,ean-case_pack-35644,SOMMER-129046,8000500329061,ASMIN-4296,SOMMER-124013,SOMMER-141063,ean-case_pack-27721,SOMMER-113025,ean-case_pack-29272,ML-VIL-OSKU-831050,SOMMER-134036,SOMMER-101001,SOMMER-206074,ASMIN-700,SOMMER-107011,4260193043024,SOMMER-120041,4260158881739,ASMIN-2281,SOMMER-100018,ean-case_pack-35814,4002650006995,SOMMER-121021,SOMMER-113009,ASMIN-9842,MISSING-10035,ASMIN-5050,4260158881630,42116424,SOMMER-209027,SOMMER-120055,SOMMER-121053,ASMIN-934,ML-WEBER-5710,4260158882231,SOMMER-145049,ASMIN-549,4260158881432,SOMMER-141002,SOMMER-122216,SOMMER-125268,SOMMER-122014,ASMIN-596,4069400358308,SOMMER-100040,SOMMER-118045,SOMMER-204013,SOMMER-107035,SOMMER-125169,SOMMER-114052,4260158886239,SOMMER-141049,SOMMER-122098,SOMMER-124110,ean-case_pack-45015,ean-case_pack-27566,SOMMER-144048,8710622530084,ean-case_pack-40548,5710840211799,SOMMER-125194,ean-case_pack-36854,ASMIN-1563,ASMIN-982,SOMMER-206089,ASMIN-955,ASMIN-1253,SOMMER-100019,ASMIN-937,SOMMER-410029}'::text[])) OR (stock_items.ean IS NULL))
  • Rows Removed by Filter: 245
4. 100.113 2,151.964 ↓ 11.0 321,972 1

Nested Loop (cost=17,768.97..84,262.63 rows=29,241 width=69) (actual time=1,505.742..2,151.964 rows=321,972 loops=1)

5. 85.718 386.371 ↓ 10.0 83,274 1

Hash Join (cost=17,768.55..19,422.73 rows=8,333 width=65) (actual time=198.470..386.371 rows=83,274 loops=1)

  • Hash Cond: (order_requests.venue_id = venues.id)
6. 57.888 297.303 ↓ 5.0 84,019 1

Hash Join (cost=17,578.73..19,087.11 rows=16,662 width=65) (actual time=195.102..297.303 rows=84,019 loops=1)

  • Hash Cond: (order_requests.supplier_store_id = supplier_stores.id)
7. 187.502 239.217 ↓ 1.0 84,408 1

Sort (cost=17,563.20..17,769.66 rows=82,583 width=189) (actual time=194.855..239.217 rows=84,408 loops=1)

  • Sort Key: order_requests.created_at
  • Sort Method: external merge Disk: 4,120kB
8. 51.715 51.715 ↓ 1.0 84,408 1

Seq Scan on order_requests (cost=0.00..3,195.83 rows=82,583 width=189) (actual time=0.015..51.715 rows=84,408 loops=1)

9. 0.014 0.198 ↓ 2.1 57 1

Hash (cost=15.20..15.20 rows=27 width=49) (actual time=0.198..0.198 rows=57 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
10. 0.036 0.184 ↓ 2.1 57 1

Hash Join (cost=9.00..15.20 rows=27 width=49) (actual time=0.130..0.184 rows=57 loops=1)

  • Hash Cond: (supplier_stores.supplier_id = suppliers.id)
11. 0.050 0.050 ↓ 2.0 136 1

Seq Scan on supplier_stores (cost=0.00..5.67 rows=67 width=37) (actual time=0.019..0.050 rows=136 loops=1)

  • Filter: CASE WHEN ((name)::text = 'B.E.S.T. ACME'::text) THEN false ELSE true END
12. 0.008 0.098 ↑ 1.0 46 1

Hash (cost=8.43..8.43 rows=46 width=28) (actual time=0.097..0.098 rows=46 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
13. 0.090 0.090 ↑ 1.0 46 1

Seq Scan on suppliers (cost=0.00..8.43 rows=46 width=28) (actual time=0.017..0.090 rows=46 loops=1)

  • Filter: ((status)::text = 'live'::text)
  • Rows Removed by Filter: 68
14. 0.767 3.350 ↓ 2.0 4,050 1

Hash (cost=164.54..164.54 rows=2,022 width=16) (actual time=3.350..3.350 rows=4,050 loops=1)

  • Buckets: 4,096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 222kB
15. 2.583 2.583 ↓ 2.0 4,050 1

Seq Scan on venues (cost=0.00..164.54 rows=2,022 width=16) (actual time=0.024..2.583 rows=4,050 loops=1)

  • Filter: CASE WHEN ((name)::text = 'Best Abholmarkt'::text) THEN false ELSE true END
  • Rows Removed by Filter: 2
16. 1,665.480 1,665.480 ↑ 2.5 4 83,274

Index Scan using index_order_request_items_on_order_request_id on order_request_items (cost=0.43..7.68 rows=10 width=20) (actual time=0.016..0.020 rows=4 loops=83,274)

  • Index Cond: (order_request_id = order_requests.id)
  • Filter: ((created_at >= '2020-08-10 00:00:00'::timestamp without time zone) AND (created_at < '2020-10-19 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 20
17. 2,253.804 2,253.804 ↑ 1.0 1 321,972

Index Scan using stock_items_pkey on stock_items (cost=0.42..0.60 rows=1 width=130) (actual time=0.006..0.007 rows=1 loops=321,972)

  • Index Cond: (order_request_items.stock_item_id = id)
Planning time : 31.892 ms
Execution time : 30,372.512 ms