explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zf8o : hash bigint

Settings
# exclusive inclusive rows x rows loops node
1. 2.753 3.989 ↑ 1.0 1,000 1

Bitmap Heap Scan on tests (cost=988.75..3,235.75 rows=1,000 width=38) (actual time=1.255..3.989 rows=1,000 loops=1)

  • Recheck Cond: (id_hash = ANY ('{14,17,19,31,43,46,70,145,172,255,268,286,358,408,414,415,422,476,514,518,526,591,619,647,657,668,678,695,726,745,764,765,767,782,791,802,819,841,864,876,888,896,908,919,928,971,987,989,994,1020,1051,1058,1081,1087,1119,1144,1163,1177,1189,1193,1231,1272,1288,1289,1293,1316,1333,1348,1351,1357,1401,1402,1420,1434,1441,1454,1504,1519,1540,1564,1577,1621,1624,1630,1635,1672,1679,1684,1697,1755,1766,1771,1772,1804,1814,1824,1840,1842,1846,1853,1866,1869,1889,1893,1903,1930,1933,1937,1990,2000,2057,2058,2066,2075,2085,2087,2096,2102,2129,2134,2173,2183,2203,2256,2260,2264,2299,2333,2349,2401,2420,2454,2486,2511,2517,2525,2540,2576,2585,2605,2644,2715,2727,2774,2797,2802,2816,2846,2868,2882,2886,2889,2903,2952,2981,2996,3003,3006,3078,3093,3124,3193,3233,3253,3256,3259,3290,3316,3331,3350,3366,3381,3433,3443,3467,3474,3483,3498,3535,3546,3556,3568,3578,3603,3606,3610,3620,3626,3644,3675,3689,3696,3699,3701,3712,3723,3734,3764,3766,3767,3771,3773,3783,3785,3795,3810,3812,3814,3857,3858,3859,3871,3885,3896,3914,3915,3920,4048,4053,4054,4060,4093,4095,4117,4122,4132,4133,4142,4148,4182,4185,4186,4194,4228,4285,4336,4399,4418,4421,4428,4451,4458,4504,4518,4530,4533,4545,4556,4569,4570,4626,4654,4695,4730,4752,4757,4786,4788,4792,4809,4813,4866,4880,4887,4889,4905,4917,4992,4997,5022,5040,5085,5102,5140,5166,5192,5195,5197,5263,5302,5330,5335,5425,5427,5428,5457,5458,5459,5476,5573,5617,5659,5685,5688,5698,5702,5710,5739,5759,5762,5793,5797,5812,5836,5874,5923,5927,5928,5956,5990,5993,5997,6008,6048,6058,6067,6072,6073,6077,6081,6117,6120,6122,6144,6173,6185,6201,6202,6243,6271,6324,6360,6402,6407,6419,6423,6429,6439,6440,6469,6479,6488,6502,6509,6513,6538,6544,6552,6582,6596,6620,6622,6637,6690,6702,6726,6728,6747,6756,6764,6803,6826,6834,6845,6848,6875,6883,6889,6896,6900,6904,6932,6965,6967,6988,6990,7010,7021,7031,7037,7081,7103,7141,7142,7215,7244,7267,7275,7281,7290,7319,7375,7394,7398,7406,7416,7420,7430,7486,7540,7549,7554,7578,7607,7613,7614,7637,7650,7664,7692,7707,7715,7765,7774,7780,7825,7866,7911,7927,7941,7962,7967,7989,7999,8043,8119,8133,8149,8165,8205,8218,8220,8244,8285,8313,8357,8398,8412,8416,8417,8462,8475,8479,8487,8494,8533,8547,8560,8569,8592,8598,8674,8685,8687,8725,8786,8800,8809,8813,8824,8842,8891,8940,8946,8960,8975,8993,9033,9049,9053,9084,9088,9118,9138,9143,9149,9161,9163,9166,9207,9211,9227,9259,9280,9308,9311,9337,9339,9356,9359,9403,9461,9472,9499,9528,9530,9537,9573,9584,9611,9621,9636,9664,9677,9681,9701,9716,9747,9749,9756,9770,9780,9788,9810,9825,9830,9837,9846,9869,9872,9883,9884,9885,9889,9897,9921,9927,9932,9947,9968,9972,9994,10000,10004,10037,10057,10058,10061,10064,10128,10131,10133,10148,10160,10167,10226,10231,10236,10242,10249,10298,10348,10424,10428,10434,10449,10481,10509,10568,10575,10624,10700,10709,10717,10728,10777,10854,10906,10927,10934,10952,10955,10965,10981,10986,11012,11025,11032,11041,11054,11065,11131,11169,11173,11265,11277,11281,11306,11324,11359,11366,11384,11397,11402,11404,11446,11457,11483,11521,11525,11582,11592,11628,11663,11670,11675,11693,11706,11712,11727,11742,11756,11759,11762,11773,11784,11790,11828,11841,11846,11887,11925,11932,11997,12019,12022,12026,12044,12066,12082,12090,12106,12131,12135,12145,12162,12183,12213,12228,12229,12238,12246,12273,12278,12299,12308,12327,12328,12342,12344,12349,12357,12358,12360,12372,12412,12420,12432,12436,12455,12475,12481,12496,12530,12537,12547,12580,12581,12589,12609,12614,12636,12676,12700,12708,12725,12750,12794,12814,12816,12859,12868,12918,12939,12963,12971,12997,13003,13007,13014,13018,13023,13038,13048,13061,13072,13073,13103,13106,13108,13182,13185,13218,13255,13280,13343,13344,13346,13347,13350,13367,13390,13490,13505,13530,13541,13542,13550,13551,13554,13612,13657,13682,13684,13757,13768,13778,13784,13796,13804,13830,13833,13838,13841,13887,13899,13909,13920,13930,13961,13979,13981,14041,14047,14073,14077,14102,14110,14159,14177,14225,14281,14312,14316,14367,14371,14401,14430,14456,14522,14537,14558,14559,14563,14565,14579,14611,14612,14633,14634,14728,14830,14853,14896,14919,14927,14946,14948,14951,14957,15019,15035,15058,15065,15094,15109,15110,15112,15149,15167,15168,15192,15210,15216,15220,15258,15324,15334,15356,15370,15376,15387,15406,15410,15420,15451,15459,15471,15491,15492,15505,15531,15559,15582,15583,15595,15627,15659,15669,15672,15686,15689,15696,15708,15712,15727,15830,15865,15977,15982,15993,16016,16027,16029,16060,16091,16098,16112,16177,16197,16217,16254,16264,16271,16343,16358,16366,16370,16385,16394,16415,16418,16430,16485,16489,16525,16568,16602,16625,16635,16638,16640,16644,16656,16690,16692,16705,16744,16747,16854,16860,16882,16883,16894,16952,16955,16962,16963,17009,17033,17040,17089,17132,17143,17155,17165,17177,17181,17235,17280,17305,17323,17340,17342,17346,17421,17444,17457,17489,17491,17518,17535,17540,17542,17544,17561,17619,17630,17635,17642,17643,17655,17662,17770,17783,17790,17792,17851,17856,17876,17901,17913,17937,17996,18024,18053,18080,18082,18107,18157,18184,18192,18197,18232,18233,18244,18257,18267,18281,18284,18303,18377,18383,18402,18422,18470,18471,18565,18595,18610,18615,18682,18683,18699,18725,18744,18745,18760,18806,18865,18883,18892,18944,18963,18979,18981,19016,19017,19042,19074,19113,19120,19127,19131,19141,19161,19165,19174,19176,19188,19190,19191,19193,19210,19231,19240,19270,19288,19306,19331,19335,19341,19342,19348,19390,19428,19454,19465,19495,19522}'::bigint[]))
  • Rows Removed by Index Recheck: 5
  • Heap Blocks: exact=168
2. 1.236 1.236 ↓ 1.0 1,005 1

Bitmap Index Scan on index_id_hash (cost=0.00..988.50 rows=1,000 width=0) (actual time=1.236..1.236 rows=1,005 loops=1)

  • Index Cond: (id_hash = ANY ('{14,17,19,31,43,46,70,145,172,255,268,286,358,408,414,415,422,476,514,518,526,591,619,647,657,668,678,695,726,745,764,765,767,782,791,802,819,841,864,876,888,896,908,919,928,971,987,989,994,1020,1051,1058,1081,1087,1119,1144,1163,1177,1189,1193,1231,1272,1288,1289,1293,1316,1333,1348,1351,1357,1401,1402,1420,1434,1441,1454,1504,1519,1540,1564,1577,1621,1624,1630,1635,1672,1679,1684,1697,1755,1766,1771,1772,1804,1814,1824,1840,1842,1846,1853,1866,1869,1889,1893,1903,1930,1933,1937,1990,2000,2057,2058,2066,2075,2085,2087,2096,2102,2129,2134,2173,2183,2203,2256,2260,2264,2299,2333,2349,2401,2420,2454,2486,2511,2517,2525,2540,2576,2585,2605,2644,2715,2727,2774,2797,2802,2816,2846,2868,2882,2886,2889,2903,2952,2981,2996,3003,3006,3078,3093,3124,3193,3233,3253,3256,3259,3290,3316,3331,3350,3366,3381,3433,3443,3467,3474,3483,3498,3535,3546,3556,3568,3578,3603,3606,3610,3620,3626,3644,3675,3689,3696,3699,3701,3712,3723,3734,3764,3766,3767,3771,3773,3783,3785,3795,3810,3812,3814,3857,3858,3859,3871,3885,3896,3914,3915,3920,4048,4053,4054,4060,4093,4095,4117,4122,4132,4133,4142,4148,4182,4185,4186,4194,4228,4285,4336,4399,4418,4421,4428,4451,4458,4504,4518,4530,4533,4545,4556,4569,4570,4626,4654,4695,4730,4752,4757,4786,4788,4792,4809,4813,4866,4880,4887,4889,4905,4917,4992,4997,5022,5040,5085,5102,5140,5166,5192,5195,5197,5263,5302,5330,5335,5425,5427,5428,5457,5458,5459,5476,5573,5617,5659,5685,5688,5698,5702,5710,5739,5759,5762,5793,5797,5812,5836,5874,5923,5927,5928,5956,5990,5993,5997,6008,6048,6058,6067,6072,6073,6077,6081,6117,6120,6122,6144,6173,6185,6201,6202,6243,6271,6324,6360,6402,6407,6419,6423,6429,6439,6440,6469,6479,6488,6502,6509,6513,6538,6544,6552,6582,6596,6620,6622,6637,6690,6702,6726,6728,6747,6756,6764,6803,6826,6834,6845,6848,6875,6883,6889,6896,6900,6904,6932,6965,6967,6988,6990,7010,7021,7031,7037,7081,7103,7141,7142,7215,7244,7267,7275,7281,7290,7319,7375,7394,7398,7406,7416,7420,7430,7486,7540,7549,7554,7578,7607,7613,7614,7637,7650,7664,7692,7707,7715,7765,7774,7780,7825,7866,7911,7927,7941,7962,7967,7989,7999,8043,8119,8133,8149,8165,8205,8218,8220,8244,8285,8313,8357,8398,8412,8416,8417,8462,8475,8479,8487,8494,8533,8547,8560,8569,8592,8598,8674,8685,8687,8725,8786,8800,8809,8813,8824,8842,8891,8940,8946,8960,8975,8993,9033,9049,9053,9084,9088,9118,9138,9143,9149,9161,9163,9166,9207,9211,9227,9259,9280,9308,9311,9337,9339,9356,9359,9403,9461,9472,9499,9528,9530,9537,9573,9584,9611,9621,9636,9664,9677,9681,9701,9716,9747,9749,9756,9770,9780,9788,9810,9825,9830,9837,9846,9869,9872,9883,9884,9885,9889,9897,9921,9927,9932,9947,9968,9972,9994,10000,10004,10037,10057,10058,10061,10064,10128,10131,10133,10148,10160,10167,10226,10231,10236,10242,10249,10298,10348,10424,10428,10434,10449,10481,10509,10568,10575,10624,10700,10709,10717,10728,10777,10854,10906,10927,10934,10952,10955,10965,10981,10986,11012,11025,11032,11041,11054,11065,11131,11169,11173,11265,11277,11281,11306,11324,11359,11366,11384,11397,11402,11404,11446,11457,11483,11521,11525,11582,11592,11628,11663,11670,11675,11693,11706,11712,11727,11742,11756,11759,11762,11773,11784,11790,11828,11841,11846,11887,11925,11932,11997,12019,12022,12026,12044,12066,12082,12090,12106,12131,12135,12145,12162,12183,12213,12228,12229,12238,12246,12273,12278,12299,12308,12327,12328,12342,12344,12349,12357,12358,12360,12372,12412,12420,12432,12436,12455,12475,12481,12496,12530,12537,12547,12580,12581,12589,12609,12614,12636,12676,12700,12708,12725,12750,12794,12814,12816,12859,12868,12918,12939,12963,12971,12997,13003,13007,13014,13018,13023,13038,13048,13061,13072,13073,13103,13106,13108,13182,13185,13218,13255,13280,13343,13344,13346,13347,13350,13367,13390,13490,13505,13530,13541,13542,13550,13551,13554,13612,13657,13682,13684,13757,13768,13778,13784,13796,13804,13830,13833,13838,13841,13887,13899,13909,13920,13930,13961,13979,13981,14041,14047,14073,14077,14102,14110,14159,14177,14225,14281,14312,14316,14367,14371,14401,14430,14456,14522,14537,14558,14559,14563,14565,14579,14611,14612,14633,14634,14728,14830,14853,14896,14919,14927,14946,14948,14951,14957,15019,15035,15058,15065,15094,15109,15110,15112,15149,15167,15168,15192,15210,15216,15220,15258,15324,15334,15356,15370,15376,15387,15406,15410,15420,15451,15459,15471,15491,15492,15505,15531,15559,15582,15583,15595,15627,15659,15669,15672,15686,15689,15696,15708,15712,15727,15830,15865,15977,15982,15993,16016,16027,16029,16060,16091,16098,16112,16177,16197,16217,16254,16264,16271,16343,16358,16366,16370,16385,16394,16415,16418,16430,16485,16489,16525,16568,16602,16625,16635,16638,16640,16644,16656,16690,16692,16705,16744,16747,16854,16860,16882,16883,16894,16952,16955,16962,16963,17009,17033,17040,17089,17132,17143,17155,17165,17177,17181,17235,17280,17305,17323,17340,17342,17346,17421,17444,17457,17489,17491,17518,17535,17540,17542,17544,17561,17619,17630,17635,17642,17643,17655,17662,17770,17783,17790,17792,17851,17856,17876,17901,17913,17937,17996,18024,18053,18080,18082,18107,18157,18184,18192,18197,18232,18233,18244,18257,18267,18281,18284,18303,18377,18383,18402,18422,18470,18471,18565,18595,18610,18615,18682,18683,18699,18725,18744,18745,18760,18806,18865,18883,18892,18944,18963,18979,18981,19016,19017,19042,19074,19113,19120,19127,19131,19141,19161,19165,19174,19176,19188,19190,19191,19193,19210,19231,19240,19270,19288,19306,19331,19335,19341,19342,19348,19390,19428,19454,19465,19495,19522}'::bigint[]))
Planning time : 1.067 ms
Execution time : 4.024 ms