explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rxfv

Settings
# exclusive inclusive rows x rows loops node
1. 0.251 289.504 ↑ 1.1 1,000 1

Nested Loop (cost=6,458.09..15,659.66 rows=1,100 width=179) (actual time=30.343..289.504 rows=1,000 loops=1)

2. 0.639 30.253 ↑ 1.1 1,000 1

HashAggregate (cost=6,457.66..6,468.66 rows=1,100 width=8) (actual time=30.014..30.253 rows=1,000 loops=1)

  • Group Key: storetable.userid
3. 29.614 29.614 ↑ 1.1 1,000 1

Index Scan using storetable_pkey on storetable (cost=0.43..6,454.91 rows=1,100 width=8) (actual time=0.167..29.614 rows=1,000 loops=1)

  • Index Cond: (storeid = ANY ('{104506,104507,104512,52313,217848,104514,108820,66321,558820,104509,104515,104517,104518,104519,104520,128782,222266,2227887,104522,104523,104524,104525,104526,127877,3090209,104530,158192,104510,103498,104528,104534,104516,127879,104508,209812,6558,127878,104529,127881,2182,104531,222267,104533,558836,108824,353240,108819,1954476,108826,353200,353210,15224,2059263,127882,131718,128069,934409,127883,3091683,3093253,127889,2353665,241943,4567175,127915,241951,127943,127892,127933,127946,5162352,241948,416624,3099539,130790,108825,241950,108573,241942,3103301,108831,217850,127884,217858,8706,127887,127903,127888,108828,127890,127893,217869,127904,1542519,277244,277239,127926,416626,416646,416649,104506,104507,104512,52313,217848,104514,108820,66321,558820,104509,104515,104517,104518,104519,104520,128782,222266,2227887,104522,104523,104524,104525,104526,127877,3090209,104530,158192,104510,103498,104528,104534,104516,127879,104508,209812,6558,127878,104529,127881,2182,104531,222267,104533,558836,108824,353240,108819,1954476,108826,353200,353210,15224,2059263,127882,131718,128069,934409,127883,3091683,3093253,127889,2353665,241943,4567175,127915,241951,127943,127892,127933,127946,5162352,241948,416624,3099539,130790,108825,241950,108573,241942,3103301,108831,217850,127884,217858,8706,127887,127903,127888,108828,127890,127893,217869,127904,1542519,277244,277239,127926,416626,416646,416649,558822,5038905,127905,108829,127895,131719,127896,2227889,127898,127894,127899,61356,108834,108832,127907,353201,127901,127908,127902,127912,2353666,127914,109106,127911,131717,127897,127917,127952,131720,104535,75664,416642,127927,1540052,127938,1540066,127935,104527,104536,1540074,127942,127934,353224,209814,203723,185798,203729,203736,1540093,1540118,127393,129866,129924,209810,31187,1540053,222283,222284,222269,222270,222277,131722,222279,222280,127939,127921,127922,127923,127948,127941,127920,131723,131724,131725,104537,1540059,558823,104538,104539,127951,222295,209817,122613,2353667,1540091,127929,127931,1540110,127936,104555,4567176,122616,222274,127947,127956,222275,127937,837610,1540112,127932,3101524,1540120,3101528,1954480,222276,127944,131727,127954,3099545,127957,127984,127958,127961,2353668,104543,104544,209818,104383,122615,3099552,82087,127969,131728,131737,127981,127962,127993,128004,128006,122617,217853,81975,2059265,131735,131736,222285,2227891,82078,128010,353215,3103375,353203,127996,353212,3103927,127963,127965,127913,128003,131729,127966,127967,127968,127970,131731,2507457,353220,209820,127973,241949,127978,127979,127980,203718,128027,127983,131742,127986,127987,127995,127998,127989,127991,127992,127964,128002,128007,128008,127976,128009,128015,128012,127999,1540055,128014,127990,127972,558824,222310,131732,129899,131412,128001,2059267,2353670,209822,558826,278805,353204,128000,4567177,128005,222281,1542527,209828,222302,129869,129893,59066,129901,203711,1542523,353205,1540056,203722,2227893,129898,209836,3139608,203725,562838,128017,131734,185799,131738,185819,131743,131744,131745,185802,131748,131760,131733,185804,1823858,1823864,222289,222290,185805,185806,185807,222292,185814,222293,222305,185815,185816,131739,131741,353232,131746,562845,185820,131747,558825,2507459,185823,185821,558827,185828,185829,185830,185831,185832,185822,185818,185850,5038906,128018,128025,128020,128021,128023,127925,101560,128026,353207,128028,111932,128030,128047,128034,128016,128036,131749,128037,5038907,128031,2507460,128039,128049,128041,128045,127971,203728,128040,128043,2507463,107207,131752,131758,1823859,185825,101556,1144375,1954515,131766,131759,131757,128033,131761,203661,190863,128044,131756,93407,222297,185835,124059,3139600,3139601,185863,185839,185840,185841,185837,185844,3139602,185865,107318,185833,185848,353214,185854,185855,3139629,3139632,185878,185857,241945,185838,185861,185862,278782,185868,185869,185876,4567178,185836,185875,1144388,185796,185879,185881,131755,185845,353209,2059268,185846,1144402,2325804,185856,185852,131762,241946,131763,558830,108837,104251,108839,85380,108840,108838,108842,108843,131764,111943,562839,131765,108847,277245,222343,562851,5038908,108836,108841,562861,2227896,1540057,108846,2059270,5162353,353211,203731,185894,6954,222324,222304,222353,131768,1542525,1542566,185882,2059273,5038909,2507461,1823732,563441,185893,241947,3139571,131793,222306,185888,185890,222315,185895,558839,1540058,90972,131769,131770,131771,222317,131774,59940,2507475,131784,185889,185905,562840,131777,131782,1436235,131787,185910,131786,2507462,131788,131781,131790,131778,131792,131794,131799,185883,185891,241952,241954,353218,353213,131789,1434696,1434716,2325795,1436229,2507472,2507483,2507465,2507488,222303,1540060,111938,111937,222301,209843,241955,203734,203738,203770,416643,82645,209847,185898,209823,185924,209826,209827,209790,209833,209834,209835,222307,1542526,222311,209854,562842,222309,2227890,40982,104098,185900,564085,222313,1161891,3099546,203753,209837,3099650,209804,209815,353216,416635,3099656,56291,185901,1542540,3099666,3099620,1161901,558832,1161947,222300,91088,185902,1540061,111952,111940,111934,111935,111936,2227897,111939,111946,111947,111948,111949,35481,43901,222312,222314,111957,111958,111962,1542529,111959,222320,111969,111964,111965,111970,5038910,111966,111967,185874,185896,185897,185908,558862,1542551,131825,129874,131796,131800,131801,5038911,185911,1161881,1162851,1162870,2507476,131832,131802,131803,131804,131805,131806,131808,2227898,131811,131812,131813,131814,131815,131823,131836,131816,12755,185917,13798,1540062,185921,1144377,131822,131831,131827,131830,131835,131785,131826,558835,131819,131833,129872,111974,111968,129873,185912,131807,131839,111696,222308,203744,203742,111973,222336,129882,111972,131817,131837,131829,131834,558837,129876,129877,129868,129878,129884,203741,203743,129880,129881,43416,129885,129887,129888,129889,129891,203748,129895,129896,129897,203751,203754,203755,562846,111930,1434709,111976,111978,111979,2325797,111981,185913,111984,111987,111993,112012,111989,111990,111991,111994,111995,111996,111997,111998,111999,129871,359793,129890,111986,111983,2227899,2227906,112000,112001,112002,112003,112004,112006,112007,222316,112011,112015,1540065,112020,112022,112026,129883,131841,112013,111985,185915,112034,112048,112050,112053,112030,129939,77256,129920,129932,2059275,129921,113946,129922,129903,562847,129935,112010,3099547,129940,5038912,129910,129911,1847894,129913,129914,564086,112019,3101519,1144383,3103376,3103912,1161903,1161919,129870,3103931,12762,129915,129917,129918,129919,129926,129907,129653,129925,129875,129936,129927,129938,185916,129934,129937,129931,203756,7004,129929,129942,129928,112023,112024,112025,112072,112035,2059278,112042,112031,112049,112052,112051,112037,112066,112097,112098,112111,112112,112114,112014,129916,129943,111933,112032,558840,112093,2325798,2325803,2326408,112043,131842,1878607,185920,131828,112028,558842,5162354,185922,185928,185931,185933,3101515,185930,112096,112099,1540068,112029,112033,112039,112047,112044,103317,112046,112055,3099548,112040,112060,112067,185927,3101514,112027,96807,2325801,122618,129946,104540,129879,129944,104222,3099381,1540070,112041,562848,3103377,3103380,3103930,129950,129951,185932,5313333,129957,3099550,131843,129945,222321,3085760,129956,129959,129955,131844,1144384,129963,129964,129948,129958,3101516,5038913,112056,112057,112059,3103378,112063,112068,5162355,112062,112085,110526,112075,112078,112087,112080,112088,2325785,112089,112090,112081,112091,112069,2059279,185935,112083,112092,12928,108580,112094,1145238,112079,112073,2326387,1542532,112102,112108,112110,112084,15597,112074,112106,129965,185939,185937,40618,31864,34564,60849,34852,34906,54833,78405,12479,27037,37057,16717,16760,185945,21056,3099542,4563,4645,7106,5441,56088}'::bigint[]))
4. 259.000 259.000 ↑ 1.0 1 1,000

Index Scan using usertable_pkey on usertable (cost=0.43..8.36 rows=1 width=179) (actual time=0.259..0.259 rows=1 loops=1,000)

  • Index Cond: (userid = storetable.userid)
Planning time : 1.993 ms
Execution time : 289.626 ms