explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lI9f

Settings
# exclusive inclusive rows x rows loops node
1. 5.973 9,874.492 ↑ 1.0 4,998 1

HashAggregate (cost=25,788.01..25,838.00 rows=4,999 width=32) (actual time=9,873.420..9,874.492 rows=4,998 loops=1)

  • Output: p1.lobj_id, l0.commentushort, l0.lobj_id
  • Group Key: p1.lobj_id, l0.commentushort, l0.lobj_id
  • Buffers: shared hit=21040
2. 6,081.684 9,868.519 ↑ 1.0 4,998 1

Nested Loop Left Join (cost=0.97..25,750.52 rows=4,999 width=32) (actual time=0.724..9,868.519 rows=4,998 loops=1)

  • Output: p1.lobj_id, l0.commentushort, l0.lobj_id
  • Join Filter: (l0.lobj_id = ln1.childlobj_id)
  • Rows Removed by Join Filter: 88859442
  • Buffers: shared hit=21040
3. 28.339 28.339 ↑ 1.0 4,998 1

Index Scan using ixu_o_job_id on dalimes.o_job l0 (cost=0.41..25,486.74 rows=4,999 width=24) (actual time=0.031..28.339 rows=4,998 loops=1)

  • Output: l0.innerpage_creepvalue, l0.new_mainpageorder, l0.commentushort, l0.new_bleedleftandright, l0.new_inhousepostprocessing, l0.ts_lastchange, l0.new_lockshortname, l0.lobj_isroot, l0.creationuser_code, l0.new_pageorderworkflow, l0.new_collatingmarksposition, l0.new_trimmedwidth, l0.lobj_name, l0.new_iccname, l0.new_creepingreference, l0.outerpage_scalingstartvalue, l0.blocksize_front, l0.lobj_id, l0.new_folding, l0.new_compensatebracketeffect, l0.new_jobworkflow, l0.new_publicationdate, l0.new_shiftmark, l0.new_usesectionscaling, l0.maximalscaling_use, l0.blocksize_back, l0.new_defaultoffsety, l0.new_shrinkouterribon, l0.new_pagecuttoff, l0.outerpage_creepvalue, l0.nw_denyupdateofpublicationda, l0.new_defaultoffsetx, l0.new_uselinearissuescaling, l0.new_reversedview, l0.commentulong, l0.innerpage_scalingvalue, l0.ts_creation, l0.maximalscaling_stepsperform, l0.new_skalingmethod, l0.lobj_version, l0.maximalscaling_steps, l0.new_priority, l0.parent_node_id, l0.new_uselinearsectionscaling, l0.new_routingmargins, l0.new_exportasrss, l0.new_usenbpageforskaling, l0.new_trimmedheight, l0.new_reelpostprocessing, l0.maximalscaling_value, l0.new_applycreeping, l0.new_useissuescaling, l0.new_defaultrotation, l0.ostt_value, l0.new_bleedtopandbottom, l0.new_safetytb, l0.ostt_list, l0.lastchangeuser_code, l0.node_id, l0.new_simulation, l0.new_formworkflow, l0.new_safetylr, l0.syshierarchy, l0.outerpage_scalingvalue, l0.ts_deletion, l0.segmenttrim_gutter, l0.segmenttrim_routingmargins, l0.printedtrim_head, l0.segmenttrim_footer, l0.segmenttrim_outer, l0.segmenttrim_overfold, l0.segmenttrim_head, l0.printedtrim_footer, l0.new_rolemasks, l0.printedtrim_face, l0.new_site, l0.segmenttrim_millingdepth
  • Index Cond: ((l0.lobj_id = ANY ('{35074466,35068619,35060688,35060441,35060148,35053694,35044931,35044185,35043109,35040955,34988336,34968094,34965076,34954459,34953946,34948793,34931858,34926589,34924993,34922140,34920433,34918030,34917815,34913529,34911345,34910444,34908923,34906844,34893878,34893182,34891365,34890749,34888260,34886104,34885142,34883924,34883300,34882527,34881522,34878957,34876609,34874992,34874012,34869538,34865556,34864743,34862752,34855986,34855236,34854632,34854531,34854431,34854331,34854231,34854131,34854031,34853931,34853831,34853731,34853631,34853531,34853431,34853331,34853231,34853131,34853031,34852931,34852831,34852731,34852058,34848405,34847861,34844232,34840382,34838455,34829358,34828911,34824427,34824268,34823023,34813105,34809159,34808839,34808590,34808357,34808124,34807891,34807658,34807425,34807192,34806956,34806712,34806476,34806243,34806010,34805777,34805543,34804093,34803857,34803498,34803129,34802877,34802638,34802405,34793821,34778066,34777192,34776932,34776695,34776095,34775649,34775085,34771803,34768893,34746316,34746208,34741620,34736450,34732989,34726660,34722531,34720222,34704714,34703328,34690132,34687746,34680260,34680193,34668523,34667634,34667551,34658667,34657612,34654921,34654352,34651676,34650779,34649538,34648453,34646307,34644558,34643067,34642430,34633680,34632326,34631632,34629703,34626604,34625123,34624271,34621574,34621213,34620459,34618537,34618058,34617887,34617146,34616758,34616512,34615056,34612243,34610856,34604421,34603176,34602966,34599387,34598806,34598148,34597246,34594535,34592575,34592050,34588827,34588554,34588320,34587997,34587615,34587262,34586899,34586538,34586141,34585439,34584662,34583849,34583429,34581395,34581311,34581105,34581021,34579582,34577830,34571560,34571058,34565437,34564453,34561475,34561369,34560109,34558238,34557664,34557338,34556641,34556219,34555165,34553193,34552815,34550801,34545591,34545098,34540202,34539444,34539305,34539017,34537702,34533075,34532788,34523262,34518128,34517488,34515618,34513205,34509244,34507472,34505124,34503177,34500171,34492321,34482579,34481341,34478887,34478800,34477450,34476825,34476168,34475325,34463410,34462790,34460521,34449818,34443728,34440897,34434537,34434105,34433380,34432839,34431855,34430455,34430378,34429196,34426129,34425734,34423991,34419909,34415346,34406389,34405588,34403556,34402380,34400824,34392339,34391864,34381801,34381434,34375628,34373487,34372945,34371534,34370645,34369992,34369496,34369389,34361986,34361708,34360641,34357035,34356434,34351174,34347743,34345157,34342907,34334093,34332715,34331789,34331682,34331473,34329922,34328182,34328093,34327984,34327205,34326914,34312607,34312175,34308568,34296292,34296043,34295801,34295559,34295297,34294113,34293166,34293080,34292932,34284658,34280496,34279594,34276409,34275407,34273651,34271602,34263906,34261269,34251244,34248321,34247274,34246488,34242558,34234803,34232712,34232493,34226604,34226405,34225337,34224298,34219607,34219401,34218564,34217356,34213870,34213584,34212124,34211525,34209500,34207198,34205686,34203233,34197007,34192591,34190817,34190166,34187039,34181668,34181174,34179950,34178846,34178303,34168253,34164886,34164223,34163508,34160376,34159252,34158473,34158187,34156491,34156347,34155794,34154663,34153630,34153394,34153198,34152418,34151856,34151049,34150483,34149941,34149405,34148499,34148312,34146311,34138231,34138012,34132390,34130941,34129827,34126813,34125863,34124289,34123999,34122132,34121289,34121202,34120092,34117720,34116472,34116139,34115600,34114124,34107606,34107379,34103127,34102959,34102673,34102559,34102454,34094692,34087989,34086097,34085941,34085449,34085298,34077826,34076471,34076238,34076003,34075770,34075535,34075297,34074867,34073530,34073297,34073064,34072831,34072590,34072341,34072076,34071839,34071558,34071325,34071084,34070833,34068846,34068129,34064402,34064119,34063878,34063341,34063108,34062875,34062642,34062409,34062176,34061943,34061710,34061477,34061244,34061011,34052904,34052554,34043860,34033103,34032915,34029104,34026702,34025143,34024849,34023806,34022187,34021394,34020815,34019718,34019221,34014082,34012613,34011349,34007940,34002789,34002027,34001304,34000098,33997381,33996624,33996481,33984913,33983450,33978926,33970413,33967808,33967096,33956570,33953247,33952930,33951781,33949166,33947901,33937124,33935312,33933797,33933631,33933433,33932243,33928830,33927583,33926646,33924030,33922833,33922316,33921462,33921385,33918512,33914802,33910745,33910604,33910469,33910227,33909863,33909736,33909104,33908362,33903682,33900705,33896760,33895772,33891195,33889995,33888183,33886141,33882620,33876206,33875894,33875016,33871562,33870487,33869258,33862143,33856424,33856107,33855780,33855207,33854835,33854829,33853455,33853199,33847992,33847316,33839018,33837817,33837266,33837006,33835193,33835086,33830164,33820575,33820231,33789985,33789778,33785891,33785292,33783310,33779570,33779476,33776405,33766672,33759538,33758847,33757950,33757854,33757738,33757601,33757058,33756512,33756305,33756193,33755430,33743086,33741237,33739627,33725383,33722557,33720702,33719631,33719526,33717454,33715412,33714267,33711228,33710023,33698798,33694900,33690580,33689211,33686857,33685668,33683339,33676889,33674787,33672947,33671501,33669226,33669018,33666531,33664982,33663696,33662869,33660735,33659057,33655577,33653880,33653667,33650912,33647790,33638440,33636790,33636650,33634614,33632807,33629004,33628130,33625375,33620616,33618613,33614979,33612775,33612525,33608606,33608396,33601776,33601269,33599379,33597939,33596902,33596749,33592151,33589871,33583762,33567100,33554819,33551408,33548552,33545076,33543950,33543755,33541327,33532706,33530278,33529155,33526662,33524724,33517298,33511463,33508971,33505940,33499198,33496769,33496544,33496293,33492150,33490935,33484869,33482317,33481942,33480883,33479845,33479396,33479307,33478419,33477159,33476590,33476288,33474281,33473919,33473594,33471151,33469102,33467050,33465106,33464986,33464851,33464675,33464177,33464041,33463891,33463755,33463574,33463315,33462802,33462485,33461668,33461161,33454839,33440358,33435095,33432041,33430255,33428498,33427352,33427259,33426129,33425362,33423340,33421490,33421382,33421248,33421146,33420135,33419549,33419442,33419342,33419192,33417988,33417747,33417654,33416062,33414829,33414684,33414554,33414353,33414254,33414158,33414063,33413964,33413810,33413453,33413188,33412571,33410660,33409755,33405288,33403077,33402979,33402170,33400860,33400354,33395645,33393358,33392339,33390538,33389796,33387760,33387015,33383565,33382155,33381589,33373132,33367073,33366361,33361047,33359831,33357672,33357116,33356143,33355808,33355119,33354430,33353913,33334357,33331536,33330815,33327918,33325413,33323957,33319989,33317909,33316977,33316076,33314467,33314116,33314029,33313812,33312603,33311685,33307878,33307764,33306915,33306823,33304252,33300758,33297225,33295930,33295460,33291508,33287811,33287440,33285359,33284056,33283380,33280992,33278779,33274038,33273577,33272883,33270619,33266238,33265569,33265339,33263431,33261088,33260525,33258125,33251416,33244569,33240999,33240624,33239538,33230717,33224471,33223589,33223037,33219175,33213600,33208927,33205472,33205326,33205238,33202834,33142502,33141053,33140113,33139112,33136808,33136718,33135106,33132903,33132155,33131792,33130869,33130292,33129685,33129573,33127790,33127285,33127177,33126806,33124890,33115876,33114860,33111092,33103235,33101340,33100037,33095648,33095526,33095264,33093683,33090130,33088831,33085912,33085869,33085781,33084008,33076674,33073801,33067229,33061910,33060534,33060285,33060052,33059169,33058855,33058531,33058295,33058054,33057821,33057588,33057355,33057114,33056863,33056449,33055940,33053289,33051954,33049716,33047079,33038562,33032498,33031885,33031690,33031577,33026200,33025870,33019052,33015025,33014593,33007543,33007225,33002888,32967807,32966626,32966062,32965308,32961963,32961239,32950571,32936068,32935828,32935595,32935312,32934762,32934515,32934244,32934010,32933777,32933536,32931982,32931702,32929825,32929717,32929147,32927320,32915492,32914462,32907085,32906644,32906556,32902093,32901903,32899920,32899547,32899296,32899035,32898949,32898716,32898518,32898284,32898051,32897818,32897585,32897318,32896181,32895580,32895302,32892199,32890989,32880119,32876288,32875927,32873808,32871795,32870978,32870772,32869759,32869255,32868310,32862632,32862541,32862478,32861736,32861340,32858103,32857931,32857299,32854999,32852474,32851083,32850492,32845712,32844958,32843920,32842984,32842892,32840453,32840081,32831270,32829685,32827008,32826630,32825163,32825058,32803258,32802178,32801506,32800094,32781506,32778416,32774189,32771924,32764279,32764187,32764093,32764001,32763667,32763033,32762391,32762087,32759858,32758540,32754816,32744769,32742138,32727559,32694571,32694051,32693959,32692437,32691710,32691614,32686571,32686470,32685512,32678553,32671729,32671492,32671196,32671049,32669493,32665552,32664446,32661065,32660817,32660528,32641464,32640846,32633763,32628671,32619107,32618244,32617156,32616207,32615849,32615137,32614410,32614042,32610338,32609395,32608476,32608384,32600360,32594123,32590858,32589313,32589171,32588760,32588032,32585960,32583845,32581629,32579606,32577391,32577162,32575102,32568728,32567176,32561892,32561527,32560414,32558421,32557907,32554726,32552326,32549897,32547846,32545795,32543656,32541293,32538869,32537021,32534896,32534297,32533522,32532720,32524152,32523725,32521533,32513728,32510596,32510385,32506351,32505847,32505762,32505261,32490044,32488362,32486001,32483986,32481125,32481034,32477787,32477620,32472750,32463797,32463575,32461694,32459852,32459765,32457511,32456215,32455864,32455764,32455680,32455588,32454245,32452310,32452215,32450531,32449419,32448352,32448273,32447834,32444943,32438182,32437817,32434420,32434187,32433918,32433685,32433451,32432926,32432685,32432444,32429552,32419081,32418986,32418364,32417754,32416631,32415878,32408903,32406256,32401779,32399396,32398623,32388670,32386854,32383967,32377595,32374831,32372895,32370938,32370043,32368245,32366210,32363715,32363538,32363297,32361254,32358938,32352821,32346677,32344698,32342287,32340152,32336454,32336335,32331645,32328339,32328244,32327561,32327405,32325097,32324011,32323055,32319774,32319193,32315314,32313234,32313092,32310150,32306447,32305660,32304795,32301397,32300243,32295264,32293996,32288579,32287835,32286904,32281778,32280232,32279683,32279536,32274519,32272694,32269403,32266083,32265303,32263610,32260551,32252698,32248707,32248078,32244942,32243508,32241737,32236601,32236306,32234979,32231189,32230144,32224156,32221639,32220632,32215354,32213243,32211559,32210788,32210034,32209484,32208567,32207805,32199054,32194093,32189087,32184551,32184451,32183896,32174291,32171733,32171494,32170849,32170465,32170105,32167661,32166331,32165930,32165349,32162636,32162290,32160733,32160624,32157628,32150898,32150646,32150413,32150180,32149939,32149683,32149441,32149198,32148390,32147834,32146723,32145950,32145171,32143367,32139610,32138179,32137854,32136922,32136821,32136449,32135627,32133062,32132082,32131562,32131423,32131339,32131239,32130876,32130586,32128039,32126636,32124996,32124663,32124214,32123980,32118716,32118631,32117672,32117070,32115422,32115345,32115226,32115133,32114283,32114204,32101709,32098780,32096811,32090012,32089754,32088180,32087453,32081842,32079086,32078123,32076655,32067334,32065121,32062715,32060218,32057839,32057580,32053554,32051490,32046676,32040239,32040094,32038023,32033886,32028202,32023896,32023614,32019503,32017857,32014844,32012463,32009567,32007660,32007428,32005826,32003714,32003003,31995271,31991436,31980736,31979684,31975449,31972834,31968193,31961997,31959079,31953612,31950771,31950486,31948625,31947650,31947036,31946023,31945360,31944770,31943602,31942453,31941488,31940625,31940348,31938499,31937022,31936442,31934874,31933973,31933447,31932059,31929042,31927985,31924556,31923711,31923610,31923148,31922296,31921873,31921787,31920791,31920031,31917395,31915370,31914807,31914621,31914427,31914324,31913858,31913652,31913635,31913172,31913079,31909380,31907850,31907438,31906050,31902067,31900872,31898587,31897400,31896487,31893405,31891938,31886641,31885250,31879632,31879469,31878387,31877304,31876515,31876176,31870842,31870457,31866317,31865382,31863423,31862614,31859869,31858572,31858167,31857030,31856841,31855921,31845143,31831756,31831424,31831337,31829538,31827783,31827095,31820342,31818889,31815245,31812281,31810624,31809633,31808866,31808658,31808268,31803702,31801425,31800274,31799836,31799009,31798473,31793027,31783573,31770574,31770367,31768582,31767627,31765183,31763734,31759754,31756455,31755461,31754170,31750413,31750189,31750035,31749220,31746511,31745584,31744566,31738649,31738290,31738044,31736264,31724950,31724328,31722622,31722468,31722333,31722191,31722084,31715058,31712532,31712271,31712038,31711805,31711571,31710944,31710352,31710116,31709405,31709315,31708455,31704904,31702855,31702475,31691446,31686989,31686131,31685977,31685627,31685339,31682572,31681902,31681547,31681297,31681051,31680818,31680537,31680231,31679956,31678752,31678254,31669955,31669218,31665718,31663947,31663678,31660442,31660081,31659992,31657040,31656143,31651893,31648856,31646456,31646180,31641942,31641692,31640715,31638315,31637380,31630946,31629956,31627946,31626929,31626761,31624101,31621831,31618497,31616104,31614008,31613920,31611527,31610891,31604937,31601773,31600302,31600158,31595694,31591676,31589482,31587148,31583444,31582350,31579110,31578710,31578477,31578244,31578011,31577474,31577240,31577006,31576772,31576673,31572821,31572466,31571984,31569897,31563674,31562843,31562062,31561607,31561511,31560035,31558019,31557632,31554613,31553771,31549402,31549186,31546011,31543377,31541640,31540639,31540558,31539621,31537830,31537101,31536905,31536512,31536317,31532157,31531695,31531453,31523659,31519682,31519595,31509042,31505560,31505388,31504814,31499361,31499245,31493914,31492995,31489876,31487854,31486947,31485809,31483102,31482692,31482398,31481784,31481203,31478441,31475672,31473167,31470461,31468372,31466263,31465837,31465730,31465617,31465498,31465080,31463626,31460651,31451384,31446440,31434261,31430465,31426684,31426553,31423832,31421808,31421053,31420537,31420071,31419218,31419134,31419050,31418137,31413395,31412470,31411625,31411116,31410062,31407295,31405557,31403283,31403145,31403025,31402231,31401196,31396913,31395721,31392315,31388258,31383734,31381253,31380997,31373299,31372943,31372809,31372504,31370508,31368594,31368378,31366279,31361550,31360073,31357463,31356722,31354298,31352219,31345718,31342639,31341712,31333292,31330773,31327998,31322047,31320482,31319873,31316103,31314170,31312809,31312589,31312373,31305268,31302855,31299385,31299165,31297960,31297198,31296971,31296840,31296753,31296646,31296547,31294203,31292012,31290195,31288379,31287099,31283599,31283217,31278860,31277938,31275329,31274713,31272518,31266477,31261786,31259211,31258943,31255356,31248665,31245184,31236917,31235266,31227460,31224765,31223369,31221216,31220228,31219319,31217791,31216653,31212170,31210899,31208700,31207676,31206986,31205901,31205525,31205446,31202868,31201678,31197253,31196686,31194842,31194331,31192601,31191501,31185658,31181847,31180149,31179776,31179522,31179336,31179204,31179120,31178952,31178497,31178325,31178199,31178114,31178029,31177945,31177840,31177749,31177667,31177585,31175554,31174196,31173948,31171466,31170815,31170733,31165869,31164034,31161640,31159368,31158408,31152757,31152154,31148374,31148142,31145217,31131799,31131527,31129965,31129137,31128625,31122353,31118821,31114109,31109176,31107940,31106259,31103885,31103223,31100805,31090274,31088944,31086903,31085597,31079766,31079257,31078170,31073519,31069722,31068373,31067896,31062023,31055755,31049568,31048402,31045396,31042744,31042486,31039768,31023516,31020386,31016108,31012491,31008379,31004048,31001563,31001440,30999832,30998488,30995334,30995185,30994328,30991853,30990256,30987513,30986698,30984720,30981188,30981103,30979433,30979349,30978672,30978148,30978034,30977694,30977073,30976744,30976436,30974759,30972690,30971646,30971417,30969189,30966151,30965837,30965438,30965103,30964577,30964213,30963834,30963360,30960688,30958676,30957249,30957041,30955875,30953794,30953097,30952864,30952630,30952417,30952058,30951695,30951397,30951096,30950783,30950542,30950148,30949983,30948669,30948314,30947717,30947272,30946407,30946039,30938920,30938810,30937913,30937505,30936817,30935828,30935740,30935392,30934973,30934632,30929642,30927092,30926680,30926377,30926048,30924778,30914350,30913635,30913495,30910954,30910672,30907645,30905788,30904008,30903894,30903694,30899429,30896181,30892506,30886721,30885467,30884971,30869113,30867594,30858747,30855467,30854603,30851340,30849736,30849132,30846723,30844655,30844525,30842610,30837884,30837355,30835110,30831457,30824318,30823062,30822714,30822469,30820919,30817317,30816179,30815679,30815252,30815141,30815005,30814430,30814346,30813746,30807266,30804884,30804695,30804307,30803737,30803318,30802890,30785763,30785567,30785403,30785203,30783045,30778875,30777570,30771850,30769360,30768534,30766351,30765799,30765357,30764106,30763448,30762040,30761557,30761091,30754418,30752900,30752580,30748112,30742275,30738954,30738748,30738010,30737457,30736939,30734920,30732316,30723892,30723798,30723692,30723301,30719247,30715985,30715411,30714829,30714622,30712070,30711018,30710786,30710517,30710267,30710032,30709751,30709513,30709280,30708985,30708720,30708481,30708218,30707981,30701466,30696629,30695408,30693943,30691567,30688642,30688281,30686951,30684734,30684644,30683110,30679680,30677909,30675996,30674089,30670557,30666572,30666353,30664924,30664268,30657388,30656698,30654416,30651191,30650391,30649246,30643183,30642080,30639437,30637187,30636615,30634695,30631653,30629452,30627399,30625611,30621933,30600990,30599610,30592570,30591391,30587442,30584918,30583802,30581572,30580962,30580731,30580380,30572988,30570004,30567780,30567426,30566865,30562445,30561261,30558272,30556730,30555887,30554966,30554788,30552986,30546067,30543060,30542610,30542436,30541341,30540987,30536684,30536574,30534918,30532349,30530717,30525167,30518248,30517890,30516359,30514302,30512179,30510727,30509774,30508007,30507713,30507629,30507421,30505501,30496327,30496240,30495231,30491888,30491317,30491200,30490783,30489077,30487829,30486788,30486740,30476282,30475450,30469646,30466809,30466479,30460619,30458795,30458683,30458259,30458025,30457792,30457559,30456823,30456033,30455631,30455463,30455316,30455173,30455029,30444291,30436382,30434001,30431581,30429931,30428456,30421420,30417286,30409604,30408164,30408076,30400941,30398429,30398192,30390301,30390068,30385460,30371207,30370384,30367749,30366414,30364841,30363419,30362814,30362100,30361778,30360369,30358549,30356414,30341123,30338590,30336736,30336639,30332942,30328911,30327558,30327448,30327365,30326998,30326058,30325409,30320465,30317638,30314455,30304439,30304175,30298869,30292620,30291522,30289494,30286079,30285092,30283125,30282232,30279705,30274960,30272221,30270289,30270067,30269912,30269825,30266313,30265630,30260626,30260376,30256613,30252172,30248784,30244100,30235568,30235481,30235227,30226712,30225564,30220107,30219787,30214225,30210639,30208196,30205361,30204266,30204095,30201674,30196552,30188910,30188490,30188141,30185346,30183710,30178139,30175734,30173486,30171239,30170102,30167420,30167273,30164802,30164393,30164116,30163840,30163193,30162201,30161582,30160359,30159662,30158097,30155802,30154568,30154074,30153813,30153036,30152068,30150417,30150143,30149901,30149652,30149417,30149182,30148948,30148714,30148478,30148054,30147628,30147278,30147159,30146310,30146205,30143857,30137105,30137004,30136742,30135148,30134450,30133147,30132039,30131097,30131029,30130125,30128298,30125930,30125807,30125721,30125624,30120802,30120115,30119447,30118639,30117673,30116780,30115792,30115263,30114276,30113625,30113228,30112721,30111809,30104609,30099342,30096881,30096457,30096352,30089530,30086983,30083690,30080662,30076930,30076542,30076292,30075690,30075174,30074621,30074073,30073452,30072912,30070869,30068648,30066389,30065808,30064625,30064271,30061943,30058892,30051818,30051659,30050606,30050302,30049845,30039490,30037315,30035846,30028596,30026104,30025382,30025282,30017923,30017793,30009815,30005889,30003432,29996237,29995718,29995701,29994921,29994837,29987958,29981703,29980774,29978437,29971830,29971745,29968479,29965704,29964788,29964411,29963144,29961953,29954724,29953811,29952177,29949323,29946043,29945190,29944811,29944538,29943557,29943442,29942427,29942343,29938854,29937531,29934979,29933295,29933221,29931112,29927524,29923641,29921721,29920268,29918764,29918620,29914122,29913913,29913464,29913341,29907703,29907500,29905286,29904751,29904269,29903356,29903163,29897812,29897591,29896295,29895747,29894071,29893362,29893242,29891679,29888452,29886356,29885742,29885448,29885121,29883030,29882667,29882156,29879309,29878733,29876763,29874362,29871975,29871836,29870053,29869961,29869866,29865704,29864149,29863550,29862650,29860270,29858213,29857728,29853540,29852022,29851118,29850104,29843541,29842408,29841928,29841275,29838284,29837734,29836867,29836453,29836369,29835194,29834813,29831144,29827522,29827128,29826160,29824550,29823503,29823293,29821348,29821178,29820937,29820766,29820663,29820427,29819755,29819554,29819422,29819106,29818359,29817598,29815466,29813694,29812858,29810887,29808762,29807221,29805621,29803508,29801244,29800105,29790583,29786102,29782698,29781580,29781318,29772216,29770111,29766276,29763936,29760344,29750366,29740999,29740560,29739562,29738597,29738349,29737534,29737450,29735621,29734754,29732861,29730973,29726977,29726322,29725771,29721961,29721159,29717335,29717215,29717033,29502508,28834028,28831741,28824105,28821692,28819480,28816271,28809756,28809487,28808675,28808096,28806523,28803864,28801559,28801293,28799747,28793147,28792996,28788865,28785794,28783377,28783040,28779239,28774011,28771799,28767991,28765835,28765132,28761209,28759558,28756468,28756367,28754361,28752063,28748791,28745993,28742210,28741500,28739451,28737058,28735253,28731602,28729824,28728896,28725544,28724772,28722790,28719096,28716853,28716753,28714725,28712884,28711595,28706446,28704261,28703809,28701888,28700962,28699923,28699220,28694530,28692567,28691519,28688219,28686144,28685971,28685884,28685797,28685460,28683389,28681653,28680829,28674646,28665658,28660393,28652630,28652516,28652328,28649892,28646742,28646480,28645224,28642231,28641937,28641693,28641456,28640812,28640789,28640550,28640527,28640288,28640263,28640026,28639395,28639142,28638859,28638604,28638300,28637568,28636826,28634716,28632612,28629772,28627674,28626595,28626008,28624751,28624128,28621814,28619129,28618828,28618579,28618341,28617843,28617404,28617081,28616844,28616591,28616337,28616250,28615951,28615695,28615434,28615197,28606223,28603709,28602935,28602647,28602353,28602109,28601849,28601582,28601345,28601106,28600860,28600094,28599822,28599584,28598382,28597489,28594341,28592242,28587446,28585438,28582955,28578974,28578800,28578401,28575322,28572512,28571872,28571402,28570199,28568183,28567285,28566307,28563703,28563211,28561798,28559357,28552095,28551553,28550747,28547982,28547337,28545070,28542785,28541467,28539084,28537024,28532462,28529052,28526153,28525921,28525040,28523628,28519920,28518432,28515688,28514350,28514199,28513039,28512439,28512262,28510749,28502905,28499395,28499227,28497377,28494970,28494566,28494105,28493684,28491029,28490622,28485675,28483529,28482924,28482212,28479641,28479511,28479235,28475109,28469804,28469511,28468571,28457617,28457419,28457037,28456705,28455973,28453046,28451101,28448339,28448058,28439734,28439524,28438250,28436673,28436379,28436214,28435979,28434622,28427525,28421723,28421639,28421151,28420794,28420000,28419664,28415434,28414387,28413185,28412990,28412373,28411920,28410824,28410108,28407309,28406861,28405009,28404895,28404790,28404695,28404603,28404507,28402173,28402084,28401641,28401557,28399796,28397911,28396319,28394129,28390919,28390561,28389200,28388993,28388912,28387043,28386406,28384956,28383842,28368514,28366727,28363430,28361928,28359975,28357150,28353890,28352256,28348426,28347366,28347011,28346814,28345421,28343567,28343452,28342782,28342016,28341101,28339491,28338687,28337076,28333989,28331150,28328925,28328289,28327998,28325569,28322900,28319866,28318300,28317999,28316013,28315185,28309799,28307301,28303852,28299132,28296837,28296737,28296114,28294537,28294434,28284502,28280200,28276818,28275988,28275084,28273679,28272927,28272394,28270873,28267759,28266586,28255259,28254387,28252430,28252137,28251997,28251382,28247721,28247026,28246308,28245827,28240824,28239995,28237567,28235256,28235050,28234888,28234287,28230642,28225865,28225692,28224801,28222981,28222585,28222152,28220103,28215865,28213549,28208048,28207168,28206597,28205972,28205691,28205257,28204894,28202705,28198354,28197498,28196950,28196773,28196477,28192383,28190317,28189948,28189664,28186975,28185172,28180764,28179460,28175611,28175188,28174092,28172249,28165366,28165016,28163155,28162812,28161362,28160488,28160356,28160265,28160178,28160027,28158937,28158348,28157932,28154897,28154453,28153564,28152068,28150641,28150557,28147700,28145986,28142909,28140540,28139663,28139029,28137657,28136819,28135663,28128073,28127544,28125778,28125515,28124303,28122665,28121555,28120687,28119848,28118685,28118027,28117359,28116571,28116012,28115257,28113608,28113073,28110018,28109944,28109302,28108673,28104803,28104438,28102752,28102116,28100119,28096361,28089695,28088807,28087441,28086753,28086506,28083388,28077305,28076930,28076837,28073747,28071069,28058311,28055846,28049547,28042503,28036539,28035219,28034791,28032408,28032065,28031053,28030962,28030637,28029801,28029459,28025055,28015982,28015770,28013766,28013660,28013326,28010880,28010738,28009644,28009549,28009431,28009326,28009227,28009135,28008885,28007997,28006673,28006487,28005312,28004318,28003779,28002197,28000387,28000136,27998600,27997133,27996486,27996092,27995722,27995547,27995447,27995192,27991047,27988982,27985994,27983191,27980363,27980267,27980032,27979795,27978020,27975352,27974919,27974685,27974453,27972791,27972248,27968856,27958237,27958156,27957743,27957308,27957008,27956856,27954707,27952906,27950392,27950313,27950108,27946636,27946458,27946212,27946071,27945810,27942901,27934963,27931712,27930971,27930819,27930666,27930512,27930357,27926575,27923048,27920654,27920460,27920320,27918099,27906638,27906131,27905223,27904379,27901005,27899652,27896409,27888693,27888412,27887232,27885946,27884485,27883870,27882876,27881946,27880914,27880232,27878707,27877386,27876717,27875799,27875107,27874644,27874403,27873202,27873108,27872482,27868584,27867431,27866291,27861747,27860992,27858884,27858195,27856817,27856179,27855791,27855109,27855030,27854891,27853213,27850915,27850389,27850289,27849723,27848733,27847454,27845790,27842579,27842428,27842214,27841718,27840466,27840341,27840064,27839279,27839045,27838665,27837729,27836478,27836247,27835368,27832918,27831908,27831269,27831177,27828506,27828171,27822172,27821952,27817910,27813248,27813065,27812433,27812092,27811791,27810666,27810575,27810145,27809952,27804017,27803666,27801382,27800909,27800487,27799885,27798450,27798359,27789438,27789328,27788839,27787455,27786227,27785229,27784689,27784459,27783854,27783145,27781863,27781667,27781249,27780303,27778220,27777440,27775348,27774033,27772930,27772457,27772225,27771808,27771312,27770543,27769031,27768659,27768358,27768046,27767802,27767570,27767338,27767106,27766873,27766641,27766408,27766169,27765936,27765516,27765262,27764979,27764729,27764497,27764255,27764023,27763689,27763452,27762570,27762162,27757709,27755933,27755848,27755466,27752762,27750923,27750106,27746845,27745369,27743421,27743316,27742417,27742033,27740877,27740714,27729820,27728379,27727419,27726718,27716797,27712329,27711745,27710520,27710154,27708477,27707939,27707797,27706354,27703624,27703539,27703236,27702425,27700460,27697929,27697718,27697507,27695435,27691331,27690913,27686520,27685442,27682132,27679883,27676357,27675850,27670618,27669870,27669711,27667543,27666977,27662029,27660073,27658790,27657960,27657373,27655851,27655766,27654303,27651802,27649297,27649053,27646705,27646461,27646334,27646097,27645860,27643928,27643559,27643320,27642952,27642694,27642462,27638884,27635454,27632869,27630670,27629654,27628802,27628208,27622022,27621892,27616679,27614053,27608763,27608258,27606671,27605380,27602770,27599177,27597280,27595208,27594505,27594419,27592117,27591653,27590752,27588090,27587920,27587824,27585856,27585553,27585405,27585307,27571657,27568513,27567713,27567621,27567391,27564984,27563888,27561483,27561012,27557073,27556976,27555900,27552743,27552013,27550003,27549088,27547876,27547773,27545187,27542689,27542448,27538029,27537642,27534321,27533955,27528455,27527186,27526198,27521635,27519731,27518486,27516203,27512363,27510312,27510222,27509672,27508924,27506846,27506290,27505546,27505024,27499420,27497327,27495992,27494243,27493065,27487795,27487703,27487553,27484952,27484111,27483876,27472998,27470305,27466676,27462317,27455491,27449716,27449306,27449090,27448785,27448508,27448269,27444862,27444735,27438193,27436437,27423379,27422446,27422285,27419746,27377703,27376554,27374934,27374081,27369584,27369202,27367689,27367505,27366790,27366421,27366134,27365920,27365218,27362926,27361172,27360618,27359997,27357576,27356072,27353697,27352494,27351542,27351440,27349623,27334475,27332671,27331938,27331858,27330652,27304147,27301632,27299578,27297937,27296093,27291997,27289112,27288095,27286992,27286646,27286414,27286182,27285950,27283145,27270753,27268837,27266797,27264655,27263024,27259630,27259079,27258072,27256764,27252119,27251456,27250165,27244751,27241529,27239796,27239036,27238769,27237543,27237282,27225931,27223855,27222774,27222537,27222218,27217833,27213744,27204148,27203935,27203247,27202614,27201992,27201611,27201321,27200825,27200540,27199308,27198518,27194316,27191696,27191226,27191075,27190282,27188103,27187541,27186473,27183444,27182125,27182027,27178461,27171864,27171570,27170962,27170477,27167720,27167614,27162268,27158329,27156296,27155594,27155494,27155406,27154161,27151888,27151736,27151431,27150280,27150170,27146130,27144394,27140604,27138626,27137802,27137722,27137632,27137220,27136485,27134199,27133456,27127838,27126980,27126890,27124763,27124096,27122831,27120728,27120304,27116503,27110302,27109145,27106217,27105280,27104481,27100968,27097717,27097202,27085209,27084077,27082842,27076768,27074294,27074190,27063083,27062323,27061356,27060079,27059117,27052707,27049300,27049048,27048656,27048423,27048191,27047937,27047556,27047207,27046974,27046739,27046542,27036227,27033974,27032056,27029596,27025567,27024674,27023305,27021221,27019182,27017446,27008321,27004207,27002684,26999031,26996955,26992253,26991757,26991345,26985504,26985150,26974186,26972309,26970116,26966941,26966409,26966241,26962060,26961994,26961804,26961575,26959311,26958711,26957848,26957139,26955709,26955599,26954975,26954405,26953850,26952677,26952382,26950929,26950697,26949827,26948800,26948012,26947282,26947132,26946304,26945506,26945424,26944505,26943839,26943757,26942942,26942794,26942526,26942327,26942018,26941786,26941554,26941304,26941072,26940808,26940552,26940320,26939904,26939624,26939392,26939160,26938928,26938696,26938465,26935832,26932424,26932264,26930661,26929191,26929086,26928364,26926282,26926056,26925866,26925324,26923273,26923194,26923033,26922801,26922565,26922332,26922099,26921866,26921632,26921399,26921159,26920927,26920691,26908816,26907014,26905848,26905388,26903601,26902896,26901701,26899161,26897360,26894462,26894067,26893650,26891571,26890938,26887531,26886014,26884876,26883913,26882405,26882083,26881974,26880079,26877637,26876566,26873708,26873005,26872471,26872198,26869449,26863665,26863431,26863344,26862108,26860426,26855580,26851123,26850315,26850108,26848239,26846158,26845863,26845514,26840466,26839709,26838147,26835954,26831266,26830932,26826833,26824968,26822236,26821570,26819525,26819020,26817056,26814706,26812675,26812533,26811264,26808902,26806559,26805546,26799837,26799725,26799638,26799551,26799464,26799377,26799290,26799203,26799116,26799029,26798942,26798855,26798768,26798681,26798594,26798507,26798420,26798333,26798246,26798159,26798072,26797033,26796734,26796638,26796456,26796369,26796282,26796143,26795772,26795288,26795013,26794293,26792295,26792183,26788376,26786319,26785751,26783081,26776920,26775955,26774424,26774000,26761801,26761151,26759397,26759024,26756333,26754189,26753992,26751310,26750078,26749607,26749508,26744185,26743756,26741930,26741745,26741553,26741471,26738771,26732277,26729240,26719395,26717667,26710100,26707559,26707345,26705970,26705770,26705649,26704996,26704125,26702289,26702114,26701509,26697209,26695154,26692218,26692003,26686371,26684276,26681850,26680177,26678123,26648008,26641334,26640195,26640042,26638983,26638093,26636534,26628902,26628047,26625451,26625239,26618948,26618471,26618389,26617186,26614099,26612398,26612000,26611896,26611007,26610372,26609140,26608460,26607466,26606740,26606639,26606538,26606352,26606259,26606136,26606038,26605760,26605291,26603537,26595033,26592514,26590765,26588283,26588028,26583888,26583217,26582152,26578913,26578826,26578739,26578647,26577654,26577511,26577393,26576941,26576457,26576020,26575666,26574908,26574565,26573135,26572368,26572039,26571640,26571165,26570569,26570341,26569983,26569798,26569717,26569636,26569541,26569461,26569381,26569296,26569212,26564503,26562559,26561277,26560460,26560235,26555877,26554008,26551860,26551742,26550649,26546960,26546272,26540809,26540244,26538851,26537901,26535276,26530983,26530592,26528810,26525933,26525745,26523300,26521990,26519098,26514443,26514291,26514055,26512372,26509845,26509004,26504216,26503981,26500907,26498049,26495701,26495518,26489823,26480708,26474878,26468995,26467114,26466292,26464436,26456129,26455027,26451281,26446645,26444461,26442973,26442123,26439523,26438046,26437438,26430637,26429985,26429672,26427622,26425730,26425075,26422692,26402706,26401607,26401473,26397265,26394506,26393751,26393653,26392312,26386435,26386315,26384903,26384670,26384231,26383800,26383398,26383043,26381472,26376382,26372888,26371298,26367010,26366666,26366554,26365677,26363351,26359653,26358626,26356637,26339762,26336912,26335465,26331646,26320235,26318099,26314180,26313942,26312564,26312016,26311348,26310879,26306578,26304331,26302346,26301951,26295588,26293194,26282964,26280761,26280086,26277587,26277108,26276369,26276262,26275803,26275053,26274517,26274072,26272836,26272579,26271840,26271322,26271243,26270791,26269445,26269359,26268911,26267674,26267222,26266790,26266341,26266059,26263817,26263152,26262901,26261968,26260856,26259384,26259068,26256349,26256112,26252990,26248731,26248414,26245975,26235617,26233557,26229689,26229592,26229157,26223493,26222934,26221029,26217854,26216109,26216022,26214138,26212636,26208549,26208396,26205971,26204068,26203985,26203855,26197010,26195176,26192266,26191949,26189587,26186738,26182886,26179946,26178129,26173895,26166032,26165156,26163850,26160705,26160120,26158498,26156145,26155840,26149469,26147820,26146463,26142581,26141978,26141495,26141379,26140984,26140785,26139556,26127958,26127385,26126266,26125276,26124624,26124506,26124246,26123856,26123522,26123255,26122997,26122757,26122521,26122092,26121835,26121399,26117755,26117571,26115655,26114119,26111830,26110602,26109712,26107853,26107024,26103278,26101892,26101138,26100335,26097261,26090581,26089995,26089351,26088260,26086549,26082872,26078847,26078158,26077720,26077557,26077475,26077309,26076871,26073168,26072602,26065597,26044634,26044219,26031117,26030884,26030649,26030417,26030177,26029464,26029225,26023878,26022823,26006660,25997391,25996836,25992000,25990871,25990575,25976638,25959116,25956974,25955662,25955555,25955349,25953887,25949170,25942777,25942191,25940366,25938049,25937318,25936410,25932525,25929696,25928280,25921071,25914007,25913732,25911796,25911244,25909117,25909023,25907698,25907572,25903572,25902028,25901823,25900912,25900835,25900519,25900441,25900364,25900281,25898961,25894689,25890502,25888234,25887722,25886680,25884974,25884164,25883870,25880481,25879528,25877748,25876220,25875745,25873167,25871112,25868640,25866618,25862594,25860153,25858461,25855642,25854996,25853957,25851760,25848443,25846693,25846157,25836491,25836264,25833078,25829999,25829755,25817492,25804604,25802919,25802364,25795737,25793256,25791201,25789180,25787835,25784935,25784039,25780804,25779935,25778521,25777887,25775862,25771315,25770685,25770128,25770007,25763840,25762123,25760045,25758672,25757191,25757073,25756915,25754160,25738816,25730314,25724171,25723877,25723602,25721382,25718417,25714137,25713765,25709653,25703943,25703838,25702278,25701162,25701055,25700477,25699254,25699083,25693717,25692834,25685558,25684227,25675371,25671916,25670124,25668588,25666725,25665225,25659307,25654060,25651029,25647040,25641748,25641335,25640394,25639194,25629753,25629003,25625745,25623304,25621460,25620299,25619848,25617700,25614584,25612189,25611628,25607684,25607442,25605690,25604066,25602007,25599511,25596548,25594364,25592805,25591314,25590330,25590108,25589813,25589742,25589272,25587496,25584223,25577389,25576836,25572632,25570646,25570503,25569355,25568696,25565491,25563427,25562450,25560352,25557962,25555115,25554642,25551959,25541225,25538736,25538362,25537888,25537481,25536780,25535813,25535503,25535147,25534049,25533525,25533276,25532993,25532759,25532495,25532021,25531786,25531345,25531129,25530211,25529979,25526953,25526619,25526165,25521622,25521224,25521142,25521057,25519519,25516652,25507093,25506442,25503594,25499733,25496547,25495914,25495314,25494595,25472468,25472383,25472207,25469778,25469224,25468690,25467076,25465616,25458064,25455870,25455694,25448328,25445022,25435961,25433713,25429634,25428271,25427417,25426999,25422797,25422480,25418739,25418659,25418080,25415858,25415081,25414500,25413644,25413071,25412489,25407832,25406495,25401099,25400545,25399522,25397675,25394187,25393236,25391482,25390645,25386292,25386002,25385722,25383981,25383771,25382625,25382538,25382438,25381962,25380157,25379328,25379244,25378645,25378125,25376813,25375097,25373676,25372788,25372015,25370261,25370149,25369850,25368682,25367207,25367131,25366569,25366025,25364724,25364081,25363527,25361797,25361435,25360557,25360025,25359923,25357258,25355804,25354204,25353118,25352212,25351880,25351168,25349861,25348870,25347907,25346799,25346130,25345544,25344939,25344307,25343679,25342980,25342909,25342403,25341874,25341374,25340783,25340281,25339781,25338457,25338219,25336908,25335025,25334927,25334816,25334055,25333335,25332741,25331588,25331494,25330775,25330160,25329469,25329299,25328790,25327419,25326918,25326368,25325815,25324410,25324334,25322795,25320892,25320331,25319224,25319043,25318471,25317357,25317277,25316314,25315378,25315299,25313244,25310534,25309238,25308468,25307485,25306406,25305530,25305440,25304717,25303626,25300544,25300343,25298827,25296701,25295943,25295160,25294541,25293505,25293004,25291435,25288056,25287543,25284297,25284120,25284032,25283922,25283817,25283721,25278874,25277641,25276002,25275441,25274136,25270441,25269662,25266533,25266432,25266246,25266224,25266206,25266186,25262328,25259202,25254684,25254347,25241324,25241083,25240819,25239706,25227861,25225027,25224493,25216532,25211459,25211008,25210681,25208297,25199023,25196402,25191949,25189058,25188978,25188898,25188818,25188738,25188658,25186563,25186454,25186374,25186294,25184914,25184834,25182965,25182885,25182805,25182725,25181093,25180115,25179519,25179430,25176566,25175959,25175832,25173767,25171730,25170519,25170183,25168929,25167538,25164805,25163859,25162848,25161428,25160871,25159561,25158685,25156720,25148253,25146008,25145462,25143000,25141243,25135814,25135211,25135194,25134184,25132391,25130891,25129981,25127899,25127797,25126827,25120375,25120072,25119806,25119402,25116610,25113604,25111875,25110377,25107679,25106681,25104392,25103122,25101642,25101520,25101399,25101318,25101226,25101168,25101079,25100991,25100910,25100456,25100373,25100292,25100058,25099976,25099874,25099793,25099704,25099623,25099416,25098105,25097390,25096241,25096146,25094936,25094248,25092750,25091398,25087414,25084582,25082333,25081660,25081104,25080543,25080011,25079481,25078917,25078415,25077839,25076890,25074056,25071908,25071779,25071196,25070183,25069571,25066668,25066457,25066277,25065096,25064416,25062847,25061785,25061048,25060589,25059380,25057740,25053571,25051773,25050320,25050240,25050060,25049434,25048036,25047936,25047827,25046392,25046312,25046232,25045503,25044504,25044173,25040775,25039770,25037603,25037053,25036009,25035925,25032925,25031251,25030408,25029253,25029133,25028280,25026866,25025401,25021530,25018221,25018006,25016462,25011577,25011215,25009197,25009198,25009082,25005875,25005640,24992752,24987677,24982834,24980778,24979972,24979474,24975587,24972564,24972054,24971873,24971678,24970876,24968190,24964473,24963267,24961698,24948558,24947578,24946189,24942875,24942475,24940755,24940184,24937432,24933283,24922291,24922147,24915586,24911710,24910437,24909148,24908747,24905584,24901652,24898690,24897822,24897745,24897124,24889378,24888700,24885838,24881697,24881503,24881016,24879979,24879853,24876830,24873002,24866772,24861016,24859911,24859764,24859657,24857503,24854844,24850912,24850822,24850659,24849758,24849383,24847312,24846528,24839164,24839066,24838975,24838846,24836564,24829685,24829605,24828370,24828290,24827492,24826851,24825117,24824454,24823662,24822403,24821773,24820359,24819716,24818837,24812518,24811380,24811277,24807250,24805459,24805173,24803100,24800618,24795805,24792757,24789065,24786454,24782988,24779105,24777754,24776824,24775899,24772710,24770528,24768464,24768332,24762766,24762667,24760428,24756801,24754709,24752652,24750152,24749610,24744773,24742240,24738714,24736803,24731938,24730192,24730055,24729779,24728067,24725654,24720163,24719503,24718929,24715751,24715391,24711163,24703098,24702828,24699430,24699235,24699158,24699065,24692989,24688498,24680815,24674835,24670224,24669188,24668553,24665255,24662205,24661973,24661741,24661509,24661277,24660774,24660307,24657922,24656890,24656328,24654483,24654377,24649361,24649174,24639064,24637871,24609664,24609678,24609658,24609722,24609501,24607344,24607350,24607399,24607409,24607549,24607419,24607358,24607327,24607294,24607554,24607295,24607293,24607421,24607300,24607346,24607023,24601166,24600679,24600193,24599937,24599787,24598106,24597947,24593494,24587740,24586077,24583719,24582573,24578710,24578484,24577487,24576984,24569553,24569435,24568659,24535432,24534545,24534547,24533618,24533485,24531068,24529688,24527381,24526073,24517337,24514662,24512209,24509713,24504432,24499209,24499210,24499211,24499208,24499061,24497181,24479647,24478421,24447827,24369232,24367131,24367135,24367139,24367132,24367464,24367207,24363661,24363621,24363643,24363644,24363771,24363654,24363603,24363682,24359268,24359324,24359289,24359256,24359190,24359369,24359287,24359352,24359185,24359280,24357997,24358006,24358003,24357530,24353473,24353435,24353498,24353439,24353449,24353492,24353440,24353504,24353507,24353539,24353463,24353433,24353409,24353416,24353429,24353427,24353100,24351837,24350549,24350434,24350303,24350216,24350129,24350042,24349955,24349868,24349781,24349693,24349606,24346799,24343332,24337305,24334189,24334072,24333955,24333838,24329168,24329167,24329170,24329169,24328987,24328986,24328786,24328791,24328787,24328789,24328788,24328795,24328567,24328565,24328532,24328418,24321409,24321410,24321415,24321412,24321411,24321417,24321198,24320959,24319618,24315078,24312689,24309655,24309654,24309653,24309547,24307775,24307705,24307484,24307485,24307486,24307416,24307344,24307165,24307164,24307167,24307052,24304949,24304395,24301650,24301597,24301322,24301313,24301310,24301309,24301311,24301320,24301312,24301372,24301314,24301269,24301192,24297014,24296727,24151467,24150502,24149592,24149593,24149150,24148748,24147937,24147936,24147541,24147186,24146832,24146509,24146220,24145943,24145680,24145425,24145164,24144874,24144557,24143847,24143849,24141851,24141840,24141846,24141841,24141837,24141848,24141849,24141853,24140182,24140178,24140177,24140172,24140174,24140175,24138002,24138020,24138033,24138019,24139004,24138221,24138004,24138013,24136481,24136555,24136483,24136482,24136480,24136212,24134118,24134109,24135500,24134101,24134115,24134107,24134116,24134093,24134103,24133813,24131375,24131378,24131386,24131380,24131381,24131512,24131377,24131376,24131385,24131128,24129880,24125051,24124746,24123072,24121433,24116200,24115943,24115785,24111640,24111394,24106005,24105766,24099853,24099598,24099231,24095326,24091233,24091005,24089631,24068533,24068175,24060276,24060023,24059769,24059514,24059261,24059007,24058754,24056522,23972020,23971678,23971995,23971990,23971695,23971697,23972069,23972908,23972113,23972767,23973207,23973735,23971987,23971991,23972379,23972579,23971854}'::bigint[])) AND (l0.ts_deletion = 0))
  • Buffers: shared hit=20059
4. 3,752.423 3,758.496 ↓ 17,780.0 17,780 4,998

Materialize (cost=0.56..188.79 rows=1 width=16) (actual time=0.000..0.752 rows=17,780 loops=4,998)

  • Output: ln1.childlobj_id, p1.lobj_id
  • Buffers: shared hit=981
5. 1.765 6.073 ↓ 17,780.0 17,780 1

Nested Loop (cost=0.56..188.79 rows=1 width=16) (actual time=0.028..6.073 rows=17,780 loops=1)

  • Output: ln1.childlobj_id, p1.lobj_id
  • Buffers: shared hit=981
6. 0.018 0.018 ↑ 1.0 39 1

Seq Scan on dalimes.o_customer p1 (cost=0.00..1.49 rows=39 width=8) (actual time=0.004..0.018 rows=39 loops=1)

  • Output: p1.lobj_version, p1.parent_node_id, p1.node_id, p1.lobj_isroot, p1.ts_deletion, p1.commentushort, p1.lobj_name, p1.lastchangeuser_code, p1.commentulong, p1.defaultproduct_productid, p1.ostt_list, p1.ostt_value, p1.ts_creation, p1.ts_lastchange, p1.syshierarchy, p1.creationuser_code, p1.lobj_id, p1.defaultsite_siteid
  • Filter: (p1.ts_deletion = 0)
  • Buffers: shared hit=1
7. 4.290 4.290 ↓ 456.0 456 39

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.56..4.79 rows=1 width=16) (actual time=0.008..0.110 rows=456 loops=39)

  • Output: ln1.parentotpl_id, ln1.parentlobj_id, ln1.ts_deletion, ln1.childotpl_id, ln1.childlobj_id, ln1.olnk_id
  • Index Cond: ((ln1.parentotpl_id = 41) AND (ln1.parentlobj_id = p1.lobj_id) AND (ln1.ts_deletion = 0) AND (ln1.childotpl_id = 8))
  • Heap Fetches: 495
  • Buffers: shared hit=980