explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oX9g : NAC 09:45 -ref 1

Settings
# exclusive inclusive rows x rows loops node
1. 4.785 1,252.803 ↓ 1,624.0 4,872 1

HashAggregate (cost=6,395.78..6,395.81 rows=3 width=8) (actual time=1,251.995..1,252.803 rows=4,872 loops=1)

  • Output: l0.lobj_id
  • Group Key: l0.lobj_id
  • Buffers: shared hit=93454
2. 30.322 1,248.018 ↓ 1,624.0 4,872 1

Nested Loop (cost=2,053.78..6,395.77 rows=3 width=8) (actual time=111.427..1,248.018 rows=4,872 loops=1)

  • Output: l0.lobj_id
  • Buffers: shared hit=93454
3. 15.640 34.382 ↓ 222.7 35,858 1

Hash Join (cost=2,053.49..5,246.52 rows=161 width=8) (actual time=8.110..34.382 rows=35,858 loops=1)

  • Output: ln1.childlobj_id
  • Hash Cond: (ln1.parentlobj_id = p1.lobj_id)
  • Buffers: shared hit=2817
4. 10.938 16.409 ↓ 7.1 36,858 1

Bitmap Heap Scan on dalimes.objectlink ln1 (cost=1,841.71..5,013.63 rows=5,202 width=16) (actual time=5.760..16.409 rows=36,858 loops=1)

  • Output: ln1.olnk_id, ln1.parentotpl_id, ln1.parentlobj_id, ln1.childotpl_id, ln1.childlobj_id, ln1.ts_deletion
  • Recheck Cond: ((ln1.childotpl_id = 53) AND (ln1.ts_deletion = 0) AND (ln1.parentotpl_id = 19))
  • Heap Blocks: exact=2394
  • Buffers: shared hit=2702
5. 5.471 5.471 ↓ 7.3 37,993 1

Bitmap Index Scan on ix_objectlink_child_id (cost=0.00..1,840.41 rows=5,202 width=0) (actual time=5.471..5.471 rows=37,993 loops=1)

  • Index Cond: ((ln1.childotpl_id = 53) AND (ln1.ts_deletion = 0) AND (ln1.parentotpl_id = 19))
  • Buffers: shared hit=308
6. 0.555 2.333 ↑ 1.0 3,466 1

Hash (cost=167.95..167.95 rows=3,506 width=8) (actual time=2.333..2.333 rows=3,466 loops=1)

  • Output: p1.lobj_id
  • Buckets: 4096 Batches: 1 Memory Usage: 168kB
  • Buffers: shared hit=115
7. 1.778 1.778 ↑ 1.0 3,466 1

Seq Scan on dalimes.o_folder p1 (cost=0.00..167.95 rows=3,506 width=8) (actual time=0.010..1.778 rows=3,466 loops=1)

  • Output: p1.lobj_id
  • Filter: ((p1.lobj_id <> '0'::bigint) AND (p1.ts_deletion = 0))
  • Rows Removed by Filter: 25
  • Buffers: shared hit=115
8. 1,183.314 1,183.314 ↓ 0.0 0 35,858

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.29..7.13 rows=1 width=8) (actual time=0.033..0.033 rows=0 loops=35,858)

  • Output: l0.ts_deletion, l0.lobj_id
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = ln1.childlobj_id))
  • Filter: (l0.lobj_id = ANY ('{179498,183866,196228,197164,154326,171259,199084,174371,182618,418746,196700,171091,198668,198540,184458,169207,154257,175444,197636,156566,155895,195208,178734,182538,174762,181370,174117,170691,194245,196320,170735,171379,194477,154116,180522,181606,171412,184514,190814,196860,168338,184994,196120,169907,174134,184270,190919,197896,191193,175147,181050,194233,198348,171187,180318,197448,194889,191262,183918,168383,197484,184570,183194,154103,171163,179250,196820,199118,184046,191286,181142,172476,184610,179598,184934,197684,198784,180322,194437,172545,197832,196508,198312,179950,184814,170587,154528,194597,172881,174581,169099,154930,182718,154618,171195,199008,176711,180734,175228,184602,184846,194813,182426,180942,187812,169763,178674,182958,178171,181874,178503,180378,197404,169955,182358,180582,181806,419419,174333,174483,179390,194981,170035,183486,187958,154630,181330,196500,169775,198936,183766,183774,168816,181842,185432,154802,180114,179578,194485,176615,153813,177396,180270,183658,154926,196028,180926,197436,184254,197348,196484,180162,178686,195152,178754,175110,342973,183830,195679,171263,174010,169995,194921,180006,197884,197988,154243,173449,198868,196652,179358,181678,194985,180550,176947,170415,170831,176707,177035,169587,198220,196864,181134,190854,177436,195340,194869,180170,180530,179586,180798,182054,184266,180474,173506,169035,177156,183274,169103,183242,173474,170771,197280,195752,182262,154742,177015,184442,185278,183958,172462,196216,169903,185532,153946,197376,179538,177822,173726,177206,182178,198268,179902,198944,195651,184586,170199,155875,179130,170791,153958,194945,195912,153857,197900,190645,179206,182646,181474,183354,194401,197720,194273,169523,195272,196892,169039,180262,154966,183466,418844,195252,197196,182910,155022,182026,185086,170279,185290,194665,183842,197928,198412,173967,172631,179874,153845,153998,174910,174568,180810,196524,179302,181218,168971,182326,196812,195968,196940,188165,181958,184286,155859,196816,194421,196540,197324,180566,178618,176635,181450,170259,168752,171023,180690,177850,180234,181446,181946,185074,182666,196020,170287,174903,172529,183046,183750,154730,180458,175164,179210,181786,195940,181506,418710,170163,194101,177492,180906,183734,183014,156498,180214,170823,169811,198464,196832,418314,156562,170843,182190,169519,178590,197688,172576,168500,194345,342934,170191,179122,197564,181762,153890,170307,181818,183518,175276,184194,197016,178448,194157,198848,170723,198948,184106,179682,184118,180830,183810,175241,169227,179770,154834,179266,170419,182854,194217,194473,179930,185006,195436,197540,172196,194957,185379,197136,154782,196180,196240,195268,182222,195876,182890,176819,180750,196248,178489,179978,194297,182970,182766,183374,179910,180802,187933,156558,169679,170555,179998,177412,156550,199159,154646,197056,174657,181598,190681,179570,183438,184202,153938,154492,183210,195844,168496,169615,179674,191156,171339,175269,171367,174606,184426,185929,179526,196688,154682,196844,198160,196244,169603,198600,183890,169111,194637,154598,197760,181334,182046,169455,196124,194541,185178,175480,172656,181366,169095,153918,195240,196564,178522,184702,198244,184374,184214,191218,190843,196732,154694,197528,185918,198200,181374,198116,179794,198468,168772,196696,174883,171295,181466,181798,170099,174237,183726,194505,197156,175089,179790,179062,177281,177220,182470,197148,196012,155811,177464,177227,179458,170739,180286,175248,196504,180306,178186,178424,174490,185110,418714,177249,197400,185450,177039,177818,179510,195932,194853,176727,184666,181970,171408,197008,183626,179942,197100,172254,170111,181402,197004,196008,154095,183674,185150,195264,196440,179506,155156,169487,183170,179150,195888,194501,196596,182838,168516,184206,194581,183694,187868,169335,182170,184262,179990,170303,170867,169043,197916,183178,154099,179462,182662,473483,168828,154488,180486,176955,198476,181578,168424,184954,177600,183426,172964,195980,197876,177723,169219,177560,180158,177133,154634,183862,155746,194821,190667,174288,180514,190911,419415,196516,178217,184282,187879,169343,195828,170543,198076,174866,195468,183690,169771,170219,179494,195687,174524,168804,182318,180682,155062,185383,169175,170311,198792,195033,198204,196404,172381,179654,183514,197068,154714,179178,178822,198028,182306,184614,169147,170651,181014,184486,188182,198436,155412,154942,173769,177202,194129,181890,183634,184798,179690,180998,174002,181498,182202,181206,181282,154253,182678,194269,154890,182206,180982,172931,169651,169215,181046,198800,182526,173510,174021,196376,170267,181962,195316,179230,182750,155567,177786,169507,153853,199225,168410,169927,184294,155026,191103,194373,170631,176715,175174,170935,170291,182698,195884,169135,171203,180614,176987,177444,180770,184650,195852,156518,169791,198316,173659,191170,169795,183682,181810,188019,169407,190964,173639,197360,183430,171107,179862,184726,174378,181314,178432,181074,177500,171303,180182,181238,198504,184062,170363,181546,154974,183542,172998,188140,194349,169395,182862,182626,184302,198252,156506,177528,172320,155835,179078,172885,185266,180030,194409,171227,178806,155754,174155,170087,191342,178726,168650,194445,172360,188204,181326,288240,170887,185134,169459,196408,176923,195284,185230,170891,179738,181642,181690,198884,197904,183478,155782,194809,169275,180850,183446,184466,154532,177839,155449,181914,155431,154638,170963,170323,194133,195072,183822,185254,179450,175265,179134,195580,179618,418787,197328,198508,172917,171327,177085,195360,196232,171135,169107,177235,182922,196328,181082,185234,195699,170647,181358,180014,195472,176878,418808,169391,184534,155730,180434,174127,180186,177031,177727,181386,172175,184010,154229,174836,198496,170787,194405,179454,184730,181202,197628,169951,198592,153825,194153,170067,183310,184946,177089,182558,182590,184378,172292,196976,184306,182454,180038,198932,173949,179222,179382,181214,195728,185018,197624,182398,197396,180062,181722,171319,174708,195196,177260,179626,191174,195344,178210,169571,170147,197936,153829,154626,183746,188222,183182,177779,182638,185218,195464,154576,170575,196336,195552,180058,196156,181026,168728,180814,194621,180822,178766,155778,170343,171155,169911,174849,196736,177476,194949,199218,183022,195356,178167,196684,181302,194713,174041,183258,197596,181350,195484,195984,184070,182582,179486,197568,184398,194729,181654,172427,174500,184874,196896,179542,168756,169887,178750,177719,174151,194625,185540,178646,170103,172278,194489,176975,190978,198760,196600,172569,194517,184526,170795,180586,171383,196100,182610,182130,183606,168460,185246,195376,196468,155714,183898,176782,187872,197592,172512,196744,190810,195164,169151,177636,184042,198812,198288,188132,173547,194693,342923,170639,177011,182874,169655,182962,179634,184178,177192,183490,182954,154187,182778,195992,177652,181066,155445,168959,190847,179722,196884,185114,182074,183018,197920,197104,177428,182118,169915,180646,182110,185210,195832,169659,181438,194569,183154,183286,155457,187954,176939,179842,155131,191067,195864,170815,187980,181646,188121,195904,185955,198040,183470,184114,196144,172889,198968,182586,194645,182506,190885,177596,177893,197820,173530,181790,176786,198376,194393,197124,191207,185022,180626,187947,191282,181130,196412,172324,181042,184694,179298,181462,179038,168776,170179,176827,184018,184390,171131,183954,177152,177306,185050,198688,198408,170895,180042,180702,176963,182686,170623,169575,183930,181586,178175,182814,169999,195892,170995,196796,154239,179670,184918,168724,196272,194257,182298,194649,169255,184190,183622,187829,195804,197704,173985,191107,172673,179414,180402,196984,179202,169855,170195,185443,191310,176806,185536,195108,169471,154642,174923,168588,175204,194925,169819,188081,194861,197516,169859,196648,174510,184894,155408,191139,198640,155499,197176,198536,184962,180238,183266,196880,187778,179394,195988,172110,197752,473511,197188,196132,197296,171422,198920,179258,170283,183598,195920,184866,169699,170331,196048,196680,154878,153942,170911,196456,169619,169863,181794,191239,171351,196152,155596,198308,154606,180526,182658,182786,155803,196064,195556,170355,182950,183570,182114,180622,168596,181110,195160,179858,168447,196888,173692,194997,197364,179638,185407,196748,198740,174203,154710,168512,187890,169251,194277,196044,181926,195276,176943,154218,183874,183790,197588,182086,182938,197700,197480,197312,171363,175437,155678,179378,196676,170579,154726,170367,174896,184502,185078,181866,198124,171399,195404,195548,197740,197384,179262,198248,184850,196076,198136,155682,155738,171456,196804,155416,171143,196252,170959,175490,175072,168580,180090,180722,195812,185058,155528,195588,196520,182642,198952,177163,197248,154910,170443,198704,183150,171191,154602,196492,175123,177480,181570,154746,181078,181382,197072,177790,181554,198336,184618,178440,196164,198748,194281,183558,184806,170071,168482,198440,154702,179778,181230,179726,198480,155819,194429,194785,190957,169415,176667,180858,168963,170563,199132,188074,177580,196036,183586,197744,195760,180714,183642,169635,198452,198548,198188,170271,180174,191019,169235,171015,184322,170507,154312,197672,154854,181178,184350,188147,154166,181542,178496,198104,195428,171243,183158,180018,182378,179854,178586,168354,195192,197380,197388,195104,182554,182882,169491,195711,180894,171271,194137,168375,183986,155018,182038,177881,179514,197780,184058,194737,175194,155487,176916,183698,198096,174296,177440,196932,176840,195140,156546,170403,179290,198064,154698,194837,195576,173467,183302,195037,196452,181502,181770,179214,194937,196616,190663,170231,179182,180082,168720,179490,171219,178455,172377,181070,185589,156514,171011,174220,172559,198216,196472,195972,154275,168608,172103,173932,175082,195384,196264,185222,174425,170835,154994,168951,181522,179446,170927,155831,171267,188060,191270,156526,473504,196080,418739,194801,198232,181918,183994,170211,180354,177188,174701,177568,179406,197468,196084,195630,171111,181454,180454,185082,196808,184982,172874,184450,154790,183174,179534,182986,194725,168836,173673,180554,179194,180422,198196,197964,194221,173002,180258,184490,172310,169979,182866,196256,182386,199236,182294,180138,176611,172171,170435,179622,194593,180970,178662,184862,170183,177277,174182,173534,180298,180642,197268,170703,177688,185258,195308,177349,195572,179658,170883,174558,198712,172903,182090,181246,168840,195088,195076,154874,185414,196000,154774,169747,174395,170503,194653,182758,196944,184970,195520,196188,191015,179954,183654,195784,179166,197092,196720,154614,191322,169583,198456,178742,195476,197556,181778,170951,194565,173871,188110,170007,173663,181534,169203,174650,153934,196212,169723,170839,180882,179434,185206,155560,180086,196876,170063,182146,177273,183506,197140,197336,195380,169515,198488,170135,198092,195944,153902,168342,174320,171183,198596,182482,170915,183334,184646,194829,196528,174588,180450,171255,173597,174473,182138,184026,184974,197724,176731,177576,191258,195148,196052,181362,174856,169055,155152,182446,171051,196204,198108,196432,183534,169423,170019,190677,170711,179094,181318,183922,195756,155483,176959,195924,198724,170907,172956,195488,183250,198056,181098,181126,196728,168967,154500,171055,156510,182898,184906,181730,196096,198828,170255,181622,178444,178469,174619,180986,168824,179582,187984,194629,179186,184082,197584,173685,174075,178237,198528,170347,178262,195068,170431,172942,168732,155657,197276,171127,180846,153982,190806,182790,185922,156606,195512,194741,177861,170675,177548,168620,155164,195788,183330,184162,197224,197680,194497,172247,155441,198132,177231,196140,198100,169119,174517,154754,188172,194965,183106,155556,180730,178436,180078,195824,180886,155742,170371,179306,197064,198680,181118,197160,195348,195916,198804,173734,184910,153817,181718,180010,198864,179518,180274,187902,170719,198588,185485,169879,197272,185298,194705,171387,178746,194481,170511,197452,181198,184530,154982,197796,174930,196580,155855,168796,179474,170939,178203,177376,181726,180618,178670,168760,182542,179558,154137,184678,169091,184686,195744,194309,184198,181102,171359,195568,195136,176858,182794,181434,198940,194325,181038,197908,182030,199004,181922,182402,198824,184890,185322,173888,170767,173481,188045,184074,170807,170139,172555,197112,184094,195168,180938,191091,174006,197020,181930,196388,197976,190858,191031,197656,171251,197880,198896,183702,172607,184406,185302,197812,185250,153841,181862,181174,197080,183238,183942,183638,180330,194305,196752,194633,195584,183834,198520,182370,173453,191095,342930,176627,169163,180654,194341,181002,196512,197236,194333,182926,184298,191135,194865,196364,195292,190870,177007,179894,183462,183538,196588,177148,179286,179086,181614,155424,172896,197696,196112,181482,177508,175252,154301,170763,155843,187976,181942,197200,183630,181850,179962,183418,195622,173899,172402,174316,155160,174592,195659,174715,180242,179614,184422,170459,178626,183118,180110,197648,182826,195005,155540,185282,183214,197252,182702,170747,177389,194513,195420,179806,154568,195540,185174,198180,181854,177288,194657,184902,171039,171247,194149,197308,177504,196656,168748,172237,179402,176999,170875,170379,184138,196352,180954,185042,196936,196956,198532,197972,181650,198620,182010,155607,183754,182282,197504,181574,170047,168983,171123,174347,179810,185194,169579,198264,169379,190829,153974,170083,173041,196304,180382,181734,169943,171452,195480,177452,198156,170931,179906,169315,169439,197728,199101,187858,196608,170871,174775,283302,155476,178128,180230,170583,195200,198472,183370,169623,184522,195508,179926,183474,197520,183342,171223,181938,196292,179610,195244,154222,173751,178251,418393,195840,169271,182174,173576,182154,170023,170335,196756,197212,169611,182742,198484,180326,169695,182182,183578,190982,179170,191362,169171,169143,191007,196208,184542,196116,169759,184870,179866,198720,197260,184510,178714,183998,182450,197560,182002,179710,195025,197012,155863,176655,173709,177656,170495,197476,183946,194141,175062,180118,196556,194977,196604,181254,190933,195928,169355,181290,182330,179190,197996,170903,183382,154766,180774,198352,177342,473496,195691,183970,198676,190659,172395,198672,182382,171031,196288,191274,183322,174548,191326,198364,178574,196284,171147,183346,183034,183550,185090,183270,172580,195643,197652,198572,179074,194117,180050,196148,196952,179334,196532,170463,184942,170643,184050,184242,172179,180002,181638,182738,155513,177096,180478,170411,183074,174782,179898,169503,198568,173554,187998,182562,185326,196024,196776,184014,180142,180686,173744,176995,184318,418783,169351,194661,168371,169971,185571,182162,196104,182746,183982,171043,180302,198744,183166,183282,177814,178272,181166,173562,196396,170203,170455,169671,180310,155851,180506,168947,195952,198708,170919,191294,191338,197084,155915,177804,179410,176851,182774,177484,178196,178694,169643,184682,169071,154846,443607,181550,155871,170659,183050,197512,169263,196136,198176,172258,194973,179602,197756,156502,198372,198652,179058,195452,196868,177885,197524,194549,180502,185198,176671,182362,169939,177592,180362,173604,196716,154954,170487,180094,174809,194789,176951,182522,183926,179606,173586,196316,155168,177692,181782,175508,197856,169419,181710,179878,196192,195216,196464,184338,180314,180510,198060,169899,182422,154124,196708,173719,174258,190899,171433,196536,196900,194289,196032,197144,180266,443600,153865,179318,180726,155799,174684,179798,197288,196348,196712,197840,168464,197968,180534,179242,179342,183394,183610,155847,169359,174436,180898,196428,443615,184774,196788,179162,199000,154662,195655,191178,169707,195560,185130,182946,155722,184170,182894,187909,174950,168468,178602,188196,178790,181378,182310,195364,153881,172144,194917,183326,196476,174792,195368,183206,187801,173782,184430,180710,180206,182410,183582,182602,180678,174275,194249,178124,170535,155627,185390,191115,196768,172349,173677,170571,181566,187771,185418,183498,184922,169007,154866,181954,177242,194441,194749,197180,182694,184558,175106,181830,183314,181994,181590,171395,170423,173892,182998,170863,180918,173936,181898,168346,179238,187836,195956,197240,170427,183882,195080,171067,172910,198168,155674,182394,197028,184246,197060,197508,177144,172120,180754,154938,179958,196856,178762,154986,169015,177178,180494,181766,178557,172161,175032,176663,170483,173517,184006,197532,168492,181106,194909,170567,195220,184210,180874,191229,171323,418767,184546,178578,168792,196400,155807,170003,172490,182770,196704,180342,190866,198516,180198,183886,168387,181626,179066,182550,156578,177512,179030,182126,153966,195432,197572,179522,181630,173498,194701,168428,191186,197132,180950,181910,182214,194105,174940,173566,169451,170299,194321,185544,195172,177772,183162,195396,177298,191011,154862,156570,177043,198660,179554,194897,170235,182614,172974,195592,190641,177524,183122,183858,184706,169667,181934,183718,179026,182186,184978,179366,184182,182058,183086,170383,173034,194733,172438,169895,184822,169663,198052,180278,196660,195683,184838,154287,175476,182810,196312,168636,198280,170187,196460,179234,197800,196420,184714,196628,176931,179466,199091,170751,195204,198772,172356,183306,183110,183082,195041,177328,195948,174802,177628,179114,176643,171151,181354,184418,183730,179706,195816,185464,198080,182574,169387,169639,180542,194797,180570,197784,155182,182106,197992,183230,198272,185294,196772,197768,197608,177755,179422,181702,196236,155619,183530,181422,197500,185170,195176,198856,155899,154830,188015,184990,184478,183042,169187,196108,180994,184690,187754,419262,179870,190688,182042,183650,172224,184830,197052,183338,183594,170247,170447,171071,185361,185522,191250,180154,169431,170663,155750,182266,153978,188027,198988,182942,172213,180390,191059,187785,169595,181294,196368,154718,172522,170667,169267,196948,179922,155758,185274,183254,184926,177632,195045,197228,194357,195180,184474,185498,170755,198524,194145,191254,196276,185166,418725,170155,184066,174309,191035,155770,172388,195976,182230,196920,179050,180990,196644,198016,170215,196300,174343,171083,170167,184606,168624,196904,180358,197460,181414,173632,169155,195908,169563,170295,154978,195288,184554,197152,169739,169287,194845,184722,198088,198736,182238,172334,169875,196692,177917,195156,155175,155552,169023,169191,194329,168975,197732,179158,175466,197472,181562,169735,171371,182434,196436,199016,173429,179750,197256,180250,181858,168812,174405,180398,183870,170519,182094,174199,197408,154734,194781,198564,174224,185968,194793,178810,169731,170527,418818,198240,173425,154496,194969,181410,155465,183090,179362,180562,197492,196060,153954,183262,194573,199240,181342,181430,170315,194125,170727,154902,185306,182982,182734,172299,180218,181822,198732,155046,184810,171311,194769,174596,199196,197980,198900,169075,173912,184498,198628,182366,172960,191302,177556,182754,183402,155766,181242,183102,194301,172639,198728,198780,172451,195736,179698,190941,180470,180190,154758,155058,181758,154176,155050,182594,194525,154906,169539,172370,155645,182442,155054,172413,181162,343075,182798,184930,195336,180946,195084,180826,195792,180026,184362,185561,182142,169303,198004,194717,196072,153894,155002,154950,196968,197244,182066,155034,179574,196852,170551,179846,183778,196040,195544,195320,169367,198068,169411,179326,180146,185038,198888,171179,156594,195780,182510,153986,196620,196848,179782,183030,194561,194805,197576,194913,175052,177338,172590,179226,197356,171307,195224,172274,179986,180638,196424,196360,198980,154886,168576,173017,169323,182158,170899,178598,191023,169299,179766,195536,198928,194901,197444,154998,169727,179694,169063,196172,185475,177170,178722,173628,183526,179666,184438,179082,183914,182006,180786,198916,154283,155574,182278,195960,174725,194557,196612,154990,196792,182374,183798,183934,155014,170607,180742,172458,181582,178758,169427,169535,154962,182258,195124,198292,183058,184842,180738,179426,177051,180558,194857,170687,198976,178738,182514,173618,185425,182850,195500,176979,181122,174113,181406,182070,185575,190986,182722,198356,182018,185460,195001,182274,185351,198164,181750,194721,155123,179218,183098,180418,182290,168702,173006,180226,181266,194381,184626,194753,179970,181998,197764,183814,198560,168604,178518,181694,155883,185310,181490,169243,185214,179022,181902,170803,181286,418732,199192,180838,184126,154158,183562,194617,183502,155789,197788,174106,194685,174991,199108,184342,177520,170599,170635,195626,169827,174051,180074,196916,197320,196784,179438,178157,181210,183762,184230,169363,156582,179754,183114,173491,174213,182906,177604,170603,179566,182530,169687,183414,183386,418706,191298,178179,181834,176603,195184,198000,168744,181774,198296,180910,196296,181090,170811,170967,176991,184662,179966,184098,185945,169447,185002,155532,154279,181322,177696,179126,179822,197032,169223,154622,195013,199128,173442,196584,198796,197192,182194,179802,182350,169867,168406,180578,174168,177174,183198,170075,170859,176912,183566,155453,179110,181742,183666,180210,155186,196280,156598,154271,187761,194881,169047,195132,197956,181538,181594,195212,199077,183938,169019,177023,180594,184494,154686,197168,180194,154476,195715,182242,169531,179742,182606,169179,184030,153873,153994,181194,170031,184334,190878,180634,180282,183026,194953,195596,171470,188106,198636,196168,176796,171391,185439,153833,169843,170151,182714,183770,154484,171075,177324,178774,155524,174086,182990,169719,184574,169871,156590,174351,153877,198820,154658,197948,182414,168420,155548,188200,179350,194377,176699,196092,170975,169931,198604,194905,185102,195332,181950,183686,178702,170671,195772,171299,169935,181226,190822,179594,174822,178778,180482,170991,178826,198228,191166,197344,178146,182654,195820,170947,155520,178782,174667,169059,197868,181634,183126,196980,197848,179106,184142,168504,191266,179734,183362,176895,182870,170987,155649,197488,174459,194533,181982,173590,179786,182082,181158,177536,198140,183786,180598,181278,185515,179482,176927,185182,155469,169547,185146,169975,177416,178547,184346,198256,169743,194537,176659,169087,171355,175287,196260,170499,170847,198776,179418,195116,172189,181738,179054,195613,155774,195260,183850,153922,171063,183298,185318,179838,170655,168832,194385,198304,154191,184794,171211,179974,169291,171095,191203,171347,198972,177759,179046,169567,178255,170011,177003,185054,153970,198236,174974,197108,184710,155867,169231,185034,179718,198428,154822,169011,195707,196016,177552,155823,183246,179246,181526,198072,155006,418760,183714,197944,184102,168350,195796,155401,182934,195400,178630,169067,184086,177829,181310,168768,183146,195601,197340,197548,183006,182682,191099,169599,170359,178428,183554,198624,197216,182246,184394,184858,155582,198924,197940,173881,175462,184786,180426,171315,176691,197420,195634,179818,170611,154894,177913,185896,154148,171047,184826,195836,170547,191314,155603,179746,154838,170827,197660,196224,172217,174062,170923,182974,194669,342892,153990,171059,181298,198184,174544,169631,181746,185162,199184,179982,183066,183950,180414,170679,176599,178786,194545,177123,195675,198544,184958,170715,184446,182050,181870,194777,177366,179274,185094,195236,188154,194229,183134,174037,182730,195808,175021,176679,155589,170055,181706,177854,181682,179070,177140,198448,195092,155038,196496,179098,191045,183002,170387,154162,173928,194841,155042,182342,155907,185340,190836,172984,196548,155420,197300,168955,175501,195021,168991,182254,182458,169767,175025,198024,180394,154330,183458,153962,473479,194885,191246,182918,198152,198460,180370,194941,184402,194237,176723,179850,194585,170223,182234,170159,175140,180538,171235,174268,196840,197924,198716,197368,176874,197864,180446,173558,194893,169675,196924,169807,198420,174082,154670,169239,174254,194469,198964,196568,197580,184638,169331,181058,178798,154918,184310,182834,169823,179470,181186,198320,198840,176967,177432,183378,181398,182474,171159,191027,183962,154914,181190,195372,154536,170043,194433,195324,342902,169963,177496,182762,174633,181150,184882,196160,170059,198276,172949,183222,187894,169259,194609,173867,198212,195444,191278,177564,188095,182914,171087,181010,181878,168600,170239,176651,182502,180022,185336,197172,187851,190915,171207,197424,154870,184234,170523,184734,155461,194449,182782,185062,168820,155641,178142,179730,198416,196828,184802,419402,178682,170983,342884,174829,181618,197828,188038,154480,169083,194745,184326,184630,170107,171287,154814,196372,197536,182210,181894,181670,194697,168475,168788,169711,168784,183054,183742,418718,183574,198608,181674,179254,196960,190637,176623,184470,194413,175300,177472,183078,172338,174244,155667,173502,178706,194677,177516,198656,194369,180222,177448,180126,180178,179102,197044,174961,182930,168716,197640,198344,169483,169987,177456,194873,154572,169211,183710,179546,195800,177681,168643,191290,183846,195504,198036,169403,182710,179642,180862,191000,185226,184738,184742,198260,184038,184134,154858,179686,182886,188192,195896,178224,171115,197416,170207,171019,174643,195964,183670,194605,194553,181698,182818,183234,179762,181974,179198,173975,184290,195188,195703,185365,180666,188214,154882,183138,184598,184150,177359,180166,197464,171463,182338,194765,198172,170327,179090,196488,198768,153930,168592,196764,342909,154540,183826,170127,153861,169787,168628,155879,184154,175001,183366,184622,187962,183662,171139,184654,418791,188023,175214,180034,182726,195112,179330,182570,197088,179282,180834,182218,183190,180914,197712,194817,180658,195695,197496,342941,170731,169511,195868,178510,172089,180854,169079,155815,181826,185468,195880,179174,177668,176847,180746,181906,195416,180890,180246,172140,180106,170339,170491,195300,172148,183202,197776,170439,169551,194589,183974,195144,153950,168995,198032,175221,169027,170479,184386,154018,199012,182314,179310,198808,185551,172079,196220,153926,184218,179774,179590,170091,184250,197352,187929,184258,181494,190926,187940,169127,174677,170855,197668,180930,182302,155145,190652,195312,197676,198500,182830,184658,176703,187808,180406,195304,196384,178582,178614,155734,169815,195120,169283,185579,173652,185070,180818,181390,191146,180698,183186,170171,197852,172469,184998,180490,183038,199163,183966,185190,154674,182706,197716,182390,174954,198764,197116,191334,154786,196760,197220,197708,180442,195532,197264,179994,195232,153885,156602,181170,342913,187969,191306,195049,174623,155611,195460,171007,178814,184966,195256,170115,185242,181662,179678,172483,198552,197440,194417,196780,170375,176687,177404,191225,181062,184886,183806,169683,174752,198832,188218,197932,171375,198632,183722,180778,181602,190874,154654,196988,196724,169123,170243,195748,175133,178420,195228,180346,190907,198148,196184,198664,181114,155397,182978,195496,181182,180602,153910,173681,177532,184330,178818,184878,153849,154806,177488,184834,177119,178638,177572,155141,170775,174144,172342,198584,177408,183878,179502,170391,175448,178730,170695,168808,182518,178283,180794,188053,184314,191318,177400,183010,198392,184078,183318,174432,198752,169435,176639,183910,182462,181274,181846,181394,176647,198512,154666,172663,182498,181154,171199,198360,198852,195528,171480,191330,194253,188005,183854,170999,184670,180806,181610,191111,154810,195996,198696,183406,195064,182598,170559,169839,168987,179630,184022,169479,171079,156542,196740,169959,182354,199136,172420,182478,180902,154564,178514,178678,195564,168736,473500,174014,188102,184594,179270,181886,197120,181034,154778,418840,155491,195860,171035,154738,194317,178650,184146,187919,195667,174388,181658,179946,170979,174409,184110,177871,182418,179322,181978,154706,184582,185098,184274,197616,199177,170779,182670,198616,154195,177620,185505,171167,184518,197048,154560,195764,198876,181458,183094,184354,198208,178666,197024,172935,194453,174537,179314,179042,183422,178135,198424,176935,169247,182062,185186,169115,174055,184818,188158,198492,185369,185138,184634,156554,170123,170531,191211,198844,154002,171231,194265,181258,196928,197600,153821,187886,154750,169327,156574,171331,153914,182966,198908,178802,177302,155495,197456,196392,182122,154334,177106,169347,171291,196356,195524,195412,196624,197632,183590,169051,196912,194961,180066,178294,176683,183618,168379,198340,176739,181966,182270,182634,178770,180662,154826,198872,169467,178606,198996,183906,185202,175455,195424,179338,194285,181486,197040,176905,198576,181714,154898,170251,195060,180546,197952,194929,198816,169339,176735,179714,196068,179646,196592,176631,181990,182630,195408,418795,179530,179886,195352,175280,178698,169883,172924,198648,197816,178290,171279,198404,156522,197232,154970,190818,169307,179814,154014,194313,168398,178276,196544,196632,197836,175497,180630,198192,169559,169167,183358,168612,169691,198388,180338,169967,197372,179758,173421,181222,154291,184718,169495,169311,181022,169499,171171,194509,184174,168402,154610,169279,181814,179834,188067,178634,188049,154205,174742,183546,171404,184122,197984,182846,185122,169555,169543,197644,194457,182674,195280,181346,175099,168616,180290,182346,190802,194397,168358,179478,168584,174463,182994,174364,199200,170351,196196,182466,191346,180350,185270,196088,190945,169919,177047,181270,194425,184090,179154,172635,155903,154472,169803,183398,195605,179398,182490,182034,179370,182014,183410,182250,185286,196836,179826,194241,184434,191131,170319,176607,184002,198396,175005,184382,185118,194689,198112,184562,155634,174694,156538,170851,155653,196992,198328,184550,194641,180046,182546,183678,155718,182150,170743,155911,196996,169031,197096,194529,183782,198020,170039,169139,185344,187840,179562,197412,172306,198084,170971,194361,179914,182842,154088,194877,198904,171429,198128,180054,196552,179662,180866,181146,197604,196572,198644,168764,171099,180254,156586,179650,198048,195647,183450,197792,198788,188114,182494,197912,169715,170799,180386,177624,178658,176885,196004,176983,180518,180590,198144,195671,169371,180878,168999,181514,184358,182902,171103,180202,197204,199170,153898,170467,185593,168391,177897,180766,199232,196332,197316,183510,195392,155127,182198,180978,196636,197860,155503,196560,182134,190892,195776,194353,195100,181838,191084,169159,171003,169851,179830,184366,190990,170227,180098,179354,181754,197544,169831,196416,173027,194261,154120,172504,170819,195856,185238,196056,173460,194761,180294,170471,183990,170783,180134,197332,197552,171239,169835,180934,182098,156534,197208,169751,180122,198368,197844,170539,183218,197808,184566,173730,181426,154922,183802,194493,154308,184950,170263,180670,180762,195440,197804,178794,169755,169131,179034,183226,180706,170955,183614,178690,185030,198912,183442,154946,154958,174292,196268,181094,177664,198692,183894,188088,171119,198284,180410,188136,177420,168800,171335,180130,183294,177709,154690,177588,168740,179386,185314,194365,196908,195900,196200,153869,182286,198400,170119,182022,155839,181234,177584,169983,183818,173755,179882,184226,177027,180674,342969,197892,170707,169891,194461,155010,196444,179294,196176,418753,177256,196128,184914,191074,169383,180650,181138,182806,194613,185026,198684,170591,176971,195448,198992,181054,198700,183706,155615,194601,179346,183838,184130,419365,174192,177794,155891,170759,169923,170615,177320,180870,171027,194757,172991,178465,180782,169475,180842,181250,198984,196664,182406,184370,197888,173611,184158,197612,170027,179138,194337,154794,169527,174178,185397,195128,196344,180498,180966,153837,169607,196640,170619,197432,197736,174981,181478,170451,194521,177210,184278,175160,169783,181666,195296,183522,197128,171175,198956,180466,183902,178111,194933,154141,184414,198380,172508,169295,176695,154650,173705,178594,198880,168508,180922,195516,194709,176619,195768,177019,190862,184454,182690,170943,171343,194681,195492,183278,180974,170595,180430,195096,169319,182858,181530,169947,155536,170051,197392,198384,170475,198012,176675,195248,178642,182334,196668,197292,185154,195388,199214,172770,194825,342954,196308,198612,154267,179890,180374,181262,178710,172282,181418,194993,173759,179442,190903,191052,180070,194849,183454,169003,168780,198332,196824,155762,198836,195872,174449,175045,194389,194109,198960,172600,199207,196972,180150,154556,169703,198044,198300,154006,176823,170175,190953,181510,184578,169799,169847,179142,196340,172075,195009,197824,185106,170095,173971,180102,154183,155827,169627,198324,197428,198860,169991,198432,155726,180610,197304,198580,169591,182102,182802,188128,197748,185010,185014,195456,196480,172500,155623,171215,172434,169375,182622,183434,180366,179550,182166,180958,179430,178654,177540,170079,178718,184506,197960,181442,179278,184938,195848,184986,195936,170407,180462,199188,182078,196800,194121,181882,199152,184462,177889,197772,182430,172406,194989,195017,181558,182486,181470,194293,170399,168979,171275,196448,154770,172611,185889,198008,169647,177544,170395,183290,190971,188226,197076,180962,183482,185142,194773,170699,188031,196576,197692,194673,155887,178244,180438,177846,184898,184186,183062,181306,172127,172867,194113,194577,174732,155030,179934,182822,185158,177921,169399,182878,195609,197284,170627,177424,182534,178610,179702,183978,182438,198892,183070,155686,196380,177660,195663,197620,176719,184698,190949,198756,182650,195740,342888,184778,185046,172209,185126,180606,198120,183350,180758,154934,168844,169779,179374,187822,170015,177460,184482,179118,179146,184166,168632,181006,172615,179918,170131,187898,173992,170683,184410,197036,183794,182322,181086,183758,155544,169199,196672,197664,195732,178622,169443,170275,180334,154850,196872,197000,194225,153906,181030,191182,196964,197184,173010,172096,184590,183646,170879,181986,184034,194833,195029,195328,183142,183390,180790,190937,198224,169463,191063,184222,183738,180694,187991,197872,174099,181686,196324,185066,184674,198444,198556,184538,169183,173924,169195,178561,177468,178150,184854,181518,180718,183494,184782,179938,181802,184238,184790,182226,156530,154322,174876,194465,184642,171283,184054,183602,182566,170143,181018,180574,178473,185262,154010,155578,172652,177316,182578,183130,170515,187847,175187,181338}'::bigint[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 18631
  • Buffers: shared hit=90637
Execution time : 1,253.038 ms