explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7o77

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 47.051 ↓ 0.0 0 1

Nested Loop (cost=1.14..3,688.37 rows=1 width=8) (actual time=47.051..47.051 rows=0 loops=1)

2. 0.017 47.050 ↓ 0.0 0 1

Nested Loop (cost=0.85..3,685.93 rows=1 width=12) (actual time=47.050..47.050 rows=0 loops=1)

  • Join Filter: (slr_order_for_job_item.candidate_id = slr_employee.candidate_id)
3. 0.052 46.601 ↓ 1.0 36 1

Nested Loop (cost=0.42..3,082.71 rows=35 width=16) (actual time=1.038..46.601 rows=36 loops=1)

4. 46.261 46.261 ↓ 1.0 36 1

Seq Scan on slr_order_for_job_item (cost=0.00..2,990.22 rows=35 width=12) (actual time=1.022..46.261 rows=36 loops=1)

  • Filter: (admission_date = to_date('2019-03-20'::text, 'yyyy-mm-dd'::text))
  • Rows Removed by Filter: 97005
5. 0.288 0.288 ↑ 1.0 1 36

Index Only Scan using slr_candidate_pkey on slr_candidate (cost=0.42..2.64 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=36)

  • Index Cond: (id = slr_order_for_job_item.candidate_id)
  • Heap Fetches: 36
6. 0.432 0.432 ↓ 0.0 0 36

Index Scan using slr_employee_candidate_id on slr_employee (cost=0.42..17.22 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=36)

  • Index Cond: (candidate_id = slr_candidate.id)
  • Filter: ((ent_id = 4806) AND (id = ANY ('{1069320,1069321,1069322,1069323,1069324,1069325,1069327,1069328,1069329,1069331,1069332,1069333,1069336,1069338,1069339,1069341,1069342,1069343,1069344,1069345,1069348,1069350,1069351,1069353,1069354,1069355,1069357,1069358,1069362,1069363,1069364,1069365,1069366,1069368,1069369,1069370,1069371,1069372,1069374,1069375,1069376,1069377,1069378,1069380,1069381,1069382,1069384,1069385,1069386,1069387,1069388,1069389,1069390,1069391,1069393,1069394,1069395,1069396,1069397,1069398,1069399,1069400,1069401,1069402,1069404,1069405,1069406,1069407,1069409,1069410,1069411,1069412,1069414,1069415,1069417,1069418,1069419,1069420,1069421,1069423,1069425,1069426,1069427,1069430,1069432,1069433,1069434,1069437,1069439,1069440,1069441,1069442,1069443,1069448,1069449,1069451,1069453,1069456,1069457,1069458,1069459,1069460,1069461,1069462,1069464,1069465,1069467,1069468,1069469,1069470,1069471,1069473,1069474,1069475,1069476,1069478,1069479,1069480,1069482,1069483,1069484,1069485,1069486,1069487,1069488,1069489,1069490,1069491,1069492,1069493,1069494,1069495,1069497,1069498,1069499,1069500,1069501,1069503,1069504,1069506,1069508,1069509,1069510,1069511,1069512,1069513,1069514,1069515,1069518,1069521,1069523,1069524,1069525,1069527,1069528,1069529,1069530,1069531,1069533,1069537,1069538,1069539,1069540,1069542,1069544,1069545,1069547,1069548,1069549,1069552,1069553,1069554,1069555,1069556,1069557,1069558,1069561,1069562,1069563,1069564,1069565,1069566,1069568,1069569,1069570,1069572,1069573,1069575,1069577,1069578,1069579,1069580,1069581,1069582,1069583,1069584,1069585,1069586,1069590,1069592,1069595,1069596,1069615,1069619,1069622,1069626,1069627,1069628,1069629,1069631,1069633,1069634,1069635,1069636,1069637,1069638,1069639,1069641,1069645,1069646,1069648,1069649,1069650,1069651,1069652,1069653,1069656,1069657,1069658,1069659,1069660,1069661,1069662,1069665,1069666,1069667,1069668,1069671,1069674,1069675,1069677,1069678,1069682,1069683,1069684,1069693,1069696,1069697,1069700,1069701,1069702,1069703,1069704,1069705,1069712,1069713,1069714,1069715,1069716,1069717,1069718,1069721,1069722,1069723,1069725,1069727,1069730,1069732,1069733,1069734,1069736,1069738,1069739,1069740,1069741,1069742,1069744,1069755,1069756,1069757,1069761,1069762,1069763,1069764,1069765,1069767,1069768,1069769,1069770,1069771,1069772,1069773,1069774,1069775,1069776,1069781,1069782,1069784,1069785,1069788,1069793,1069794,1069796,1069798,1069800,1069801,1069804,1069805,1069806,1069808,1069809,1069810,1069812,1069813,1069814,1069815,1069816,1069817,1069819,1069820,1069821,1069822,1069823,1069824,1069826,1069831,1069832,1069834,1069860,1069862,1069863,1069864,1069865,1069867,1069868,1069870,1069871,1069872,1069875,1069876,1069878,1069879,1069880,1069881,1069882,1069883,1069885,1069886,1069887,1069888,1069889,1069890,1069891,1069892,1069896,1069897,1069898,1069900,1069905,1069911,1069912,1069916,1069917,1069918,1069923,1069924,1069925,1069926,1069929,1069930,1069937,1069938,1069939,1069940,1069941,1069943,1069944,1069946,1069947,1069948,1069952,1069953,1069954,1069955,1069956,1069957,1069959,1069960,1069961,1069964,1069965,1069967,1069968,1069973,1069974,1069989,1069994,1069995,1069996,1069997,1069998,1069999,1070000,1070001,1070003,1070005,1070006,1070009,1070011,1070013,1070014,1070015,1070016,1070017,1070019,1070021,1070028,1070029,1070031,1070036,1070037,1070040,1070043,1070044,1070045,1070047,1070048,1070049,1070057,1070058,1070059,1070060,1070063,1070064,1070077,1070078,1070079,1070081,1070083,1070084,1070085,1070086,1070090,1070091,1070097,1070100,1070104,1070108,1070110,1070114,1070115,1070116,1070117,1070118,1070120,1070121,1070122,1070123,1070124,1070125,1070127,1070128,1070129,1070131,1070132,1070133,1070134,1070135,1070136,1070150,1070151,1070152,1070154,1070155,1070156,1070157,1070158,1070159,1070160,1070161,1070166,1070167,1070168,1070169,1070170,1070171,1070172,1070173,1070174,1070175,1070176,1070177,1070178,1070179,1070181,1070182,1070183,1070184,1070185,1070186,1070187,1070188,1070189,1070191,1070192,1070193,1070195,1070196,1070197,1070198,1070200,1070201,1070203,1070204,1070206,1070218,1070220,1070222,1070223,1070224,1070226,1070228,1070229,1070230,1070232,1070233,1070234,1070236,1070238,1070239,1070240,1070241,1070242,1070243,1070246,1070248,1070250,1070251,1070252,1070254,1070256,1070258,1070260,1070261,1070263,1070265,1070268,1070269,1070270,1070271,1070272,1070273,1070274,1070275,1070276,1070282,1070283,1070285,1070286,1070287,1070288,1070289,1070291,1070292,1070293,1070294,1070295,1070296,1070297,1070298,1070300,1070301,1070303,1070305,1070309,1070310,1070311,1070312,1070314,1070315,1070316,1070317,1070318,1070322,1070323,1070324,1070325,1070326,1070327,1070328,1070329,1070331,1070332,1070333,1070334,1070335,1070336,1070337,1070338,1070339,1070340,1070341,1070342,1070343,1070344,1070345,1070347,1070348,1070349,1070350,1070351,1070353,1070354,1070355,1070357,1070359,1070361,1070362,1070363,1070364,1070365,1070367,1070368,1070369,1070370,1070371,1070373,1070374,1070375,1070377,1070378,1070379,1070380,1070381,1070382,1070383,1070384,1070385,1070392,1070393,1070397,1070405,1070406,1070407,1070408,1070409,1070410,1070412,1070413,1070416,1070422,1070423,1070425,1070428,1070453,1070465,1070467,1070468,1070469,1070470,1070471,1070472,1070473,1070474,1070475,1070479,1070481,1070482,1070483,1070484,1070492,1070493,1070494,1070496,1070497,1070507,1070510,1070511,1070518,1070521,1070522,1070523,1070524,1070528,1070529,1070530,1070531,1070533,1070545,1070546,1070547,1070548,1070550,1070551,1070552,1070553,1070554,1070555,1070559,1070560,1070562,1070566,1070567,1070568,1070569,1070570,1070572,1070573,1070575,1070577,1070578,1070579,1070580,1070583,1070584,1070585,1070587,1070588,1070589,1070591,1070592,1070593,1070594,1070595,1070598,1070600,1070601,1070602,1070605,1070606,1070620,1070621,1070622,1070624,1070625,1070626,1070629,1070630,1070636,1070639,1070640,1070641,1070644,1070645,1070646,1070647,1070649,1070652,1070653,1070654,1070662,1070663,1070664,1070665,1070666,1070667,1070670,1070671,1070672,1070673,1070675,1070678,1070679,1070680,1070681,1070683,1070684,1070685,1070689,1070692,1070694,1070695,1070696,1070697,1070698,1070699,1070700,1070703,1070707,1070721,1070722,1070725,1070727,1070728,1070730,1070731,1070733,1070734,1070735,1070738,1070739,1070741,1070742,1070743,1070745,1070746,1070747,1070748,1070749,1070750,1070752,1070753,1070755,1070757,1070758,1070759,1070760,1070761,1070763,1070764,1070766,1070768,1070770,1070771,1070772,1070773,1070774,1070775,1070776,1070777,1070780,1070781,1070782,1070784,1070785,1070787,1070788,1070789,1070790,1070791,1070792,1070793,1070794,1070795,1070798,1070800,1070801,1070802,1070803,1070804,1070805,1070807,1070808,1070809,1070810,1070812,1070813,1070814,1070815,1070816,1070817,1070818,1070819,1070820,1070821,1070822,1070823,1070824,1070825,1070827,1070828,1070829,1070830,1070833,1070835,1070836,1070837,1070838,1070843,1070844,1070847,1070848,1070849,1070852,1070853,1070855,1070866,1070867,1070869,1070870,1070871,1070873,1070874,1070875,1070876,1070877,1070878,1070881,1070883,1070884,1070894,1070895,1070896,1070897,1070898,1070899,1070900,1070901,1070902,1070903,1070904,1070905,1070906,1070907,1070908,1070909,1070910,1070911,1070912,1070913,1070914,1070915,1070916,1070917,1070918,1070919,1070921,1070922,1070925,1070926,1070928,1070929,1070930,1070931,1070932,1070933,1070934,1070938,1070939,1070940,1070942,1070943,1070944,1070945,1070946,1070947,1070948,1070949,1070950,1070951,1070952,1070953,1070954,1070955,1070956,1070957,1070959,1070960,1070961,1070962,1070963,1070965,1070966,1070967,1070969,1070970,1070971,1070974,1070976,1070977,1070978,1070980,1070982,1070984,1070985,1070986,1070987,1070988,1070989,1070990,1070991,1070992,1070993,1070994,1070995,1070996,1070997,1070998,1070999,1071000,1071001,1071002,1071003,1071004,1071005,1071006,1071008,1071009,1071010,1071011,1071012,1071013,1071014,1071015,1071016,1071017,1071019,1071020,1071021,1071022,1071023,1071024,1071025,1071026,1071027,1071028,1071030,1071032,1071033,1071034,1071036,1071037,1071038,1071039,1071040,1071041,1071042,1071043,1071044,1071045,1071046,1071048,1071049,1071051,1071052,1071053,1071054,1071055,1071057,1071058,1071059,1071061,1071063,1071064,1071065,1071066,1071067,1071068,1071070,1071071,1071072,1071073,1071074,1071076,1071077,1071078,1071079,1071080,1071081,1071082,1071083,1071084,1071085,1071086,1071087,1071088,1071089,1071090,1071091,1071092,1071093,1071094,1071095,1071096,1071097,1071098,1071099,1071100,1071101,1071102,1071103,1071104,1071105,1071106,1071107,1071108,1071109,1071110,1071111,1071112,1071114,1071115,1071116,1071117,1071118,1071119,1071120,1071121,1071122,1071123,1071125,1071126,1071127,1071128,1071132,1071133,1071135,1071136,1071137,1071138,1071139,1071140,1071141,1071143,1071144,1071145,1071146,1071147,1071148,1071149,1071150,1071151,1071152,1071153,1071154,1071155,1071156,1071157,1071158,1071161,1071163,1071164,1071165,1071166,1071167,1071168,1071169,1071170,1071171,1071172,1071173,1071174,1071175,1071176,1071177,1071178,1071180,1071181,1071182,1071183,1071184,1071185,1071186,1071188,1071189,1071191,1071192,1071193,1071194,1071195,1071196,1071197,1071198,1071199,1071200,1071202,1071203,1071204,1071205,1071206,1071207,1071208,1071209,1071210,1071211,1071212,1071214,1071215,1071216,1071217,1071219,1071220,1071221,1071222,1071223,1071224,1071225,1071226,1071227,1071228,1071229,1071230,1071231,1071232,1071233,1071234,1071235,1071236,1071237,1071238,1071239,1071240,1071241,1071242,1071243,1071244,1071245,1071246,1071248,1071249,1071250,1071251,1071252,1071253,1071254,1071255,1071256,1071257,1071258,1071260,1071261,1071262,1071263,1071265,1071266,1071267,1071268,1071269,1071270,1071271,1071272,1071273,1071274,1071275,1071276,1071277,1071279,1071280,1071281,1071282,1071283,1071284,1071285,1071286,1071288,1071289,1071291,1071292,1071293,1071295,1071296,1071297,1071298,1071299,1071300,1071301,1071303,1071304,1071305,1071306,1071307,1071308,1071309,1071310,1071311,1071312,1071314,1071315,1071316,1071317,1071318,1071319,1071321,1071322,1071323,1071324,1071325,1071326,1071327,1071328,1071329,1071330,1071331,1071333,1071334,1071335,1071336,1071337,1071338,1071339,1071340,1071341,1071342,1071343,1071344,1071345,1071346,1071347,1071348,1071349,1071351,1071352,1071353,1071354,1071355,1071356,1071358,1071359,1071360,1071362,1071363,1071364,1071365,1071366,1071367,1071368,1071369,1071370,1071371,1071372,1071373,1071374,1071375,1071376,1071377,1071379,1071380,1071381,1071382,1071384,1071385,1071386,1071387,1071388,1071389,1071390,1071391,1071393,1071394,1071395,1071397,1071398,1071399,1071400,1071401,1071402,1071403,1071404,1071405,1071406,1071407,1071408,1071410,1071411,1071412,1071413,1071414,1071415,1071418,1071419,1071420,1071421,1071422,1071423,1071424,1071425,1071426,1071427,1071428,1071429,1071430,1071431,1071432,1071433,1071434,1071435,1071437,1071438,1071440,1071441,1071442,1071444,1071445,1071447,1071448,1071449,1071450,1071451,1071452,1071454,1071455,1071457,1071458,1071459,1071460,1071462,1071463,1071464,1071465,1071466,1071467,1071468,1071469,1071471,1071472,1071473,1071474,1071475,1071476,1071477,1071478,1071479,1071480,1071481,1071483,1071484,1071485,1071486,1071487,1071488,1071489,1071490,1071491,1071492,1071494,1071495,1071496,1071497,1071498,1071499,1071500,1071501,1071502,1071503,1071504,1071505,1071506,1071507,1071508,1071509,1071510,1071511,1071512,1071513,1071514,1071516,1071517,1071518,1071519,1071520,1071521,1071522,1071523,1071525,1071526,1071527,1071528,1071531,1071532,1071533,1071534,1071536,1071537,1071539,1071540,1071541,1071543,1071544,1071546,1071547,1071548,1071549,1071550,1071551,1071552,1071553,1071554,1071555,1071556,1071557,1071559,1071560,1071561,1071562,1071563,1071564,1071565,1071566,1071568,1071569,1071570,1071571,1071572,1071573,1071574,1071576,1071578,1071579,1071580,1071581,1071582,1071583,1071584,1071585,1071586,1071587,1071588,1071589,1071590,1071591,1071592,1071594,1071595,1071596,1071597,1071598,1071599,1071600,1071601,1071603,1071604,1071605,1071608,1071609,1071610,1071612,1071613,1071614,1071615,1071616,1071617,1071618,1071621,1071622,1071623,1071624,1071625,1071626,1071627,1071628,1071629,1071630,1071631,1071632,1071634,1071635,1071637,1071638,1071639,1071640,1071641,1071642,1071643,1071644,1071645,1071646,1071647,1071648,1071649,1071650,1071651,1071653,1071656,1071659,1071660,1071661,1071662,1071663,1071664,1071666,1071667,1071668,1071669,1071670,1071671,1071672,1071674,1071676,1071678,1071679,1071680,1071681,1071682,1071683,1071685,1071686,1071687,1071689,1071690,1071691,1071692,1071693,1071694,1071695,1071696,1071697,1071698,1071700,1071701,1071702,1071703,1071704,1071706,1071707,1071709,1071710,1071711,1071712,1071713,1071714,1071715,1071716,1071717,1071718,1071719,1071720,1071721,1071722,1071723,1071724,1071727,1071728,1071729,1071730,1071731,1071732,1071733,1071734,1071735,1071736,1071737,1071738,1071739,1071742,1071743,1071745,1071746,1071749,1071750,1071751,1071752,1071753,1071754,1071755,1071756,1071757,1071758,1071759,1071760,1071761,1071762,1071763,1071764,1071766,1071767,1071768,1071769,1071770,1071771,1071772,1071773,1071774,1071776,1071777,1071778,1071779,1071781,1071782,1071783,1071784,1071787,1071788,1071789,1071791,1071792,1071793,1071794,1071795,1071796,1071797,1071798,1071799,1071800,1071801,1071802,1071803,1071804,1071805,1071806,1071807,1071808,1071809,1071811,1071812,1071813,1071814,1071816,1071817,1071818,1071819,1071820,1071823,1071824,1071825,1071826,1071827,1071828,1071829,1071830,1071831,1071832,1071833,1071834,1071835,1071838,1071839,1071840,1071842,1071844,1071845,1071846,1071848,1071849,1071851,1071852,1071853,1071854,1071855,1071856,1071857,1071858,1071859,1071860,1071861,1071862,1071863,1071864,1071866,1071867,1071868,1071869,1071870,1071871,1071872,1071873,1071874,1071875,1071876,1071878,1071879,1071880,1071881,1071882,1071883,1071885,1071886,1071887,1071888,1071889,1071891,1071892,1071893,1071894,1071895,1071896,1071897,1071899,1071900,1071901,1071903,1071905,1071906,1071907,1071908,1071910,1071912,1071913,1071914,1071915,1071916,1071917,1071918,1071919,1071920,1071921,1071922,1071923,1071924,1071925,1071926,1071927,1071928,1071929,1071930,1071931,1071932,1071933,1071934,1071935,1071936,1071937,1071938,1071939,1071940,1071941,1071943,1071945,1071946,1071947,1071948,1071949,1071950,1071951,1071953,1071954,1071955,1071956,1071957,1071958,1071959,1071960,1071961,1071962,1071963,1071964,1071966,1071967,1071969,1071970,1071971,1071973,1071974,1071976,1071977,1071978,1071979,1071980,1071982,1071985,1071987,1071988,1071990,1071991,1071994,1071995,1071996,1071997,1071998,1071999,1072000,1072001,1072002,1072004,1072005,1072006,1072007,1072008,1072009,1072010,1072011,1072012,1072013,1072014,1072015,1072016,1072017,1072018,1072019,1072020,1072021,1072022,1072023,1072024,1072025,1072026,1072027,1072028,1072029,1072030,1072031,1072032,1072033,1072034,1072035,1072036,1072037,1072038,1072039,1072040,1072041,1072042,1072044,1072047,1072048,1072050,1072051,1072052,1072053,1072055,1072056,1072057,1072058,1072060,1072061,1072063,1072064,1072065,1072067,1072068,1072069,1072070,1072071,1072072,1072073,1072074,1072075,1072076,1072077,1072078,1072079,1072080,1072081,1072082,1072083,1072084,1072085,1072086,1072087,1072088,1072089,1072090,1072091,1072092,1072094,1072095,1072096,1072098,1072099,1072101,1072102,1072103,1072104,1072105,1072106,1072107,1072109,1072110,1072111,1072112,1072113,1072115,1072116,1072117,1072118,1072119,1072120,1072121,1072123,1072124,1072125,1072126,1072127,1072129,1072130,1072133,1072134,1072135,1072136,1072138,1072139,1072140,1072141,1072142,1072143,1072144,1072145,1072147,1072150,1072151,1072152,1072154,1072155,1072156,1072158,1072160,1072161,1072162,1072163,1072164,1072165,1072166,1072167,1072168,1072169,1072170,1072171,1072172,1072173,1072175,1072176,1072177,1072178,1072180,1072181,1072183,1072184,1072186,1072187,1072188,1072189,1072190,1072192,1072194,1072196,1072198,1072203,1072205,1072206,1072207,1072208,1072209,1072210,1072211,1072212,1072213,1072215,1072216,1072217,1072218,1072219,1072220,1072221,1072222,1072223,1072224,1072225,1072226,1072227,1072228,1072229,1072230,1072231,1072233,1072234,1072235,1072236,1072237,1072238,1072239,1072240,1072241,1072243,1072244,1072245,1072246,1072247,1072250,1072251,1072252,1072253,1072254,1072255,1072256,1072257,1072258,1072259,1072261,1072263,1072265,1072266,1072270,1072272,1072274,1072276,1072280,1072282,1072284,1072286,1072288,1072289,1072291,1072292,1072293,1072294,1072295,1072296,1072298,1072299,1072300,1072301,1072302,1072304,1072305,1072306,1072307,1072308,1072309,1072310,1072311,1072312,1072313,1072314,1072315,1072316,1072317,1072318,1072319,1072320,1072322,1072325,1072326,1072327,1072328,1072329,1072330,1072332,1072333,1072334,1072339,1072340,1072341,1072343,1072344,1072347,1072348,1072351,1072352,1072353,1072354,1072355,1072356,1072357,1072358,1072359,1072360,1072361,1072362,1072363,1072364,1072365,1072366,1072367,1072368,1072369,1072370,1072371,1072372,1072373,1072374,1072375,1072376,1072377,1072378,1072379,1072380,1072381,1072382,1072385,1072386,1072387,1072388,1072389,1072390,1072391,1072392,1072393,1072394,1072395,1072396,1072397,1072398,1072399,1072400,1072401,1072402,1072403,1072404,1072405,1072406,1072407,1072408,1072409,1072410,1072411,1072412,1072413,1072414,1072415,1072416,1072417,1072418,1072419,1072420,1072421,1072422,1072424,1072425,1072426,1072429,1072430,1072431,1072432,1072434,1072435,1072437,1072438,1072439,1072442,1072443,1072444,1072445,1072447,1072448,1072449,1072450,1072451,1072452,1072453,1072455,1072456,1072457,1072458,1072459,1072460,1072461,1072463,1072464,1072465,1072466,1072467,1072468,1072469,1072470,1072472,1072473,1072474,1072475,1072476,1072477,1072479,1072480,1072481,1072482,1072483,1072486,1072487,1072488,1072489,1072490,1072491,1072493,1072494,1072496,1072497,1072498,1072499,1072500,1072501,1072502,1072503,1072504,1072505,1072506,1072507,1072508,1072509,1072510,1072511,1072512,1072513,1072514,1072515,1072516,1072517,1072518,1072519,1072520,1072521,1072522,1072523,1072524,1072525,1072526,1072527,1072528,1072529,1072531,1072532,1072533,1072534,1072535,1072536,1072537,1072538,1072539,1072540,1072541,1072542,1072543,1072544,1072546,1072547,1072548,1072549,1072551,1072552,1072553,1072554,1072555,1072556,1072557,1072558,1072559,1072560,1072561,1072563,1072564,1072565,1072568,1072569,1072570,1072572,1072573,1072574,1072575,1072576,1072577,1072578,1072579,1072580,1072582,1072583,1072584,1072585,1072586,1072587,1072589,1072590,1072592,1072593,1072594,1072595,1072596,1072597,1072598,1072602,1072603,1072605,1072607,1072609,1072612,1072613,1072614,1072615,1072617,1072618,1072619,1072620,1072622,1072623,1072624,1072625,1072626,1072628,1072629,1072630,1072632,1072634,1072635,1072636,1072637,1072638,1072639,1072640,1072642,1072643,1072644,1072645,1072646,1072649,1072650,1072651,1072652,1072653,1072654,1072656,1072657,1072659,1072660,1072661,1072663,1072665,1072666,1072667,1072668,1072669,1072670,1072672,1072673,1072675,1072676,1072677,1072678,1072679,1072680,1072681,1072683,1072684,1072685,1072686,1072688,1072689,1072690,1072692,1072693,1072694,1072695,1072696,1072697,1072698,1072699,1072700,1072701,1072703,1072704,1072705,1072706,1072707,1072708,1072709,1072710,1072711,1072712,1072715,1072716,1072717,1072718,1072719,1072720,1072721,1072722,1072723,1072724,1072726,1072727,1072728,1072730,1072731,1072732,1072734,1072735,1072736,1072737,1072739,1072740,1072741,1072742,1072743,1072744,1072745,1072746,1072749,1072750,1072752,1072753,1072754,1072755,1072756,1072757,1072758,1072760,1072761,1072763,1072765,1072766,1072767,1072768,1072769,1072770,1072771,1072772,1072774,1072776,1072777,1072778,1072779,1072780,1072781,1072782,1072783,1072784,1072785,1072786,1072787,1072788,1072789,1072790,1072791,1072792,1072794,1072795,1072796,1072797,1072799,1072801,1072802,1072803,1072804,1072805,1072806,1072807,1072809,1072811,1072812,1072813,1072814,1072815,1072816,1072817,1072818,1072819,1072820,1072823,1072824,1072825,1072826,1072827,1072830,1072831,1072832,1072833,1072834,1072835,1072836,1072837,1072838,1072840,1072841,1072843,1072844,1072845,1072847,1072848,1072849,1072850,1072851,1072852,1072853,1072854,1072855,1072856,1072858,1072860,1072862,1072863,1072864,1072865,1072866,1072867,1072868,1072869,1072870,1072871,1072872,1072873,1072875,1072876,1072877,1072878,1072879,1072881,1072882,1072883,1072886,1072887,1072888,1072889,1072890,1072891,1072892,1072893,1072894,1072895,1072896,1072897,1072899,1072900,1072901,1072902,1072903,1072905,1072906,1072908,1072909,1072910,1072912,1072913,1072914,1072915,1072916,1072917,1072918,1072919,1072920,1072923,1072924,1072925,1072926,1072927,1072928,1072929,1072932,1072936,1072937,1072938,1072939,1072940,1072941,1072942,1072943,1072944,1072945,1072946,1072947,1072948,1072949,1072950,1072951,1072953,1072954,1072955,1072956,1072957,1072958,1072959,1072961,1072962,1072963,1072964,1072965,1072967,1072968,1072969,1072970,1072971,1072973,1072974,1072975,1072976,1072977,1072978,1072980,1072981,1072982,1072983,1072984,1072985,1072986,1072988,1072989,1072990,1072991,1072992,1072993,1072995,1072997,1072998,1072999,1073001,1073002,1073003,1073004,1073005,1073006,1073007,1073008,1073009,1073010,1073011,1073012,1073013,1073014,1073016,1073018,1073019,1073022,1073023,1073024,1073025,1073026,1073027,1073028,1073029,1073031,1073032,1073033,1073034,1073035,1073036,1073037,1073038,1073039,1073040,1073041,1073042,1073043,1073044,1073045,1073047,1073048,1073049,1073050,1073051,1073052,1073053,1073054,1073055,1073057,1073058,1073060,1073061,1073062,1073063,1073064,1073067,1073069,1073071,1073072,1073074,1073075,1073076,1073077,1073078,1073079,1073088,1073089,1073092,1073093,1073102,1073165,1073166,1073167,1073169,1073171,1073172,1073174,1073175,1073176,1073190,1073191,1073192,1073194,1073195,1073196,1073197,1073198,1073199,1073202,1073203,1073204,1073205,1073206,1073208,1073209,1073210,1073214,1073227,1073245,1073247,1073260,1073302,1073303,1073307,1073308,1073309,1073310,1073311,1073312,1073323,1073325,1073335,1073336,1073338,1073366,1073368,1073372,1073374,1073375,1073376,1073378,1073379,1073380,1073381,1073382,1073383,1073384,1073386,1073396,1073397,1073405,1073412,1073413,1073414,1073415,1073416,1073417,1073419,1073420,1073422,1073423,1073424,1073428,1073429,1073431,1073432,1073433,1073434,1073435,1073436,1073437,1073438,1073439,1073440,1073441,1073442,1073443,1073444,1073445,1073446,1073448,1073454,1073463,1073466,1073467,1073473,1073484,1073487,1073491,1073493,1073494,1073528,1073547,1073552,1073554,1073555,1073556,1073557,1073559,1073560,1073576,1073578,1073599,1073604,1073605,1073606,1073607,1073608,1073609,1073612,1073620,1073621,1073622,1073623,1073624,1073625,1073626,1073627,1073628,1073629,1073630,1073631,1073632,1073633,1073634,1073637,1073638,1073639,1073640,1073647,1073649,1073656,1073657,1073672,1073673,1073674,1073675,1073676,1073716,1073717,1073718,1073721,1073723,1073724,1073725,1073726,1073727,1073728,1073744,1073748,1073752,1073800,1073812,1073813,1073814,1073816,1073817,1073818,1073819,1073821,1073822,1073823,1073824,1073832,1073833,1073834,1073835,1073840,1073843,1073844,1073847,1073848,1073849,1073850,1073851,1073853,1073855,1073856,1073857,1073858,1073859,1073860,1073896,1073898,1073899,1073927,1073931,1073932,1073999,1074001,1074002,1074003,1074005,1074006,1074008,1074009,1074013,1074037,1074050,1074052,1074053,1074054,1074055,1074056,1074057,1074059,1074060,1074061,1074063,1074090,1074091,1074092,1074093,1074096,1074097,1074112,1074122,1074131,1074137,1074145,1074148,1074150,1074151,1074152,1074153,1074154,1074155,1074156,1074160,1074190,1074203,1074407,1074413,1074487,1074490,1074493,1074530,1074543,1074551,1074558,1074561,1074595,1074610,1074611,1074678,1074826,1074835,1074836,1074895,1074964,1075032,1075033,1075036,1075049,1075060,1075097,1075106,1075239,1075240,1075267,1075268,1075272,1075300,1075301,1075302,1075303,1075305,1075306,1075310,1075317,1075318,1075348,1075349,1075350,1075351,1075352,1075353,1075354,1075355,1075358,1075359,1075376,1075381,1075383,1075385,1075388,1075391,1075394,1075398,1075400,1075401,1075403,1075405,1075478,1075493,1075522,1075523,1075529,1075530,1075532,1075557,1075558,1075564,1075567,1075568,1075569,1075570,1075571,1075572,1075573,1075574,1075576,1075585,1075586,1075587,1075588,1075604,1076309,1076324,1076335,1076336,1076345,1076357,1076362,1076363,1076364,1076377,1076378,1076379,1076382,1076388,1076394,1076401,1076420,1076551,1076600,1076641,1076642,1076643,1076645,1076646,1076648,1076649,1076651,1076652,1076653,1076654,1076655,1076656,1076689,1076691,1076692,1076693,1076694,1076703,1076705,1076706,1076722,1076725,1076726,1076727,1076728,1076729,1076731,1076734,1076735,1076736,1076737,1076740,1076741,1076744,1076747,1076748,1076760,1076761,1076765,1076767,1076776,1076778,1076779,1076780,1076787,1076791,1076792,1078630,1078631,1078632,1078633,1078636,1078638,1078640,1078641,1078642,1078643,1078644,1078645,1078646,1078647,1078648,1078649,1078650,1078653,1078654,1078657,1078658,1078659,1078660,1078661,1078662,1078663,1078664,1078665,1078666,1078667,1078668,1078669,1078670,1078671,1078672,1078673,1078675,1078676,1078681,1078683,1078684,1078685,1078686,1078691,1078693,1078696,1078697,1078698,1078699,1078702,1078703,1078704,1078705,1078706,1078739,1078741,1078745,1078746,1078752,1078880,1080808,1088380,1088824,1088826,1088828,1088829,1088836,1088837,1088838,1088839,1088841,1088851,1088852,1088856,1088857,1088860,1088862,1088863,1088864,1088865,1088866,1088873,1088874,1088875,1088876,1088879,1088883,1088886,1088887,1088888,1088889,1088890,1088893,1088895,1088897,1088898,1088900,1088901,1088902,1088904,1088905,1088909,1088913,1088915,1088916,1088920,1088925,1088931,1088932,1088933,1088934,1088935,1088936,1088939,1088948,1088953,1088957,1088959,1088962,1088972,1088974,1088976,1088979,1088985,1088987,1088994,1088996,1088999,1089003,1089008,1089009,1089010,1089019,1089021,1089023,1089024,1089029,1089034,1089035,1089037,1089038,1089041,1089043,1089046,1089047,1089049,1089052,1089054,1089055,1089057,1089058,1089059,1089060,1089063,1089070,1089071,1089072,1089074,1089079,1089084,1089086,1089092,1089095,1089096,1089097,1089098,1089099,1089102,1089104,1089106,1089109,1089118,1089120,1089122,1089123,1089124,1089125,1089134,1089135,1089137,1089138,1089141,1089142,1089145,1089149,1089150,1089151,1089152,1089164,1089165,1089166,1089176,1089188,1089189,1089195,1089199,1089202,1089204,1089206,1089216,1089217,1089220,1089221,1089222,1089223,1089224,1089226,1089227,1089237,1089243,1089244,1089245,1090551,1090552,1090554,1090556,1090557,1090561,1090562,1090565,1092796,1092798,1109948,1111940,1113074,1114861,1121994,1129057,1129059,1135314,1135316,1135589,1135593,1135594,1135597,1135598,1135599,1136446,1136456,1136457,1136593,1136636,1136647,1136658,1137400,1137403,1137412,1137420,1137423,1137425,1137430,1137431,1137432,1137435,1141773,1144045,1144733,1144885,1159261,1159267,1159268,1159331,1159332,1159333,1159334,1159335,1159336,1159337,1159339,1159345,1159363,1159412,1159416,1159423,1159424,1159434,1159447,1159448,1159449,1159515,1159516,1159517,1159518,1159520,1159541,1159542,1159562,1159571,1159634,1159670,1159691,1159722,1159753,1159757,1159758,1159765,1159768,1159841,1159878,1159879,1159889,1159991,1160000,1160001,1160012,1160025,1160026,1160027,1160034,1160061,1160065,1160090,1160092,1160102,1160103,1160104,1160105,1160121,1160122,1160164,1160175,1160199,1160200,1160210,1160211,1160213,1160214,1160215,1160229,1160230,1160231,1160243,1160244,1160245,1160308,1160322,1160350,1160351,1160376,1160378,1160387,1160399,1160478,1160479,1160480,1160481,1160482,1160483,1160484,1160486,1160500,1160521,1160559,1160565,1160573,1160574,1160575,1160576,1160577,1160580,1160585,1160586,1160589,1160869,1160876,1160892,1162070,1162072,1162073,1169928,1172181,1172182,1174030,1179511,1181554,1181628,1184920,1184921,1184922,1184923,1184924,1184925,1184926,1184928,1184933,1184934,1184939,1184940,1184941,1184942,1184943,1184945,1184946,1184948,1184949,1184950,1184951,1184953,1184954,1184955,1184956,1184958,1184960,1184962,1184963,1184964,1184965,1184966,1184970,1184971,1184972,1184973,1184976,1184977,1184978,1184979,1184981,1184982,1184983,1184984,1184985,1184986,1184987,1184988,1184989,1184990,1184991,1184992,1184994,1184997,1184998,1184999,1185000,1185002,1185003,1185004,1185005,1185006,1185008,1185009,1185010,1185011,1185012,1185013,1185014,1185015,1185016,1185019,1185020,1185021,1185022,1185023,1185024,1185026,1185027,1185028,1185029,1185030,1185031,1185032,1185033,1185034,1185035,1185037,1185038,1185039,1185040,1185041,1185042,1185043,1185044,1185045,1185046,1185047,1185048,1185049,1185050,1185051,1185052,1185053,1185054,1185055,1185056,1185057,1185058,1185059,1185060,1185061,1185062,1185063,1185064,1185065,1185066,1185067,1185068,1185069,1185070,1185071,1185072,1185073,1185074,1185075,1185076,1185077,1185078,1185079,1185080,1185081,1185082,1185083,1185084,1185085,1185086,1185087,1185089,1185090,1185091,1185095,1185100,1185101,1185102,1185103,1185104,1185105,1185106,1185107,1185108,1185109,1185111,1185112,1185114,1185116,1185118,1185119,1185120,1185121,1185125,1185126,1185127,1185128,1185129,1185130,1185131,1185132,1185133,1185134,1185136,1185137,1185139,1185140,1185141,1185142,1185143,1185144,1185145,1185146,1185147,1185148,1185149,1185150,1185151,1185152,1185153,1185155,1185156,1185157,1185158,1185160,1185164,1185165,1185166,1185167,1185168,1185170,1185171,1185172,1185176,1185177,1185178,1185179,1185180,1185181,1185182,1185184,1185185,1185186,1185187,1185189,1185190,1185191,1185192,1185193,1185195,1185196,1185198,1185199,1185200,1185201,1185202,1185203,1185205,1185206,1185207,1185209,1185210,1185211,1185212,1185213,1185215,1185216,1185218,1185219,1185220,1185222,1185223,1185226,1185227,1185228,1185229,1185230,1185231,1185232,1185233,1185234,1185235,1185236,1185237,1185238,1185240,1185241,1185242,1185243,1185244,1185245,1185246,1185247,1185248,1185249,1185250,1185251,1185252,1185253,1185254,1185255,1185256,1185257,1185258,1185259,1185260,1185261,1185263,1185264,1185265,1185266,1185267,1185268,1185270,1185271,1185272,1185274,1185275,1185276,1185277,1185278,1185279,1185280,1185281,1185282,1185283,1185285,1185286,1185287,1185288,1185289,1185290,1185291,1185292,1185293,1185294,1185295,1185296,1185297,1185298,1185301,1185302,1185303,1185304,1185305,1185306,1185308,1185309,1185310,1185313,1185314,1185315,1185319,1185320,1185321,1185322,1185323,1185324,1185325,1185326,1185328,1185332,1185337,1185338,1185340,1185342,1185343,1185344,1185345,1185346,1185347,1185350,1185351,1185352,1185353,1185354,1185355,1185356,1185359,1185361,1185362,1185363,1185367,1185368,1185369,1185370,1185376,1185377,1185378,1185379,1185380,1185381,1185382,1185383,1185384,1185385,1185386,1185387,1185388,1185391,1185392,1185393,1185394,1185395,1185396,1185397,1185400,1185401,1185402,1185403,1185405,1185406,1185407,1185408,1185410,1185411,1185412,1185413,1185414,1185415,1185416,1185417,1185425,1185426,1185427,1185428,1185429,1185430,1185431,1185432,1185433,1185434,1185435,1185436,1185437,1185438,1185439,1185440,1185441,1185443,1185444,1185445,1185446,1185447,1185448,1185449,1185450,1185451,1185452,1185453,1185454,1185455,1185456,1185457,1185458,1185459,1185460,1185461,1185462,1185463,1185466,1185467,1185468,1185470,1185471,1185472,1185473,1185474,1185475,1185510,1185511,1185512,1185513,1185514,1185515,1185516,1185517,1185519,1185520,1185522,1185523,1185524,1185525,1185526,1185527,1185528,1185529,1185530,1185531,1185532,1185533,1185534,1185535,1185536,1185537,1185538,1185539,1185540,1185541,1185542,1185543,1185544,1185545,1185546,1185547,1185548,1185549,1185550,1185551,1185552,1185553,1185554,1185555,1185556,1185557,1185558,1185569,1185570,1185571,1185572,1185573,1185575,1185577,1185579,1185580,1185581,1185582,1185583,1185585,1185586,1185587,1185588,1185589,1185590,1185592,1185595,1185598,1185599,1185600,1185601,1185602,1185603,1185604,1185605,1185606,1185607,1185608,1185609,1185610,1185611,1185612,1185613,1185614,1185615,1185616,1185617,1185641,1185642,1185643,1185644,1185645,1185646,1185647,1185648,1185649,1185650,1185652,1185653,1185654,1185659,1185660,1185661,1185662,1185663,1185664,1185665,1185667,1185668,1185669,1185670,1185671,1185672,1185673,1185674,1185675,1185676,1185677,1185678,1185679,1185680,1185681,1185682,1185683,1185691,1185726,1185727,1185728,1185729,1185730,1185731,1185733,1185734,1185735,1185738,1185739,1185740,1185741,1185742,1185743,1185744,1185749,1185750,1185751,1185752,1185754,1185766,1185767,1185768,1185769,1185780,1185782,1185783,1185784,1185785,1185786,1185787,1185791,1185792,1185793,1185798,1185805,1185806,1185807,1185808,1185809,1185810,1185811,1185812,1185813,1185814,1185815,1185816,1185817,1185818,1185820,1185821,1185822,1185823,1185824,1185825,1185826,1185827,1185828,1185838,1185839,1185840,1185841,1185842,1185843,1185844,1185845,1185846,1185847,1185848,1185849,1185850,1185851,1185852,1185853,1185854,1185855,1185856,1185857,1185858,1185859,1185860,1185861,1185862,1185863,1185864,1185865,1185866,1185867,1185868,1185869,1185870,1185871,1185872,1185873,1185874,1185875,1185876,1185877,1185878,1185879,1185880,1185881,1185882,1185883,1185884,1185885,1185886,1185892,1185893,1185894,1185895,1185896,1185897,1185898,1185900,1185901,1185902,1185903,1185904,1185905,1185909,1185910,1185911,1185912,1185913,1185916,1185919,1185920,1185921,1185922,1185923,1185924,1185925,1185926,1185927,1185928,1185929,1185930,1185931,1185932,1188032,1188033,1188034,1188035,1188036,1188037,1188038,1188039,1189184,1189185,1189186,1191341,1192714,1193083,1194899,1195850,1195865,1195866,1195947,1195948,1196617,1197496,1197498,1197509,1197510,1197511,1197512,1197515,1197517,1197518,1197522,1197532,1197533,1197534,1197535,1197536,1197537,1197540,1197543,1197544,1197549,1197551,1197553,1197562,1197563,1197564,1197566,1197569,1197571,1197572,1197575,1197576,1197589,1197591,1197595,1197598,1197605,1197611,1197613,1197618,1197621,1197623,1197624,1197627,1197692,1197732,1197763,1197789,1197790,1197802,1197811,1197829,1197911,1198380,1198389,1198608,1198610,1198702,1198718,1199165,1199265,1199269,1199270,1199271,1199272,1199330,1199336,1199337,1199355,1199426,1199489,1199490,1199597,1199598,1199805,1199891,1199892,1199893,1199894,1199908,1199914,1199920,1199926,1199927,1199928,1199929,1199933,1199934,1199935,1199944,1199945,1199946,1199947,1199950,1200042,1200078,1200108,1200109,1200147,1200203,1200204,1200205,1200213,1200425,1200426,1200427,1200437,1200444,1200445,1200446,1200448,1200547,1200564,1200618,1200619,1200620,1201480,1201482,1201487,1201488,1201489,1201601,1201602,1201609,1201660,1201661,1201662,1201663,1201664,1201879,1201918,1201924,1201938,1201947,1201961,1201969,1201970,1201971,1201972,1201973,1201983,1202000,1202005,1202016,1202021,1202030,1202067,1202083,1202097,1202107,1202131,1202177,1202245,1202259,1202282,1202347,1202393,1202752,1202775,1202776,1202777,1202790,1202795,1202796,1202798,1202799,1202800,1202810,1202812,1202813,1202836,1202837,1202881,1202882,1202898,1202927,1202928,1202937,1202956,1202957,1202991,1202998,1202999,1203003,1203058,1203059,1203060,1203082,1203354,1203355,1203362,1203425,1203430,1203499,1203631,1203851,1203853,1203854,1203857,1203860,1203863,1203864,1203867,1203869,1204208,1204209,1204899,1204900,1204902,1204917,1204918,1204921,1204925,1205137,1205265,1205710,1205722,1205723,1205724,1205763,1206000,1206036,1206037,1206117,1206937,1207277,1207950,1209339,1210140,1210141,1210144,1210145,1210229}'::integer[])))
  • Rows Removed by Filter: 4
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using slr_order_for_job_pkey on slr_order_for_job (cost=0.29..2.45 rows=1 width=4) (never executed)

  • Index Cond: (id = slr_order_for_job_item.order_id)
  • Heap Fetches: 0