explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IsT6 : Optimization for: plan #QiS5

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 9.050 26,323.326 ↓ 5,801.0 5,801 1

Nested Loop Left Join (cost=471,332.85..471,483.23 rows=1 width=80) (actual time=25,088.905..26,323.326 rows=5,801 loops=1)

2.          

CTE animais

3. 32.704 18,160.699 ↑ 1.0 5,801 1

GroupAggregate (cost=467,908.19..468,136.60 rows=5,801 width=12) (actual time=18,087.173..18,160.699 rows=5,801 loops=1)

  • Group Key: a_1.id
4. 159.871 18,127.995 ↓ 9.1 207,615 1

Sort (cost=467,908.19..467,964.99 rows=22,720 width=12) (actual time=18,087.132..18,127.995 rows=207,615 loops=1)

  • Sort Key: a_1.id
  • Sort Method: external merge Disk: 4,488kB
5. 2,841.579 17,968.124 ↓ 9.1 207,615 1

Hash Join (cost=41,313.98..466,264.20 rows=22,720 width=12) (actual time=2,754.999..17,968.124 rows=207,615 loops=1)

  • Hash Cond: (pm.animal_id = a_1.id)
6. 15,108.647 15,108.647 ↑ 1.0 12,432,673 1

Seq Scan on mbw_pesagem_medicao pm (cost=0.00..392,313.23 rows=12,433,123 width=8) (actual time=1.527..15,108.647 rows=12,432,673 loops=1)

7. 1.235 17.898 ↑ 1.0 5,801 1

Hash (cost=41,241.47..41,241.47 rows=5,801 width=8) (actual time=17.898..17.898 rows=5,801 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 291kB
8. 16.663 16.663 ↑ 1.0 5,801 1

Index Scan using mbw_animal_pkey on mbw_animal a_1 (cost=0.43..41,241.47 rows=5,801 width=8) (actual time=1.702..16.663 rows=5,801 loops=1)

  • Index Cond: (id = ANY ('{12658945,12659263,12659345,12659406,12659494,12659555,12659653,12660334,12661714,12661889,12662046,12662450,12662977,12662978,12663074,12663147,12663254,12663484,12663507,12663511,12663763,12663839,12664223,12664248,12664341,12664552,12664567,12664659,12664695,12664753,12664787,12664992,12665131,12665279,12665440,12665473,12665766,12665771,12665846,12665895,12665953,12666275,12666282,12666330,12666695,12666875,12666917,12666936,12667238,12667321,12667348,12667386,12667469,12667489,12667589,12667599,12667604,12667638,12667682,12667933,12667959,12668069,12668221,12668324,12668330,12668360,12668489,12668519,12668671,12668692,12668811,12668901,12668940,12669367,12669441,12669560,12669631,12669715,12669781,12670404,12670616,12670800,12670938,12671137,12671295,12671791,12672133,12672164,12672188,12672189,12672319,12672393,12672502,12672543,12672672,12672777,12672788,12672931,12672938,12672980,12672995,12673520,12673736,12679016,12679109,12679140,12679170,12679374,12679618,12679633,12679814,12680111,12680570,12680988,12681134,12681555,12681557,12681573,12681683,12681979,12682092,12682164,12682192,12682222,12682359,12682372,12682393,12682394,12682430,12682432,12682459,12682512,12682525,12682526,12682568,12682843,12682910,12682942,12683173,12683759,12683869,12683893,12683901,12683942,12684000,12684053,12684136,12684262,12684331,12684697,12684711,12685341,12685375,12685819,12685850,12685916,12686008,12686213,12686278,12686324,12686407,12686673,12686678,12686679,12686773,12686777,12686814,12686824,12687516,12687698,12687739,12687766,12687804,12687880,12687893,12687900,12687927,12688063,12688103,12688107,12688169,12688181,12688239,12688245,12688252,12688371,12688462,12688674,12688742,12688916,12689158,12689306,12689404,12689476,12689537,12689628,12689752,12689786,12689805,12689895,12690018,12690145,12690266,12690492,12690582,12690728,12690815,12690867,12690916,12691049,12691087,12691088,12691451,12691468,12691603,12691772,12692041,12692065,12692445,12692586,12692770,12693182,12693242,12693399,12693461,12693549,12693764,12693907,12693916,12693942,12693999,12694010,12694016,12694061,12694099,12694103,12694137,12694153,12694160,12694222,12694528,12694552,12694648,12694652,12694676,12694679,12694683,12694691,12694693,12694698,12694702,12694711,12694715,12694729,12694747,12694757,12694773,12694780,12694797,12694800,12694802,12694891,12694983,12694985,12694987,12694990,12694991,12695021,12695102,12695114,12695117,12695121,12695141,12695147,12695153,12695162,12695170,12695175,12695236,12695243,12695256,12695257,12695385,12695399,12695506,12695508,12695528,12695530,12695542,12695560,12695648,12695764,12695766,12695774,12695782,12695784,12695796,12695804,12695810,12695818,12695838,12695843,12695846,12695971,12695974,12695976,12695980,12696014,12696017,12696019,12696022,12696078,12696094,12696097,12696099,12696214,12696246,12696294,12696302,12696306,12696319,12696420,12696447,12697048,12697107,12697123,12697209,12697217,12697219,12697222,12697246,12697424,12697425,12697440,12697444,12697491,12697557,12697561,12697589,12697672,12697680,12697728,12697735,12697741,12697756,12697757,12697782,12697810,12698265,12698272,12698284,12698332,12698334,12698342,12698416,12698431,12698444,12698501,12698505,12698508,12698512,12698559,12698635,12698846,12698853,12698859,12698992,12699012,12699022,12699025,12699031,12699032,12699033,12699040,12699078,12699079,12699081,12699084,12699093,12699111,12699120,12699214,12699224,12699302,12699314,12699335,12699339,12699469,12699470,12699480,12699501,12699511,12699528,12699542,12699544,12699550,12699557,12699650,12699770,12699771,12699813,12699825,12699879,12699882,12699886,12706978,12707598,12707696,12707740,12707798,12707825,12707865,12707867,12707870,12707926,12707938,12707981,12707986,12708040,12708135,12708152,12708244,12708275,12708305,12709465,12709468,12709609,12709623,12709708,12709780,12709794,12709796,12709916,12709999,12710000,12710015,12710021,12710028,12710032,12710033,12710035,12710231,12710235,12710295,12710473,12710481,12710493,12710505,12710735,12710787,12710792,12710892,12710908,12710917,12710999,12711096,12711259,12711307,12711314,12711316,12711498,12711831,12711931,12712009,12712214,12712222,12712249,12712317,12712328,12712339,12712376,12712383,12712559,12712605,12712779,12712862,12712899,12712912,12712968,12713005,12713035,12713186,12713187,12713290,12713296,12713314,12713315,12713384,12713390,12713435,12713494,12713625,12713687,12713702,12713726,12713808,12713826,12713836,12713966,12713985,12714007,12714009,12714029,12714136,12714145,12714179,12714248,12714252,12714315,12714317,12714419,12714523,12714557,12714591,12714674,12714713,12715088,12715108,12715110,12718103,12718534,12718567,12719023,12719147,12719148,12719151,12719228,12719466,12719470,12719527,12719531,12719533,12719539,12719541,12719547,12719563,12719574,12719739,12719740,12719741,12719745,12719773,12719784,12719787,12719790,12719793,12719798,12719801,12719811,12720055,12720095,12720098,12720107,12720108,12720112,12720114,12720119,12720182,12720194,12720586,12720595,12720605,12721263,12721643,12721644,12721715,12721884,12721893,12721907,12721942,12721950,12722107,12722119,12722123,12722125,12722174,12722179,12722180,12722185,12722186,12722193,12722195,12722197,12722201,12722220,12722222,12722229,12722233,12722235,12722237,12722241,12722244,12722249,12722250,12722257,12722261,12722265,12722266,12722273,12722275,12722570,12722571,12722572,12722575,12722804,12722806,12722811,12722845,12722846,12722853,12722856,12722859,12722863,12722864,12722866,12722867,12722886,12722893,12722895,12722897,12722899,12722978,12722987,12723105,12723140,12723141,12723157,12723562,12723566,12723567,12723572,12723580,12723644,12723669,12723686,12723716,12723774,12723782,12724182,12724192,12724193,12724194,12724265,12724268,12724274,12724275,12724280,12724282,12724292,12724293,12724294,12724305,12724466,12724476,12724489,12724531,12724534,12724535,12724539,12724541,12724580,12724592,12724600,12724730,12724773,12724784,12724785,12724787,12724788,12724792,12724798,12724805,12724806,12724847,12724871,12724936,12724939,12724950,12724958,12724962,12725102,12725114,12725175,12725273,12725276,12725296,12725297,12725306,12725348,12725466,12725474,12725475,12725485,12725488,12725549,12725570,12725571,12725574,12725577,12725581,12732561,12732568,12732571,12732572,12732625,12732629,12732663,12732664,12732676,12732791,12732793,12732872,12732874,12733036,12733142,12733144,12733153,12733387,12733446,12733476,12733478,12733507,12733509,12733531,12734053,12734185,12734187,12734211,12734215,12734262,12734273,12734354,12734390,12734423,12734426,12734427,12734434,12734440,12734448,12734476,12734750,12734752,12734755,12734773,12734774,12734782,12734783,12734788,12734790,12734801,12735138,12737724,12737729,12738297,12738305,12738307,12738308,12738319,12658533,12659518,12659524,12659563,12659977,12660340,12660716,12661465,12661890,12662169,12662265,12662280,12662638,12662990,12663044,12663068,12663069,12663099,12663101,12663158,12663571,12663623,12663787,12664138,12664367,12664637,12664726,12664745,12664757,12664758,12664776,12664794,12664831,12664893,12664911,12664935,12664959,12665252,12665257,12665266,12665333,12665349,12665374,12665945,12665981,12666175,12666234,12666286,12666300,12666737,12666783,12666800,12666882,12666885,12666922,12667255,12667310,12667537,12667550,12667826,12667880,12667983,12668208,12668229,12668404,12668420,12668707,12668828,12668842,12668872,12668894,12668985,12668986,12668998,12669008,12669065,12669121,12669219,12669483,12669559,12669695,12670079,12670155,12670467,12670898,12671064,12671192,12671235,12671239,12671259,12671352,12671366,12671494,12671565,12671611,12671896,12671940,12672155,12672193,12672206,12672511,12672591,12672683,12672707,12672733,12672740,12672754,12672786,12672951,12673001,12673016,12673018,12673109,12673777,12676104,12679238,12679281,12679367,12679526,12679573,12679660,12680264,12680372,12680582,12680790,12681127,12681152,12681206,12681315,12681389,12681396,12681426,12681437,12681684,12682022,12682023,12682094,12682159,12682373,12682468,12682469,12682508,12682520,12682523,12682528,12682530,12682567,12682570,12682571,12683167,12683216,12683336,12683466,12683747,12683762,12683826,12683871,12683879,12683892,12684033,12684107,12684299,12684627,12684774,12684812,12684817,12684936,12685003,12685011,12685187,12685435,12685515,12685563,12685715,12685746,12685751,12685895,12686010,12686061,12686329,12686661,12686672,12686690,12686744,12686776,12686821,12686875,12687427,12687635,12687692,12687759,12687765,12687788,12687843,12687872,12687943,12687962,12687966,12688025,12688066,12688075,12688090,12688182,12688567,12688596,12688608,12688615,12688704,12688726,12688751,12689443,12689472,12689525,12689697,12689732,12689790,12689809,12689880,12689892,12689927,12689989,12690234,12690258,12690288,12690372,12690417,12690651,12690707,12690808,12690868,12690886,12691018,12691165,12691389,12691463,12691526,12692152,12692224,12692615,12692747,12692821,12693320,12693377,12693402,12693638,12693692,12693881,12693889,12693905,12694045,12694082,12694135,12694218,12694669,12694672,12694680,12694685,12694686,12694700,12694730,12694753,12694760,12694772,12694786,12694787,12694799,12695000,12695097,12695103,12695107,12695119,12695120,12695127,12695128,12695135,12695173,12695187,12695237,12695240,12695242,12695263,12695264,12695387,12695391,12695396,12695413,12695425,12695431,12695434,12695442,12695512,12695531,12695557,12695575,12695580,12695635,12695769,12695770,12695773,12695775,12695779,12695783,12695786,12695811,12695822,12695830,12695839,12695849,12695856,12695860,12695884,12695928,12695962,12695970,12695975,12696009,12696027,12696030,12696067,12696074,12696079,12696084,12696095,12696135,12696149,12696248,12696256,12696261,12696292,12696297,12696317,12696365,12696371,12696430,12696436,12696446,12697096,12697099,12697132,12697223,12697236,12697241,12697247,12697248,12697257,12697268,12697407,12697411,12697432,12697461,12697554,12697586,12697594,12697600,12697607,12697616,12697622,12697676,12697677,12697679,12697693,12697694,12697727,12697829,12698261,12698360,12698430,12698435,12698450,12698453,12698455,12698510,12698513,12698623,12698630,12698636,12698724,12698740,12698774,12698777,12698780,12698801,12698984,12699047,12699098,12699100,12699101,12699105,12699114,12699119,12699121,12699173,12699176,12699177,12699181,12699183,12699184,12699202,12699209,12699210,12699220,12699226,12699246,12699275,12699277,12699299,12699309,12699315,12699336,12699338,12699472,12699505,12699522,12699523,12699547,12699558,12699559,12699568,12699623,12699760,12699768,12699852,12699867,12699880,12707567,12707595,12707603,12707718,12707753,12707776,12707827,12707828,12707831,12707842,12707937,12707971,12708048,12708124,12708125,12708182,12708252,12708692,12709466,12709470,12709491,12709495,12709498,12709499,12709500,12709508,12709511,12709579,12709600,12709622,12709756,12709771,12709793,12709885,12709922,12709981,12709997,12710019,12710230,12710248,12710308,12710312,12710326,12710477,12710490,12710501,12710507,12710624,12710638,12710712,12710736,12710754,12710887,12710918,12710954,12711030,12711082,12711315,12711353,12711358,12711373,12711377,12711378,12711499,12711636,12711670,12711687,12711689,12711804,12711806,12711820,12711834,12711839,12711842,12711854,12711922,12711939,12712106,12712109,12712111,12712113,12712115,12712120,12712143,12712199,12712220,12712337,12712341,12712352,12712359,12712361,12712390,12712540,12712756,12712763,12712789,12712796,12712869,12712910,12712925,12712962,12712977,12713004,12713076,12713084,12713147,12713304,12713312,12713319,12713378,12713442,12713598,12713599,12713641,12713677,12713831,12713833,12713920,12713950,12714063,12714121,12714152,12714194,12714320,12714327,12714533,12714634,12714944,12714951,12714956,12715111,12715290,12715411,12718269,12718913,12719021,12719030,12719098,12719455,12719457,12719461,12719462,12719469,12719540,12719548,12719553,12719566,12719570,12719733,12719765,12719770,12719772,12719775,12719776,12719783,12719788,12719795,12719806,12719812,12719818,12719822,12720060,12720061,12720102,12720180,12720181,12720189,12720195,12720196,12720590,12720963,12721267,12721637,12721641,12721716,12721732,12722084,12722110,12722111,12722117,12722178,12722182,12722196,12722202,12722205,12722206,12722211,12722215,12722225,12722230,12722242,12722246,12722248,12722252,12722253,12722260,12722263,12722269,12722276,12722286,12722287,12722540,12722564,12722573,12722574,12722812,12722847,12722851,12722862,12722869,12722894,12722896,12722901,12723017,12723020,12723093,12723104,12723110,12723111,12723113,12723114,12723117,12723159,12723160,12723162,12723477,12723481,12723485,12723487,12723563,12723564,12723576,12723577,12723581,12723610,12723614,12723622,12723645,12723667,12723688,12723713,12723717,12724250,12724254,12724257,12724259,12724266,12724269,12724271,12724273,12724278,12724281,12724283,12724289,12724295,12724297,12724306,12724308,12724333,12724484,12724485,12724494,12724527,12724532,12724533,12724536,12724554,12724558,12724581,12724591,12724595,12724596,12724597,12724693,12724719,12724722,12724727,12724772,12724794,12724797,12724800,12724802,12724875,12724929,12724945,12724949,12724951,12724960,12725030,12725103,12725105,12725111,12725157,12725172,12725209,12725218,12725221,12725222,12725269,12725270,12725272,12725275,12725462,12725463,12725479,12725484,12725556,12725560,12725690,12730364,12732564,12732566,12732569,12732628,12732632,12732659,12732666,12732794,12733093,12733117,12733121,12733125,12733145,12733155,12733156,12733198,12733291,12733350,12733384,12733441,12733483,12733508,12733528,12733530,12733567,12733578,12734047,12734108,12734143,12734153,12734179,12734180,12734213,12734214,12734222,12734253,12734261,12734274,12734304,12734396,12734421,12734422,12734425,12734429,12734436,12734443,12734446,12734584,12734746,12734748,12734758,12734760,12734768,12734769,12734770,12734772,12734775,12734778,12734779,12734796,12735875,12737726,12738314,12659374,12659409,12659429,12659572,12659576,12660281,12660298,12660315,12660343,12660431,12660682,12661405,12661910,12662109,12662573,12662592,12662856,12662924,12663160,12663224,12663769,12664343,12664435,12664553,12664569,12665058,12665186,12665207,12665242,12665277,12665292,12665390,12665398,12665442,12665474,12665619,12665621,12665643,12665919,12666323,12666790,12666883,12666888,12666902,12666915,12667013,12667229,12667379,12667641,12667737,12668365,12668367,12668412,12668632,12668689,12668933,12669098,12669466,12669536,12669625,12669640,12669775,12670222,12670321,12670364,12670676,12670916,12670985,12670988,12671031,12671065,12671078,12671130,12671237,12671299,12671303,12671329,12671485,12671496,12672170,12672227,12672252,12672298,12672381,12672609,12672625,12672651,12672684,12673029,12673083,12673571,12673626,12678850,12679021,12679113,12679274,12679292,12679299,12679321,12679610,12679625,12679901,12680133,12680492,12680614,12680619,12680628,12680756,12680796,12681010,12681028,12681104,12681124,12681143,12681257,12681483,12681499,12681842,12681941,12682139,12682148,12682240,12682251,12682369,12682387,12682427,12682433,12682458,12682511,12682564,12682832,12683175,12683698,12683811,12683817,12683864,12683887,12683933,12683958,12684298,12684307,12684537,12684688,12684800,12684839,12684902,12685023,12685028,12685186,12685260,12685342,12685591,12685923,12686541,12686670,12686748,12686758,12686819,12686828,12687076,12687410,12687540,12687720,12687755,12687790,12687805,12687811,12687867,12687868,12687870,12687898,12687940,12687942,12688009,12688028,12688086,12688126,12688207,12688234,12688465,12688717,12688797,12688830,12689232,12689448,12689508,12689552,12689576,12689603,12689705,12689739,12689862,12689943,12689981,12690003,12690031,12690037,12690121,12690231,12690259,12690315,12690812,12690865,12691166,12691193,12691330,12691520,12691725,12692170,12692172,12692387,12692530,12692753,12692859,12692879,12693350,12693382,12693792,12693851,12693906,12693908,12693940,12693951,12693970,12693980,12693981,12693983,12694013,12694018,12694019,12694058,12694102,12694140,12694150,12694152,12694210,12694225,12694678,12694690,12694703,12694719,12694722,12694726,12694737,12694738,12694739,12694740,12694746,12694761,12694769,12694782,12694805,12694984,12694997,12695093,12695132,12695138,12695140,12695151,12695152,12695159,12695161,12695172,12695177,12695186,12695244,12695252,12695254,12695386,12695388,12695403,12695410,12695426,12695430,12695432,12695521,12695603,12695618,12695767,12695777,12695795,12695797,12695809,12695812,12695813,12695823,12695825,12695837,12695845,12695881,12695885,12695886,12695887,12695895,12695925,12695932,12695979,12695983,12696063,12696065,12696069,12696070,12696076,12696080,12696083,12696090,12696104,12696108,12696110,12696111,12696142,12696212,12696226,12696229,12696240,12696244,12696252,12696255,12696262,12696265,12696314,12696343,12696843,12697097,12697100,12697104,12697121,12697142,12697211,12697214,12697221,12697243,12697249,12697251,12697252,12697259,12697447,12697449,12697457,12697458,12697553,12697559,12697582,12697609,12697610,12697685,12697734,12697736,12697737,12697742,12697763,12698245,12698257,12698264,12698351,12698412,12698413,12698427,12698470,12698503,12698523,12698633,12698645,12698691,12698695,12698712,12698728,12698766,12698881,12698986,12698989,12699028,12699048,12699083,12699103,12699104,12699113,12699118,12699171,12699179,12699201,12699211,12699230,12699231,12699269,12699270,12699271,12699300,12699313,12699332,12699334,12699391,12699520,12699526,12699531,12699537,12699539,12699551,12699553,12699563,12699625,12699674,12699683,12699745,12699772,12699816,12699821,12699854,12699868,12699878,12707368,12707575,12707682,12707691,12707719,12707918,12707989,12708005,12708046,12708063,12708179,12708277,12708283,12708317,12708659,12708743,12709489,12709575,12709597,12709602,12709611,12709697,12709707,12709763,12709768,12709783,12709982,12710011,12710016,12710023,12710036,12710228,12710241,12710245,12710249,12710319,12710478,12710479,12710484,12710487,12710631,12710707,12710755,12710756,12710783,12711012,12711029,12711129,12711322,12711326,12711340,12711344,12711362,12711363,12711494,12711585,12711612,12711626,12711679,12711807,12711835,12711856,12711928,12712010,12712042,12712105,12712114,12712202,12712204,12712206,12712318,12712322,12712335,12712336,12712343,12712351,12712386,12712395,12712549,12712746,12712867,12712873,12712880,12712909,12712911,12713074,12713085,12713158,12713188,12713332,12713373,12713376,12713380,12713412,12713444,12713591,12713603,12713632,12713650,12713707,12713714,12713790,12713828,12713839,12713904,12713918,12713945,12713952,12713965,12713968,12713973,12714014,12714018,12714129,12714168,12714171,12714189,12714207,12714211,12714426,12714433,12714544,12714567,12714589,12714601,12714628,12714649,12714736,12714934,12714955,12714961,12714969,12715048,12715089,12715405,12718532,12718911,12719027,12719145,12719206,12719211,12719231,12719451,12719459,12719467,12719515,12719530,12719535,12719538,12719552,12719556,12719560,12719564,12719572,12719573,12719759,12719774,12719785,12719786,12719810,12719815,12719819,12719820,12719821,12720058,12720064,12720065,12720103,12720118,12720177,12720178,12720184,12720187,12720199,12720585,12720588,12720593,12720603,12720604,12721264,12721602,12721634,12721891,12721897,12721908,12721947,12722102,12722122,12722167,12722176,12722190,12722203,12722207,12722208,12722214,12722223,12722228,12722231,12722236,12722247,12722255,12722256,12722258,12722264,12722267,12722268,12722278,12722279,12722282,12722552,12722553,12722567,12722696,12722808,12722815,12722819,12722843,12722852,12722860,12722868,12722892,12722900,12723043,12723115,12723135,12723147,12723152,12723153,12723156,12723158,12723441,12723462,12723464,12723475,12723478,12723488,12723489,12723574,12723582,12723612,12723618,12723731,12724181,12724183,12724187,12724253,12724260,12724279,12724284,12724286,12724287,12724304,12724331,12724332,12724474,12724475,12724488,12724491,12724530,12724538,12724552,12724556,12724557,12724578,12724587,12724588,12724589,12724590,12724593,12724604,12724691,12724724,12724728,12724778,12724779,12724790,12724793,12724795,12724809,12724870,12724957,12724964,12725115,12725116,12725132,12725139,12725160,12725161,12725164,12725168,12725174,12725195,12725201,12725311,12725388,12725389,12725392,12725476,12725487,12725489,12725563,12725584,12725585,12725677,12725678,12726525,12732238,12732270,12732302,12732570,12732626,12732630,12732631,12732633,12732661,12732662,12732665,12733037,12733065,12733067,12733095,12733096,12733119,12733120,12733123,12733147,12733152,12733266,12733352,12733388,12733493,12734025,12734099,12734189,12734260,12734265,12734281,12734370,12734428,12734449,12734756,12734771,12734785,12734791,12734800,12735140,12735870,12735887,12737725,12738303,12658698,12658754,12658968,12658996,12659108,12659377,12659421,12659461,12659756,12660166,12660171,12660331,12661510,12661863,12662111,12662309,12662500,12662576,12662643,12662736,12662754,12662850,12663020,12663448,12663997,12664118,12664263,12664531,12664581,12664621,12665050,12665259,12665641,12665719,12665811,12665843,12665906,12665916,12665989,12666192,12666411,12666932,12667252,12667382,12667500,12667910,12668384,12668410,12668421,12668672,12668734,12668829,12668849,12668869,12668946,12668963,12668974,12669021,12669438,12669535,12669699,12669914,12670144,12670443,12670445,12670469,12670914,12671025,12671232,12671254,12671268,12671447,12671495,12671698,12672141,12672257,12672300,12672628,12672693,12672703,12672706,12672710,12672948,12673008,12673010,12673017,12673537,12673624,12673713,12679040,12679096,12679128,12679167,12679743,12679771,12679826,12680195,12680595,12680644,12680980,12680995,12681055,12681150,12681611,12681775,12681782,12682151,12682184,12682185,12682208,12682284,12682351,12682392,12682456,12682465,12682510,12682844,12682868,12683267,12683592,12683594,12683653,12683662,12683758,12683809,12683832,12683859,12683940,12683953,12684051,12684229,12684675,12684828,12684913,12685081,12685411,12685795,12685796,12685803,12685922,12686219,12686232,12686281,12686418,12686575,12686604,12686617,12686668,12686680,12686769,12686812,12686840,12687158,12687606,12687617,12688120,12688140,12688158,12688297,12688473,12688483,12688517,12688521,12688617,12688716,12688796,12688813,12689454,12689475,12689651,12689766,12689828,12689887,12689908,12690010,12690020,12690052,12690295,12690699,12690736,12690782,12690838,12691093,12691129,12691289,12691302,12691415,12691739,12692290,12692441,12692617,12692687,12692872,12693306,12693531,12693879,12693945,12693953,12693965,12693967,12693996,12693998,12694000,12694042,12694063,12694086,12694087,12694095,12694148,12694169,12694649,12694650,12694651,12694692,12694709,12694712,12694716,12694717,12694748,12694750,12694775,12695104,12695116,12695122,12695131,12695149,12695155,12695163,12695181,12695189,12695238,12695241,12695245,12695247,12695251,12695267,12695405,12695406,12695416,12695417,12695419,12695424,12695435,12695437,12695438,12695514,12695516,12695518,12695538,12695539,12695546,12695570,12695622,12695763,12695792,12695821,12695827,12695834,12695836,12695844,12695848,12695862,12695934,12695978,12696029,12696066,12696068,12696071,12696087,12696114,12696118,12696134,12696217,12696228,12696233,12696235,12696236,12696258,12696260,12696313,12696370,12696433,12696435,12696437,12697068,12697069,12697079,12697105,12697106,12697108,12697113,12697128,12697129,12697146,12697212,12697216,12697231,12697234,12697263,12697269,12697412,12697420,12697426,12697428,12697429,12697442,12697451,12697469,12697473,12697478,12697484,12697492,12697593,12697604,12697608,12697674,12697688,12697690,12697740,12697764,12697790,12697797,12697826,12697828,12698258,12698259,12698337,12698409,12698414,12698429,12698452,12698460,12698461,12698773,12698821,12698831,12698838,12698851,12698867,12698885,12698978,12699002,12699036,12699071,12699088,12699089,12699092,12699107,12699108,12699116,12699195,12699207,12699298,12699307,12699458,12699490,12699499,12699534,12699538,12699541,12699545,12699546,12699640,12699657,12699665,12699767,12699818,12699851,12699874,12699885,12703544,12707572,12707582,12707610,12707819,12707839,12707939,12707947,12708033,12708059,12708123,12708130,12708701,12708738,12709464,12709492,12709497,12709618,12709619,12709694,12709704,12709936,12709943,12709996,12710004,12710010,12710030,12710238,12710297,12710300,12710320,12710491,12710595,12710720,12710789,12710894,12710900,12710907,12710914,12711009,12711084,12711090,12711111,12711239,12711359,12711361,12711368,12711374,12711501,12711513,12711569,12711570,12711584,12711625,12711672,12711685,12711690,12711828,12711923,12711930,12712005,12712038,12712044,12712207,12712209,12712259,12712265,12712363,12712377,12712423,12712514,12712521,12712539,12712753,12712783,12712785,12712787,12712790,12712800,12712868,12712971,12713002,12713078,12713089,12713283,12713313,12713323,12713371,12713406,12713422,12713600,12713656,12713686,12713692,12713699,12713717,12713758,12713766,12713771,12713774,12713851,12713928,12714110,12714169,12714175,12714209,12714228,12714235,12714243,12714314,12714363,12714383,12714441,12714460,12714565,12714629,12714639,12714693,12714723,12714947,12714984,12715053,12715109,12718909,12719024,12719144,12719150,12719152,12719153,12719204,12719207,12719464,12719512,12719521,12719522,12719534,12719543,12719544,12719545,12719546,12719549,12719554,12719571,12719575,12719686,12719731,12719743,12719744,12719767,12719771,12719789,12719813,12719814,12719817,12720057,12720096,12720101,12720104,12720110,12720111,12720185,12720197,12720198,12720581,12720582,12720589,12720592,12720964,12721609,12721629,12721631,12721633,12721640,12721642,12721894,12721896,12722105,12722168,12722192,12722199,12722200,12722210,12722212,12722216,12722218,12722226,12722234,12722238,12722239,12722240,12722251,12722254,12722262,12722281,12722566,12722568,12722569,12722799,12722809,12722818,12722828,12722844,12722857,12722858,12722870,12722871,12722888,12722889,12722891,12723106,12723116,12723138,12723155,12723473,12723474,12723486,12723561,12723583,12723620,12723623,12723624,12723655,12723683,12723685,12723700,12723707,12723715,12723726,12724184,12724185,12724186,12724252,12724255,12724267,12724272,12724291,12724296,12724298,12724300,12724301,12724302,12724309,12724467,12724471,12724472,12724483,12724486,12724487,12724495,12724529,12724551,12724553,12724559,12724579,12724582,12724583,12724586,12724598,12724605,12724720,12724721,12724776,12724783,12724786,12724789,12724791,12724799,12724801,12724803,12724807,12724872,12724873,12724937,12724946,12724948,12724961,12724963,12724965,12725022,12725100,12725108,12725134,12725138,12725140,12725144,12725156,12725171,12725173,12725197,12725210,12725211,12725213,12725214,12725268,12725277,12725280,12725281,12725299,12725307,12725324,12725338,12725343,12725344,12725390,12725391,12725591,12725679,12725681,12732232,12732559,12732560,12732562,12732565,12732573,12732624,12732627,12732660,12732668,12732773,12732792,12732825,12732873,12733092,12733094,12733124,12733148,12733149,12733150,12733151,12733265,12733379,12733390,12733456,12733473,12733484,12733494,12733497,12733519,12733529,12734003,12734184,12734263,12734351,12734353,12734380,12734394,12734413,12734420,12734430,12734438,12734447,12734585,12734588,12734593,12734757,12734759,12734767,12734781,12734784,12734799,12734802,12735885,12737249,12737728,12737730,12738293,12738298,12738321,12738423,12739551,12736857,12740850,12740397,12739495,12737490,12737398,12740102,12738403,12739005,12734973,12737587,12735125,12737495,12735391,12735517,12738228,12737648,12735453,12739360,12741017,12736752,12737898,12737334,12737296,12737077,12734612,12738351,12736600,12740678,12737674,12740656,12738355,12735982,12739577,12735632,12740549,12740761,12740657,12735838,12736707,12740276,12736266,12736713,12737675,12740139,12737821,12737431,12740360,12739090,12735713,12739409,12739357,12735772,12736664,12735333,12734824,12735018,12739625,12740742,12733964,12738825,12738982,12736534,12735583,12736044,12735238,12740596,12737637,12734828,12736981,12736197,12736831,12738507,12737186,12735827,12739868,12736651,12735770,12740863,12735644,12737837,12741165,12740797,12734652,12739856,12734705,12734821,12735719,12737475,12734635,12738111,12738880,12739740,12738823,12737971,12737569,12735928,12737199,12735132,12735073,12736189,12737710,12737762,12738717,12735436,12740870,12738753,12735943,12739660,12738001,12736633,12735076,12734937,12740342,12735991,12736176,12740101,12737298,12736498,12736495,12738808,12739157,12734948,12738006,12737653,12737551,12737894,12735919,12737915,12737281,12738864,12737078,12739169,12735416,12734572,12735543,12739678,12740467,12736658,12739883,12738737,12740700,12738122,12737750,12737089,12738921,12735649,12739128,12738501,12735541,12735107,12736207,12740617,12739002,12739025,12738374,12736124,12740138,12737806,12739473,12738384,12735828,12738817,12740198,12740568,12739634,12734636,12735637,12735640,12736040,12734842,12737209,12739379,12739437,12739158,12740231,12738659,12741205,12735792,12740338,12734642,12741044,12739384,12739263,12735379,12737550,12740113,12735072,12735709,12736623,12738920,12735895,12740639,12735075,12737226,12735460,12737677,12741244,12737494,12739453,12737101,12741004,12740310,12737299,12737968,12735716,12737115,12736412,12737588,12739173,12740667,12735445,12735261,12741014,12737038,12737903,12740874,12735930,12739591,12740585,12735279,12740047,12738630,12737521,12740267,12735160,12735440,12735017,12734870,12734984,12735921,12737402,12735320,12736714,12737256,12741001,12741002,12738252,12738258,12736883,12739259,12738537,12739414,12734844,12737718,12734658,12737223,12737869,12736374,12740073,12735046,12739776,12738610,12737940,12736170,12736489,12736835,12737647,12738656,12734966,12739862,12737149,12735477,12737039,12737552,12735323,12740563,12741007,12740699,12738050,12740807,12737001,12740473,12738667,12735756,12740088,12737313,12740912,12739213,12736538,12740277,12734700,12739549,12739724,12734607,12737747,12740384,12739996,12740411,12735923,12737850,12734935,12738049,12735993,12735050,12738867,12739770,12735774,12741266,12736885,12739844,12740035,12738919,12737340,12735786,12736796,12740593,12735983,12740148,12735173,12737763,12738523,12738715,12739831,12736804,12737838,12735472,12739211,12738918,12738755,12736672,12736992,12738353,12738519,12735250,12735174,12741204,12737810,12735697,12737426,12739613,12736459,12735535,12738868,12741221,12734947,12735041,12740302,12738280,12739743,12734979,12736719,12738504,12738407,12737047,12735546,12738756,12741238,12735534,12737176,12740313,12738434,12739475,12735701,12734920,12737202,12735315,12738618,12739176,12736278,12739032,12737300,12738646,12737906,12739314,12734918,12740792,12736461,12737941,12734616,12740551,12737936,12741011,12734674,12738623,12737480,12736841,12740114,12736390,12738084,12736436,12735012,12739730,12740982,12737371,12735314,12739850,12737424,12737851,12737560,12737034,12736920,12740577,12734974,12739875,12736758,12740312,12735382,12741268,12741168,12741217,12737760,12736392,12735966,12737991,12739732,12735004,12740329,12740264,12736629,12736558,12734934,12739171,12735432,12736604,12736610,12734610,12739765,12735122,12740259,12738225,12736647,12739026,12725393,12738902,12735454,12739747,12736854,12735987,12735506,12736998,12736370,12739110,12737635,12738547,12740683,12740481,12738260,12737893,12740059,12737087,12736553,12734946,12734740,12738282,12740100,12735319,12735638,12738455,12738232,12738913,12737688,12736985,12741022,12740160,12737542,12737396,12734831,12739761,12739150,12736433,12736181,12734877,12737897,12737012,12735176,12740386,12734835,12739266,12735461,12737854,12739711,12740934,12737932,12738879,12741250,12734880,12740112,12738622,12734728,12735349,12738558,12738401,12737035,12736289,12737201,12737332,12739007,12736183,12739569,12737744,12740835,12737740,12738254,12734907,12740298,12736546,12737561,12740071,12736462,12741308,12736309,12738714,12726512,12736225,12740323,12740778,12737196,12738926,12737563,12740140,12741197,12735866,12737225,12735109,12737920,12738354,12735863,12738922,12740033,12739474,12736661,12736194,12736655,12737608,12741091,12740343,12736173,12734936,12738736,12740398,12739698,12735854,12739380,12740133,12738875,12737628,12735178,12735501,12739153,12737922,12737076,12737924,12735408,12735439,12740921,12737400,12737905,12736549,12737655,12734083,12737836,12740268,12735336,12737075,12735502,12735926,12736716,12739661,12738188,12738184,12739799,12738108,12738865,12738234,12737479,12735258,12737820,12741083,12740777,12739735,12740594,12741245,12734697,12739252,12739679,12735700,12740689,12738261,12738047,12739330,12739197,12735965,12735761,12735610,12735067,12736030,12740581,12734921,12736295,12736878,12736948,12739617,12739196,12735325,12737967,12736121,12739757,12734885,12735069,12736115,12741289,12738262,12737008,12738745,12738802,12738758,12738862,12737773,12740904,12740425,12740605,12740627,12738483,12733066,12736757,12736168,12739710,12736659,12740458,12738359,12736699,12736487,12738516,12735462,12737847,12737938,12737040,12739795,12736304,12736119,12736840,12738650,12737370,12739270,12737589,12736706,12736431,12734628,12737044,12736234,12739481,12736944,12738367,12735269,12740265,12739151,12738752,12736306,12738647,12735443,12737385,12737074,12738912,12739709,12735648,12739294,12738872,12737676,12739250,12739164,12734990,12738211,12735691,12739857,12737852,12735071,12737708,12735545,12737501,12736916,12738869,12741435,12740151,12737177,12736460,12735240,12739006,12739773,12734515,12735833,12735121,12740158,12740141,12739739,12734938,12737261,12737230,12734668,12738492,12735763,12738816,12738458,12738665,12735378,12737781,12735377,12740314,12740232,12739756,12738570,12735123,12736710,12738571,12736554,12738112,12737896,12737258,12736674,12736486,12739355,12740244,12735328,12736947,12737719,12736110,12739845,12735338,12735582,12740780,12740470,12737541,12737907,12735860,12736235,12737909,12737106,12737318,12736919,12738119,12738541,12736276,12735344,12736237,12740692,12739309,12736286,12735131,12739185,12740096,12735313,12728744,12738083,12736980,12741360,12739359,12735712,12738605,12740856,12738976,12735931,12734945,12741173,12739696,12739572,12738908,12739550,12738985,12739155,12737846,12739385,12735776,12734620,12740963,12738901,12741152,12738490,12737711,12736708,12735043,12736701,12740758,12736621,12740632,12738368,12740746,12737969,12735793,12736879,12737255,12738672,12737111,12734836,12735446,12737779,12734160,12741008,12734629,12736192,12739995,12734827,12738972,12740049,12741058,12735704,12734874,12740155,12734991,12740408,12739214,12735635,12740578,12740924,12737705,12739166,12737271,12738655,12740116,12736188,12737433,12739142,12739712,12736551,12737086,12734655,12735620,12738081,12740146,12736019,12735990,12737775,12741089,12740867,12738669,12736294,12737641,12735785,12740887,12739152,12740432,12736921,12740396,12737126,12735911,12737817,12735452,12738185,12734916,12734557,12735711,12739244,12740622,12737343,12740682,12740687,12737823,12739331,12740633,12738818,12734908,12735633,12739256,12735699,12740061,12738183,12739494,12740712,12735973,12740269,12740142,12739096,12739444,12738561,12740540,12740150,12738433,12741192,12735645,12740006,12740965,12741248,12738911,12735853,12738259,12741072,12738489,12735692,12740233,12738545,12736270,12738774,12736544,12736607,12739676,12735642,12740011,12740745,12737564,12737321,12738754,12734639,12736624,12738670,12735389,12734809,12738226,12740472,12737812,12738436,12737505,12735508,12740468,12737834,12740487,12740103,12741251,12738430,12737399,12736849,12735618,12738104,12739570,12740907,12738043,12740147,12732577,12734847,12735064,12735769,12736863,12738645,12741269,12737519,12734952,12737378,12734875,12735376,12735933,12739433,12734904,12740272,12740925,12741086,12737624,12724853,12736855,12737465,12735395,12737657,12738824,12734696,12739043,12738386,12734884,12735646,12740482,12736415,12739048,12736536,12737259,12738649,12736552,12740688,12735247,12737539,12737333,12738931,12734621,12738624,12738543,12739053,12739290,12737204,12740527,12737476,12739318,12737571,12737950,12736414,12734633,12736799,12741048,12737636,12740157,12740465,12736499,12736756,12740665,12736670,12740838,12738660,12738493,12737749,12741162,12737807,12740258,12738961,12739476,12738182,12737771,12739704,12739322,12738075,12738348,12737392,12736861,12738402,12740666,12735865,12738863,12735326,12740553,12735392,12738061,12736704,12741018,12735322,12735431,12736667,12735231,12740969,12736703,12735509,12734727,12735415,12738614,12740294,12737935,12736174,12739212,12739045,12741016,12737835,12736236,12740967,12736231,12740245,12735348,12736203,12739667,12735129,12739261,12739835,12736120,12739659,12738788,12736622,12734630,12735775,12737279,12739830,12734817,12736273,12737745,12735510,12736438,12735474,12739260,12738903,12737004,12737297,12740704,12740385,12735708,12735044,12738264,12740819,12739154,12736416,12736310,12737901,12739734,12737629,12738400,12737782,12736993,12735832,12737224,12740739,12736669,12738870,12740109,12739321,12735180,12735340,12740556,12739869,12737890,12740765,12740274,12735116,12739652,12738453,12735856,12736025,12740275,12740616,12735177,12738933,12736302,12740538,12736167,12735281,12738692,12740450,12738923,12736228,12740554,12740070,12736313,12737949,12734562,12736700,12735222,12739415,12739245,12737506,12736711,12736712,12735720,12739651,12737377,12737741,12739130,12739630,12737889,12739797,12738746,12740010,12737341,12739677,12738573,12737707,12734977,12735777,12737580,12737743,12740932,12737594,12741095,12734996,12736800,12739552,12738608,12736851,12739203,12739451,12737104,12735394,12735537,12740971,12735220,12740775,12739058,12735515,12741243,12734615,12739697,12740769,12740790,12738544,12739177,12737440,12736678,12735113,12736127,12740153,12736182,12735588,12738057,12734972,12740808,12735922,12740266,12735236,12736376,12735223,12737772,12737613,12738495,12736671,12738790,12736859,12738898,12734511,12736171,12740000,12734631,12735124,12734915,12736559,12740983,12737109,12739262,12740882,12739834,12734656,12737323,12734837,12735275,12739046,12738505,12738277,12740571,12738072,12738002,12738427,12734949,12740328,12735970,12739101,12736630,12739137,12734829,12737096,12740873,12734838,12735468,12740228,12735705,12740849,12737990,12738115,12739010,12736874,12736230,12740076,12740311,12734913,12739849,12736556,12736627,12737430,12735507,12737208,12734653,12737815,12740973,12736798,12736298,12737331,12738336,12737099,12738509,12737562,12739109,12736837,12735611,12736657,12738727,12737780,12736317,12739248,12740023,12736663,12734496,12739246,12735352,12735861,12740592,12734595,12741358,12735346,12736267,12741015,12736437,12741174,12740824,12736293,12739424,12740262,12740353,12738110,12740356,12738620,12734556,12738114,12737887,12741442,12740580,12740615,12736625,12740858,12739012,12738693,12735130,12738615,12735862,12740740,12739336,12739004,12735327,12740821,12738113,12737112,12734953,12740604,12738435,12740901,12739777,12736666,12737988,12736369,12735634,12736833,12736550,12740137,12740162,12738546,12740297,12736668,12739443,12736547,12740899,12737045,12735317,12736275,12739174,12741160,12740968,12737659,12736129,12737904,12740078,12738340,12735974,12736858,12735639,12738502,12741028,12735079,12740368,12739172,12737902,12737814,12735927,12734845,12735061,12738106,12735574,12736140,12739803,12738398,12739298,12739029,12734651,12737227,12739313,12735264,12734632,12738814,12741185,12740019,12737808,12737005,12738549,12739708,12736465,12734819,12736650,12737187,12736394,12741021,12737994,12734873,12741005,12736679,12740595,12734709,12737499,12738538,12737596,12741230,12739426,12738432,12737930,12739692,12740426,12739054,12739323,12734957,12738103,12739184,12740536,12736277,12735577,12739407,12737488,12738279,12737859,12737003,12737943,12739103,12739257,12736759,12735715,12739713,12736717,12738906,12736439,12735544,12738257,12738210,12739873,12737912,12738369,12735332,12735576,12740655,12737742,12740299,12734634,12739356,12734526,12738117,12739479,12736702,12739881,12740058,12736490,12737769,12734524,12736180,12737529,12740866,12735242,12735532,12734666,12734994,12738518,12741222,12738805,12736852,12740908,12740443,12734818,12739139,12735531,12738256,12736836,12737712,12740296,12736602,12736229,12740351,12736680,12736371,12735985,12740430,12740868,12739008,12737946,12735409,12737278,12738804,12737041,12740492,12740841,12734971,12740975,12739388,12731887,12740152,12739738,12739040,12737437,12740530,12741060,12738371,12738350,12740894,12735030,12736303,12740972,12740404,12740053,12737863,12736440,12740804,12737610,12738759,12736829,12735784,12737945,12735944,12735533,12740561,12740584,12737381,12738426,12737721,12740018,12735329,12741034,12734619,12738559,12735318,12738510,12736943,12741224,12739878,12735110,12740974,12740630,12737380,12740279,12739055,12737706,12741085,12740108,12739575,12734573,12736827,12736838,12735049,12738801,12738503,12740681,12739440,12738574,12735111,12735347,12740643,12737548,12737970,12734987,12739548,12737222,12741246,12734887,12740197,12741019,12738924,12735647,12735920,12736233,12737182,12740347,12737939,12738042,12739333,12738352,12734813,12734944,12739387,12736860,12737892,12737080,12739044,12734810,12739195,12738212,12740460,12734909,12740898,12739192,12740350,12738729,12737397,12738929,12741343,12737376,12740532,12740246,12736832,12732974,12737002,12739098,12736873,12738457,12739585,12737593,12736274,12737425,12737116,12740093,12738070,12736652,12737102,12734669,12735127,12734834,12740306,12738496,12738512,12735925,12735438,12738782,12741006,12739637,12736656,12738116,12735768,12735694,12740565,12737987,12735689,12735463,12737082,12740970,12734613,12734943,12735106,12736419,12738548,12741438,12738082,12740305,12740445,12739410,12741031,12737081,12735980,12741223,12735760,12728748,12741009,12738643,12738071,12736379,12736227,12738540,12738761,12740072,12738494,12736649,12738820,12735444,12735548,12735117,12736533,12736391,12738278,12734995,12738055,12741003,12737073,12739826,12739423,12738227,12739605,12739163,12740486,12737205,12740602,12738074,12737229,12736177,12735115,12737140,12736946,12739186,12736435,12737543,12736776,12736696,12739160,12738215,12738873,12741065,12737084,12735783,12740857,12735260,12734976,12740402,12737228,12735324,12735612,12739579,12739606,12740400,12740034,12736378,12737309,12737640,12736654,12725716,12740410,12739049,12737997,12740686,12730483,12737178,12738053,12740586,12734609,12735752,12740248,12735529,12736631,12735334,12739580,12737866,12734637,12734881,12740260,12738077,12740768,12738454,12735380,12736540,12738971,12740020,12737502,12737382,12740379,12737198,12736434,12740922,12741171,12741225,12736208,12736856,12739498,12737336,12735256,12737658,12736548,12736441,12735114,12739779,12739762,12740785,12738360,12739285,12737554,12738785,12735706,12737007,12740805,12726517,12738900,12739039,12736922,12741051,12735133,12737844,12737764,12738539,12739170,12739182,12734675,12739870,12741229,12738408,12738962,12738284,12740471,12739828,12739482,12735578,12734872,12740913,12737282,12740050,12737530,12740399,12740680,12734914,12735918,12735826,12737231,12736268,12735161,12738051,12735994,12739381,12734883,12736697,12735503,12740145,12735381,12735246,12737984,12739312,12735430,12734672,12737600,12737195,12739460,12741434,12739180,12737014,12740134,12735505,12738120,12737816,12740021,12739289,12737462,12740851,12740906,12739999,12735268,12736494,12736186,12741311,12738877,12740547,12738515,12735787,12737704,12739614,12741339,12737477,12737809,12738459,12737206,12739480,12740115,12735750,12741090,12739033,12738506,12738186,12736292,12737487,12739758,12734815,12737911,12737768,12734939,12735001,12737933,12737085,12740918,12734878,12736022,12735789,12736676,12736754,12740009,12739693,12737428,12737436,12738052,12740966,12738651,12736535,12739867,12740702,12740813,12738871,12737373,12740789,12740840,12736456,12734912,12737463,12738662,12736834,12739769,12737855,12741013,12740962,12741000,12738874,12740698,12736117,12735504,12736956,12738373,12738783,12737342,12739599,12738907,12736458,12740837,12735433,12740382,12737777,12737995,12739047,12734841,12735441,12739148,12737013,12738619,12741064,12739144,12741301,12738827,12738866,12740641,12735835,12734822,12740528,12734638,12737090,12736880,12738724,12739353,12740136,12736297,12741441,12737498,12739275,12739297,12737761,12735016,12737553,12740647,12736826,12738925,12737189,12737931,12736413,12737765,12740161,12736997,12738044,12738661,12736232,12737252,12740833,12741061,12734679,12738631,12735932,12739255,12736802,12737783,12738522,12738520,12739087,12738560,12736421,12740091,12737180,12740703,12737845,12735119,12738213,12735015,12737626,12737496,12735924,12740051,12739286,12741288,12734941,12737770,12738499,12737079,12735910,12740401,12739417,12739051,12737857,12737720,12741093,12739168,12738928,12736223,12740339,12738806,12736842,12734805,12740524,12736224,12734826,12737009,12739162,12734940,12735384,12739827,12739499,12739658,12736995,12739760,12739705,12736626,12739038,12739707,12739189,12737273,12739354,12737503,12735411,12738187,12736206,12740603,12735442,12738882,12734665,12737148,12738076,12740446,12739588,12734882,12736457,12735335,12738807,12739824,12737986,12737200,12739102,12736845,12740413,12740300,12739449,12737221,12740978,12736373,12740235,12738456,12735435,12734606,12740599,12734980,12737908,12740905,12736029,12739714,12737805,12736222,12736372,12741037,12740818,12740104,12734487,12735855,12737372,12734618,12737900,12736660,12734978,12738731,12741303,12740976,12740601,12738773,12738914,12737197,12739833,12739243,12737254,12733054,12737937,12737179,12739310,12736249,12737504,12739031,12740814,12736184,12739627,12734999,12736628,12738342,12737813,12734811,12738738,12739089,12734849,12735581,12740558,12735771,12738757,12737992,12737015,12734677,12740304,12738572,12737092,12734735,12741097,12740911,12740718,12740230,12736751,12739694,12739565,12738606,12738800,12740748,12739431,12735536,12737819,12736375,12737383,12735068,12735179,12737944,12735989,12738497,12739829,12740652,12740685,12740270,12736675,12737713,12735321,12739741,12735975,12735580,12735977,12739282,12737682,12740537,12737037,12735690,12740474,12741340,12738383,12737432,12738916,12739167,12739264,12739315,12740022,12738654,12738881,12738064,12736760,12740914,12740454,12734823,12735747,12738508,12739457,12738899,12740340,12738826,12734919,12739836,12737622,12740541,12740798,12735013,12736715,12734814,12741196,12734833,12736300,12736942,12738079,12739477,12735929,12738498,12740659,12737615,12736543,12736271,12735913,12739147,12738723,12740836,12739680,12737918,12739843,12738819,12739059,12736198,12740263,12737103,12736839,12740444,12736432,12735542,12736290,12741271,12740457,12735218,12740890,12737010,12739691,12737748,12740839,12739052,12740701,12739060,12740341,12737088,12735448,12736653,12734917,12737384,12735829,12739478,12737609,12740159,12738694,12736830,12738337,12737856,12740229,12736316,12739247,12737489,12735613,12739041,12734905,12738491,12737774,12735971,12738822,12738878,12740523,12739316,12735781,12736226,12737218,12737891,12738356,12736201,12736557,12740378,12736848,12735455,12740628,12735754,12737948,12740234,12737916,12735780,12737434,12741232,12736130,12739135,12738932,12735857,12735897,12735011,12736205,12740801,12739731,12738751,12735267,12734839,12739500,12740322,12740697,12740308,12735717,12736202,12737335,12737537,12738517,12741295,12737203,12740372,12735707,12738621,12735790,12737301,12734931,12734876,12734888,12740600,12740642,12736272,12735914,12738784,12739802,12734843,12739159,12740679,12738003,12736111,12735575,12739134,12739001,12739736,12738668,12740902,12739800,12740852,12738905,12737036,12740637,12735972,12736125,12735702,12734840,12740753,12740409,12735172,12740403,12741191,12740533,12739268,12739612,12739804,12737184,12740845,12739600,12736718,12739175,12739382,12741440,12734932,12738511,12734698,12735048,12740295,12736844,12734992,12740429,12738648,12740624,12738607,12740529,12738380,12739181,12737679,12739208,12738663,12740977,12735695,12737989,12736677,12737439,12740526,12738748,12738720,12734733,12736801,12736021,12738481,12738930,12737401,12739653,12740618,12737811,12738255,12736307,12734663,12737272,12735864,12740910,12739877,12740261,12737110,12740455,12736131,12738909,12740359,12737895,12736269,12737934,12738557,12737614,12738536,12736545,12735788,12735014,12740796,12740587,12739587,12738513,12740791,12740199,12739386,12735047,12740979,12737822,12740080,12740766,12735388,12740872,12737461,12741313,12741045,12740412,12736867,12739609,12735386,12737590,12738405,12739267,12734598,12735619,12740448,12734522,12737555,12737339,12737155,12734627,12737650,12738739,12735836,12737678,12738964,12737302,12738787,12737638,12735126,12735070,12736312,12735698,12740609,12737888,12739131,12740453,12738744,12740690,12740365,12739258,12740623,12738349,12737369,12739574,12737253,12740301,12735469,12739434,12739674,12739325,12736128,12740209,12735579,12738382,12737998,12740711,12738691,12735751,12739754,12735237,12740143,12740427,12739571,12735458,12741213,12741267,12739421,12738078,12736175,12736204,12740705,12740048,12735000,12735383,12738366,12740859,12736665,12734871,12734671,12736464,12735465,12738283,12737947,12735331,12739000,12734608,12737642,12739858,12738338,12735244,12739846,12741249,12736872,12734640,12740383,12737464,12738695,12737595,12735979,12738005,12738399,12737181,12735447,12740981,12738370,12740144,12738749,12737435,12735063,12738815,12739254,12735473,12740156,12738666,12734820,12736850,12740525,12740406,12737536,12737746,12739311,12740658,12737993,12726519,12740928,12740082,12739253,12735942,12740337,12736179,12739003,12737942,12737649,12737438,12736632,12735283,12737858,12736305,12736609,12734848,12736209,12735128,12737394,12740535,12736506,12735134,12737665,12737427,12738066,12734664,12740273,12740032,12738915,12734911,12738927,12736319,12739581,12740980,12737375,12739408,12737093,12739794,12737379,12740083,12737996,12737778,12739796,12737616,12734808,12737972,12738821,12740548,12741189,12739156,12740200,12740057,12734614,12734942,12734812,12736542,12739590,12739279,12737853,12738253,12737709,12739825,12739210,12737185,12737146,12735782,12735858,12740135,12738281,12737374,12739361,12737549,12734611,12736853,12741096,12738716,12740598,12738917,12739358,12736989,12739798,12735834,12739251,12737611,12737919,12739695,12738372,12740534,12735413,12741036,12737617,12737493,12738910,12735112,12736555,12737545,12738102,12736648,12738514,12737091,12741010,12739317,12737107,12735636,12736662,12739666,12735859,12738828,12735794,12741184,12739727,12735066,12737680,12738786,12735045,12734699,12737652,12740007,12734825,12738109,12736034,12737280,12739726,12740271,12738963,12736308,12739108,12736847,12741210,12736393,12737776,12734574,12734617,12737899,12741305,12735986,12740105,12739249,12734830,12735968,12739706,12734673,12734816,12737260,12740820,12735757,12741231,12739566,12734933,12739097,12734986,12735277,12738750,12738876,12741175,12738803,12738216,12741247,12737006,12741040,12737540,12740891,12735450,12740498,12739011,12739287,12735643,12735527,12739028,12737474,12737139,12736123,12735641,12739586,12735696,12740405,12734670,12740075,12740307,12740559,12740631,12736537,12741039,12735387,12737337,12739042,12741314,12740052,12738747,12736803,12736753,12740823,12740743,12735120,12741312,12736846,12734975,12737914,12740638,12734561,12740749,12736463,12739383,12737156,12735703,12740933,12737913,12739442,12735693,12740428,12735002,12740684,12739265,12736389,12739416,12736884,12737188,12735969,12734846,12739435,12737804,12741033,12739204,12739178,12738671,12737217,12740154,12736109,12736178,12737183,12736599,12740531,12735390,12740008,12737393,12738488,12736917,12738789,12740031,12736755,12737145,12737500,12735470,12740827,12739428,12737154,12736646,12740407,12736320,12737538,12737210,12738189,12738500,12737843,12737910,12736287,12737338,12741439,12740149,12737612,12734667,12739801,12734988,12737528,12736705,12738404,12737681,12740348,12736539,12735867,12738575,12735337}'::integer[]))
9.          

CTE datas

10. 1.612 77.228 ↑ 200.0 1 1

HashAggregate (cost=145.03..147.03 rows=200 width=12) (actual time=77.226..77.228 rows=1 loops=1)

  • Group Key: a_2.contrato_id
11. 75.616 75.616 ↑ 1.0 5,801 1

CTE Scan on animais a_2 (cost=0.00..116.02 rows=5,801 width=8) (actual time=0.001..75.616 rows=5,801 loops=1)

12. 3.899 25,148.275 ↓ 5,801.0 5,801 1

Nested Loop Left Join (cost=3,048.98..3,186.80 rows=1 width=68) (actual time=25,088.304..25,148.275 rows=5,801 loops=1)

13. 9.655 25,126.973 ↓ 5,801.0 5,801 1

Nested Loop (cost=3,048.70..3,186.50 rows=1 width=56) (actual time=25,086.448..25,126.973 rows=5,801 loops=1)

14. 17.699 25,105.716 ↓ 5,801.0 5,801 1

Hash Join (cost=3,048.55..3,186.33 rows=1 width=49) (actual time=25,086.412..25,105.716 rows=5,801 loops=1)

  • Hash Cond: (an.animal_id = a.id)
15. 18,088.884 18,088.884 ↑ 1.0 5,801 1

CTE Scan on animais an (cost=0.00..116.02 rows=5,801 width=4) (actual time=18,087.180..18,088.884 rows=5,801 loops=1)

16. 49.124 6,999.133 ↓ 15,408.4 77,042 1

Hash (cost=3,048.49..3,048.49 rows=5 width=53) (actual time=6,999.133..6,999.133 rows=77,042 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 2 (originally 1) Memory Usage: 3,724kB
17. 92.341 6,950.009 ↓ 15,408.4 77,042 1

Nested Loop (cost=0.68..3,048.49 rows=5 width=53) (actual time=3,581.498..6,950.009 rows=77,042 loops=1)

18. 13.243 3,621.904 ↓ 15,408.4 77,042 1

Nested Loop (cost=0.25..3,006.25 rows=5 width=20) (actual time=3,580.070..3,621.904 rows=77,042 loops=1)

19. 77.232 77.232 ↑ 200.0 1 1

CTE Scan on datas d (cost=0.00..4.00 rows=200 width=12) (actual time=77.229..77.232 rows=1 loops=1)

20. 3,531.429 3,531.429 ↓ 77,042.0 77,042 1

Function Scan on controle_ponderal up (cost=0.25..15.25 rows=1 width=20) (actual time=3,502.832..3,531.429 rows=77,042 loops=1)

  • Filter: ((ordenacao = 1) AND (d.contrato_id = contrato_id))
21. 3,235.764 3,235.764 ↑ 1.0 1 77,042

Index Scan using mbw_animal_pkey on mbw_animal a (cost=0.43..8.45 rows=1 width=33) (actual time=0.042..0.042 rows=1 loops=77,042)

  • Index Cond: (id = up.animal_id)
22. 11.602 11.602 ↑ 1.0 1 5,801

Index Scan using mbw_raca_pkey on mbw_raca r (cost=0.14..0.16 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=5,801)

  • Index Cond: (id = a.raca_id)
23. 17.403 17.403 ↑ 1.0 1 5,801

Index Scan using mbw_localizacao_pkey on mbw_localizacao l (cost=0.29..0.31 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=5,801)

  • Index Cond: (id = a.localizacao_id)
24. 1,166.001 1,166.001 ↑ 5.0 1 5,801

Function Scan on obtenha_primeiro_peso_animal_na_propriedade pp (cost=0.25..12.75 rows=5 width=16) (actual time=0.201..0.201 rows=1 loops=5,801)

  • Filter: (animal_id = a.id)
Planning time : 40.495 ms
Execution time : 26,326.636 ms