explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3TaT

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 483.438 ↓ 0.0 0 1

Sort (cost=622,954.07..622,954.10 rows=10 width=44) (actual time=483.437..483.438 rows=0 loops=1)

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

Limit (cost=622,953.78..622,953.80 rows=10 width=44) (actual time=483.393..483.393 rows=0 loops=1)

3. 0.017 483.391 ↓ 0.0 0 1

Sort (cost=622,953.78..622,960.31 rows=2,612 width=44) (actual time=483.390..483.391 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 483.374 ↓ 0.0 0 1

GroupAggregate (cost=622,558.25..622,897.33 rows=2,612 width=44) (actual time=483.373..483.374 rows=0 loops=1)

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

Sort (cost=622,558.25..622,594.11 rows=14,342 width=24) (actual time=483.369..483.370 rows=0 loops=1)

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

Hash Join (cost=191,530.33..621,568.09 rows=14,342 width=24) (actual time=483.357..483.358 rows=0 loops=1)

  • Hash Cond: (po_monthly_flart.id_infra_instan = po_proj_sub_infra.id_infra_instan)
7. 0.009 483.354 ↓ 0.0 0 1

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

8. 187.696 252.328 ↓ 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=252.327..252.328 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
9. 64.632 64.632 ↓ 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=64.631..64.632 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))
10. 167.338 231.017 ↓ 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=231.016..231.017 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
11. 63.679 63.679 ↑ 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.678..63.679 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))
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=184,491.83..184,491.83 rows=8,508 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=175,475.52..184,491.83 rows=8,508 width=8) (never executed)

  • Hash Cond: (po_proj_sub_infra.id_project_sub = po_project_sub.id_project_sub)
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on po_proj_sub_infra (cost=0.00..7,266.71 rows=443,871 width=8) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash (cost=175,441.92..175,441.92 rows=2,688 width=8) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on po_project_sub (cost=0.00..175,441.92 rows=2,688 width=8) (never executed)

  • 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[]))
Planning time : 28.929 ms
Execution time : 484.692 ms