explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7MtT

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 306.999 ↓ 0.0 0 1

Sort (cost=470,222.25..470,222.27 rows=10 width=44) (actual time=306.998..306.999 rows=0 loops=1)

  • Sort Key: (sum(po_monthly_flart.nu_low_flart_files)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.004 306.987 ↓ 0.0 0 1

Limit (cost=470,221.96..470,221.98 rows=10 width=44) (actual time=306.986..306.987 rows=0 loops=1)

3. 0.010 306.983 ↓ 0.0 0 1

Sort (cost=470,221.96..470,222.09 rows=53 width=44) (actual time=306.982..306.983 rows=0 loops=1)

  • Sort Key: po_project_sub.id_project, (sum(po_monthly_flart.nu_low_flart_files)) DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.004 306.973 ↓ 0.0 0 1

GroupAggregate (cost=470,218.69..470,220.81 rows=53 width=44) (actual time=306.972..306.973 rows=0 loops=1)

  • Group Key: po_project_sub.id_project
5. 0.012 306.969 ↓ 0.0 0 1

Sort (cost=470,218.69..470,218.82 rows=53 width=24) (actual time=306.968..306.969 rows=0 loops=1)

  • Sort Key: po_project_sub.id_project
  • Sort Method: quicksort Memory: 25kB
6. 0.004 306.957 ↓ 0.0 0 1

Nested Loop (cost=44,272.90..470,217.17 rows=53 width=24) (actual time=306.956..306.957 rows=0 loops=1)

7. 0.003 306.953 ↓ 0.0 0 1

Hash Join (cost=44,272.61..469,691.88 rows=407 width=24) (actual time=306.952..306.953 rows=0 loops=1)

  • Hash Cond: (po_monthly_flart.id_infra_instan = po_proj_sub_infra.id_infra_instan)
8. 0.010 306.950 ↓ 0.0 0 1

Append (cost=6,932.15..426,076.51 rows=716,665 width=24) (actual time=306.949..306.950 rows=0 loops=1)

9. 95.961 158.859 ↓ 0.0 0 1

Bitmap Heap Scan on po_monthly_flart (cost=6,932.15..229,193.71 rows=337,424 width=24) (actual time=158.858..158.859 rows=0 loops=1)

  • 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)
  • Heap Blocks: exact=81,274
10. 62.898 62.898 ↓ 1.0 372,299 1

Bitmap Index Scan on index_monthly_to_id_tseries (cost=0.00..6,847.80 rows=370,579 width=0) (actual time=62.897..62.898 rows=372,299 loops=1)

  • Index Cond: (id_tseries = ((date_trunc('month'::text, (('now'::cstring)::date)::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval))
11. 84.781 148.081 ↓ 0.0 0 1

Bitmap Heap Scan on po_monthly_flart_83 (cost=8,227.57..196,882.80 rows=379,241 width=24) (actual time=148.080..148.081 rows=0 loops=1)

  • 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)
  • Heap Blocks: exact=76,417
12. 63.300 63.300 ↑ 1.0 372,299 1

Bitmap Index Scan on po_monthly_flart_83_id_tseries_idx (cost=0.00..8,132.76 rows=379,241 width=0) (actual time=63.299..63.300 rows=372,299 loops=1)

  • Index Cond: (id_tseries = ((date_trunc('month'::text, (('now'::cstring)::date)::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval))
13. 0.000 0.000 ↓ 0.0 0

Hash (cost=37,337.44..37,337.44 rows=242 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..37,337.44 rows=242 width=8) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using index_po_proj_sub_infra_id_project_sub on po_proj_sub_infra (cost=0.42..8,437.58 rows=12,602 width=8) (never executed)

  • Index Cond: (id_project_sub = ANY ('{184103,264124,162824,77767,165893,59212,264049,162825,54289,265050,57628,198430,264073,39487,57550,61110,62077,162828,62354,54417,165668,79164,162365,264074,198513,54290,162374,264125,55311,137501,162427,206308,264757,222658,264326,206370,182533,182544,186314,206175,182534,182548,206318,186313,189934,264763,182541,182539,182536,182535,182538,187223,182537,201634,182543,186312,252754,189933,182542,182540,222643,264426,204496,263619,222614,204501,264407,263620,264444,61781,54571,53767,87185,53736,196246,61782,77939,138328,138329,54281,76820,77927,204064,263520,187286,206278,77757,77761,169080,206218,253329,206192,169081,264781,264398,264778,206210,264390,38179,169082,169083,77881,76871,197423,197424,76869,206262,206314,206196,264745,263526,54282,62520,200547,194349,189935,252755,201488,165393,204502,263275,204469,204470,204471,204070,61118,64407,62094,58991,252756,165395,222752,62378,254752,165397,253379,198397,263684,264945,184227,162922,206915,165669,263685,263686,184181,206191,165399,186535,265016,263276,184283,264649,184091,264334,184163,61103,252757,264679,184194,239990,184257,184281,186602,165403,184205,60438,201609,156250,264683,264386,184253,186603,184204,165407,165408,165409,165410,153342,201490,206916,184262,162843,165412,165413,184225,184211,184246,186604,184237,184174,64362,254692,165419,253380,60594,184232,184256,184266,184173,184208,183963,186605,184282,184209,184178,165422,184276,184165,263277,184284,186606,53719,64401,58951,53050,57624,165427,264768,264423,162434,263687,40060,187345,54103,53769,162436,265045,263688,80656,57531,84904,76872,79187,187346,206251,263278,204618,222686,204422,264705,264361,53031,263689,54283,162437,252595,62091,76866,137178,184867,187337,184868,77763,184869,184870,187339,252758,264486,239991,263690,76771,169084,88796,198514,187340,53771,61119,264696,264335,79189,77760,162845,263691,85077,142738,88797,62088,40042,77770,165263,165428,264733,264724,264387,264391,53773,162440,263692,197369,53754,162442,162443,162444,263693,201661,201662,206317,264313,264367,187328,156140,53724,53725,56952,76902,206282,253371,198432,162446,264126,196477,252759,198172,198175,198164,196481,264691,197370,155370,198176,197396,197400,187001,196486,198168,198174,196476,197395,198171,197371,198167,189937,196491,198182,198170,196480,198169,252760,198173,239992,264344,222706,239978,53009,187262,53756,187362,40068,206279,263543,53777,264712,264368,59240,62474,240508,240509,64359,75840,184068,165429,64358,184230,201665,184224,165431,156246,184260,165433,184186,201641,264686,264362,265049,187285,222701,204811,204443,222702,204812,204445,239979,64412,162447,52715,57444,53780,187326,264534,53781,57409,162846,264075,54558,53782,53784,61784,57535,57413,198495,264027,56814,264710,264369,264718,263623,264487,252761,239980,254713,242489,264697,264345,264714,264392,162847,162848,162849,162850,53755,184278,186607,169085,54079,165435,204205,64408,254771,252762,222728,184105,264648,184101,264327,165436,138337,81030,146824,57523,62080,53785,200015,198434,54445,162451,77762,138331,264699,264346,162851,162852,263536,254714,264704,242490,165437,184085,184079,184207,224567,184255,204472,154058,184267,184239,162452,162453,184235,184217,184228,184275,184191,184216,165438,162853,156247,184277,206296,254791,253372,264700,264448,54562,206274,61121,77605,77885,206300,253373,206261,254772,253374,40062,88657,77753,53788,53793,53794,198515,187354,38191,53795,264800,264314,162455,87219,146825,126028,64403,162854,126020,162855,38194,165301,39884,57637,222687,254796,204619,253375,204423,61785,39503,206226,264729,264370,187363,184176,264662,263279,200016,162923,263862,198427,263863,264540,126021,53568,60272,252763,222729,89523,56965,57534,61122,263864,62090,54102,160759,254691,252764,160757,194374,194370,222730,204392,53679,206252,252765,222731,206254,53757,80654,187336,81028,57394,138341,189938,165440,42504,53797,57419,162459,53578,54425,206239,253376,198490,263280,84619,54420,198408,263865,264523,162462,263866,162463,60273,126029,197442,197521,206288,76764,162467,263867,187365,38181,53753,187310,162856,263868,52320,162857,263869,53799,53800,53801,254773,253377,77758,198475,187351,54461,264727,264371,206917,190017,252766,184261,239967,137179,57520,61786,53049,138330,187364,142737,39484,60274,206256,253378,79468,206188,252767,222732,206216,53806,198524,76787,169086,165442,263281,137547,222703,204813,204446,53807,162471,264076,254585,184168,223106,50070,263282,162858,206266,254536,142751,200017,200014,262980,252768,200548,262981,222672,187303,57540,187320,162472,53030,162473,262982,262983,200022,184223,76873,57570,264795,264408,138193,80782,200023,262984,58617,77604,206918,206173,239968,239969,206375,222673,197464,197405,198138,197417,198139,197401,197414,197416,197412,197403,198145,197410,198142,197413,198127,198137,198150,198144,197409,197406,198187,198140,198152,198153,189171,198134,198128,197475,198141,197402,224405,198148,197418,198131,197415,197411,198135,198146,198151,198130,197408,197404,198126,198133,197407,198191,197419,198188,197472,197477,197483,197481,197484,197422,197474,197420,198185,197421,62376,61104,61105,77928,58646,224537,58994,184215,252769,186534,222674,186536,165446,61108,264676,200020,262985,264372,57571,264685,200019,262986,252770,239970,262987,201610,187321,187322,187305,200025,58634,58636,58633,187304,206919,262988,186317,201648,262989,200013,165447,61142,165448,162475,206243,263537,206289,264427,162924,264127,162476,162477,165449,75841,198480,264944,252771,264682,194373,222650,222675,194386,265029,263538,254756,252772,194372,222676,254757,194391,253321,265028,194376,263539,254758,194390,253322,264661,254759,194423,253323,264442,265027,263540,265026,194383,263541,194393,194375,265025,263542,156207,263189,264399,254732,253312,187357,184222,184196,265024,206920,263284,204539,252773,222677,200026,184263,200549,197379,197560,197597,197571,197562,197561,197607,169087,162479,165450,206195,206272,264717,264412,264706,264363,254715,253313,254716,242495,264701,264355,206184,263285,165451,197555,254797,204620,222688,204424,253314,264077,38188,169088,162925,264128,165453,264726,206207,165452,201663,264364,206756,53726,206270,206271,201667,201666,198479,168025,182550,182549,252774,186319,222678,49402,165454,162482,264129,264542,138191,57862,42505,264668,264432,162483,206292,263535,222689,204621,204425,252775,206215,222679,60275,254774,253315,56878,264744,153812,264719,252776,206203,196483,197615,264437,264315,222680,162486,264546,187324,206320,138190,80807,78601,78604,60641,56802,49382,122495,162860,162861,79359,254792,253316,162487,264078,187314,61787,198162,54301,81025,264715,264413,254793,253317,56806,76768,198092,197556,206186,263289,198400,264079,187329,197492,184059,254689,253318,264678,265023,184187,263290,264404,186608,162489,264673,194378,252777,239975,252778}'::integer[]))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using po_project_sub_id_project_sub_key on po_project_sub (cost=0.42..2.28 rows=1 width=8) (never executed)

  • Index Cond: (id_project_sub = po_proj_sub_infra.id_project_sub)
  • Filter: (id_project = ANY ('{15905,9194,2719,2720,10187,10189,9695,9694,10470,10472,10498,10543,15829,15831,15832,15833,15835,15836,15837,15838,15839,15842,15904,37095,37566,74267,74268,74269,74270,74271,74272,74275,74276,37299,74277,74279,74278,74280,38418,38914,38944,38945,38946,38947,38948,38949,38950,38951,39116,39120,39122,39126,39127,39129,39132,39133,39137,39139,39140,39144,39145,39149,39152,39157,39165,39166,39167,39168,39169,39170,78309,78308,78356,78357,78358,78359,78360,78361,78362,78363,78364,78365,78366,78368,78369,78370,78371,78372,78373,78374,78379,78380,78381,78382,78383,78384,78385,78386,78387,78388,78389,78390,78391,78310,78311,78367,78375,78376,78377,78378,78392,78393,78394,78395,78396,78397,78398,78399,78400,78401,78402,78403,78404,78405,78406,78407,78408,78409,78410,78411,78412,78413,78415,78416,78417,78418,78419,78420,78421,78422,78414,78423,47250,47277,47370,47371,47452,47923,47517,47544,47548,47574,47656,47658,47700,47704,47706,47707,47708,47754,47758,47767,47775,47783,47784,47793,47820,47844,47853,47857,47898,47909,47924,47925,47926,47927,47928,47940,47941,47942,47943,47944,47945,47946,47951,47952,47956,47957,47962,47963,47964,47965,47976,48014,48016,48017,48019,48021,48036,48061,48062,48098,48111,48112,48227,48286,48467,49652,78638,78639,78640,50236,50287,50293,50309,79220,79221,79222,79223,79224,79225,79226,79228,79229,79230,79231,79232,79233,79234,79237,79238,79239,79240,79241,79242,79243,79244,79245,79246,79247,79248,79249,79250,79251,79252,79227,51360,51361,51362,51363,51403,51521,51520,51526,51530,51531,51540,51845,51875,51928,51910,51721,51909,51884,51843,51859,51866,51907,51920,51952,51953,51954,51955,51956,51957,51958,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51970,51971,51972,51973,51975,52031,52048,52052,52112,52137,52142,52145,52746,52270,52271,52277,52286,52300,52301,52305,52306,52307,52309,52310,52315,52316,52317,52324,52325,52326,52327,52328,52747,52334,52342,52343,52347,52348,52350,52351,52352,52353,52354,52355,52356,52357,52358,52359,52360,52361,52362,52363,52364,52365,52366,52367,52368,52369,52748,52370,52371,52372,52373,52374,52375,52749,52430,52750,52527,52533,52534,52548,52553,52554,52555,52556,52574,52577,52583,52591,52603,52606,52609,52618,52622,52624,52626,52636,52639,52642,52643,52646,52669,52672,52674,52678,52683,52693,52726,52728,52729,52730,52731,52732,52733,52738,52739,52740,52741,52742,52744,52753,52765,52828,52835,52875,52874,52878,52893,53168,53450,54351,54904,54905,54907,58741,58745,57036,57037,57038,57039,57094,57193,57212,57214,57237,57238,57239,57240,57242,57254,57255,57258,57265,58749,57287,57295,57300,57301,57311,57317,57345,58750,57351,57352,57353,57354,57355,57356,57357,57358,57359,57360,57361,57362,57363,57365,57366,57370,57372,57373,57381,57383,57384,57386,57399,57402,57403,57418,57419,57426,57427,57436,57439,57447,57460,57461,57462,57463,57464,57465,57466,57467,57468,57469,57470,57471,57472,57474,57475,57476,57488,57489,57490,57491,57492,57493,57494,57495,57496,57497,57500,57501,57502,57503,57538,57539,57541,57542,57543,57544,57545,57546,57547,57548,57549,57550,57555,57558,57559,57607,57647,58751,57691,57795,57797,57802,57971,57972,58106,58107,58108,58109,58110,58111,58112,58113,58114,58115,58116,58117,58118,58119,58120,58121,58122,58123,58124,58125,58126,58127,58128,58129,58130,58131,58132,58133,58134,58135,58136,58137,58138,58139,58140,58141,58142,58143,58144,58145,58146,58147,58148,58149,58150,58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171,58172,58173,58174,58175,58209,58210,58211,58212,58213,58214,58215,58216,58221,58222,58223,58224,58225,58231,58232,58233,58234,58235,58236,58240,58242,58255,58257,58259,58265,58274,58275,58276,58277,58320,58325,58361,58362,58363,58364,58365,58366,58367,58376,58377,58382,58386,58387,58404,58407,58408,58409,58442,58649,58661,58717,58697,58681,58711,58654,58699,58709,58653,58746,58667,58747,58759,58646,58648,58650,58651,58652,58655,58657,58659,58660,58662,58663,58664,58665,58666,58669,58671,58672,58673,58674,58675,58676,58678,58679,58682,58683,58684,58685,58686,58689,58694,58696,58704,58708,58710,58713,58714,58716,58718,58719,58722,58748,58740,58744,58752,58753,58754,58755,58756,58757,58758,58760,52936,58762,58765,59540,59560,59582,59583,59584,59585,59586,59587,59588,59589,59590,59591,59592,59595,59596,59600,59538,59602,59612,59613,59614,59615,59616,59617,59618,59619,59620,59621,59622,59624,59643,59644,59645,59646,59647,59649,59651,59653,59655,59659,59663,59664,59665,59666,59668,59669,59675,59678,59683,59684,59685,59687,59689,59691,59692,59693,59694,59696,59698,59708,59702,59703,59705,59707,59777,59810,59867,59704,59706,59709,59743,59769,59809,59813,59858,59922,59710,59792,59892,59712,59713,59814,59856,59907,59714,59715,59716,59717,59718,59719,59720,59721,59722,59723,59724,59725,59728,59730,59731,59768,59838,59843,59845,59857,59859,59861,59876,59885,59909,59911,59921,59923,59726,59853,59727,59729,59753,59754,59808,59815,59820,59824,59827,59875,59732,59733,59759,59760,59762,59801,59844,59847,59868,59890,59891,59901,59739,59797,59740,59742,59744,59745,59780,59793,59860,59862,59881,59888,59746,59905,59752,59755,59757,59758,59794,59796,59807,59816,59837,59840,59854,59895,59929,59761,59766,59818,59836,59879,59767,59835,59852,59817,59898,59775,59782,59902,59926,59783,59784,59832,59887,59906,59908,59829,59873,59910,59795,59800,59834,59806,59904,59811,59812,59846,59819,59839,59842,59848,59821,59825,59826,59828,59833,59841,59850,59851,59863,59864,59865,59869,59870,59871,59889,59900,59903,59916,59924,59872,59899,59874,59880,59886,59894,59896,59897,59912,59913,59914,59927,59981,59988,59989,59990,59991,59995,59997,60142,59999,60000,60001,60002,60003,60004,60005,60007,60008,60009,60010,60011,60012,60013,60015,60016,60017,60018,60019,60020,60021,60022,60023,60024,60025,60026,60027,60028,60029,60030,60031,60032,60033,60034,60035,60036}'::integer[]))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using po_project_pkey on po_project (cost=0.29..1.28 rows=1 width=4) (never executed)

  • Index Cond: (id_project = po_project_sub.id_project)
  • Filter: (id_organization = ANY ('{349,193,195,203,191,204,196,197,198,199,133,331,350,126,190,272,292,339,290,287,342,333,340,347,337,341,351,356,355,354,353,192,194,366,352,367,368,369,363,362,361,373,398,402,374,377,376,397,386,375,378,396,385,383,379,384,380,381,382,424,403,399,401,400,338,288,562,563,564}'::integer[]))
Planning time : 33.792 ms
Execution time : 307.580 ms