explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PaWh

Settings
# exclusive inclusive rows x rows loops node
1. 0.178 1,274.066 ↓ 1.2 392 1

Sort (cost=26,145.22..26,146.01 rows=319 width=62) (actual time=1,274.030..1,274.066 rows=392 loops=1)

  • Sort Key: (sum(po_monthly_flart.nu_commit_count)) DESC
  • Sort Method: quicksort Memory: 80kB
2. 87.841 1,273.888 ↓ 1.2 392 1

GroupAggregate (cost=26,118.32..26,131.95 rows=319 width=62) (actual time=1,132.912..1,273.888 rows=392 loops=1)

  • Group Key: po_monthly_flart.tx_file_type
3. 313.339 1,186.047 ↓ 1,122.3 361,393 1

Sort (cost=26,118.32..26,119.13 rows=322 width=31) (actual time=1,132.878..1,186.047 rows=361,393 loops=1)

  • Sort Key: po_monthly_flart.tx_file_type
  • Sort Method: quicksort Memory: 40,522kB
4. 65.482 872.708 ↓ 1,122.3 361,393 1

Hash Join (cost=6,473.71..26,104.91 rows=322 width=31) (actual time=8.433..872.708 rows=361,393 loops=1)

  • Hash Cond: (po_project.id_organization = org.id_organization)
5. 81.103 807.128 ↓ 1,122.3 361,393 1

Nested Loop (cost=6,457.00..26,083.77 rows=322 width=35) (actual time=8.329..807.128 rows=361,393 loops=1)

6. 13.922 59.025 ↓ 233.5 83,375 1

Merge Join (cost=6,452.85..19,570.99 rows=357 width=8) (actual time=8.287..59.025 rows=83,375 loops=1)

  • Merge Cond: (po_project_sub.id_project_sub = po_proj_sub_infra.id_project_sub)
7. 2.241 9.309 ↓ 7.8 6,285 1

Sort (cost=6,452.43..6,454.45 rows=810 width=8) (actual time=8.277..9.309 rows=6,285 loops=1)

  • Sort Key: po_project_sub.id_project_sub
  • Sort Method: quicksort Memory: 487kB
8. 1.394 7.068 ↓ 7.8 6,285 1

Hash Join (cost=1,125.43..6,413.30 rows=810 width=8) (actual time=1.844..7.068 rows=6,285 loops=1)

  • Hash Cond: (po_project_sub.id_project = po_project.id_project)
9. 3.846 3.846 ↑ 1.0 6,285 1

Index Scan using po_project_sub_id_project on po_project_sub (cost=0.42..5,256.29 rows=6,371 width=8) (actual time=0.007..3.846 rows=6,285 loops=1)

  • Index Cond: (id_project = ANY ('{60141,87909,65850,66768,63443,59892,61336,65845,63424,70511,57212,62100,61307,72252,65424,87455,70515,66714,86900,87240,59995,62310,86247,86948,87121,61832,58662,62324,68354,86256,61995,63470,62327,62145,87290,63704,61389,63489,73028,87568,62111,78394,65889,63494,73035,62081,62252,87377,65381,63456,62097,59732,64446,87629,68193,67759,58683,86191,86282,63703,68381,59901,86903,64419,87082,68376,72960,63701,70692,88203,87651,51866,67591,86098,87212,61955,87525,87973,65828,70477,63485,87530,62258,87184,66739,68114,59783,68026,67752,65854,87354,52772,63581,66745,70681,73030,65880,70748,70742,86259,86297,86869,59649,70766,62025,61306,64394,87950,86213,66704,61837,65839,70530,67743,66220,86175,63441,87472,58679,87522,67758,86214,67744,47277,66803,87372,87422,59868,65697,87460,59847,62135,61905,87326,65393,62240,65792,65846,67583,87321,63455,62079,63461,86908,62152,87954,59795,66808,87113,87245,66762,87434,63445,88178,63482,88170,86232,65881,68050,63514,63436,87300,87546,66688,52771,86298,87166,86829,87217,66679,66205,72959,86845,59997,67775,62063,63711,59991,86181,68386,60209,63580,70675,87640,59740,59651,65383,65764,59837,87265,86148,87960,87160,87429,62211,57036,66212,66224,88128,61999,63542,62146,52770,68034,62315,59720,67746,24056,62076,51843,70797,70801,87123,58713,65414,62273,78383,65405,66692,68366,64401,87423,66711,59821,68384,86272,61990,59755,70532,87999,59801,62031,66675,63433,70696,87907,62308,68134,62022,60119,70586,88179,87190,61390,64449,62270,58653,65707,87891,61969,62044,86284,59858,51526,66696,78639,60118,65891,64445,86141,63562,63570,68391,64904,59665,63706,87114,70759,63394,62089,68075,59890,86811,60005,67610,59796,65430,63509,87284,86924,86936,65844,87263,62085,60009,62003,66767,64402,67581,66199,86125,70534,68394,60213,62218,87617,66672,59889,66799,67776,86158,86853,63589,58649,87890,86185,86241,62282,87967,59869,66210,65795,61825,65787,86937,59846,87259,86871,87360,68413,61382,68357,66758,66719,70728,87652,62302,62251,63469,62138,70714,50287,59894,86269,59744,66721,59880,65882,62041,59716,66223,59731,63583,59675,68412,72312,87538,86294,66211,67760,58709,62147,86239,70761,59704,59841,86243,74267,70416,86931,86928,86246,86227,65467,59792,59875,62245,87367,59833,86135,59872,65418,62227,87972,59814,68401,87539,87604,70456,87667,68359,63516,63478,59902,87949,63521,86121,87531,61836,87917,59914,87102,87158,87957,62043,59819,63572,62276,68198,73038,67612,51920,66769,87457,61970,74271,70542,64444,66687,59669,62221,71107,62021,60133,87968,87374,68185,87923,86268,87904,73031,10457,58684,68365,86144,63586,87359,65700,68290,62047,86819,87636,71104,65832,63523,70445,63573,87659,86193,60114,62096,87914,61997,65401,66797,65516,86199,59811,62263,87380,87181,65890,65888,61338,65419,87942,51859,66795,70823,86817,73037,62006,64453,70405,86950,70529,62092,65838,66674,87885,87489,66789,59767,87661,65384,65701,65478,59924,63543,86253,87475,87436,58648,66197,70503,58669,87465,66713,72219,87333,68379,86205,63575,87980,87483,87918,58696,59908,70783,87226,86277,86225,66737,61998,86204,62064,65415,62292,68351,86894,86296,86176,87453,86375,87239,72919,16355,70698,58765,61835,86874,61904,87350,86858,51884,70796,87966,65767,59689,59725,70691,66191,67754,66744,86891,87161,86904,70808,63571,58711,87258,87480,86299,68361,59861,86217,70418,87443,87415,86866,62220,68420,59835,63453,73041,87080,68113,65769,87442,62154,67763,86273,63517,68027,86887,59851,87381,65847,87952,87913,67586,61535,65417,62286,59794,79234,86263,62061,78310,88198,62264,65406,65852,78380,62306,66810,87618,65477,70770,66802,62106,61310,62056,60126,87596,73043,65788,66188,59848,73039,86223,61935,87427,73045,61362,65397,62116,51530,87273,86855,59759,87635,59825,63539,86228,66703,87935,62029,59904,63524,65431,87156,51377,64403,70479,70584,66647,71097,87903,63569,86192,61337,63493,70387,51521,62321,70682,73036,86923,67615,86258,74272,59807,87587,66779,86876,72215,86361,37091,65771,87898,70753,66757,66222,86094,87122,87298,87555,86210,66200,66673,65848,86254,59721,65391,87438,72241,61917,59926,87416,63565,87307,68422,62068,62005,64428,62016,72338,59766,62269,65556,59988,87269,88011,87616,51928,67785,68403,60138,65835,60124,62103,59853,59754,59678,63705,38934,87528,65833,87345,62124,63547,70767,78369,86234,61810,62115,51845,87488,65421,64405,70676,70670,87397,79241,66691,88171,87456,68262,65557,87574,86913,10472,59762,86261,86146,66646,86179,87893,87894,65425,61972,62009,62262,64418,63537,87621,72290,63435,68380,59646,60007,86921,10447,64455,86245,87369,88040,59906,88180,61958,59706,88053,87083,87934,86265,62318,87128,65837,86159,59834,62057,87129,63564,65475,87944,59891,59724,58666,87897,66761,62105,87387,87289,87419,87163,68382,62180,72220,64239,68281,62158,86161,62284,87126,68414,68277,62023,85477,86938,68369,65402,70693,67761,63522,87937,63498,62224,64459,68254,62274,87908,87079,86201,59659,86119,62004,68377,59854,87440,86233,65751,63552,59712,65470,87278,70522,64414,66195,74269,63496,70580,66764,68360,87469,87172,70763,63512,86196,87071,66124,87242,67617,60125,62254,59844,64432,60140,65759,65426,70732,86155,66214,59687,51520,62307,86300,62316,64447,62162,58659,61359,63490,61943,59723,87111,63567,63468,63534,87481,86203,87341,61976,65883,61816,63551,86877,86275,61906,86890,73034,66805,62167,52936,87125,59826,66217,61829,67768,61994,63446,87027,61822,65474,58719,68367,62060,70678,78370,61361,65877,65782,87975,86943,87329,87118,87379,87537,87390,68353,86209,87078,66689,87395,73042,65849,59903,65830,68276,64261,67592,59705,87902,57193,62037,60211,65793,86821,62305,61305,87316,86927,61824,86897,66749,87589,86906,59881,65691,61828,70668,58650,67751,62050,61312,86147,61358,70794,65618,62278,62008,61834,62299,63519,86244,74275,66192,71091,59864,62019,62151,87624,10450,87527,62133,87257,60001,59713,86270,70762,78375,64429,66707,86162,70750,63545,61820,87959,86224,59921,65762,64413,86889,87155,87445,86935,59769,58686,62036,68300,86816,63484,68363,88036,87117,87901,66815,86934,65388,68085,66792,66650,86856,87459,78366,87294,87958,65462,63501,59815,58685,66189,87309,62209,62052,86914,62102,65396,62176,68206,59909,66710,67585,62181,58671,88173,62319,86171,52828,70812,70771,86875,65472,63415,63492,63438,68405,67616,65559,86163,87075,88172,68059,10470,86252,86276,59913,65719,59927,52835,86286,86249,70738,65763,62125,65752,61833,59888,86895,66203,86827,87081,58717,61335,68375,68370,87225,65468,61914,65872,68130,65432,86202,61823,67742,65457,66746,70432,86198,86260,66193,59727,67774,68204,51721,62118,59708,87536,63530,87471,86881,70735,65859,61942,70694,87346,70540,63477,65412,87970,60217,87167,87924,63499,87564,70488,74279,68117,65558,87922,70725,87639,86911,86195,86207,66204,86236,63475,78638,79246,87218,87362,63487,70430,87547,61826,61821,65413,62325,70754,86396,65699,86334,65416,60115,87485,59870,70528,70687,87633,61962,65394,70810,87619,87565,88210,87931,70768,68371,66705,63480,62000,63505,68390,67749,86346,65766,61818,70703,64397,61939,70710,68293,65777,87107,86917,58674,68373,63463,87889,63479,58673,65479,51907,62261,63502,61309,72237,63481,60004,70537,66699,67757,61813,70424,87912,71101,63416,87612,86184,86138,87981,87396,72253,62075,66724,87120,59829,68203,61959,88174,87238,59761,86832,70740,63550,87303,65385,62071,68368,70582,61819,62113,61931,70669,52766,87521,86852,59644,66196,86177,86264,63462,86212,68186,62219,59845,66198,88192,66221,86835,61365,63708,65392,87164,59668,86848,62160,87116,86136,86150,87014,59806,86888,86820,63464,62232,86186,62303,61380,87965,62288,62001,65460,66649,87315,59905,63532,63423,87962,87884,65878,86237,63466,58447,87933,59828,62033,68402,62066,62087,87573,59856,78358,66655,63536,70419,60128,62018,62137,70709,65841,86940,59860,87905,87932,87582,60137,59912,61973,87385,87418,87074,68410,86939,70473,87535,87963,87227,66783,68042,68404,62053,63635,66194,87378,87634,86863,87883,63511,70799,86170,86846,52048,62122,87658,72221,68392,86149,59817,66807,59897,70535,68372,68398,87383,71092,87895,62225,87130,62259,66208,62301,65898,66676,87178,65714,72238,62078,61954,65408,78309,70485,59916,65731,71099,61901,87576,62014,24055,59692,78361,68275,87281,86211,66690,59887,87559,68302,87977,61961,86818,87185,59879,86882,66747,87189,60216,64420,62314,60123,61936,70684,62108,70464,86902,65420,65861,70811,64393,86870,66202,66787,68396,65765,66774,86200,67770,66685,61830,86847,70760,86920,87256,70791,66680,87572,64913,86898,86281,62069,61363,68406,86823,87084,68028,70752,62091,86883,65398,87412,71098,87171,86772,62322,62030,79242,86168,64416,60003,65887,86933,70498,62117,61817,62082,87073,66741,67582,87632,87241,87921,70431,70352,58663,86901,70487,58652,86160,66656,63544,71100,65897,74268,64398,87112,70685,86182,63418,59886,63520,68350,87272,87331,86120,66645,68268,59839,87915,59691,87342,87410,87562,60132,87338,63437,86229,87906,61265,64408,66812,59719,87628,65791,88195,10458,58710,65895,63556,86188,63579,68393,61393,70512,58449,62275,64458,87159,78311,70414,62026,63472,65834,87675,86156,62255,67579,70470,86183,65518,87976,59850,61897,70489,86221,65409,68189,86925,62067,62157,70769,86143,61930,87299,63483,87558,61381,60000,63471,64424,70695,87938,66201,87939,86266,62086,66750,86100,86279,86949,63417,68184,61815,65874,62101,86151,62077,59838,64425,47250,63476,72239,87627,68409,58654,86892,86257,62287,59730,86814,78362,87211,86152,71096,68358,88200,70688,62074,62002,65875,70731,60129,72293,61827,65382,62049,62323,86916,70790,61308,62035,87964,87413,86197,61968,68407,60210,60116,62328,87119,59885,61383,59859,63491,61831,65461,59707,66190,87579,88209,61357,68191,86124,88033,70689,87464,66695,63576,72236,70788,86341,87127,88177,60122,58697,61926,65768,62038,61956,86206,68195,70531,68399,66219,59538,59703,65869,61996,65549,88142,86288,62250,87594,62024,59536,87940,67613,65713,65469,87926,62244,65727,62007,67611,62034,65407,66698,86189,66743,62090,59862,59664,87243,61346,68274,87578,62011,62109,87358,87486,72233,64443,86857,61957,59758,63425,87371,59907,62120,87247,88056,86194,62172,59820,68207,62257,87951,74280,86242,59743,68295,66226,66777,63434,86174,63513,67580,66736,88047,86886,87458,66667,73032,58646,86280,86219,59666,59836,58672,68378,74277,68060,86773,87900,86285,87344,87613,74270,63518,86850,58446,87925,62080,59852,68411,61348,66760,68067,86946,63531,71106,66648,78308,59685,64412,87600,66706,63508,63578,65779,86137,86332,59718,87077,64415,87586,59663,87955,52137,57214,16360,61360,58665,86872,66225,87262,65399,65687,66718,59816,74276,59694,62148,65450,59809,59813,61366,59843,87978,59714,87328,87236,63473,70533,58699,52767,70802,86178,68421,52774,87401,66123,65886,52765,70673,63440,63506,63510,87899,52893,63507,86231,65836,86302,62017,68400,87317,87886,73033,86879,86164,86849,66712,86278,62139,68389,63553,87995,87373,86154,68362,60008,63574,86878,62253,59800,70729,87361,68038,62229,63527,86216,62112,87595,68387,87260,87426,70749,87175,86287,86915,50236,87407,87673,70734,59896,87452,59709,63486,68419,88123,86885,86099,86912,58716,63497,64417,70441,65428,61838,87186,70581,62107,86101,87157,62013,72276,66684,61379,87888,87920,87916,87943,87433,68352,66701,63474,88196,64426,64427,60134,87969,61965,59818,61345,86893,70793,68356,71094,67762,72224,65387,62127,87399,52878,86293,86867,63541,87311,86941,51909,62311,86942,65386,65471,61349,65693,62126,86851,61314,66702,68408,63561,87219,62054,60131,87910,86267,70755,63439,63503,70536,61311,62136,87320,67584,86868,71105,66700,65866,70446,61339,63526,87364,65704,87295,88107,61938,59910,65400,63568,67765,87249,62042,58714,86289,70809,87625,63554,68385,59757,66778,60127,62281,62291,66709,59726,51875,70712,86831,66756,87319,86833,63442,87388,58762,65709,87961,87919,86295,86238,87076,62010,61388,59899,59745,65864,87649,62055,63444,61946,63535,66732,62040,61812,68423,65774,87424,51910,57038,86834,86250,63467,70680,66776,87468,65395,65705,86929,73040,65389,65789,65404,70585,66206,61903,66742,66816,59871,64448,64254,86735,88176,62140,62095,79249,86145,62129,87376,59874,86830,87650,68165,68280,70457,72336,86255,87473,59655,70543,59857,65829,87896,86220,52874,87394,52875,59999,60212,62312,67755,68167,52768,87391,71103,66599,63560,70671,64395,59827,87599,87911,51403,86153,87339,60139,68364,86291,67764,86140,87466,86230,62104,66794,63515,86932,66218,87428,65776,66801,60130,87195,87620,87430,62271,59863,59647,86884,88175,87608,87593,59895,87115,86274,86248,86290,86180,87244,63432,63495,63488,87254,62015,59840,61811,60142,87072,86815,64431,87544,62028,86187,87892,65851,66722,59842,86922,86283,59753,65867,62249,62272,86303,59808,59867,79226,86905,59832,59768,88194,86251,61364,63458,87252,62123,87425,68052,61899,63457,70672,52773,88181,87268,86169,65717,86235,68397,87571,61347,59742,65794,68166,86123,65879,68355,86945,86172,68072,70583,86387,70765,87370,61919,87305,87561,87449,87285,67614,86859,61313,66772,62119,59898,66207,65427,65856,59876,65853,87638,66753,59684,58704,63431,65710,59810,10498,86122,86262,61536,68030,62161,65403,62226,63702,66771,87941,86370,59812,86292,70756,58682,62027,70679,86918,52052,61952,57039,51531}'::bigint[]))
10. 0.508 1.828 ↓ 1.0 4,724 1

Hash (cost=1,065.98..1,065.98 rows=4,723 width=8) (actual time=1.827..1.828 rows=4,724 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 249kB
11. 1.009 1.320 ↓ 1.0 4,724 1

Bitmap Heap Scan on po_project (cost=219.75..1,065.98 rows=4,723 width=8) (actual time=0.329..1.320 rows=4,724 loops=1)

  • Recheck Cond: (id_organization = ANY ('{195,380,347,400,368,204,362,361,384,399,356,355,397,333,290,379,292,376,349,363,199,382,197,351,191,367,386,194,378,369,396,352,398,288,366,203,385,375,192,338,424,193,381,331,350,377,403,374,272,198,383,354}'::bigint[]))
  • Heap Blocks: exact=176
12. 0.311 0.311 ↓ 1.0 4,724 1

Bitmap Index Scan on po_project_id_org (cost=0.00..218.57 rows=4,723 width=0) (actual time=0.311..0.311 rows=4,724 loops=1)

  • Index Cond: (id_organization = ANY ('{195,380,347,400,368,204,362,361,384,399,356,355,397,333,290,379,292,376,349,363,199,382,197,351,191,367,386,194,378,369,396,352,398,288,366,203,385,375,192,338,424,193,381,331,350,377,403,374,272,198,383,354}'::bigint[]))
13. 35.794 35.794 ↓ 1.3 83,375 1

Index Scan using index_po_proj_sub_infra_id_project_sub on po_proj_sub_infra (cost=0.42..12,956.46 rows=61,797 width=8) (actual time=0.007..35.794 rows=83,375 loops=1)

  • Index Cond: (id_project_sub = ANY ('{204473,194387,153920,204122,264128,201609,239961,197414,252897,167655,186403,76869,187239,198540,197595,57569,263746,235761,53033,167782,201654,61396,53816,194406,169076,265019,201400,182538,165570,197979,264076,201107,264204,54578,184270,101764,169148,263840,206186,254677,79187,206251,53784,162412,162683,197609,196485,162948,167818,187306,183918,204091,195083,263855,197484,59901,167852,264948,186602,53847,76788,252836,56885,183999,64419,251399,184046,222667,85209,165643,77887,204169,184085,162808,165564,184029,264507,162582,53030,79561,162891,252908,137181,38181,52995,204558,204166,189945,194348,200556,167712,88657,50068,162975,165451,201382,39503,183973,204090,263748,165452,197404,60273,184001,263839,76888,162936,189971,62051,165499,184253,201300,239801,206228,184077,223129,56926,224527,235757,264187,184032,185432,61124,252851,203970,84618,197436,167353,254778,38184,264156,192996,57512,206338,197526,162538,204129,187364,189937,54606,204514,165436,183943,186469,62531,62523,169118,165837,54467,167957,203987,223102,194282,53937,200821,53681,52713,254759,163795,189943,252781,182703,154016,184266,79166,254746,53892,56829,53880,252868,201406,197438,162483,62089,165877,187332,252766,197481,183958,54561,53020,263550,184770,162437,64402,60438,156265,53736,166387,162766,165596,222651,61400,56830,61781,206255,126407,223130,264039,263808,206281,263626,165613,53919,222669,53831,165585,198402,76879,53991,199952,163773,200581,201647,263563,263536,201274,206361,77929,263180,165558,189966,204555,222646,53956,162595,263688,254786,184009,186382,39487,200566,200848,53922,196462,252914,133246,162817,167741,252678,76767,186327,264621,203955,183215,42505,197574,126400,194401,186328,53908,184033,206362,264511,204218,97760,53034,62378,53721,206280,189964,53767,184052,234905,53050,162447,252879,183603,190015,263754,252907,185438,252774,263696,60257,254744,264674,252865,165489,169174,263677,161088,198821,198412,137183,165727,186364,169169,204512,55304,83898,223090,183519,165644,198430,197576,148261,264508,201408,183592,254582,264522,242198,204118,264149,183993,61795,165627,206916,254766,198447,162828,202724,53714,254745,53930,252806,252788,206301,252799,252883,252905,62047,201602,83589,253327,162440,197642,263565,242204,77939,53737,182528,56835,165618,204570,198139,203950,262980,61784,200230,165578,52377,187290,196481,187333,165399,204114,186430,186312,198475,58991,76867,162568,197559,186427,198825,254729,265030,254737,196293,197444,263181,52320,62088,239807,38187,206253,53863,200910,198395,203992,252854,138341,187340,183260,162625,52717,137182,61385,162570,53807,165672,242199,196490,64387,148067,263682,252802,252848,198437,198464,186357,204814,162854,182680,264124,53923,54565,54098,184733,162403,153981,197445,203949,166392,264046,254727,122896,53894,186473,183934,186410,263719,194345,197564,77793,75870,53691,166371,197466,254694,187318,255095,162359,165476,252919,55307,198198,204119,156128,183475,49382,198841,231560,254738,263820,206246,60276,187297,101739,201105,183971,184194,168027,194157,189960,138333,156247,53048,184245,184106,206327,183992,222723,183692,201646,182555,204171,204613,265032,122494,252759,204616,38188,189934,165431,197971,167167,61797,162800,198419,183961,198164,200161,263731,201623,183940,263526,162467,252591,200563,182533,223089,263186,264169,162493,52362,138337,53749,186358,165840,62061,194386,194381,56883,186614,183959,254706,264528,182717,254799,198519,198560,196248,198202,101949,156127,57437,197607,54293,57416,184020,162826,165615,197417,56960,201616,60282,197678,184015,56841,201678,203937,264058,206159,58613,64403,198441,167777,153470,206202,165648,198127,53577,81026,184783,165880,263865,64358,197435,57570,186394,56936,201692,200547,254732,162914,53801,183438,146827,183935,162938,153938,167828,162372,197842,198413,222684,201410,184215,166395,206171,254773,264520,200270,224558,263835,183840,138345,53977,264624,137178,165843,204572,78005,223098,263642,54605,201104,186607,186481,196463,196297,184230,196482,183516,264537,263661,58977,197373,182544,252789,84619,187328,204467,182530,264506,204596,194158,165412,254749,54444,82327,183289,64405,56880,204811,162699,200137,222650,184209,263191,77749,198501,198541,252892,197589,75836,184040,197519,57862,197974,184261,196296,195081,186404,183843,201610,197665,197455,156117,186625,187313,60279,166376,75776,167850,201675,162857,162586,162935,61108,239803,42506,162574,162370,165571,84927,62369,53799,183613,53579,198200,153497,83903,77885,206299,263680,254804,52716,53921,198116,196489,264509,264188,198468,201670,264609,264619,123543,165636,194155,197506,183259,252844,197518,224564,75869,165640,235767,53970,53010,204125,165604,165705,163844,264073,75866,186365,38190,166375,183292,162360,162806,126026,59213,200568,263269,165598,204087,120848,254736,169388,198843,161089,204513,184868,223114,184869,252830,89523,204812,198561,165637,263564,40067,186349,182712,201651,53575,183703,264786,263242,186329,184043,254790,162394,264626,62059,184183,165580,120095,263827,262981,166381,254793,186351,182548,162811,76822,162400,252565,264032,77757,186482,197400,165879,204066,183938,263230,263666,167734,204067,185450,197639,263755,123947,38179,165662,165701,60457,251401,53987,197450,201510,264043,201275,198453,252777,53812,263281,194410,197583,184030,184063,203969,88768,162841,57515,264053,75775,200818,187291,198415,165876,169193,264150,263636,183491,165464,165422,186372,263850,78604,203921,76871,197703,184761,162847,224546,197874,162556,186605,184881,186393,53715,53049,85090,169192,263816,184180,252811,196470,264057,162895,204094,56962,61399,184206,252682,153952,189968,198090,40042,165502,264515,182714,55384,184262,53726,149351,53988,182541,162385,187330,57624,62050,198478,182716,167165,197916,223097,61778,204080,80658,89445,162381,203958,197685,200017,254711,55279,53978,204211,185431,206182,125402,198476,264943,167675,81030,162837,239974,183300,88757,138330,184016,183426,189991,167175,252921,54308,80810,187279,183675,252918,54079,194267,204348,53766,206366,162843,197813,59343,61104,200822,194290,184060,200231,165647,169149,201631,263705,264805,55381,200013,184282,183987,54460,54426,76778,254707,206238,163787,186370,206357,53576,47006,53797,252852,167760,203961,53826,62052,57408,54005,54563,162722,39485,264719,52712,252756,254682,55277,252816,183524,197670,163774,263797,254789,254781,167707,184749,55278,146521,169175,223120,252764,61786,198204,252794,252772,252870,162810,201661,196473,183514,265016,204113,135031,54297,183377,263640,198477,61122,206367,169147,196474,186335,53969,197465,254713,198436,167612,187331,197618,76865,53743,162546,183368,54557,162626,184044,197488,186250,263239,62093,57395,254717,263567,56934,197529,60272,57219,204547,186439,162976,264504,263741,53829,165620,200560,126021,39493,197503,76773,224518,263694,56941,263863,53910,197550,186338,57550,53992,55301,162984,201638,61142,79171,252904,76866,56806,53679,147983,186399,197707,254733,189972,165403,194395,186603,197853,76782,194364,252808,197411,166382,197917,201614,254795,57399,162459,52371,182552,165656,162648,251400,162382,78551,162725,57539,203938,165410,235638,254842,165587,165475,194366,162940,197443,163852,54100,165563,264097,198218,183832,197451,197617,101762,264947,264161,53793,84914,198223,194151,183203,194373,184276,165528,169120,160759,80823,53680,263224,223103,50073,165505,182698,187275,165556,162868,182645,206286,197578,142751,262986,203995,101947,252866,187326,253312,153314,156246,254681,64404,197663,79563,53972,204116,186604,162939,162846,183781,57394,252793,186471,206200,75864,165447,251404,239965,183628,252899,252771,165617,183952,87173,58617,153970,204163,64361,60385,162807,254593,198423,56812,204614,203948,198442,167905,39492,264162,163820,194299,57433,183635,197360,198175,203925,183430,242499,187304,182700,169176,58966,58626,264165,263889,198428,75873,184037,167833,252824,204124,263838,162536,263723,182557,165487,54096,56877,201644,263862,198504,165488,165827,201662,53035,183689,263684,53821,184062,162678,204528,77880,53747,252791,183542,79470,263792,242200,198451,194349,186359,184272,53000,165881,183984,122740,163777,186468,184086,194368,196221,197410,196290,254761,254788,62062,189933,183560,194352,60552,165407,197548,168028,196215,53817,165554,182682,204498,263769,243590,39479,186613,197418,252885,60262,194409,263278,53045,198105,198571,165395,183924,62376,38191,57404,53567,60278,206193,254740,200582,163789,263718,54419,54278,190019,161120,186353,101737,263544,186366,53459,76878,79164,163776,165503,58620,187336,184073,53782,55300,60266,54307,153936,189938,263781,61422,223107,254764,55306,189969,165572,162695,224581,264516,162508,184281,148084,189954,263837,64407,156136,186629,197641,189956,56939,167755,162774,252864,198538,254730,58627,195072,52368,75840,64420,85076,197567,198417,184265,263851,142739,263789,252916,198184,198508,206329,53709,252872,252880,76873,200025,252922,53001,263818,263804,56970,204083,183950,58641,54465,201710,77889,264622,57402,39481,163803,53031,254752,184061,201413,182713,133222,203986,187351,184756,184041,204217,153469,187301,54577,203962,200019,201619,162738,167673,162912,184019,169348,167166,200820,161099,184213,53771,263537,160804,198470,165651,85111,182699,165393,252819,206239,146828,61106,169178,183937,184010,162501,223133,166379,76870,62353,54569,198496,59289,53762,125440,60274,162443,162392,194153,169117,162427,263244,146949,80822,198490,198448,264640,265021,201401,263545,196496,252762,53593,201520,77751,64408,182558,83907,165408,163807,163821,182679,197533,201642,197514,53983,183891,206199,201607,197459,264125,264949,196497,204620,186426,254784,185446,223115,204207,252910,197427,165409,186464,186373,77763,50071,197906,197396,52992,264513,264088,204540,184205,200026,198517,184011,184279,54305,53717,79182,80807,252773,53755,184199,183621,252850,57436,184211,264612,201664,162692,197507,162794,54101,263235,53838,184224,148086,59212,183623,163839,198460,264608,201629,264142,165565,54420,77761,252818,186384,53684,206185,54459,187338,53794,206332,265013,201422,166378,206218,197689,223131,162477,56879,62074,163854,198157,263243,183933,123948,264538,162516,165561,163806,204003,82340,252592,183704,254708,61787,186354,206232,197368,165641,197929,53914,204453,194372,165622,263747,222726,55382,53727,162925,162793,165470,166393,58976,163796,222664,186417,198420,197596,165498,163810,53785,206179,54301,197523,184070,56946,76923,165883,197581,162813,64369,58616,162814,165468,197568,84624,57540,162795,264630,88583,186314,146831,202725,206174,163772,165581,198554,52375,62354,264625,167679,184874,162519,197580,204474,53965,197437,252871,187289,264606,199949,57419,39489,198193,203943,263812,201267,57562,198433,186453,197699,189948,53718,57250,167870,52998,263655,201663,189981,158519,194400,62090,62366,162444,201656,206298,60676,263649,85114,58629,165553,204501,201660,183962,263739,76769,162878,163786,264029,182535,53465,201617,78601,166369,39486,252778,255099,264093,224526,252593,204209,52994,263620,198427,252896,59386,169161,184079,169157,198212,206258,196468,56814,146826,204549,240509,56882,186462,76861,162746,184179,58646,58639,264627,163823,223112,162524,57628,204622,59240,186319,165717,200251,40068,203933,169151,184735,162897,184042,201290,252783,54600,58615,53038,187283,162694,197407,62080,264542,165614,198125,197479,88801,198397,156250,64412,184260,54602,118018,197424,184178,169170,254806,126022,184734,203993,187169,264529,263841,61785,252861,197522,85075,56932,263289,252769,53890,254679,204530,165660,53568,165501,198416,167834,165511,56811,196459,198418,162647,224559,255102,197920,264523,184175,197463,263798,162954,197429,54097,80787,54466,61023,56952,53769,79174,204573,203917,252795,252814,196467,198511,224566,125438,198461,53457,183585,264658,38172,57393,198219,162442,60265,206215,54576,263662,165458,198491,187325,206925,252822,113650,198494,186331,186387,54279,252801,40065,201287,57421,264048,53975,187352,85101,165586,264101,97762,59263,183470,85093,156143,189967,189994,79565,198151,201653,184257,165456,204583,263232,197935,206926,56807,53954,263800,201606,198025,254763,162380,264154,75875,77758,165606,263237,64417,61148,197587,60261,165512,163783,253300,196291,206243,252849,194369,162665,252832,162578,254590,204167,264037,53962,49402,57523,62364,167671,186334,165471,183954,201381,165457,254767,53916,264607,201513,194351,198408,77764,201711,184204,52987,206919,263831,186609,165460,198403,169173,53720,166386,203954,264951,263529,163770,186386,165582,165729,54300,62365,167719,186432,55276,198507,183441,197561,198535,263672,182686,53942,187361,183930,169125,184738,87219,162785,206219,165599,223099,196247,198503,186336,165463,162451,197416,38194,182696,137180,57510,254755,184871,252779,252876,54078,79189,198471,224585,187335,75780,242191,184047,57415,79468,197398,264503,162562,201500,198401,198426,264618,59221,167607,197704,263622,206929,252856,197494,62527,198111,53887,167173,54306,126031,252847,153812,54463,263658,201282,167910,185443,53811,201691,197374,54281,197464,198227,61388,202733,184223,187365,162865,162362,186368,254691,62072,196488,166365,254803,80655,64411,198474,264031,53951,263761,197431,187276,54304,166367,186606,184208,197516,50074,197649,198181,239969,153459,76874,153705,58622,184776,54303,264770,165449,64409,198536,53943,183444,264527,76801,184049,57526,204075,204099,186330,187292,254748,183266,57636,162486,197606,123471,264616,53759,75779,197403,62474,61397,102120,183951,194370,59287,197712,254696,76884,58997,64363,184256,165670,200580,206245,122495,206261,186369,88803,254772,182663,183545,147984,242197,182641,264163,162605,187280,182658,53777,264512,56929,186450,62370,146825,126018,198429,184173,187224,39490,264703,165546,183207,206289,61110,186363,188947,183597,56937,224567,186416,201106,254718,200554,264094,79360,198465,204208,187295,264040,204523,60771,57517,264635,183974,189955,263277,53818,263857,56954,183964,60475,252812,169177,264519,263697,263177,165510,189992,196298,58951,187321,162525,162664,153686,201659,162627,263228,197700,198159,167680,223125,46677,197371,57566,252902,123536,78603,62375,264202,197487,224638,196220,198482,263854,184218,198124,206224,263848,81028,165486,242194,162599,88671,264614,76925,206225,263716,263871,200020,198136,197806,184268,162624,186624,206188,56833,186340,166370,184273,197978,196252,186440,252887,61127,197415,200227,206928,198481,61394,162801,187312,196493,222685,187339,201643,264623,197571,53968,57400,198500,165632,162603,196492,198479,162848,201399,123476,122897,165551,224530,183947,252839,184025,254794,167686,252878,183968,201328,61105,53683,165306,206260,184754,57638,194281,197562,200184,198440,203994,54570,60280,53934,263853,194384,198480,182549,166394,75835,162876,165867,183966,162816,197715,201618,183985,101759,201419,186414,182706,197716,182537,200014,263692,206178,197690,97757,76776,60734,189965,54418,204816,198452,184101,198548,206166,80907,198188,197708,57418,81025,156207,120935,88758,264055,263285,201621,187284,198529,197672,204564,264153,184766,197698,264634,194408,201630,55311,203979,187305,204452,201495,197661,186536,183960,183479,75867,186431,83908,183976,56837,187350,253374,197380,102129,202730,53716,224583,154025,184349,198531,165728,163793,54558,206221,182554,264050,186379,198552,142741,251402,197440,53850,56963,194417,195075,162969,162529,189935,186467,186474,201241,242492,223110,223123,194354,264108,197489,184058,201404,76862,40063,263890,252831,186388,198210,183722,165715,263770,263272,183991,169123,183919,61401,53971,52993,75838,186311,198409,166391,53750,252782,169122,263437,79471,97758,162600,204165,137184,80659,62079,201645,252813,252874,254758,198148,198822,263767,56831,186466,264488,252882,196483,252900,60275,61386,138195,263736,198421,165573,223094,77760,62397,137186,187314,264946,186362,198216,40072,184232,196472,77930,56878,162796,182643,53043,137179,206283,253298,183388,76863,203919,198115,254709,53019,183980,40060,163798,184777,264084,201245,264107,57527,197395,54095,56842,197541,263870,138329,167697,183455,62076,113185,162436,61800,169158,52986,264716,38193,162924,162691,186333,183279,264524,204064,162589,162955,263430,62534,166390,162982,252780,252817,186446,192580,264491,197662,186320,197667,162923,186412,200284,184235,57413,53046,165591,264146,198122,183931,125439,264611,198467,162703,198512,186313,264103,161090,58958,138336,252862,182675,198196,183957,198205,197619,200909,263441,186377,200215,80906,198445,169124,53813,252594,62085,263753,200599,165513,264548,198213,53993,183921,254783,53947,204541,235759,197666,56887,184000,192999,138190,123537,165603,263842,264489,53730,186485,198134,204111,194398,189996,264547,163808,264168,198553,165642,204618,54103,183276,223088,198838,186479,54452,80808,53820,54080,263867,189993,197569,196299,200104,263749,224521,206169,138328,162783,101776,264941,53982,197694,162384,162677,242201,58625,88802,197709,252843,197611,200569,253307,165545,182559,113189,197515,197695,222745,200564,198502,194415,264129,201421,55303,162673,254775,59306,252869,254753,55386,77882,183489,263270,165428,254710,201249,162367,197495,262993,80782,223117,198456,183929,183941,162788,102132,263763,197535,264536,252754,262990,198522,162809,201515,58619,264181,201637,198823,189959,206365,167322,80652,183932,53574,263234,162472,162662,169385,194356,189927,182670,57414,169160,195071,263240,190018,53753,201673,56942,162594,206240,197643,196289,165583,263751,184732,263275,264945,194371,198092,153318,252842,203956,200911,183256,197905,201652,167171,252909,198185,254719,56922,187298,198830,198208,153300,252828,198190,198547,252787,162590,263706,167881,264546,204014,184026,252888,183422,263778,88797,165484,55310,264950,57586,264145,254735,53011,263721,252680,182551,54566,78591,263776,62092,203998,254796,183995,57435,61130,198492,186438,84621,126024,254712,198454,206172,197674,184072,224582,197819,153691,162932,186389,254769,61801,263815,183605,197430,77759,242193,194411,165592,252903,201650,252790,201709,187286,264049,183922,198509,204168,252775,165435,201613,252881,203952,206175,80815,143079,194152,183409,200016,85077,163841,201469,242496,186397,197934,201488,167677,264141,204161,197439,113174,54302,58854,184048,263773,183719,197456,80653,234898,222644,162771,264526,222655,264710,169347,197366,57443,61782,167163,165650,204354,64389,187223,194407,184760,184764,198828,153342,196471,113177,162799,206163,53687,252820,165390,53841,194392,186374,57571,224523,184082,197584,203926,197426,197713,142738,203999,252858,147985,197470,184035,194355,183906,57444,206921,264493,206168,162770,165413,262984,165873,60763,87231,198551,186392,186339,194367,101727,184087,242190,88821,167784,206158,162422,264631,201666,206284,76772,126398,201418,59424,197421,99902,182556,242195,187247,264500,252877,197921,265024,204082,204128,55385,64362,53462,206250,202729,57417,264518,167862,162637,184163,197680,77928,263846,53981,201627,206273,57511,263535,184240,197816,206160,198404,198100,189980,206249,206363,169119,200557,204095,165635,197539,54416,182709,56834,206252,254675,186422,197391,263223,60341,62068,162621,223128,165714,192567,162874,198542,206328,264059,206292,206257,53458,201634,264496,198192,204123,263229,182687,187324,162651,59024,223091,162544,197637,204529,194403,183385,263633,198463,242196,57401,169194,223127,165626,197372,263708,56888,56832,183953,166383,186488,167752,197462,64418,77927,61125,197452,194161,57409,196465,222670,252894,53461,183965,196458,222652,182539,52369,167164,197370,126019,264544,184255,184174,186419,201636,62057,79469,53688,153687,263568,40062,165453,167200,190013,183460,263646,239995,252807,263566,75842,57530,56938,184750,187282,184207,182542,184076,189941,184028,224586,62083,113646,187303,197711,182553,197644,182705,101757,197511,263436,194360,165864,182674,57407,53066,169377,252760,184198,186408,263703,186321,194397,206183,264636,165497,186435,240506,53985,64414,162545,58642,84924,201615,240311,163902,263561,235764,206278,263834,264494,138192,198563,53685,201329,252901,198098,162672,263777,194268,183981,162482,169200,183695,254800,201612,254692,204588,204000,198434,252863,264148,252840,57392,203965,138194,57519,61128,186449,142736,263466,165579,263635,77878,206922,56836,126028,162724,183727,197656,201253,263645,53781,153305,99904,198396,184002,262985,198195,165658,156200,84627,83893,149346,60764,198107,57398,53946,201639,198112,167899,40059,183942,60258,263715,162620,62060,183780,182661,76872,182543,53958,204617,162669,254714,252681,263675,162877,263241,169380,198431,197449,264499,61119,165609,223134,75781,265017,83902,198177,88658,77776,254779,263822,263693,264615,76792,242203,183945,264535,186472,125409,162860,162377,54562,198483,165539,184229,265015,182529,239968,53061,200548,61358,183462,201345,162851,197412,162383,53578,187346,162613,197486,162821,162425,198084,263779,185447,194361,165562,200050,198394,169150,42504,197696,53573,263868,198473,162563,262989,184097,204496,83904,77762,57543,204627,197638,193003,198119,40073,183800,262992,165653,264495,198414,40061,54082,162655,254695,64413,197379,183418,186413,264157,56808,169126,187316,184275,56965,264617,167700,197705,182531,162822,162462,60462,80650,165830,57533,264505,62363,198226,167688,197570,162358,203971,204454,196477,61116,252804,198513,252796,204117,62102,186391,252917,201676,162716,183205,197554,143080,264028,187363,187345,162575,99903,162531,252823,197425,163830,165605,235758,204076,204422,222708,57587,189952,162767,252893,264105,198221,54081,183214,97765,263629,39488,167848,204615,242484,252810,204212,184165,197406,263801,165362,182702,197505,167914,194160,198435,53827,186443,162471,222668,168025,200015,254777,254678,198180,54449,204074,263650,165885,162623,254716,187337,183500,46689,165589,197308,223118,184021,264639,52990,162365,197441,264118,166380,162768,162769,223122,80656,197405,54296,264545,52372,200570,59236,53712,54461,189995,194353,161086,46660,79161,137185,194376,254742,169159,62073,197509,60263,187285,223121,53740,255100,165597,197504,264111,198449,187315,161122,165560,162395,204088,53009,224532,197544,79181,165654,198129,189989,184203,252768,198499,165610,252826,184217,239979,56940,204597,187302,162510,196475,85092,187307,162414,169379,183967,56967,200549,59020,264047,186433,165884,165886,138331,61121,79169,58994,198156,76868,60768,184036,184775,53719,53980,89446,89441,60264,254750,165541,252915,60259,252906,76768,183990,263795,61118,186360,88760,189942,242202,204357,54102,184227,204506,46659,197552,165559,198410,200559,165634,239983,264510,54556,263271,54291,197520,53746,263738,222673,162619,264137,53677,203944,196292,197923,56875,60594,197493,198466,53692,80657,200817,62075,167314,183896,263225,252798,197527,53886,184071,252884,264147,254807,77605,254680,62532,186465,252911,234899,252815,162684,60367,149348,165633,153689,61111,184013,76771,162882,204121,198484,54445,201667,204826,166374,162825,252763,53928,201658,264196,45699,255097,56943,254801,61365,254785,169171,184870,204164,204120,165621,264662,79359,54001,186352,264633,162893,79381,203951,186447,224584,223108,183998,61112,197560,61154,165429,206300,194358,197476,184181,186411,264164,183946,158522,252886,76785,169201,61796,62066,76875,62087,195085,263750,126020,148062,198487,264167,163797,264178,53806,262988,62529,198458,263722,184867,138193,49383,183909,165590,263811,156141,206927,264952,162856,77787,204172,197655,240309,194365,54572,56966,204098,53990,198400,254754,168026,165506,165593,206165,263710,204063,254843,165263,204062,60267,138191,59309,53939,254798,53588,54604,56802,185445,184031,264629,254684,189957,254751,198141,162413,184226,264026,204443,184004,162745,206244,224568,53021,52988,198572,254676,254720,88667,162396,162765,55280,187170,55302,53731,184242,184050,198207,198143,184212,197602,252800,38183,61425,254585,162802,162369,264517,184277,264190,264638,169383,264944,197413,77879,165625,197593,206923,204108,201494,263676,87185,253386,165474,182647,155395,201668,186342,162566,195077,206181,264158,264075,197409,184014,162776,38192,165266,263238,198407,165602,165467,186459,197517,53800,198154,53063,202723,200134,165645,186390,50069,186477,194418,62069,165600,165361,126025,184005,54564,61779,161091,201624,263619,252835,75872,122902,167682,163904,197612,186371,57529,252891,62082,162409,252889,194302,186409,184083,186423,133255,262987,165871,80654,263226,264087,165588,197399,64398,206358,189953,204815,183248,252875,53837,77886,200063,194399,169205,197510,77752,184278,57531,162572,264497,264514,162407,199818,183522,160757,201349,89510,120851,198406,200117,252913,204475,153960,206170,240508,263273,263667,77881,204813,53871,186376,165557,55383,197401,53974,58978,263634,184872,206302,182690,206918,62067,184225,197565,197524,162671,223095,162553,252803,54425,198455,186375,201497,183977,166377,265031,197658,198183,38174,53060,264942,200573,263847,198469,264543,242460,54462,264038,101761,62077,252797,85091,264696,204205,155411,53032,57534,78587,206360,203931,167709,162416,252873,183926,75871,162622,153299,198557,88798,263794,57405,200551,204081,197646,204600,187329,167916,54289,198026,263233,183317,201242,79162,183979,194286,84904,198439,264486,56838,97764,187269,162515,197878,62359,252825,83586,186395,252679,197697,196464,196469,57434,160801,182648,264102,58640,198197,165594,187358,62099,39491,62360,57420,183939,183948,153311,186441,184051,165652,187349,186398,201628,162942,194346,252821,198834,183589,184241,55312,194389,40071,263810,201608,79560,56874,165616,204619,196495,197814,88796,234902,78582,53973,196494,183928,165829,52997,184228,206242,206920,80651,196461,102131,206291,252853,154006,187327,186381,165566,77618,54464,53819,57565,263805,49398,242491,224476,263809,57625,264699,183394,162537,88804,204574,197428,201640,203928,167726,198555,186470,201622,198432,162410,254774,198462,204100,122899,57520,165450,263274,54299,196491,197985,264123,206161,162941,254645,201690,223101,64399,167902,162909,263433,162503,206913,254743,252767,165673,53893,197719,194402,184264,53040,263765,196476,239802,57396,182649,53012,183204,224522,183206,187310,165638,59301,56928,199950,204621,186337,124495,75841,201257,197645,165875,163851,53957,64415,56884,126029,182683,204058,254797,262991,53587,189977,169172,198515,160799,162824,57627,123945,165448,263543,197807,198549,38175,61117,239957,194293,186457,196466,186458,182720,165667,56805,201626,62377,162700,83587,49406,162528,182540,162390,198450,167817,243589,183236,252838,198411,184065,201243,187161,55309,62387,204085,60270,197919,133247,254592,50070,252757,54599,201611,198163,197692,203990,252829,198486,61115,204562,254731,58630,203953,201523,120937,242189,263772,197566,182536,184186,165699,264116,61103,76775,53765,194374,198147,165540,58965,75865,78581,135032,184246,186415,224529,264036,53926,197553,196478,187277,50075,60563,186378,264133,169399,198510,254584,194276,252912,167162,186612,186380,186401,200044,182534,56843,183978,263737,187323,76876,262982,53984,198425,162812,263762,162866,166384,184006,162607,197650,254536,53953,224525,224519,165631,83890,169121,201633,167355,197531,206259,197620,186428,264180,198086,201657,53883,197546,201477,165537,88576,182650,263671,165741,184778,53065,162527,197701,203966,254756,62374,165584,186402,201265,234901,263442,194288,40074,133254,198516,196295,199951,186478,263280,182550,198443,53064,254802,204214,87221,40064,264530,201671,197572,197614,57535,186476,264521,263231,264791,53018,125405,264492,264091,58614,165730,254728,162642,167791,197830,53713,183904,162729,251398,253395,80783,162423,263824,186405,165301,204046,49399,142735,183553,204089,204607,263520,183925,252860,200565,201332,254739,183360,264115,264487,53944,81027,263698,62055,79373,162836,133250,254747,183232,201674,200018,201672,206256,194394,263227,80784,53913,184064,264539,162879,196294,206230,197693,54417,263519,186367,201635,196245,165391,62352,186332,56839,62526,75844,198101,252674,186448,206162,165555,187156,264620,195073,88805,165462,252673,123538,204204,183923,193005,252857,197933,162930,169376,187319,184269,156131,198091,165649,162424,165388,162875,204078,253354,184092,162687,84625,187334,187166,187165,156140,196460,204215,183988,53936,153559,197710,197800,64400,186418,76820,39484,252677,183955,166385,62104,78774,162714,202728,254762,198444,183949,162463,206364,252805,252833,197483,198131,40044,202731,263631,206222,53885,169195,187322,60268,197922,162652,184873,53773,56840,263379,53945,125403,198174,252898,254693,184790,184238,254782,163849,162417,198149,165607,81029,224537,198214,264122,62530,263727,184054,76924,198170,264501,89442,264502,254690,189988,263438,186407,62362,78596,197537,165608,76774,165438,263735,202726,263178,153298,197608,263744,187262,198089,263637,162446,162681,53905,53754,57439,197402,53904,184039,198495,201501,163809,204500,201496,197500,184236,252755,56921,53053,53931,165465,183356,184216,162845,206177,254724,192565,186406,183920,252895,54292,198485,197961,206287,167336,198398,183724,62520,55275,206204,61799,264541,184027,197831,79172,184172,42508,162658,263807,189958,254688,264090,57626,53029,264498,61389,198161,184865,187317,198498,264100,162901,186383,197702,183927,169381,252846,194357,162709,156130,56810,138202,62058,198524,254792,264179,167898,201677,252765,198405,223106,142746,206313,39884,56931,263825,262983,97759,196300,184105,167875,165552,197594,64410,53039,162479,56809,165836,165469,252867,148210,184259,197460,200567,252770,162721,165575,203964,163837,197434,197621,53051,59217,206914,186420,165433,165419,201708,61107,197585,57860,54571,252855,201649,169191,204625,75777,160760,163838,165655,53013,186341,52370,201620,123669,264052,263783,149359,223119,187278,206184,239982,255002,204084,254765,158524,186437,77603,126399,263806,162956,254844,201380,197597,196210,165659,263686,183532,60260,75778,184024,53734,79186,264525,166366,54290,239960,162571,163907,263175,126023,167615,64401,184003,263639,102119,162455,201625,186461,62094,54099,204628,82329,254776,149357,201665,182701,197706,186385,194379,162361,234900,163790,57564,198459,169202,57521,200562,196479,57537}'::bigint[]))
14. 166.750 667.000 ↑ 6.2 4 83,375

Append (cost=4.15..17.99 rows=25 width=35) (actual time=0.006..0.008 rows=4 loops=83,375)

15. 0.000 83.375 ↓ 0.0 0 83,375

Bitmap Heap Scan on po_monthly_flart (cost=4.15..8.18 rows=1 width=34) (actual time=0.001..0.001 rows=0 loops=83,375)

  • Recheck Cond: (id_tseries = ((date_trunc('month'::text, (('now'::cstring)::date)::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval))
  • Filter: ((id_enterprise = 83) AND (po_proj_sub_infra.id_infra_instan = id_infra_instan))
16. 83.375 83.375 ↓ 0.0 0 83,375

Bitmap Index Scan on index_monthly_to_id_tseries (cost=0.00..4.15 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=83,375)

  • Index Cond: (id_tseries = ((date_trunc('month'::text, (('now'::cstring)::date)::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval))
17. 416.875 416.875 ↑ 6.0 4 83,375

Index Scan using po_monthly_flart_infra_tseries_ent on po_monthly_flart_83 (cost=0.45..9.81 rows=24 width=35) (actual time=0.004..0.005 rows=4 loops=83,375)

  • Index Cond: ((id_enterprise = 83) AND (id_infra_instan = po_proj_sub_infra.id_infra_instan) AND (id_tseries = ((date_trunc('month'::text, (('now'::cstring)::date)::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval)))
18. 0.038 0.098 ↑ 1.1 416 1

Hash (cost=10.76..10.76 rows=476 width=4) (actual time=0.098..0.098 rows=416 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
19. 0.060 0.060 ↑ 1.1 416 1

Seq Scan on po_organization org (cost=0.00..10.76 rows=476 width=4) (actual time=0.006..0.060 rows=416 loops=1)

Planning time : 86.769 ms