explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lTwd

Settings
# exclusive inclusive rows x rows loops node
1. 1,233.957 9,794.132 ↑ 8.0 25 1

GroupAggregate (cost=92,811.40..92,905.13 rows=200 width=20) (actual time=7,638.551..9,794.132 rows=25 loops=1)

  • Group Key: monthly_flart.id_tseries
2. 3,139.434 8,560.175 ↓ 1,329.8 9,545,045 1

Sort (cost=92,811.40..92,829.35 rows=7,178 width=12) (actual time=7,595.222..8,560.175 rows=9,545,045 loops=1)

  • Sort Key: monthly_flart.id_tseries
  • Sort Method: external merge Disk: 205,256kB
3. 2,350.147 5,420.741 ↓ 1,329.8 9,545,045 1

Hash Join (cost=19,154.84..92,351.67 rows=7,178 width=12) (actual time=275.135..5,420.741 rows=9,545,045 loops=1)

  • Hash Cond: (monthly_flart.id_infra_instan = po_proj_sub_infra.id_infra_instan)
4. 618.267 2,796.014 ↓ 196.0 9,545,045 1

Append (cost=0.00..71,054.97 rows=48,708 width=16) (actual time=0.017..2,796.014 rows=9,545,045 loops=1)

5. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on po_monthly_flart monthly_flart (cost=0.00..0.00 rows=1 width=16) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: ((id_tseries >= '2018-09-30'::date) AND (id_tseries <= '2020-10-31'::date) AND (id_enterprise = 83))
6. 2,177.742 2,177.742 ↓ 196.0 9,545,045 1

Index Scan using idx_po_flart_83_ent_id_tseries on po_monthly_flart_83 monthly_flart_1 (cost=0.43..71,054.97 rows=48,707 width=16) (actual time=0.012..2,177.742 rows=9,545,045 loops=1)

  • Index Cond: ((id_enterprise = 83) AND (id_tseries >= '2018-09-30'::date) AND (id_tseries <= '2020-10-31'::date))
7. 22.518 274.580 ↓ 1.7 119,590 1

Hash (cost=18,300.04..18,300.04 rows=68,384 width=4) (actual time=274.580..274.580 rows=119,590 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 5,229kB
8. 63.519 252.062 ↓ 1.7 119,590 1

Hash Join (cost=6,915.04..18,300.04 rows=68,384 width=4) (actual time=152.845..252.062 rows=119,590 loops=1)

  • Hash Cond: (po_proj_sub_infra.id_project_sub = po_project_sub.id_project_sub)
9. 36.766 36.766 ↑ 1.0 522,775 1

Seq Scan on po_proj_sub_infra (cost=0.00..8,740.75 rows=522,775 width=8) (actual time=0.006..36.766 rows=522,775 loops=1)

10. 2.025 151.777 ↑ 2.0 10,518 1

Hash (cost=6,649.36..6,649.36 rows=21,254 width=4) (actual time=151.777..151.777 rows=10,518 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 626kB
11. 17.837 149.752 ↑ 2.0 10,518 1

Hash Join (cost=2,381.71..6,649.36 rows=21,254 width=4) (actual time=119.439..149.752 rows=10,518 loops=1)

  • Hash Cond: (po_project_sub.id_project = po_project.id_project)
12. 12.526 12.526 ↑ 1.0 162,481 1

Seq Scan on po_project_sub (cost=0.00..3,445.81 rows=162,481 width=8) (actual time=0.004..12.526 rows=162,481 loops=1)

13. 0.946 119.389 ↑ 1.0 5,761 1

Hash (cost=2,309.70..2,309.70 rows=5,761 width=4) (actual time=119.389..119.389 rows=5,761 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 267kB
14. 118.443 118.443 ↑ 1.0 5,761 1

Index Only Scan using po_project_pkey on po_project (cost=0.29..2,309.70 rows=5,761 width=4) (actual time=10.979..118.443 rows=5,761 loops=1)

  • Index Cond: (id_project = ANY ('{2719,2720,9194,9694,9695,10187,10189,10435,10447,10450,10457,10458,10468,10470,10472,10474,10498,10543,15829,15831,15832,15833,15835,15836,15837,15838,15839,15842,15904,15905,16355,16360,16529,16530,24055,24056,37091,37095,37299,37566,38418,38914,38930,38931,38934,38944,38945,38946,38947,38948,38949,38950,38951,39116,39120,39122,39126,39127,39129,39132,39133,39137,39139,39140,39144,39145,39149,39152,39157,39165,39166,39167,39168,39169,39170,47250,47277,47370,47371,47452,47517,47544,47548,47574,47656,47658,47700,47704,47706,47707,47708,47754,47758,47767,47775,47783,47784,47793,47820,47844,47853,47857,47898,47909,47923,47924,47925,47926,47927,47928,47940,47941,47942,47943,47944,47945,47946,47951,47952,47956,47957,47962,47963,47964,47965,47976,48014,48016,48017,48019,48021,48036,48061,48062,48098,48111,48112,48227,48286,48467,49652,50236,50287,50293,50309,51360,51361,51362,51363,51377,51378,51403,51520,51521,51526,51530,51531,51540,51627,51721,51843,51845,51859,51866,51875,51884,51907,51909,51910,51920,51928,51952,51953,51954,51955,51956,51957,51958,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51970,51971,51972,51973,51975,52031,52048,52052,52112,52137,52142,52145,52270,52271,52277,52286,52300,52301,52305,52306,52307,52309,52310,52315,52316,52317,52324,52325,52326,52327,52328,52334,52342,52343,52347,52348,52350,52351,52352,52353,52354,52355,52356,52357,52358,52359,52360,52361,52362,52363,52364,52365,52366,52367,52368,52369,52370,52371,52372,52373,52374,52375,52430,52527,52533,52534,52548,52553,52554,52555,52556,52574,52577,52583,52591,52603,52606,52609,52618,52622,52624,52626,52636,52639,52642,52643,52646,52669,52672,52674,52678,52683,52693,52726,52728,52729,52730,52731,52732,52733,52738,52739,52740,52741,52742,52744,52746,52747,52748,52749,52750,52753,52765,52766,52767,52768,52769,52770,52771,52772,52773,52774,52828,52835,52874,52875,52878,52893,52936,53168,53450,54351,54904,54905,54907,57036,57037,57038,57039,57094,57193,57212,57214,57237,57238,57239,57240,57242,57254,57255,57258,57265,57287,57295,57300,57301,57311,57317,57345,57351,57352,57353,57354,57355,57356,57357,57358,57359,57360,57361,57362,57363,57365,57366,57370,57372,57373,57381,57383,57384,57386,57399,57402,57403,57418,57419,57426,57427,57436,57439,57447,57460,57461,57462,57463,57464,57465,57466,57467,57468,57469,57470,57471,57472,57474,57475,57476,57488,57489,57490,57491,57492,57493,57494,57495,57496,57497,57500,57501,57502,57503,57538,57539,57541,57542,57543,57544,57545,57546,57547,57548,57549,57550,57555,57558,57559,57607,57647,57691,57795,57797,57802,57971,57972,58106,58107,58108,58109,58110,58111,58112,58113,58114,58115,58116,58117,58118,58119,58120,58121,58122,58123,58124,58125,58126,58127,58128,58129,58130,58131,58132,58133,58134,58135,58136,58137,58138,58139,58140,58141,58142,58143,58144,58145,58146,58147,58148,58149,58150,58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171,58172,58173,58174,58175,58209,58210,58211,58212,58213,58214,58215,58216,58221,58222,58223,58224,58225,58231,58232,58233,58234,58235,58236,58240,58242,58255,58257,58259,58265,58274,58275,58276,58277,58320,58325,58361,58362,58363,58364,58365,58366,58367,58376,58377,58382,58386,58387,58404,58407,58408,58409,58442,58446,58447,58449,58646,58648,58649,58650,58651,58652,58653,58654,58655,58657,58659,58660,58661,58662,58663,58664,58665,58666,58667,58669,58671,58672,58673,58674,58675,58676,58678,58679,58681,58682,58683,58684,58685,58686,58689,58694,58696,58697,58699,58704,58708,58709,58710,58711,58713,58714,58716,58717,58718,58719,58722,58740,58741,58744,58745,58746,58747,58748,58749,58750,58751,58752,58753,58754,58755,58756,58757,58758,58759,58760,58762,58765,59536,59538,59539,59540,59560,59582,59583,59584,59585,59586,59587,59588,59589,59590,59591,59592,59595,59596,59600,59602,59612,59613,59614,59615,59616,59617,59618,59619,59620,59621,59622,59624,59643,59644,59645,59646,59647,59649,59651,59653,59655,59659,59663,59664,59665,59666,59668,59669,59675,59678,59683,59684,59685,59687,59689,59691,59692,59693,59694,59696,59698,59702,59703,59704,59705,59706,59707,59708,59709,59710,59712,59713,59714,59715,59716,59717,59718,59719,59720,59721,59722,59723,59724,59725,59726,59727,59728,59729,59730,59731,59732,59733,59739,59740,59742,59743,59744,59745,59746,59752,59753,59754,59755,59757,59758,59759,59760,59761,59762,59766,59767,59768,59769,59775,59777,59780,59782,59783,59784,59792,59793,59794,59795,59796,59797,59800,59801,59806,59807,59808,59809,59810,59811,59812,59813,59814,59815,59816,59817,59818,59819,59820,59821,59824,59825,59826,59827,59828,59829,59832,59833,59834,59835,59836,59837,59838,59839,59840,59841,59842,59843,59844,59845,59846,59847,59848,59850,59851,59852,59853,59854,59856,59857,59858,59859,59860,59861,59862,59863,59864,59865,59867,59868,59869,59870,59871,59872,59873,59874,59875,59876,59879,59880,59881,59885,59886,59887,59888,59889,59890,59891,59892,59894,59895,59896,59897,59898,59899,59900,59901,59902,59903,59904,59905,59906,59907,59908,59909,59910,59911,59912,59913,59914,59916,59921,59922,59923,59924,59926,59927,59929,59981,59988,59989,59990,59991,59995,59997,59999,60000,60001,60002,60003,60004,60005,60007,60008,60009,60010,60011,60012,60013,60015,60016,60017,60018,60019,60020,60021,60022,60023,60024,60025,60026,60027,60028,60029,60030,60031,60032,60033,60034,60035,60036,60037,60038,60039,60040,60041,60042,60043,60044,60045,60046,60047,60048,60049,60050,60051,60052,60053,60054,60055,60056,60057,60058,60059,60060,60061,60062,60063,60064,60065,60066,60067,60068,60069,60070,60071,60072,60073,60074,60075,60076,60077,60078,60079,60080,60081,60082,60083,60084,60085,60114,60115,60116,60118,60119,60120,60121,60122,60123,60124,60125,60126,60127,60128,60129,60130,60131,60132,60133,60134,60136,60137,60138,60139,60140,60141,60142,60209,60210,60211,60212,60213,60216,60217,60231,60233,60235,60239,60373,61223,61224,61232,61234,61235,61236,61240,61247,61250,61251,61265,61268,61269,61270,61271,61272,61273,61274,61275,61276,61277,61278,61279,61280,61281,61282,61283,61284,61285,61286,61287,61288,61289,61290,61291,61292,61293,61294,61295,61296,61297,61298,61299,61300,61301,61302,61303,61304,61305,61306,61307,61308,61309,61310,61311,61312,61313,61314,61315,61316,61317,61318,61319,61320,61321,61322,61323,61324,61325,61326,61327,61328,61329,61330,61331,61332,61333,61334,61335,61336,61337,61338,61339,61340,61341,61342,61343,61344,61345,61346,61347,61348,61349,61350,61351,61352,61353,61354,61355,61356,61357,61358,61359,61360,61361,61362,61363,61364,61365,61366,61367,61368,61369,61370,61371,61372,61373,61374,61375,61376,61377,61378,61379,61380,61381,61382,61383,61384,61385,61386,61387,61388,61389,61390,61391,61392,61393,61394,61395,61396,61397,61398,61399,61400,61401,61402,61403,61404,61405,61406,61407,61408,61409,61410,61411,61412,61413,61414,61415,61416,61417,61418,61419,61420,61421,61422,61423,61424,61425,61426,61427,61428,61429,61430,61431,61432,61433,61434,61435,61436,61437,61438,61439,61440,61441,61442,61443,61444,61445,61446,61447,61448,61449,61450,61451,61452,61453,61454,61455,61456,61457,61458,61459,61460,61461,61462,61463,61464,61465,61466,61467,61468,61469,61470,61471,61472,61473,61474,61475,61476,61477,61478,61479,61480,61481,61482,61483,61484,61485,61486,61487,61488,61489,61490,61491,61492,61493,61494,61495,61496,61497,61498,61499,61500,61501,61502,61503,61504,61505,61506,61507,61508,61509,61510,61511,61512,61513,61514,61515,61516,61517,61518,61519,61520,61521,61522,61523,61524,61525,61526,61527,61528,61529,61530,61531,61534,61535,61536,61537,61538,61539,61540,61541,61542,61809,61810,61811,61812,61813,61814,61815,61816,61817,61818,61819,61820,61821,61822,61823,61824,61825,61826,61827,61828,61829,61830,61831,61832,61833,61834,61835,61836,61837,61838,61897,61898,61899,61900,61901,61902,61903,61904,61905,61906,61907,61908,61909,61910,61911,61912,61913,61914,61915,61916,61917,61918,61919,61920,61921,61922,61923,61924,61925,61926,61927,61928,61929,61930,61931,61932,61933,61934,61935,61936,61937,61938,61939,61940,61941,61942,61943,61944,61945,61946,61947,61948,61949,61950,61951,61952,61953,61954,61955,61956,61957,61958,61959,61960,61961,61962,61963,61964,61965,61966,61967,61968,61969,61970,61971,61972,61973,61974,61975,61976,61977,61978,61990,61992,61994,61995,61996,61997,61998,61999,62000,62001,62002,62003,62004,62005,62006,62007,62008,62009,62010,62011,62013,62014,62015,62016,62017,62018,62019,62021,62022,62023,62024,62025,62026,62027,62028,62029,62030,62031,62033,62034,62035,62036,62037,62038,62039,62040,62041,62042,62043,62044,62047,62049,62050,62052,62053,62054,62055,62056,62057,62058,62060,62061,62063,62064,62066,62067,62068,62069,62071,62074,62075,62076,62077,62078,62079,62080,62081,62082,62083,62085,62086,62087,62088,62089,62090,62091,62092,62094,62095,62096,62097,62100,62101,62102,62103,62104,62105,62106,62107,62108,62109,62110,62111,62112,62113,62115,62116,62117,62118,62119,62120,62122,62123,62124,62125,62126,62127,62128,62129,62130,62132,62133,62134,62135,62136,62137,62138,62139,62140,62141,62142,62143,62144,62145,62146,62147,62148,62149,62151,62152,62154,62157,62158,62160,62161,62162,62163,62164,62166,62167,62169,62170,62171,62172,62175,62176,62177,62178,62179,62180,62181,62182,62209,62210,62211,62214,62215,62216,62217,62218,62219,62220,62221,62222,62223,62224,62225,62226,62227,62228,62229,62230,62231,62232,62233,62235,62236,62237,62240,62242,62243,62244,62245,62246,62247,62248,62249,62250,62251,62252,62253,62254,62255,62257,62258,62259,62260,62261,62262,62263,62264,62265,62266,62267,62268,62269,62270,62271,62272,62273,62274,62275,62276,62277,62278,62279,62280,62281,62282,62283,62284,62285,62286,62287,62288,62289,62291,62292,62299,62300,62301,62302,62303,62304,62305,62306,62307,62308,62309,62310,62311,62312,62313,62314,62315,62316,62317,62318,62319,62320,62321,62322,62323,62324,62325,62326,62327,62328,62329,62330,62589,62590,62591,62592,62593,63011,63012,63394,63415,63416,63417,63418,63421,63423,63424,63425,63431,63432,63433,63434,63435,63436,63437,63438,63439,63440,63441,63442,63443,63444,63445,63446,63453,63455,63456,63457,63458,63461,63462,63463,63464,63466,63467,63468,63469,63470,63471,63472,63473,63474,63475,63476,63477,63478,63479,63480,63481,63482,63483,63484,63485,63486,63487,63488,63489,63490,63491,63492,63493,63494,63495,63496,63497,63498,63499,63501,63502,63503,63505,63506,63507,63508,63509,63510,63511,63512,63513,63514,63515,63516,63517,63518,63519,63520,63521,63522,63523,63524,63526,63527,63530,63531,63532,63534,63535,63536,63537,63539,63541,63542,63543,63544,63545,63547,63550,63551,63552,63553,63554,63556,63557,63560,63561,63562,63563,63564,63565,63567,63568,63569,63570,63571,63572,63573,63574,63575,63576,63578,63579,63580,63581,63582,63583,63584,63585,63586,63589,63633,63634,63635,63701,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,64034,64059,64239,64254,64261,64263,64264,64364,64365,64366,64367,64393,64394,64395,64397,64398,64400,64401,64402,64403,64404,64405,64407,64408,64409,64412,64413,64414,64415,64416,64417,64418,64419,64420,64423,64424,64425,64426,64427,64428,64429,64430,64431,64432,64434,64443,64444,64445,64446,64447,64448,64449,64453,64454,64455,64456,64457,64458,64459,64904,64913,65381,65382,65383,65384,65385,65386,65387,65388,65389,65390,65391,65392,65393,65394,65395,65396,65397,65398,65399,65400,65401,65402,65403,65404,65405,65406,65407,65408,65409,65410,65411,65412,65413,65414,65415,65416,65417,65418,65419,65420,65421,65422,65423,65424,65425,65426,65427,65428,65429,65430,65431,65432,65433,65450,65457,65460,65461,65462,65463,65464,65465,65466,65467,65468,65469,65470,65471,65472,65473,65474,65475,65476,65477,65478,65479,65516,65518,65549,65555,65556,65557,65558,65559,65618,65687,65689,65691,65693,65697,65698,65699,65700,65701,65702,65704,65705,65706,65707,65709,65710,65711,65713,65714,65716,65717,65719,65727,65731,65732,65746,65747,65748,65749,65751,65752,65759,65761,65762,65763,65764,65765,65766,65767,65768,65769,65771,65774,65775,65776,65777,65778,65779,65781,65782,65787,65788,65789,65790,65791,65792,65793,65794,65795,65828,65829,65830,65832,65833,65834,65835,65836,65837,65838,65839,65840,65841,65843,65844,65845,65846,65847,65848,65849,65850,65851,65852,65853,65854,65855,65856,65857,65858,65859,65860,65861,65862,65863,65864,65865,65866,65867,65868,65869,65870,65871,65872,65873,65874,65875,65876,65877,65878,65879,65880,65881,65882,65883,65884,65885,65886,65887,65888,65889,65890,65891,65892,65893,65894,65895,65896,65897,65898,65899,65900,65901,65902,65903,65904,66123,66124,66188,66189,66190,66191,66192,66193,66194,66195,66196,66197,66198,66199,66200,66201,66202,66203,66204,66205,66206,66207,66208,66209,66210,66211,66212,66213,66214,66215,66216,66217,66218,66219,66220,66221,66222,66223,66224,66225,66226,66256,66257,66283,66284,66286,66287,66590,66591,66593,66597,66599,66645,66646,66647,66648,66649,66650,66651,66652,66653,66654,66655,66656,66657,66658,66659,66660,66661,66662,66663,66664,66665,66666,66667,66668,66669,66670,66671,66672,66673,66674,66675,66676,66677,66678,66679,66680,66681,66682,66683,66684,66685,66686,66687,66688,66689,66690,66691,66692,66693,66694,66695,66696,66697,66698,66699,66700,66701,66702,66703,66704,66705,66706,66707,66708,66709,66710,66711,66712,66713,66714,66715,66716,66717,66718,66719,66720,66721,66722,66723,66724,66725,66726,66727,66728,66729,66730,66731,66732,66733,66734,66735,66736,66737,66738,66739,66740,66741,66742,66743,66744,66745,66746,66747,66748,66749,66750,66751,66752,66753,66754,66755,66756,66757,66758,66759,66760,66761,66762,66763,66764,66765,66766,66767,66768,66769,66770,66771,66772,66773,66774,66775,66776,66777,66778,66779,66780,66781,66782,66783,66784,66785,66786,66787,66788,66789,66790,66791,66792,66793,66794,66795,66796,66797,66798,66799,66800,66801,66802,66803,66804,66805,66806,66807,66808,66809,66810,66811,66812,66813,66814,66815,66816,66817,66818,66819,67578,67579,67580,67581,67582,67583,67584,67585,67586,67587,67588,67589,67590,67591,67592,67610,67611,67612,67613,67614,67615,67616,67617,67742,67743,67744,67746,67749,67751,67752,67754,67755,67756,67757,67758,67759,67760,67761,67762,67763,67764,67765,67768,67770,67773,67774,67775,67776,67785,67786,68026,68027,68028,68029,68030,68031,68032,68033,68034,68035,68036,68037,68038,68039,68040,68041,68042,68043,68044,68045,68046,68047,68048,68049,68050,68051,68052,68053,68054,68055,68056,68057,68058,68059,68060,68061,68062,68063,68064,68065,68066,68067,68068,68069,68070,68071,68072,68073,68074,68075,68076,68077,68078,68079,68080,68081,68082,68083,68084,68085,68086,68087,68088,68089,68090,68091,68092,68093,68094,68095,68096,68097,68098,68099,68100,68101,68102,68103,68104,68105,68106,68107,68108,68109,68110,68111,68112,68113,68114,68115,68116,68117,68118,68119,68120,68121,68122,68123,68124,68125,68126,68127,68128,68129,68130,68131,68132,68133,68134,68135,68136,68137,68138,68139,68140,68141,68142,68143,68144,68145,68146,68147,68148,68149,68150,68151,68152,68153,68154,68155,68156,68157,68158,68159,68160,68161,68162,68163,68164,68165,68166,68167,68168,68169,68170,68171,68172,68173,68174,68175,68176,68177,68178,68179,68180,68181,68182,68183,68184,68185,68186,68187,68188,68189,68190,68191,68192,68193,68194,68195,68196,68197,68198,68199,68200,68201,68202,68203,68204,68205,68206,68207,68208,68209,68210,68211,68212,68213,68214,68215,68216,68217,68218,68219,68220,68221,68222,68223,68224,68225,68226,68227,68228,68229,68230,68231,68232,68233,68234,68235,68236,68237,68238,68239,68240,68241,68242,68243,68244,68245,68246,68247,68248,68249,68250,68251,68252,68253,68254,68255,68256,68257,68258,68259,68260,68261,68262,68268,68270,68274,68275,68276,68277,68278,68279,68280,68281,68282,68286,68290,68293,68294,68295,68296,68300,68302,68350,68351,68352,68353,68354,68355,68356,68357,68358,68359,68360,68361,68362,68363,68364,68365,68366,68367,68368,68369,68370,68371,68372,68373,68374,68375,68376,68377,68378,68379,68380,68381,68382,68383,68384,68385,68386,68387,68388,68389,68390,68391,68392,68393,68394,68395,68396,68397,68398,68399,68400,68401,68402,68403,68404,68405,68406,68407,68408,68409,68410,68411,68412,68413,68414,68419,68420,68421,68422,68423,70352,70360,70367,70368,70369,70370,70371,70373,70374,70375,70376,70377,70378,70382,70383,70384,70385,70386,70387,70388,70389,70390,70391,70392,70393,70394,70395,70396,70397,70398,70399,70400,70405,70406,70407,70408,70409,70410,70411,70412,70413,70414,70415,70416,70417,70418,70419,70420,70421,70422,70423,70424,70425,70426,70427,70428,70429,70430,70431,70432,70433,70434,70435,70436,70437,70438,70439,70440,70441,70442,70443,70444,70445,70446,70447,70448,70449,70450,70451,70452,70453,70454,70455,70456,70457,70458,70459,70460,70461,70462,70463,70464,70465,70466,70467,70468,70469,70470,70471,70472,70473,70474,70475,70476,70477,70478,70479,70480,70481,70482,70483,70484,70485,70486,70487,70488,70489,70490,70491,70492,70493,70494,70495,70496,70497,70498,70499,70500,70501,70502,70503,70504,70505,70506,70507,70508,70509,70510,70511,70512,70513,70514,70515,70516,70517,70518,70519,70520,70521,70522,70523,70524,70525,70526,70527,70528,70529,70530,70531,70532,70533,70534,70535,70536,70537,70538,70539,70540,70541,70542,70543,70580,70581,70582,70583,70584,70585,70586,70667,70668,70669,70670,70671,70672,70673,70674,70675,70676,70677,70678,70679,70680,70681,70682,70683,70684,70685,70686,70687,70688,70689,70690,70691,70692,70693,70694,70695,70696,70697,70698,70699,70700,70701,70702,70703,70704,70705,70706,70707,70708,70709,70710,70711,70712,70713,70714,70715,70716,70717,70718,70719,70720,70721,70722,70723,70724,70725,70726,70727,70728,70729,70730,70731,70732,70733,70734,70735,70736,70737,70738,70739,70740,70741,70742,70743,70744,70745,70746,70747,70748,70749,70750,70751,70752,70753,70754,70755,70756,70757,70758,70759,70760,70761,70762,70763,70764,70765,70766,70767,70768,70769,70770,70771,70772,70773,70774,70775,70776,70777,70778,70779,70780,70781,70782,70783,70784,70785,70786,70787,70788,70789,70790,70791,70792,70793,70794,70795,70796,70797,70798,70799,70800,70801,70802,70803,70804,70805,70806,70807,70808,70809,70810,70811,70812,70813,70814,70815,70816,70817,70818,70819,70820,70821,70822,70823,70824,70825,70826,70827,70828,70829,70830,70831,70832,70836,70837,70838,70839,70840,70841,70842,70843,70844,71025,71026,71027,71028,71029,71030,71031,71032,71033,71034,71035,71036,71037,71038,71039,71040,71091,71092,71093,71094,71095,71096,71097,71098,71099,71100,71101,71102,71103,71104,71105,71106,71107,72184,72213,72214,72215,72216,72217,72218,72219,72220,72221,72222,72223,72224,72225,72226,72227,72228,72229,72230,72231,72232,72233,72234,72235,72236,72237,72238,72239,72240,72241,72242,72243,72244,72245,72246,72247,72248,72249,72250,72251,72252,72253,72254,72255,72256,72257,72258,72259,72260,72261,72262,72263,72264,72265,72266,72267,72268,72269,72270,72271,72272,72273,72274,72275,72276,72277,72278,72279,72280,72281,72282,72283,72284,72285,72286,72287,72288,72289,72290,72291,72292,72293,72294,72295,72296,72297,72298,72299,72300,72301,72302,72303,72304,72305,72306,72307,72308,72309,72310,72311,72312,72313,72314,72315,72316,72317,72318,72319,72320,72321,72322,72323,72324,72336,72861,72862,72863,72864,72865,72919,72959,72960,73028,73029,73030,73031,73032,73033,73034,73035,73036,73037,73038,73039,73040,73041,73042,73043,73044,73045,74267,74268,74269,74270,74271,74272,74275,74276,74277,74278,74279,74280,78308,78309,78310,78311,78356,78357,78358,78359,78360,78361,78362,78363,78364,78365,78366,78367,78368,78369,78370,78371,78372,78373,78374,78375,78376,78377,78378,78379,78380,78381,78382,78383,78384,78385,78386,78387,78388,78389,78390,78391,78392,78393,78394,78395,78396,78397,78398,78399,78400,78401,78402,78403,78404,78405,78406,78407,78408,78409,78410,78411,78412,78413,78414,78415,78416,78417,78418,78419,78420,78421,78422,78423,78638,78639,78640,79220,79221,79222,79223,79224,79225,79226,79227,79228,79229,79230,79231,79232,79233,79234,79237,79238,79239,79240,79241,79242,79243,79244,79245,79246,79247,79248,79249,79250,79251,79252,85477,86089,86094,86095,86098,86099,86100,86101,86102,86103,86104,86119,86120,86121,86122,86123,86124,86125,86135,86136,86137,86138,86139,86140,86141,86142,86143,86144,86145,86146,86147,86148,86149,86150,86151,86152,86153,86154,86155,86156,86157,86158,86159,86160,86161,86162,86163,86164,86165,86166,86167,86168,86169,86170,86171,86172,86173,86174,86175,86176,86177,86178,86179,86180,86181,86182,86183,86184,86185,86186,86187,86188,86189,86190,86191,86192,86193,86194,86195,86196,86197,86198,86199,86200,86201,86202,86203,86204,86205,86206,86207,86209,86210,86211,86212,86213,86214,86215,86216,86217,86219,86220,86221,86222,86223,86224,86225,86226,86227,86228,86229,86230,86231,86232,86233,86234,86235,86236,86237,86238,86239,86240,86241,86242,86243,86244,86245,86246,86247,86248,86249,86250,86251,86252,86253,86254,86255,86256,86257,86258,86259,86260,86261,86262,86263,86264,86265,86266,86267,86268,86269,86270,86271,86272,86273,86274,86275,86276,86277,86278,86279,86280,86281,86282,86283,86284,86285,86286,86287,86288,86289,86290,86291,86292,86293,86294,86295,86296,86297,86298,86299,86300,86301,86302,86303,86331,86332,86333,86334,86335,86336,86337,86338,86339,86340,86341,86342,86343,86344,86345,86346,86347,86348,86349,86350,86351,86352,86353,86354,86355,86356,86357,86358,86359,86360,86361,86362,86363,86364,86365,86366,86367,86368,86370,86371,86372,86373,86374,86375,86376,86377,86378,86379,86380,86381,86382,86383,86384,86385,86386,86387,86388,86389,86390,86391,86392,86393,86394,86395,86396,86397,86398,86399,86400,86402,86403,86404,86715,86716,86717,86718,86719,86720,86721,86735,86772,86773,86811,86812,86814,86815,86816,86817,86818,86819,86820,86821,86822,86823,86827,86828,86829,86830,86831,86832,86833,86834,86835,86845,86846,86847,86848,86849,86850,86851,86852,86853,86854,86855,86856,86857,86858,86859,86861,86862,86863,86865,86866,86867,86868,86869,86870,86871,86872,86873,86874,86875,86876,86877,86878,86879,86880,86881,86882,86883,86884,86885,86886,86887,86888,86889,86890,86891,86892,86893,86894,86895,86896,86897,86898,86899,86900,86901,86902,86903,86904,86905,86906,86907,86908,86909,86910,86911,86912,86913,86914,86915,86916,86917,86918,86919,86920,86921,86922,86923,86924,86925,86926,86927,86928,86929,86930,86931,86932,86933,86934,86935,86936,86937,86938,86939,86940,86941,86942,86943,86944,86945,86946,86948,86949,86950,86951,87014,87027,87071,87072,87073,87074,87075,87076,87077,87078,87079,87080,87081,87082,87083,87084,87102,87105,87106,87107,87108,87110,87111,87112,87113,87114,87115,87116,87117,87118,87119,87120,87121,87122,87123,87124,87125,87126,87127,87128,87129,87130,87155,87156,87157,87158,87159,87160,87161,87162,87163,87164,87165,87166,87167,87168,87170,87171,87172,87173,87174,87175,87178,87179,87180,87181,87182,87183,87184,87185,87186,87187,87188,87189,87190,87195,87196,87197,87211,87212,87217,87218,87219,87220,87221,87222,87223,87224,87225,87226,87227,87228,87236,87237,87238,87239,87240,87241,87242,87243,87244,87245,87246,87247,87248,87249,87252,87253,87254,87255,87256,87257,87258,87259,87260,87261,87262,87263,87264,87265,87266,87267,87268,87269,87270,87271,87272,87273,87274,87275,87276,87277,87278,87279,87280,87281,87282,87283,87284,87285,87286,87287,87288,87289,87290,87291,87292,87293,87294,87295,87296,87297,87298,87299,87300,87301,87302,87303,87304,87305,87306,87307,87308,87309,87310,87311,87312,87313,87314,87315,87316,87317,87318,87319,87320,87321,87322,87323,87324,87325,87326,87327,87328,87329,87330,87331,87332,87333,87334,87335,87336,87337,87338,87339,87340,87341,87342,87343,87344,87345,87346,87347,87348,87349,87350,87351,87352,87353,87354,87355,87356,87357,87358,87359,87360,87361,87362,87363,87364,87365,87366,87367,87368,87369,87370,87371,87372,87373,87374,87375,87376,87377,87378,87379,87380,87381,87382,87383,87384,87385,87386,87387,87388,87389,87390,87391,87392,87393,87394,87395,87396,87397,87398,87399,87400,87401,87402,87403,87404,87405,87406,87407,87408,87409,87410,87411,87412,87413,87414,87415,87416,87417,87418,87419,87420,87421,87422,87423,87424,87425,87426,87427,87428,87429,87430,87431,87432,87433,87434,87435,87436,87437,87438,87439,87440,87441,87442,87443,87444,87445,87446,87447,87448,87449,87450,87451,87452,87453,87454,87455,87456,87457,87458,87459,87460,87461,87462,87463,87464,87465,87466,87467,87468,87469,87470,87471,87472,87473,87474,87475,87476,87477,87478,87479,87480,87481,87482,87483,87484,87485,87486,87487,87488,87489,87521,87522,87525,87526,87527,87528,87529,87530,87531,87535,87536,87537,87538,87539,87540,87541,87544,87545,87546,87547,87548,87549,87550,87551,87552,87553,87554,87555,87556,87557,87558,87559,87560,87561,87562,87563,87564,87565,87566,87567,87568,87569,87570,87571,87572,87573,87574,87575,87576,87577,87578,87579,87580,87581,87582,87583,87584,87585,87586,87587,87588,87589,87590,87591,87592,87593,87594,87595,87596,87597,87598,87599,87600,87601,87602,87603,87604,87605,87606,87607,87608,87609,87610,87611,87612,87613,87614,87615,87616,87617,87618,87619,87620,87621,87622,87623,87624,87625,87626,87627,87628,87629,87630,87631,87632,87633,87634,87635,87636,87637,87638,87639,87640,87641,87642,87643,87644,87645,87646,87647,87648,87649,87650,87651,87652,87653,87654,87655,87656,87657,87658,87659,87660,87661,87662,87663,87664,87665,87666,87667,87668,87669,87670,87671,87672,87673,87674,87675,87676,87677,87678,87679,87691,87692,87693,87694,87695,87696,87697,87698,87699,87700,87701,87702,87703,87704,87705,87706,87707,87708,87709,87710,87711,87712,87713,87714,87715,87716,87717,87718,87719,87720,87721,87722,87723,87724,87725,87726,87727,87728,87729,87730,87731,87732,87733,87734,87735,87736,87737,87738,87739,87740,87741,87742,87743,87744,87745,87746,87747,87748,87749,87750,87751,87752,87753,87754,87755,87756,87757,87758,87759,87760,87761,87762,87763,87764,87765,87766,87767,87768,87769,87770,87771,87772,87773,87774,87775,87776,87777,87778,87779,87780,87781,87782,87783,87784,87785,87786,87787,87788,87789,87790,87791,87792,87793,87794,87795,87796,87797,87798,87799,87800,87801,87802,87803,87804,87805,87806,87807,87808,87809,87810,87811,87812,87813,87814,87815,87816,87817,87818,87819,87820,87821,87822,87823,87824,87825,87826,87827,87828,87829,87830,87831,87832,87833,87834,87835,87836,87837,87838,87839,87840,87841,87842,87843,87844,87845,87846,87847,87848,87849,87850,87851,87852,87853,87854,87855,87856,87857,87858,87859,87860,87861,87862,87863,87864,87865,87866,87867,87868,87869,87870,87871,87872,87873,87874,87875,87876,87877,87878,87883,87884,87885,87886,87887,87888,87889,87890,87891,87892,87893,87894,87895,87896,87897,87898,87899,87900,87901,87902,87903,87904,87905,87906,87907,87908,87909,87910,87911,87912,87913,87914,87915,87916,87917,87918,87919,87920,87921,87922,87923,87924,87925,87926,87927,87928,87929,87930,87931,87932,87933,87934,87935,87936,87937,87938,87939,87940,87941,87942,87943,87944,87945,87946,87947,87949,87950,87951,87952,87953,87954,87955,87956,87957,87958,87959,87960,87961,87962,87963,87964,87965,87966,87967,87968,87969,87970,87971,87972,87973,87974,87975,87976,87977,87978,87979,87980,87981,87985,87986,87987,87988,87989,87990,87991,87992,87993,87994,87995,87996,87997,87998,87999,88000,88001,88002,88003,88004,88005,88006,88007,88008,88009,88010,88011,88012,88013,88014,88015,88016,88017,88018,88019,88020,88021,88022,88023,88024,88025,88026,88027,88028,88029,88030,88031,88032,88033,88034,88035,88036,88037,88038,88039,88040,88041,88042,88043,88044,88045,88046,88047,88048,88049,88050,88051,88052,88053,88054,88055,88056,88057,88058,88059,88060,88061,88062,88063,88064,88065,88066,88067,88068,88069,88070,88071,88072,88073,88074,88075,88076,88077,88078,88079,88080,88081,88082,88083,88084,88085,88086,88087,88088,88089,88090,88091,88092,88093,88094,88095,88096,88097,88098,88099,88100,88101,88102,88103,88104,88105,88106,88107,88108,88109,88110,88111,88112,88113,88114,88115,88116,88117,88118,88119,88120,88121,88122,88123,88124,88125,88126,88127,88128,88129,88130,88131,88132,88133,88134,88135,88136,88137,88138,88139,88140,88141,88142,88170,88171,88172,88173,88174,88175,88176,88177,88178,88179,88180,88181,88182,88183,88184,88185,88186,88187,88188,88189,88190,88192,88193,88194,88195,88196,88197,88198,88199,88200,88201,88202,88203,88204,88205,88206,88207,88208,88209,88210,88220,88221,88222,88223,88224,88225,88226,88227,88228,88229,88230,88231,88232,88233,88234,88235,88236,88237,88238,88239,88240,88241,88242,88243,88244,88245,88246,88247,88249,88250,88251,88253,88254,88259,88260,88261,88262,88263,88264,88265,88266,88267,88268,88269,88270,88271,88272,88273,88274,88275,88276,88278,88279,88280,88281,88282,88283,88284,88285,88286,88288,88293,88296,88297,88298,88299,88300,88301,88302,88303,88304,88305,88306,88307,88308,88309,88310,88311,88312,88313,88314,88315,88316,88317,88318,88319,88320,88321,88851,88852,88853,88854,88855,88856,88857,88858,88859,88860,88861,88862,88863,88864,88865,89082,89083,89084,89085,89086,89087,89088,89089,89090,89091,89092,89093,89094,89095,89096,89100,89101,89102,89103,89104,89105,89106,89107,89108,89109,89110,89111,89112,89113,89114,89115,89116,89117,89118,89119,89120,89121,89122,89123,89124,89125,89126,89127,89128,89129,89130,89131,89132,89133,89134,89135,89329,89330,89331,89332,89333,89334,89335,89336,89337,89338,89339,89340,89342,89343,89344,89346,89347,89348,89351,89352,89353,89354,89355,89356,89357,89358,89359,89360,89361,89362,89363,89364,89365,89386,89387,89394,89395,89396,89397,89398,89403,89404,89405,89406,89408,89409,89422,89423,89453,89455,89456,89475,89476,89477,89478,89479,89480,89481,89482,89501,89512,89513,89516,90218,90219,90220,90223,90224,90225,90227,90228,90229,90230,90231,90232,90234,90236,90239,90242,90244,90245,90246,90247,90248,90249,90250,90251,90252,90253,90254,90255,90256,90257,90258,90259,90262,90263,90275,90282,90283,90284,90285,90286,90287,90288,90289,90290,90291,90292,90293,90294,90295,90296,90297,90298,90299,90300,90301,90302,90303,90304,90305,90306,90307,90308,90309,90310,90311,90312,90313,90314,90315,90316,90317,90318,90319,90320,90321,90322,90323,90324,90325,90326,90327,90328,90329,90330,90331,90332,90333,90334,90335,90336,90337,90359,90360,90361,90362,90365,90371,90374,90375,90376,90377,90378,90379,90380,90381,90382,90383,90384,90387,90388,90389,90390,90392,90393,90394,90395,90397,90398,90401,90402,90403,90404,90405,90406,90407,90408,90410,90411,90412,90413,90414,90418,90419,90421,90422,90423,90424,90425,90426,90427,90428,90429,90430,90431,90432,90433,90434,90435,90436,90437,90438,90439,90440,90441,90442,90443,90444,90445,90446,90448,90449,90450,90451,90452,90453,90454,90455,90456,90457,90458,90459,90460,90461,90462,90463,90464,90465,90466,90467,90468,90472,90473,90474,90475,90476,90477,90478,90479,90480,90481,90482,90483,90484,90485,90486,90487,90488,90489,90490,90491,90492,91082,91083,91084,91085,91086,91087,91088,91106,91107,91108,91109,91110,91111,91117,91118,91119,91121,91156,91157,91158,91159,91160,91161,91162,91163,91164,91165,91819,91833,91834,91932,91934,91937,91943,91955,92015,92016,92017,92018,92023,92041,92042,92045,92046,92048,92050,92067,92075,92076,92083,92084,92085,92087,92089,92090,92091,92092,92093,92094,92095,92096,92097,92098,92099,92100,92101,92102,92103,92104,92105,92106,92107,92108,92109,92110,92111,92112,92113,92114,92115,92118,92119,92127,92128,92129,92130,92131,92132,92133,92134,92135,92136,92137,92138,92139,92140,92142,92143,92144,92145,92146,92147,92148,92149,92150,92151,92152,92153,92154,92155,92156,92208,92227,92228,92229,92230,92236,92237,92238,92239,92240,92241,92242,92243,92244,92245,92246,92253,92254,92255,92256,92257,92258,92259,92260,92261,92262,92263,92264,92265,92266,92267,92268,92269,92270,92271,92272,92273,92279,92280,92808,92811,92824,92825,92826,92829,92837,92838,92839,92867,92868,92869,92876,92936,92938,92939,92940,92941,92942,92943,92951,92952,92961,92962,92973,92974,92987,92998,92999,93000,93001,93002,93003,93004,93006,93007,93008,93009,93010,93031,93032,93051,93052,93054,93055,93056,93057,93058,93059,93060,93061,93101,93102,93121,93122,93123,93124,93125,93126,93127,93128,93129,93130,93133,93134,93136,93137,93138,93141,93144,93145,93146,93147,93152,93153,93154,93174,93175,93176,93276,93277,93278,93336,93337,93339,93340,93343,93344,93345,93346,93359,93448,93449,93450,93451,93452,93453,93454,93455,93456,93457,93458,93459,93460,93461,93462,93463,93464,93465,93466,93467,93468,93469,93470,93471,93546,93547,93548,93549,93576,93581,93582,93585,93589,93615,93616,93618,93619,93620,93621,93627,93629,93630,93631,93634,93635,93636,93637,93725,93727,93728,93729,93730,93731,93732,93733,93734,93745,93746,93747,93748,93749,93751,93752,93753,93754,93755,93756,93757,93758,93759,93760,93761,93762,93763,93764,93767,93770,93771,93772,93773,93774,93775,93784,93785,93786,93804,93805,93806,93807,93808,93809,93810,93811,93812,93813,93814,94168,94169,94170,94171,94172,94173,94174,94175,94180,94341,94342,94343,94344,94345,94346,94347,94348,94349,94350,94351,94368,94369,94370,94371,94372,94373,94374,94375,94376,94377,94407,94409,94410,94411,94412,94413,94414,94415,94423,94424,94425,94426,94427,94428,94429,94430,94431,94437,94438,94439,94440,94441,94442,94443,94444,94445,94446,94447,94448,94449,94450,94451,94452,94453,94454,94455,94456,94457,94458,94459,94460,94461,94462,94463,94464,94465,94466,94467,94468,94469,94470,94471,94472,94473,94474,94475,94476,94477,94478,94479,94480,94481,94482,94483,94484,94485,94486,94487,94488,94489,94490,94491,94492,94493,94494,94495,94496,94497,94498,94499,94500,94501,94502,94503,94504,94505,94506,94953,94954,94955,94956,94957,94958,94959,94960,94961,94962,94963,94964,94965,94966,94967,94983,94986,94987,94988,94989,94990,94991,94992,94993,94994,95002,95003,95004,95005,95006,95007,95008,95009,95010,95011,95012,95013,95014,95015,95016,95017,95018,95021,95023,95024,95025,95026,95027,95028,95029,95043,95044,95045,95046,95047,95048,95058,95059,95060,95061,95062,95063,95064,95065,95066,95069,95078,95079,95080,95081,95082,95083,95095,95107,95108,95109,95110,95111,95112,95113,95114,95115,95116,95117,95136,95137,95138,95139,95140,95141,95142,95143,95144,95145,95146,95147,95148,95149,95150,95324,95325,95326,95327,95328,95329,95330,95331,95332,95333,95334,95335,95336,95337,95338,95339,95340,95341,95342,95343,95344,95345,95346,95347,95348,95349,95355,95356,95357,95358,95359,95360,95361,95362,95363,95364,95365,95366,95367,95368,95369,95370,95371,95387,95388,95389,95390,95391,95392,95746,95747,95748,95750,95751,95752,95753,95754,95755,95756,95757,95758,95759,95760,95761,95762,95763,95764,95765,95766,95789,95790,95791,95792,95793,95796,95797,95798,95800}'::integer[]))
  • Heap Fetches: 218
Planning time : 6.146 ms
Execution time : 9,848.281 ms