explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Khsc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=6,098,400.03..6,100,286.76 rows=7,303 width=20) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Group Key: ts_time -> Gather Merge (cost=6,098,400.03..6,100,104.18 rows=14,606 width=20) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=6,097,400.01..6,097,418.27 rows=7,303 width=20) (actual rows= loops=)

  • Sort Key: ts_time
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=6,096,858.33..6,096,931.36 rows=7,303 width=20) (actual rows= loops=)

  • Group Key: ts_time
  • -> Parallel Index Only Scan using idxtallnskinny on tallnskinny (cost=0.58..5602336.47 rows=65,936,248 width=12) Index Cond: (ts_key = ANY ('{128320,1894,166607,4961,120022,52760,162979,150605,98645,113695,113672,130333,20100,185907,64352,175943,28528,192502,189741,193218,170205,32041,183165,142632,107439,164609,142207,140789,77743,89703,36580,80519,107380,102581,185850,50470,70386,96582,41276,70183,133980,112510,8810,166344,134420,178217,98995,41653,119767,74182,186845,91221,141091,125080,156304,25055,16698,117728,162843,191316,144837,44838,78383,109433,52713,176225,32472,178902,122534,80957,118646,139361,184669,146170,55429,85486,85732,190644,126328,51074,129568,178082,167732,109928,66818,26832,9957,57298,136773,91669,92157,36549,48191,86075,186345,65052,144516,132938,54291,167266,124667,119439,148610,151127,165252,96987,123382,106641,13449,135611,155503,184628,121795,116564,103646,148832,195169,70667,144736,23306,53893,136244,8656,30471,3980,109858,140731,17135,66716,61950,160776,69012,115454,113592,12550,11971,193728,80806,167709,107248,77059,94339,43849,140219,64702,177887,38342,91354,37636,149074,4480,52144,96253,184619,134558,145037,77417,132683,9523,89073,1477,8206,115254,56846,163080,179096,169045,32535,150844,120655,27718,103030,107571,31431,7231,108814,45948,138287,38397,53707,54228,160570,161216,103594,29851,168779,161673,163240,78998,138254,22949,83491,62231,130012,6960,57530,96521,43030,83889,141604,58279,2450,161125,32400,97145,148823,103136,171909,151772,7761,6627,12399,163279,18483,61627,22711,56106,172241,164246,55451,39023,165374,106486,185278,13054,65801,77601,6451,7066,100743,140293,172524,11155,148413,160223,175019,182336,114836,70241,129794,55990,161530,91124,88029,125426,144228,66428,146813,31631,165470,93061,178051,50306,191212,136013,113240,69480,94157,141387,31607,148711,34138,165665,65693,98095,116595,182827,27200,68487,195563,125018,53762,149147,85943,24948,173119,119292,184841,43281,61553,131575,43836,108954,85016,13500,67942,175123,95609,97859,91285,150442,38985,99448,191358,196834,64497,187037,150945,112945,157427,116300,176648,196481,129540,5816,84396,112780,79821,94381,130053,7944,147916,8637,67611,170416,11013,27082,143985,46588,107698,116766,182202,85331,146712,68106,172466,34100,37748,194786,173701,74175,28736,49903,17522,62422,26728,133315,19749,25873,102426,185391,36190,131330,44695,168578,71837,102079,94189,192289,45375,128952,55396,41126,75111,111762,104603,127817,77375,188318,73519,97971,122537,45385,124076,32163,136209,87408,156170,28688,6362,165871,36421,156712,14868,138779,174002,175935,6577,148537,141301,28567,70527,197667,139459,15991,17578,178897,120370,157878,78806,82977,185847,79211,63383,123792,56479,41059,21071,47508,44145,169995,55989,149134,140169,59456,7320,144790,127215,68620,100076,71340,130089,33910,57770,159502,60975,41106,63873,56121,149050,183041,125144,9783,109132,154253,19059,194769,13106,192137,123133,151164,198411,169580,22335,3458,137059,67418,192119,89190,136026,181328,32508,135642,156867,118481,162184,127003,34321,40577,142611,44429,162826,84414,70271,16627,122844,153748,6869,187747,147540,72048,10687,175662,47505,66345,166826,16877,16682,145220,162368,146366,101605,130833,39216,161370,31665,90951,137547,42599,174134,90052,158028,143921,101411,178025,113817,51058,103104,5975,154747,110639,46584,113118,54738,44903,157196,144018,7553,51427,114749,29176,18512,146331,76625,172830,126184,47165,17196,121009,84329,42400,46703,152678,180060,192537,66471,45440,82029,64251,171856,176407,15850,17068,142972,137916,181614,64342,174203,181494,72971,28570,33400,140574,7683,57572,127168,197360,175121,145923,52405,95936,131168,132609,57084,153416,54990,188836,198990,52694,164330,99492,195972,185632,93587,195877,67196,135965,60799,142668,57221,72006,54624,127207,116839,167776,35470,61663,88279,176988,159006,17224,115457,67821,76598,134921,78022,16143,9939,90309,173378,195085,51510,101836,59031,67892,61811,105074,101378,110771,94518,74222,120295,197412,128257,157658,197414,166070,111681,63362,71202,10325,96662,56667,185888,197188,108839,117534,78371,117326,181929,159513,28527,39656,163993,70004,37477,100658,151898,92225,99845,137850,160786,173327,176873,50977,72144,183272,155982,873,111756,150601,52774,91641,92850,13133,16943,56697,138010,186116,4889,171705,191216,85253,178181,175795,12474,56063,63873,72760,131214,174173,67426,29452,106131,76828,176916,146227,33617,65381,62703,90958,110283,159844,139331,171335,48709,86077,71176,39725,173844,76102,190484,193970,106785,138806,184519,14222,159356,133636,146311,23553,141474,17094,19947,20589,99955,197992,155514,83896,94012,177917,88714,9117,25866,23978,140531,169453,50476,122544,114932,75797,64993,19152,179869,53673,26341,33051,4945,81213,192016,87853,126488,52471,122848,175959,177676,74868,183122,183818,185471,181798,177857,175711,163997,7568,38234,116898,91652,72282,57179,58329,28324,110765,192505,193676,173817,2414,181540,63714,166769,173480,106475,97838,62192,101293,168882,118726,169260,129747,133523,190210,26935,8419,126413,3284,59819,179760,31757,113950,43629,112188,114476,161713,198267,180035,189480,196762,137000,160182,115293,181418,186919,23194,185521,77524,8093,147890,122275,99905,79400,111012,103380,109979,20011,178745,151510,125800,116874,86279,57743,12935,161601,171869,150311,2365,184406,9131,64827,41317,131919,197217,34390,36127,190636,37918,120225,65772,120910,103424,159434,6014,28406,63510,111622,163227,138334,150948,22450,165466,61314,109393,67921,90540,107803,57433,6306,32912,8502,3655,187313,80964,178020,147628,198943,60565,27582,33128,48933,186035,12839,142027,120722,116723,59123,173766,176609,13513,164744,20707,166612,78659,81069,82156,142874,117375,181876,187414,36629,122476,62166,167760,120943,99192,94436,21139,21541,89406,17425,178488,182560,15317,105913,79777,42057,96525,171649,112801,1804,118934,61522,193884,24316,171039,186210,28032,127198,137505,188073,14725,197071,160439,193241,114616,61564,154820,69250,165716,133536,149215,41673,92873,121800,24552,12868,116478,18558,97018,107317,85512,165652,190009,24989,138045,167058,57604,169650,17431,78918,183939,177708,47084,49409,143333,187761,104588,119778,152398,106451,186510,15044,131482,197636,57839,109194,92311,12102,60573,7160,48805,197726,24344,89884,79016,191838,82870,123281,25941,54266,190926,100626,48742,117864,32469,37547,48407,166160,34313,51689,86030,143141,22822,69029,82288,29447,71806,119844,86964,26585,19126,63839,2249,125928,30322,13497,74952,44230,117409,142982,41561,37066,9451,106913,32049,146355,58502,173833,125582,129761,62788,32633,117511,189668,166240,4720,92397,138736,164303,188911,133530,124262,140381,114545,70425,136872,174914,137091,135566,187983,167081,119682,186729,120395,57746,139555,40871,11884,161639,69899,178270,150778,83203,47303,126246,91413,9482,58660,197421,72875,197052,145250,31298,180965,196232,80156,134018,144150,102132,141808,151247,124647,154825,166497,121380,26308,147711,87762,83084,122433,104971,72736,98911,119253,184939,99596,138839,93578,26283,43008,180222,110651,89728,25622,179059,114071,95680,157682,189398,67474,183183,168195,114284,86301,180523,133028,30987,57450,106326,2528,114819,191892,69492,146437,48085,185102,102461,149142,177942,9468,73349,62741,72902,184985,44159,191403,113688,133825,160994,173553,56974,68243,613,90074,14119,75458,80423,108792,4110,121283,63408,73225,52593,75044,153931,41156,94237,14584,50586,39101,6420,80337,134862,142200,116055,64319,170891,478,114334,117179,81585,43007,187083,189999,127879,4981,26153,6736,108570,94981,27626,114095,37635,146323,163867,138025,8511,175139,194634,60240,3096,75601,75103,24969,65415,142718,35565,123680,39094,179986,101833,148746,29994,118405,173862,21682,151551,159661,10306,144006,10809,182146,168663,41864,113745,112383,128235,173841,172539,186605,114053,174876,142125,118277,19132,14870,52807,99820,81773,155198,60994,191992,148045,161718,151950,81305,10302,80503,102069,71292,70246,167915,33248,186406,16043,60581,20994,91171,171627,18854,114674,107103,122337,107774,129472,51025,13774,91945,151945,173924,50070,108982,16289,89962,106839,130307,168522,54002,141884,27955,191644,164346,159657,167963,164324,159578,149181,170718,119355,72146,167615,93829,147852,52121,22006,135377,139826,192131,156246,171502,194742,72527,160078,49446,183123,31149,141097,27991,158036,169631,28468,96142,70577,27998,10557,136424,35051,10049,186320,83148,150410,123150,99088,5856,96755,161901,8643,114672,61572,100871,145172,53137,173259,26580,70708,78802,121469,196630,194143,85650,115839,95721,132485,26012,56715,94373,42878,27578,39989,107671,149205,12343,192323,180330,162543,115796,70357,170865,153778,9828,107922,53927,35122,141643,115453,64994,25203,17323,197778,15005,107934,99698,144891,66534,66876,152774,94252,77206,45603,71999,83740,129253,92033,186742,39931,152546,164590,198986,78886,14378,19319,84165,68487,197952,61716,163244,156328,100787,183985,159103,187644,150979,167942,82052,90512,41460,17775,89156,135595,124502,117473,45558,182444,175473,13805,4408,68309,37935,197404,38356,78877,114184,145366,13446,89293,46258,111945,37420,198132,21054,142440,61528,6225,92865,40159,177675,39220,133990,3230,67031,32700,94031,24566,47659,179214,37832,100805,41158,82525,88580,60601,26114,173922,195217,143095,143699,39445,36637,170692,78345,93763,144296,146804,36408,114025,147895,100456,11617,144924,128213,15207,114554,165304,158919,198661,139351,102632,34911,55982,111854,22333,85149,69650,149491,56029,135212,179679,82392,96488,61704,174478,87931,2444,94311,195077,126062,194225,150640,34893,71889,141582,51562,32179,132017,60858,51538,160082,170077,188027,163061,145732,15332,97527,117016,10779,76504,76063,130334,140553,163079,2603,19279,121851,108331,92150,1159,62818,81397,141536,188972,53651,179242,34484,92663,187153,73192,76381,127716,177982,153165,32750,70904,132610,97623,85519,67552,174166,247,12762,98353,60703,69197,197567,1435,58495,151328,40995,104496,48778,20649,135577,129222,65509,171446,109383,118684,153812,23920,31256,89109,183710,161977,162672,66006,164938,173814,12420,189469,165316,177407,168616,3299,180233,138449,57650,147186,108770,28482,82361,110335,56302,154618,191826,33871,4237,191545,89951,86150,162163,77694,36401,10447,75199,54870,70011,133119,195827,38809,112340,40727,147293,18098,122774,59388,83548,13603,101443,134533,20161,143273,95317,165523,168430,187867,143842,33020,169913,161080,1123,145525,23009,116797,127013,35482,130630,10146,28175,187354,133218,193135,46976,186169,19661,191474,17443,195686,40847,68234,102133,115203,34883,105220,157346,9082,176109,52156,180871,46649,198104,64298,11823,60004,150053,74821,50900,130947,22647,198339,193025,91589,131860,136989,27902,99182,19332,16136,35178,77796,185943,83689,49769,822,158524,71260,58095,198294,93170,19254,70901,35735,140120,91485,142170,59154,25504,77322,56948,42730,153965,82092,86966,25435,152932,153211,135822,51651,42496,90428,74592,180721,173994,182712,166260,24948,121944,67470,76498,125200,152885,92044,161843,78227,76081,9833,53082,138535,61745,158515,29011,136490,120830,2963,165035,27210,178436,71536,166041,105653,127949,120408,175472,22624,183461,2172,101253,97823,122892,28915,152763,113935,109236,137364,166979,44802,110456,120114,21199,22300,150545,152433,11510,57810,151338,176790,137112,36797,6791,110273,155865,132217,147782,134310,149843,185919,3025,68932,123145,74664,22420,50188,67286,71407,101184,145423,97399,181743,104284,182795,133190,143693,145831,1216,13800,90639,88086,42496,2722,160452,114263,53812,146747,103229,181597,92939,131986,67149,58366,100555,81049,197095,74832,91721,81493,171008,144983,128440,30002,120913,181569,47281,165803,83435,131554,158765,72703,12657,62538,99821,191628,128279,36214,167372,176745,42616,55711,160835,19059,12748,35820,75814,13089,151220,117947,121110,187629,128356,103735,98460,21595,198071,173468,143562,64617,69511,38395,166822,70530,103625,153631,187168,186274,7985,148786,106279,43782,158496,32832,117445,100033,167061,180432,33411,142012,63332,62891,17197,118421,22738,73179,14063,29599,148467,98260,97525,89340,55621,146646,62613,84649,179295,63518,9913,38718,143913,197489,70705,130203,120975,82944,136857,98676,137775,179656,117760,177222,156445,61179,182793,154839,146186,76319,62797,30340,100689,11083,189874,14266,66254,180494,178930,10571,187006,194450,88448,80241,31764,5812,72830,59764,151723,105905,2529,140459,59635,23961,105102,178206,63583,145930,134494,147928,95365,35577,108106,170194,32757,120876,149367,17748,132775,90475,11684,106676,118026,433,102660,162353,105711,192438,73563,72402,195113,138867,127245,72633,57533,70080,42439,20132,114563,97978,21169,102741,118746,141728,89933,127400,110927,159762,55090,75004,87759,191975,53376,167492,110639,140040,159567,19939,117840,27681,72133,69742,683,165905,43693,3579,88377,73597,31294,150960,177147,82987,87841,137537,4281,52974,187887,8831,87226,71927,38328,22249,861,173854,61200,147280,106563,35102,190742,46410,21573,103300,51791,178855,176414,26237,196341,68911,44594,174714,84972,68519,82946,3246,17349,84001,129359,112364,162402,26793,129246,4005,82658,84735,149881,132909,197084,67838,113581,154373,98619,131755,60967,93332,192252,75362,145686,111718,148048,173253,40552,111099,18375,54976,7557,127815,138038,125472,79708,103749,181637,68247,54456,107629,163484,116570,117588,72608,4789,176608,53939,5716,88532,161855,170420,515,97444,63470,146617,133455,94061,192409,163082,47679,106562,137059,108429,192577,174459,185861,134868,106630,171357,3310,80717,165113,25640,699,139120,101904,121944,40947,193535,109458,97085,144059,17575,46276,136295,178723,55306,37475,8199,104963,143797,75079,110224,96870,180068,27523,162372,99407,39262,25686,142129,16225,117174,32589,32518,67300,64394,150572,94744,83501,95378,32508,133718,156862,59835,187035,190503,63624,47965,115164,174504,32780,151839,108881,192351,127766,69432,74291,198455,70757,142204,71399,124263,31572,61958,98454,192165,7741,132152,39334,7215,171806,163220,150797,143957,10621,68110,4527,122212,72215,108617,48361,108934,52204,126719,108422,140004,195307,31395,64566,4277,98473,57769,170953,145467,21047,162069,70470,191330,190031,113547,42746,56065,99168,173599,64617,181678,150273,2857,67029,177727,79865,162316,12501,114040,185093,159611,146443,135657,190359,114939,164255,82593,82482,119464,46746,189977,102535,107344,109083,196586,18078,86275,189992,62297,189407,85292,179229,173419,97492,36000,117504,158509,41561,125642,15654,119148,1513,120351,86249,139115,102295,198584,164731,118891,100261,125771,21760,124954,92080,162006,87563,82816,18294,38252,170273,27831,40763,123849,8216,55280,171939,9483,137656,46436,198690,172999,194818,156673,45308,176246,77418,14281,137937,175023,58680,20908,134204,67098,126064,24250,116323,161617,119142,97578,171988,107830,139869,182856,19993,134182,81352,132700,82677,66463,14940,177212,125830,104992,26788,136103,140307,15273,96392,153427,185453,85826,39545,168371,36960,30369,57989,155010,85291,106360,98215,127138,52050,92966,175887,172035,43458,76239,29104,66359,26426,159074,15098,40699,10128,118005,195903,95533,88996,79037,94527,240,73495,56311,173678,94909,17130,171840,158254,28395,22294,108816,121217,198108,172109,111299,169570,194200,83345,119398,178134,198206,46840,104525,54628,86352,129934,170364,18792,190817,20098,105509,171770,62538,76163,64623,56584,180973,193695,169398,145856,57461,104155,15961,41644,184354,174567,100298,15326,140869,111548,103253,136863,89094,122112,84709,89072,10432,171830,101098,140050,171804,152339,87525,161374,191635,173959,18618,65,146807,68538,150871,79673,63853,144579,189927,131588,46154,99394,182362,15154,6773,116360,16101,124431,177789,152513,194086,44983,88954,867,51772,61110,3981,174290,8026,186528,222,22119,29794,143008,170923,173456,142272,179506,36843,49117,31150,134599,15699,33735,24537,101066,142514,43620,108955,57862,71448,32017,70341,191319,158342,174326,80150,37621,43385,78668,9415,72762,100024,15636,172468,103083,1320,116049,134897,139906,120578,52986,67880,138621,88128,188799,87666,35038,179639,133388,17922,10928,42943,6778,61264,150601,8090,191123,107946,40491,32993,147872,117498,99634,169403,105757,19964,67232,197531,110833,188135,140620,37575,32981,92943,179074,197811,76368,51763,111307,66899,65101,58656,27866,92884,54931,196053,66626,126860,190606,91383,143656,77624,18256,66221,72808,29739,134300,112520,57965,106946,124875,77673,12099,150206,428,27358,101692,22608,180576,171952,94032,135500,13614,183974,134654,81704,69666,1769,139450,1747,148374,54335,26034,147530,21327,148006,176485,12385,165020,152771,108444,125439,88283,129415,19837,194424,2914,182968,82331,40685,431,190611,97234,90805,47737,27767,50560,23175,10011,166427,95449,5472,127274,180636,58057,77881,118765,27713,11809,118033,22471,94109,86034,146014,64710,13679,22590,102866,105529,72180,159716,135157,129356,121672,198528,157941,175714,153274,15933,64473,164055,1107,5455,109535,11985,30298,99011,39889,69713,29320,166699,140898,123769,70807,144875,114477,139388,196472,130180,83744,174549,21999,170465,93360,38799,109432,122181,145258,1884,3341,66530,84430,105330,183378,168046,113483,52699,166712,51344,151510,166445,97751,133850,116265,107775,88849,25021,94561,114926,35620,10569,145585,18481,131103,71373,98874,115326,103465,27790,127750,139254,188503,175381,126178,69429,19697,119093,172776,190763,81284,33475,6806,96475,192535,179104,84246,49205,115461,86071,117338,140474,576,43776,166111,157267,184959,5064,30606,170703,168905,156499,109458,142640,43192,184670,82230,155828,131723,100549,19776,33861,34211,121707,31432,146668,138657,42566,109116,180403,171025,11869,122043,5747,26281,152960,46216,54691,16188,153718,156,121405,175774,146445,29243,14967,91603,25136,184768,170299,154120,189536,37204,6863,45666,3075,165928,98132,11598,12638,107261,63377,180689,172638,186067,183864,107019,111775,164360,147253,122530,51852,140710,56207,42598,184793,45641,20283,168324,72074,161837,177161,92519,172640,42960,113787,42218,15177,20159,38203,149449,188088,137412,144368,5231,43153,174931,55102,162048,179495,51035,67991,88194,112799,101986,74448,168375,92514,143583,77707,8114,52741,87604,85203,14690,74451,16017,35336,10313,38001,84527,48541,23141,25954,188550,15678,1513,165889,154617,121884,67753,99892,128702,79635,18822,186190,116030,49228,95101,58433,114681,144847,38913,70314,186152,7599,116962,166014,188691,182966,135957,181440,198345,186442,100288,22992,42522,21397,63495,121713,13794,197032,138592,186704,55241,77024,53765,165809,130913,153985,112820,111740,30909,149710,107588,179041,71642,55360,69156,63947,36766,172085,77183,36017,48234,90778,96021,110844,104639,5591,80383,172074,160771,134877,62810,72935,151504,179910,76928,127360,139214,149806,191326,127794,84146,36443,176673,185876,19485,96853,103670,56638,123716,118943,83584,178195,178985,106248,156783,93618,108847,7618,181441,123950,14503,131678,162815,51359,155308,75988,58772,159579,142394,12683,95868,131067,92431,36392,76268,103458,28141,195555,28735,50177,158036,33719,15694,30645,91193,119693,158488,136818,9226,165755,190911,99692,106522,102341,196401,6745,196662,10946,185757,112753,96199,46433,103586,8559,81745,34786,163641,189436,28048,42004,20555,46367,144624,143022,46650,99776,17119,2067,31220,33355,149874,145678,31589,137564,96494,15032,147741,89793,86327,13757,80832,20821,83906,160593,27540,82113,97084,45109,37415,153383,17770,137137,175406,170487,90380,144530,152054,142003,157448,180182,127035,156187,48618,89809,71332,165854,155259,115353,7030,178399,148887,117709,39875,4360,194532,134766,79209,98958,190829,57919,72393,166187,20416,146303,49811,129023,166903,113827,167234,7035,142215}'::integer[]))