explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TuG6

Settings
# exclusive inclusive rows x rows loops node
1. 52.330 1,903.868 ↑ 1.2 4,808 1

Gather (cost=14,064.80..287,807.65 rows=5,842 width=1,888) (actual time=222.081..1,903.868 rows=4,808 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 1.501 1,851.538 ↑ 1.4 2,404 2 / 2

Hash Left Join (cost=13,064.80..286,223.45 rows=3,436 width=1,888) (actual time=195.122..1,851.538 rows=2,404 loops=2)

  • Hash Cond: (test_case_version.last_updated_by_id = x61.id)
3. 1.621 1,849.444 ↑ 1.4 2,404 2 / 2

Hash Left Join (cost=12,979.40..286,129.02 rows=3,436 width=1,809) (actual time=194.478..1,849.444 rows=2,404 loops=2)

  • Hash Cond: (test_case_version.created_by_id = x78.id)
4. 1.822 1,846.853 ↑ 1.4 2,404 2 / 2

Nested Loop Left Join (cost=12,894.00..286,034.59 rows=3,436 width=1,762) (actual time=193.427..1,846.853 rows=2,404 loops=2)

5. 0.349 1,450.819 ↑ 1.2 798 2 / 2

Merge Left Join (cost=12,893.57..276,857.05 rows=939 width=1,429) (actual time=192.494..1,450.819 rows=798 loops=2)

  • Merge Cond: (test_case_version.id = x37.test_set_version_id)
6. 17.478 1,449.555 ↑ 1.2 798 2 / 2

Merge Left Join (cost=12,698.98..276,647.13 rows=939 width=1,393) (actual time=191.573..1,449.555 rows=798 loops=2)

  • Merge Cond: (test_case_version.id = test_case_version_custom_value_aggregator.test_case_version_id)
7. 1.889 9.236 ↑ 1.2 798 2 / 2

Sort (cost=12,698.55..12,700.89 rows=939 width=1,349) (actual time=8.988..9.236 rows=798 loops=2)

  • Sort Key: test_case_version.id
  • Sort Method: quicksort Memory: 1,853kB
  • Worker 0: Sort Method: quicksort Memory: 864kB
8. 5.053 7.347 ↑ 1.2 798 2 / 2

Parallel Bitmap Heap Scan on test_case_version (cost=5,026.67..12,652.18 rows=939 width=1,349) (actual time=2.439..7.347 rows=798 loops=2)

  • Recheck Cond: (id = ANY ('{268258,272712,272710,272709,272384,272387,272413,272414,272418,272419,272703,272704,272376,272379,270919,270909,270968,270957,270950,272064,272657,208146,208147,208148,208163,208280,210150,210151,260601,259629,246165,246191,246283,246284,247296,247291,247320,247321,250960,250962,250968,250967,250563,251923,257850,257849,257848,254254,215875,256040,256061,257823,257883,257881,257880,257894,257889,257868,210108,210114,208136,208070,245865,168328,247265,239959,217611,217612,217208,217267,217355,217362,244292,245277,245276,245298,195180,195176,195179,179699,179687,179686,179684,179678,179604,67664,67662,67689,67681,67693,67656,67797,67702,67706,67736,67740,67806,67813,71627,71585,71704,75288,75293,75209,75245,75251,75336,69862,69877,69870,69925,69953,70046,70270,70287,70200,70225,70454,70163,68080,65122,65125,65129,65178,65184,65199,65119,65268,65272,68114,67230,67257,67326,67341,64858,64864,64877,64882,64886,64999,64903,64908,64924,64917,64932,65004,65009,64743,65586,65598,65643,65658,65663,65669,65670,65675,65674,65677,65684,65685,65680,65690,65604,65614,65618,65609,65621,65627,65630,65635,65701,65706,65711,65723,65729,65719,68102,68201,68206,68211,68111,68169,68173,68177,68174,68182,68248,68259,68253,64451,64454,64458,64400,64406,64414,64416,72157,72229,72330,72144,72169,72277,72325,72137,72164,72224,72220,72266,72272,72319,72053,72232,72072,72044,72173,72135,72130,72227,72036,72120,72158,72216,72067,72063,72041,72125,72168,72162,72219,72296,72290,72390,72315,72312,72476,72480,72404,72438,75977,75903,75931,75936,75851,75865,75983,75910,75869,75915,75919,75957,75847,75882,75825,75829,75962,75852,75890,75968,75924,75856,75895,75834,75911,75947,75875,75820,78215,78367,78371,78302,78275,78291,78296,78298,75973,75926,75844,75861,75899,78219,78378,78301,78307,78280,78285,75839,72285,72383,72308,72470,72427,72432,75952,75842,75878,75907,75870,75815,75838,75902,75943,75864,75810,75833,75939,75897,75805,75828,75859,75933,75823,68107,68105,68015,68020,68199,68147,64090,64150,67214,67184,66976,66985,66926,67028,67036,67033,67031,67084,67092,69075,69079,69077,69083,69144,69204,69258,69262,68617,68592,76101,76119,248748,248747,78505,260125,66237,66240,66267,66279,66272,66286,66386,66380,66394,66311,66321,66297,221980,210751,210750,210755,210331,72976,259369,127344,66594,66523,66611,66670,66603,76146,76170,76192,76265,72889,73067,73016,68788,68794,68793,68882,68836,68841,68916,68920,68796,68799,68887,68895,68890,68800,68804,68809,68849,68846,68854,68925,68930,68785,68783,68789,68780,68872,68877,68827,68831,68910,68905,68863,66495,66490,66575,66531,66539,66545,66556,66639,66644,65727,65780,65790,65754,65803,65814,65816,65848,65853,66388,66392,66455,66465,66461,66436,66439,66441,66444,66449,66518,66525,66530,66522,76031,65777,65739,66226,66232,66254,66260,66275,66270,66375,66301,66291,65650,65671,65715,65708,65778,65779,65718,65747,66139,66161,65649,65689,65693,65632,65735,65394,65899,65849,65870,65903,66395,66393,65687,65786,65792,65721,65752,65753,65756,65758,68193,68187,68328,68335,68245,68240,68255,68251,68270,68275,68324,68266,68247,68319,68212,72269,68176,68232,65523,65522,65527,65528,65537,65539,65544,65547,65549,65550,65554,65555,65559,65561,65563,65567,65568,65578,65570,65585,65589,65588,65596,65595,65597,65513,65518,65517,65640,65641,65645,65648,65647,65653,65652,65657,65656,65661,65665,65667,65672,65678,65682,65688,65692,65600,65603,65606,65612,65616,65620,65625,65628,65633,65634,65637,65639,65287,65283,65290,65365,65339,65354,65358,65411,65417,65802,65655,65659,65664,65668,65676,65681,65686,65695,65764,65769,65713,65720,65722,65726,65728,65732,65734,65736,65755,65759,68577,68690,68603,68732,72603,72601,72606,72678,72806,72769,72794,68581,68607,68547,68552,68557,68567,68562,68587,68582,68642,68654,68657,68667,68688,68694,68596,68591,68702,68711,68719,68739,68736,68745,68572,68674,68682,68598,68753,68757,68727,66246,66261,66203,66341,65962,65969,65974,66003,66000,66005,66009,66071,66086,68343,68298,68373,68386,68338,68290,68368,68382,68441,68437,68364,68377,72468,72567,72450,72462,72524,72563,72455,72607,72602,72520,72555,72509,72547,72453,72439,72590,72514,72552,72430,72447,72585,72505,72457,72445,72596,72424,72441,72542,72488,72412,72434,72572,72531,72493,72498,72580,72537,72477,72560,72386,72473,72420,72513,72556,68451,65819,65485,65540,65548,65605,67427,67460,70839,67439,65254,68305,68310,68361,68321,68325,68268,68272,68428,68356,68363,65763,65765,65768,65770,65774,65773,65796,65702,65707,65712,65733,65738,65743,65801,65804,65813,65694,65760,70674,73929,74034,70529,70538,70466,70477,70484,70499,70493,70611,70618,70635,70626,70653,70667,70662,70555,70548,70563,70730,70725,70740,70735,70746,70670,80321,76785,76669,76712,76703,76663,76699,76729,76684,76695,76649,76714,76759,76654,76658,76691,76694,76770,76700,76705,76720,76726,76763,76773,76708,80335,80413,73913,73904,73918,73933,73847,73842,73838,73858,73856,73851,73869,73868,73863,73861,73879,73886,73884,73880,73897,73895,73893,73890,73945,73944,73939,73955,73953,73950,73949,73967,73965,73962,73960,73958,73979,73978,73974,73973,73969,73988,73987,73983,73982,73997,73993,73992,74006,74002,74016,74011,74026,74020,76735,70402,70410,70422,70394,70513,70506,70522,70520,70516,70532,70546,70431,70441,70458,70450,70460,70470,70488,70482,70496,70613,70604,70605,70619,70630,70644,70639,70649,70560,70588,70582,70595,70597,70710,70705,70721,70716,70700,70689,70683,70696,76681,73853,67365,67976,68041,68161,65557,65505,65562,65566,65579,65508,65511,65644,65636,65521,65499,65443,65447,65642,65654,65660,65666,65696,65691,65638,65700,65703,65710,65740,65744,65487,65679,65683,65782,65714,65709,65745,65746,65749,65138,65130,65141,65140,65157,65150,65167,65161,65177,65173,65187,65198,65277,65285,65281,65296,65291,65203,65208,65210,65213,65214,65219,65218,65223,65228,65232,67796,67889,67998,65378,65386,65489,65494,65437,65438,65442,65545,65615,65068,65062,65064,65079,65078,65070,65073,65120,65123,65124,65127,65132,65147,65158,65108,65112,65116,65117,65087,65090,65092,65215,65220,65224,65229,65235,65449,65450,65506,65673,65772,65704,65741,65501,65646,65705,65750,72203,72397,72291,72231,72331,72225,72200,72388,72281,75892,75802,72193,72223,72288,72384,72327,72323,72189,72218,72186,72212,72268,72276,72207,72375,72317,72310,72381,72180,72263,72365,72305,72182,72293,72249,72170,72188,72196,72165,72297,72254,72347,72342,72175,72259,72201,72358,72301,72160,72179,72154,72287,72337,72242,75929,75922,75797,75854,75850,75886,75814,75818,72174,72149,72234,72282,72334,72226,72255,72366,72311,72422,72222,72250,72357,72415,65387,65312,69432,69508,69441,69429,73620,73725,69471,67090,73446,73535,76445,78678,78697,78622,78665,78746,78751,78627,78668,78681,78686,78670,78607,78612,78664,78650,78654,78740,78730,78735,78673,78691,78617,78660,78683,78703,76488,76588,73433,76485,69430,69546,65502,65395,65028,65029,65076,65183,65093,68092,68196,68164,68243,68071,68083,68191,68159,68167,68160,68238,72295,72214,72235,72243,72208,72336,72346,72341,72307,72302,72405,72409,68051,68061,68227,68148,68145,68155,68154,68178,68183,68233,65240,65294,65375,65371,65398,65399,65393,65315,65318,65323,65324,65329,65330,65333,65336,65338,65343,65348,65357,65359,65350,65484,65402,65403,65406,65408,65412,65414,65416,65419,65421,65424,65427,65429,65448,65453,65457,65462,65466,65474,65479,69664,73812,73807,73787,73715,73720,73731,73837,73802,73711,73721,73727,73778,73833,73829,69626,69624,69632,69630,69637,69635,69638,69643,69645,69640,69676,69724,69731,69736,69739,69719,69686,69681,69692,69861,69868,69872,69878,73438,76497,76440,76435,76481,76483,76476,76479,76581,76571,76503,76493,76421,76426,76431,76463,76466,76468,76484,76489,76471,76475,76544,76564,76554,73348,73343,73356,73350,73431,73466,73410,69197,69107,69118,69126,69122,69134,69140,69303,69308,69298,69205,69211,69235,69240,69244,66863,66867,66883,66892,66890,66814,66819,66900,66947,66799,66790,66851,66855,66865,66871,66875,66873,66881,66887,66805,66846,66927,66933,66940,68992,66682,66746,66751,66755,66714,66719,66813,69073,69254,73164,73162,73294,73229,73257,68962,68964,69056,69016,69104,65390,65446,65452,65503,75917,75846,75873,75809,78209,78205,78362,78286,78270,78294,68103,64966,65036,65045,65121,73875,73896,73940,73801,69634,69679,69596,69595,69812,65128,65165,65101,65100,67760,67672,67648,65440,65495,65441,65037,65043,65042,65105,65110,65089,65201,65265,65389,65308,65311,64936,64940,73748,73762,73822,73817,73840,73867,73876,73810,73804,73739,73752,73831,73859,69722,69789,69708,69716,69820,69947,73792,73723,73736,73843,73799,73728,73744,73820,73854,73796,73816,73850,69667,69674,69670,69737,69761,69680,69912,69678,69749,69922,73742,73757,73836,73864,73734,73747,73826,69673,69743,69768,69778,69685,69917,73784,73775,73905,73844,73860,69941,67255,67198,67251,73806,73906,73818,73815,73883,73946,76689,76643,76707,76752,76686,76677,76638,76702,76668,76685,76623,76733,76664,76667,76675,76690,76628,76737,78699,78658,78729,78780,78707,76594,76657,76640,76634,76635,76709,73811,73935,73866,73889,76661,76600,76646,76639,76711,78689,78648,78718,78772,78701,76590,76652,76629,76704,73800,73791,73885,76682,76673,76697,76633,76742,76747,78712,78734,76659,76679,76619,78694,78653,78724,78775,76666,76651,76671,76604,76608,76644,76648,76716,76662,76653,76656,76674,76615,76719,76725,73805,73797,73930,73862,70096,70190,70114,69504,69507,69539,69578,69529,69495,69494,69666,69567,69503,69534,69498,69668,69573,69524,69658,69490,69561,67046,67099,67157,69437,69514,69443,69476,69591,69586,67032,67201,67148,67171,69962,69969,69974,69972,69978,69979,69984,69983,69988,69993,69998,69990,69955,70037,70031,70045,70044,70055,70050,70066,70062,70076,70017,70027,70024,70159,70153}'::bigint[]))
  • Heap Blocks: exact=888
9. 2.294 2.294 ↑ 1.0 1,596 1 / 2

Bitmap Index Scan on test_case_version_pkey (cost=0.00..5,026.27 rows=1,596 width=0) (actual time=4.588..4.588 rows=1,596 loops=1)

  • Index Cond: (id = ANY ('{268258,272712,272710,272709,272384,272387,272413,272414,272418,272419,272703,272704,272376,272379,270919,270909,270968,270957,270950,272064,272657,208146,208147,208148,208163,208280,210150,210151,260601,259629,246165,246191,246283,246284,247296,247291,247320,247321,250960,250962,250968,250967,250563,251923,257850,257849,257848,254254,215875,256040,256061,257823,257883,257881,257880,257894,257889,257868,210108,210114,208136,208070,245865,168328,247265,239959,217611,217612,217208,217267,217355,217362,244292,245277,245276,245298,195180,195176,195179,179699,179687,179686,179684,179678,179604,67664,67662,67689,67681,67693,67656,67797,67702,67706,67736,67740,67806,67813,71627,71585,71704,75288,75293,75209,75245,75251,75336,69862,69877,69870,69925,69953,70046,70270,70287,70200,70225,70454,70163,68080,65122,65125,65129,65178,65184,65199,65119,65268,65272,68114,67230,67257,67326,67341,64858,64864,64877,64882,64886,64999,64903,64908,64924,64917,64932,65004,65009,64743,65586,65598,65643,65658,65663,65669,65670,65675,65674,65677,65684,65685,65680,65690,65604,65614,65618,65609,65621,65627,65630,65635,65701,65706,65711,65723,65729,65719,68102,68201,68206,68211,68111,68169,68173,68177,68174,68182,68248,68259,68253,64451,64454,64458,64400,64406,64414,64416,72157,72229,72330,72144,72169,72277,72325,72137,72164,72224,72220,72266,72272,72319,72053,72232,72072,72044,72173,72135,72130,72227,72036,72120,72158,72216,72067,72063,72041,72125,72168,72162,72219,72296,72290,72390,72315,72312,72476,72480,72404,72438,75977,75903,75931,75936,75851,75865,75983,75910,75869,75915,75919,75957,75847,75882,75825,75829,75962,75852,75890,75968,75924,75856,75895,75834,75911,75947,75875,75820,78215,78367,78371,78302,78275,78291,78296,78298,75973,75926,75844,75861,75899,78219,78378,78301,78307,78280,78285,75839,72285,72383,72308,72470,72427,72432,75952,75842,75878,75907,75870,75815,75838,75902,75943,75864,75810,75833,75939,75897,75805,75828,75859,75933,75823,68107,68105,68015,68020,68199,68147,64090,64150,67214,67184,66976,66985,66926,67028,67036,67033,67031,67084,67092,69075,69079,69077,69083,69144,69204,69258,69262,68617,68592,76101,76119,248748,248747,78505,260125,66237,66240,66267,66279,66272,66286,66386,66380,66394,66311,66321,66297,221980,210751,210750,210755,210331,72976,259369,127344,66594,66523,66611,66670,66603,76146,76170,76192,76265,72889,73067,73016,68788,68794,68793,68882,68836,68841,68916,68920,68796,68799,68887,68895,68890,68800,68804,68809,68849,68846,68854,68925,68930,68785,68783,68789,68780,68872,68877,68827,68831,68910,68905,68863,66495,66490,66575,66531,66539,66545,66556,66639,66644,65727,65780,65790,65754,65803,65814,65816,65848,65853,66388,66392,66455,66465,66461,66436,66439,66441,66444,66449,66518,66525,66530,66522,76031,65777,65739,66226,66232,66254,66260,66275,66270,66375,66301,66291,65650,65671,65715,65708,65778,65779,65718,65747,66139,66161,65649,65689,65693,65632,65735,65394,65899,65849,65870,65903,66395,66393,65687,65786,65792,65721,65752,65753,65756,65758,68193,68187,68328,68335,68245,68240,68255,68251,68270,68275,68324,68266,68247,68319,68212,72269,68176,68232,65523,65522,65527,65528,65537,65539,65544,65547,65549,65550,65554,65555,65559,65561,65563,65567,65568,65578,65570,65585,65589,65588,65596,65595,65597,65513,65518,65517,65640,65641,65645,65648,65647,65653,65652,65657,65656,65661,65665,65667,65672,65678,65682,65688,65692,65600,65603,65606,65612,65616,65620,65625,65628,65633,65634,65637,65639,65287,65283,65290,65365,65339,65354,65358,65411,65417,65802,65655,65659,65664,65668,65676,65681,65686,65695,65764,65769,65713,65720,65722,65726,65728,65732,65734,65736,65755,65759,68577,68690,68603,68732,72603,72601,72606,72678,72806,72769,72794,68581,68607,68547,68552,68557,68567,68562,68587,68582,68642,68654,68657,68667,68688,68694,68596,68591,68702,68711,68719,68739,68736,68745,68572,68674,68682,68598,68753,68757,68727,66246,66261,66203,66341,65962,65969,65974,66003,66000,66005,66009,66071,66086,68343,68298,68373,68386,68338,68290,68368,68382,68441,68437,68364,68377,72468,72567,72450,72462,72524,72563,72455,72607,72602,72520,72555,72509,72547,72453,72439,72590,72514,72552,72430,72447,72585,72505,72457,72445,72596,72424,72441,72542,72488,72412,72434,72572,72531,72493,72498,72580,72537,72477,72560,72386,72473,72420,72513,72556,68451,65819,65485,65540,65548,65605,67427,67460,70839,67439,65254,68305,68310,68361,68321,68325,68268,68272,68428,68356,68363,65763,65765,65768,65770,65774,65773,65796,65702,65707,65712,65733,65738,65743,65801,65804,65813,65694,65760,70674,73929,74034,70529,70538,70466,70477,70484,70499,70493,70611,70618,70635,70626,70653,70667,70662,70555,70548,70563,70730,70725,70740,70735,70746,70670,80321,76785,76669,76712,76703,76663,76699,76729,76684,76695,76649,76714,76759,76654,76658,76691,76694,76770,76700,76705,76720,76726,76763,76773,76708,80335,80413,73913,73904,73918,73933,73847,73842,73838,73858,73856,73851,73869,73868,73863,73861,73879,73886,73884,73880,73897,73895,73893,73890,73945,73944,73939,73955,73953,73950,73949,73967,73965,73962,73960,73958,73979,73978,73974,73973,73969,73988,73987,73983,73982,73997,73993,73992,74006,74002,74016,74011,74026,74020,76735,70402,70410,70422,70394,70513,70506,70522,70520,70516,70532,70546,70431,70441,70458,70450,70460,70470,70488,70482,70496,70613,70604,70605,70619,70630,70644,70639,70649,70560,70588,70582,70595,70597,70710,70705,70721,70716,70700,70689,70683,70696,76681,73853,67365,67976,68041,68161,65557,65505,65562,65566,65579,65508,65511,65644,65636,65521,65499,65443,65447,65642,65654,65660,65666,65696,65691,65638,65700,65703,65710,65740,65744,65487,65679,65683,65782,65714,65709,65745,65746,65749,65138,65130,65141,65140,65157,65150,65167,65161,65177,65173,65187,65198,65277,65285,65281,65296,65291,65203,65208,65210,65213,65214,65219,65218,65223,65228,65232,67796,67889,67998,65378,65386,65489,65494,65437,65438,65442,65545,65615,65068,65062,65064,65079,65078,65070,65073,65120,65123,65124,65127,65132,65147,65158,65108,65112,65116,65117,65087,65090,65092,65215,65220,65224,65229,65235,65449,65450,65506,65673,65772,65704,65741,65501,65646,65705,65750,72203,72397,72291,72231,72331,72225,72200,72388,72281,75892,75802,72193,72223,72288,72384,72327,72323,72189,72218,72186,72212,72268,72276,72207,72375,72317,72310,72381,72180,72263,72365,72305,72182,72293,72249,72170,72188,72196,72165,72297,72254,72347,72342,72175,72259,72201,72358,72301,72160,72179,72154,72287,72337,72242,75929,75922,75797,75854,75850,75886,75814,75818,72174,72149,72234,72282,72334,72226,72255,72366,72311,72422,72222,72250,72357,72415,65387,65312,69432,69508,69441,69429,73620,73725,69471,67090,73446,73535,76445,78678,78697,78622,78665,78746,78751,78627,78668,78681,78686,78670,78607,78612,78664,78650,78654,78740,78730,78735,78673,78691,78617,78660,78683,78703,76488,76588,73433,76485,69430,69546,65502,65395,65028,65029,65076,65183,65093,68092,68196,68164,68243,68071,68083,68191,68159,68167,68160,68238,72295,72214,72235,72243,72208,72336,72346,72341,72307,72302,72405,72409,68051,68061,68227,68148,68145,68155,68154,68178,68183,68233,65240,65294,65375,65371,65398,65399,65393,65315,65318,65323,65324,65329,65330,65333,65336,65338,65343,65348,65357,65359,65350,65484,65402,65403,65406,65408,65412,65414,65416,65419,65421,65424,65427,65429,65448,65453,65457,65462,65466,65474,65479,69664,73812,73807,73787,73715,73720,73731,73837,73802,73711,73721,73727,73778,73833,73829,69626,69624,69632,69630,69637,69635,69638,69643,69645,69640,69676,69724,69731,69736,69739,69719,69686,69681,69692,69861,69868,69872,69878,73438,76497,76440,76435,76481,76483,76476,76479,76581,76571,76503,76493,76421,76426,76431,76463,76466,76468,76484,76489,76471,76475,76544,76564,76554,73348,73343,73356,73350,73431,73466,73410,69197,69107,69118,69126,69122,69134,69140,69303,69308,69298,69205,69211,69235,69240,69244,66863,66867,66883,66892,66890,66814,66819,66900,66947,66799,66790,66851,66855,66865,66871,66875,66873,66881,66887,66805,66846,66927,66933,66940,68992,66682,66746,66751,66755,66714,66719,66813,69073,69254,73164,73162,73294,73229,73257,68962,68964,69056,69016,69104,65390,65446,65452,65503,75917,75846,75873,75809,78209,78205,78362,78286,78270,78294,68103,64966,65036,65045,65121,73875,73896,73940,73801,69634,69679,69596,69595,69812,65128,65165,65101,65100,67760,67672,67648,65440,65495,65441,65037,65043,65042,65105,65110,65089,65201,65265,65389,65308,65311,64936,64940,73748,73762,73822,73817,73840,73867,73876,73810,73804,73739,73752,73831,73859,69722,69789,69708,69716,69820,69947,73792,73723,73736,73843,73799,73728,73744,73820,73854,73796,73816,73850,69667,69674,69670,69737,69761,69680,69912,69678,69749,69922,73742,73757,73836,73864,73734,73747,73826,69673,69743,69768,69778,69685,69917,73784,73775,73905,73844,73860,69941,67255,67198,67251,73806,73906,73818,73815,73883,73946,76689,76643,76707,76752,76686,76677,76638,76702,76668,76685,76623,76733,76664,76667,76675,76690,76628,76737,78699,78658,78729,78780,78707,76594,76657,76640,76634,76635,76709,73811,73935,73866,73889,76661,76600,76646,76639,76711,78689,78648,78718,78772,78701,76590,76652,76629,76704,73800,73791,73885,76682,76673,76697,76633,76742,76747,78712,78734,76659,76679,76619,78694,78653,78724,78775,76666,76651,76671,76604,76608,76644,76648,76716,76662,76653,76656,76674,76615,76719,76725,73805,73797,73930,73862,70096,70190,70114,69504,69507,69539,69578,69529,69495,69494,69666,69567,69503,69534,69498,69668,69573,69524,69658,69490,69561,67046,67099,67157,69437,69514,69443,69476,69591,69586,67032,67201,67148,67171,69962,69969,69974,69972,69978,69979,69984,69983,69988,69993,69998,69990,69955,70037,70031,70045,70044,70055,70050,70066,70062,70076,70017,70027,70024,70159,70153}'::bigint[]))
10. 24.387 1,422.841 ↑ 1.4 246,732 2 / 2

Subquery Scan on test_case_version_custom_value_aggregator (cost=0.43..263,090.65 rows=339,180 width=44) (actual time=0.079..1,422.841 rows=246,732 loops=2)

11. 450.206 1,398.454 ↑ 1.4 246,732 2 / 2

GroupAggregate (cost=0.43..259,698.85 rows=339,180 width=40) (actual time=0.078..1,398.454 rows=246,732 loops=2)

  • Group Key: test_case_version_custom_value.test_case_version_id
12. 948.248 948.248 ↑ 1.9 2,708,346 2 / 2

Index Scan using test_case_version_custom_value_test_case_version_id_idx on test_case_version_custom_value (cost=0.43..229,998.04 rows=5,092,212 width=16) (actual time=0.042..948.248 rows=2,708,346 loops=2)

13. 0.592 0.915 ↑ 2,588.0 1 2 / 2

Sort (cost=194.59..201.06 rows=2,588 width=36) (actual time=0.915..0.915 rows=1 loops=2)

  • Sort Key: x37.test_set_version_id
  • Sort Method: quicksort Memory: 299kB
  • Worker 0: Sort Method: quicksort Memory: 299kB
14. 0.323 0.323 ↑ 1.0 2,588 2 / 2

Seq Scan on test_set_test_case_version_ordered x37 (cost=0.00..47.88 rows=2,588 width=36) (actual time=0.039..0.323 rows=2,588 loops=2)

15. 394.212 394.212 ↑ 3.3 3 1,596 / 2

Index Scan using test_step_test_case_version_id_idx on test_step x36 (cost=0.43..9.67 rows=10 width=333) (actual time=0.245..0.494 rows=3 loops=1,596)

  • Index Cond: (test_case_version_id = test_case_version.id)
16. 0.494 0.970 ↑ 1.0 2,542 2 / 2

Hash (cost=52.40..52.40 rows=2,640 width=47) (actual time=0.970..0.970 rows=2,542 loops=2)

  • Buckets: 4,096 Batches: 1 Memory Usage: 210kB
17. 0.476 0.476 ↑ 1.0 2,542 2 / 2

Seq Scan on tcmt_user x78 (cost=0.00..52.40 rows=2,640 width=47) (actual time=0.032..0.476 rows=2,542 loops=2)

18. 0.396 0.593 ↑ 1.0 2,542 2 / 2

Hash (cost=52.40..52.40 rows=2,640 width=47) (actual time=0.593..0.593 rows=2,542 loops=2)

  • Buckets: 4,096 Batches: 1 Memory Usage: 210kB
19. 0.197 0.197 ↑ 1.0 2,542 2 / 2

Seq Scan on tcmt_user x61 (cost=0.00..52.40 rows=2,640 width=47) (actual time=0.008..0.197 rows=2,542 loops=2)

Planning time : 16.939 ms
Execution time : 1,905.098 ms