explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2a2P

Settings
# exclusive inclusive rows x rows loops node
1. 4.279 78.505 ↑ 1.0 4,738 1

Sort (cost=3,606.02..3,617.87 rows=4,738 width=51) (actual time=77.982..78.505 rows=4,738 loops=1)

  • Sort Key: (_st_distance(COALESCE(zone.geodata), '0101000020E610000000000000008048400000000000002040'::geography, '0'::double precision, true)), zone.zip_code, zone_enforced.ext_zone_code
  • Sort Method: quicksort Memory: 799kB
2. 62.324 74.226 ↑ 1.0 4,738 1

Hash Left Join (cost=205.23..3,316.77 rows=4,738 width=51) (actual time=4.513..74.226 rows=4,738 loops=1)

  • Hash Cond: (zone.zone_id = zone_enforced.zone_id)
3. 9.741 9.741 ↑ 1.0 4,738 1

Index Scan using zone_pkey on zone (cost=0.28..1,914.88 rows=4,738 width=206) (actual time=2.054..9.741 rows=4,738 loops=1)

  • Index Cond: (zone_id = ANY ('{2127,6539,5163,2514,7046,1694,720,2296,3804,1600,3662,862,4558,3100,1580,4868,2199,766,1640,5507,5949,3944,3718,2082,3659,6626,5922,4077,2676,3181,3736,1088,6714,5710,2352,1077,1438,1736,4338,5671,5212,5630,6099,5719,5653,4688,3056,3801,774,4040,3455,4846,4896,1173,3491,3706,4797,5056,2138,5751,5669,6751,3760,6557,6676,5943,6559,2662,4645,6645,1650,3822,4691,2475,3286,3786,5036,4308,1699,5698,1239,4756,4003,854,5631,6254,4252,7300,1690,3040,5119,5249,1544,1698,3569,4937,2522,5263,6663,1700,6341,2626,1530,6675,4073,5854,5925,6607,1939,671,3383,4419,6106,6135,6741,6430,2472,710,4486,4991,3359,2007,4006,5703,770,4123,4714,6109,6606,982,3015,5608,1389,5745,5699,1788,5554,3356,5939,874,3504,5245,5721,5871,1621,7297,5831,6613,905,1543,3699,2824,5736,2834,3563,1370,6654,4203,1020,6248,6167,3495,2738,5024,6230,931,1738,1048,5494,5373,6641,3257,4933,2730,932,6945,4735,6237,4457,1790,7086,6830,4402,1590,3216,1429,4407,978,5032,5692,6540,630,5760,4840,4805,3747,819,3182,5282,2217,6441,4099,4658,4035,2652,1609,2524,3027,5647,4291,6549,5477,6032,5234,4189,2725,5153,1800,3768,5079,5178,4323,1630,2049,1601,2362,5607,5141,5400,5661,4215,991,1029,4093,4759,5747,1958,6623,2784,256,6926,2715,1708,4399,5485,5505,3228,1381,3671,707,4069,3470,4142,2374,996,4943,2622,6610,1495,3811,4168,4542,6223,2703,1742,3044,3938,5227,1814,7072,4384,6927,1014,5044,3982,3933,3218,1756,1685,2417,1170,4599,2437,3206,3835,4637,1727,737,3992,3088,6720,1937,1078,4811,6906,5955,5437,3148,6019,2821,3294,3647,2276,2551,847,6449,4287,6149,1446,6496,4165,6482,3032,1546,6739,3064,4723,6673,5109,3137,3432,2691,760,1524,1109,5856,6487,6002,1695,2248,687,6519,3784,2956,3062,1955,2381,2729,7073,1089,6021,6276,4449,4524,7008,2307,6253,1160,3764,6904,779,3547,4438,4221,3423,731,873,4057,2080,4147,4527,6962,4854,975,5868,5261,1660,5502,3984,5715,1004,5060,3962,6857,5387,4972,961,2673,4317,3939,1712,7049,5633,3893,4296,4777,2639,6691,6534,1345,2193,5850,1103,1716,880,4921,5154,7053,3463,6148,1197,7007,718,5571,5009,4660,3336,967,2732,5273,758,3018,5003,3875,3940,3581,6001,2872,972,6127,726,5396,4594,1767,4299,3999,1385,3763,871,2656,2115,6282,3290,1406,3500,2613,1682,1118,4683,2699,3693,1080,4557,603,3123,3143,5020,2559,785,2292,2664,6172,2518,4729,6271,1647,6124,5933,3774,3572,6511,1585,6770,3253,3567,1571,1764,5702,5726,4891,1168,4727,4835,2170,1735,1572,6255,5129,1725,6516,559,3199,4138,6943,3553,5995,654,4713,5623,4617,5564,3890,702,1592,808,5836,2526,4795,5700,5225,4174,3055,3712,1377,6035,1952,5599,3812,3296,4758,6204,4055,4990,699,2303,4152,5695,1680,4243,7094,5470,1113,5697,6955,3312,4676,6138,2642,6510,5851,2853,1632,4865,5835,3636,1792,4730,1083,4581,2717,7079,1547,1582,6061,1369,1617,248,3821,3140,6092,1058,3284,3352,1940,4208,3046,4196,971,5161,2819,7091,3739,6233,5616,5049,1789,3171,6132,5364,778,2149,1105,5621,1662,3833,4959,2315,1107,5057,4177,6205,4773,5103,6181,2529,4874,2469,4922,4075,6526,5137,733,6485,4745,2345,4094,5487,6115,1618,5181,3298,4600,4045,4204,1435,1648,3304,4327,963,4717,4262,4277,4450,730,3507,7093,5465,1101,3874,4589,927,719,989,5136,7183,4778,3973,4361,4924,3013,1548,4195,771,5775,3039,6602,1717,2088,5727,688,974,2532,1063,6702,4863,3252,3969,3734,4850,4476,1022,3780,1149,6815,4987,1612,1414,3496,1342,5271,1416,6043,3263,5018,3800,704,6734,886,1081,7005,4113,5744,2727,1009,3668,3918,3902,3144,6622,895,4263,6188,864,4382,5459,1715,2814,995,2343,6794,4657,3927,2641,2206,3828,6656,1574,4058,708,6231,6212,3576,4639,3905,1773,6460,848,6213,1946,3765,4228,3061,5185,1236,2710,4771,1186,4650,4559,5226,2287,797,4496,740,1520,709,5767,5953,1372,1954,4082,4108,2709,2558,4130,714,5613,3307,4903,5041,4861,2173,4375,1567,5771,2697,3230,6480,3311,3191,6175,2086,2516,1588,2836,4048,1689,4880,5676,2552,5201,6732,6505,4587,5208,6180,4247,2434,2714,1663,4553,3541,4133,4564,7119,6721,3486,6821,2203,4740,3681,1526,5365,2756,6218,3451,2044,4946,4483,1206,1508,5769,1894,4562,5089,3134,6565,5128,5863,5081,5149,7080,2465,3713,4763,5957,5008,5491,5614,5665,6344,4131,4385,4084,6266,1868,1604,3548,3863,4311,1002,705,1512,5821,4852,4330,6444,4443,2264,5619,1561,1237,6250,4584,2336,6042,3258,2311,3543,2753,728,1085,4619,3265,2175,1202,4412,3808,6710,5999,6548,5014,5148,1628,7107,6103,3176,5046,1595,3287,3092,759,1702,3568,3887,7102,2857,5248,4608,1522,3958,1760,4301,6156,1507,741,1999,6715,3709,3385,3353,5737,2800,964,5250,5004,4280,3782,953,729,3725,6836,2442,6434,4205,1001,3381,5802,4321,1784,1064,6655,1646,3626,4755,4498,3909,4050,4110,735,1203,4772,6749,6828,3355,4867,4372,3474,4008,4512,5199,4669,3117,5063,5440,7114,6242,4677,1701,3070,4202,3922,7130,5224,6604,780,3871,721,3559,4508,4400,3834,6158,2126,6791,3187,4702,2412,6695,4682,3082,1713,6038,3702,6507,3376,3809,5833,1005,1705,1531,5114,2153,4950,6740,1114,5368,5550,5264,1554,2091,3095,1390,3722,5122,1765,1692,1090,1200,5359,2302,5393,1383,6493,3247,2189,2184,5039,5388,2734,1018,1997,818,5443,4461,2785,6688,6034,1119,3895,2005,5762,3333,5156,5015,3757,4025,6451,4102,1208,3157,4379,6719,4087,6621,4726,4974,4804,2124,1740,3068,5061,4234,8,5936,2325,6536,2162,2396,3697,5790,3942,4300,703,2829,5605,3632,3125,4083,4981,4135,1478,2141,4090,6804,2698,6618,3083,1082,3802,4614,2741,5461,5930,6517,257,6847,4274,6896,3188,968,6859,5188,1949,5438,3998,4446,1576,2233,3762,4043,1117,2579,6928,1019,6748,7090,5670,942,2379,2663,591,3072,4511,5659,3477,5071,3705,2407,4962,3342,6605,29,4695,5839,3031,4433,6518,2254,925,3587,2347,3884,1441,5787,2004,632,5022,937,5847,804,1151,4975,4670,1384,5944,6787,5050,3468,5723,6684,4125,3791,1205,45,3344,2813,4977,2413,5743,6693,6818,9,4246,2574,6274,5243,1779,6443,5162,4307,820,958,846,713,4606,901,3420,4078,1933,2520,2755,6150,6432,4140,2160,2958,1528,5694,3967,6797,893,3198,4627,6067,5645,2064,825,6025,5117,3936,4223,1570,3824,5945,3672,756,3508,5358,747,1696,1642,1688,5023,4685,6275,4481,5075,717,1337,6102,2823,5813,6177,6079,5314,5861,2046,2288,4155,2260,2723,1139,2378,2733,6665,3232,5085,5816,5992,2218,4304,2042,1092,821,6921,1675,7054,722,3210,6098,2651,6225,5576,3297,777,3565,3759,2789,4105,6674,6701,3685,1884,1869,6531,1803,3857,44,6433,25,5741,4596,5133,3947,4690,1578,4901,7134,5558,3826,6694,5144,3856,2171,3209,4074,5921,5233,4689,6232,4624,980,5774,2745,4534,1459,3844,5739,2712,5160,3639,1633,2865,4629,6047,6901,987,2187,1539,3586,3795,2118,1436,6718,4037,3295,7048,5644,6620,5844,6260,6281,1050,3745,955,7089,4448,4080,4185,1030,692,6257,250,3511,6214,2737,1084,3649,5072,6185,1204,4303,4383,3955,3816,4421,6224,4211,970,1678,5065,4739,1812,5956,6651,3814,5211,6249,3679,3048,4066,894,4191,5866,2828,4022,4012,6118,6096,3281,1532,4970,2783,690,930,6203,5062,5693,1562,4973,4064,4821,6632,1193,6938,6199,4849,1599,1697,4654,1052,3279,6463,5204,6803,1755,2192,3245,2742,3208,4908,5240,6822,969,6731,6529,3670,1691,1768,1481,6234,4824,7087,5701,3020,2133,6217,5381,1762,739,2354,3683,6472,4160,3761,5830,1196,6186,4166,2135,959,4364,6743,3314,3696,7104,6810,4417,4699,5625,3315,952,5012,1813,888,1112,4621,5657,2262,3108,6114,3186,5327,6116,5448,2726,3664,1388,1424,6111,715,1238,3058,6279,6899,6781,6636,6912,4887,6678,2438,2041,3505,3178,4218,2668,6082,6524,6530,3551,3482,6226,5370,3775,4239,859,2363,2181,1373,1162,2535,4747,6178,4493,3974,6569,6806,1100,3306,5678,5806,1956,1639,5315,4100,4011,1426,2148,1653,5042,6513,3207,3086,4700,3256,5704,3021,7071,255,2525,3898,6848,755,6649,6064,5679,3310,1055,4345,5804,2713,5800,5086,5093,2838,5823,2695,1163,1823,4757,4732,6819,4114,2194,2809,2119,6142,1454,5673,2630,6083,3954,4844,5270,4088,950,5031,4709,724,3345,2283,5688,4015,2370,6869,5279,6497,4500,2878,1066,6775,2752,2669,3196,3577,2397,4666,4368,6013,2716,5798,6805,3840,3244,3419,5499,2375,2075,6261,5247,4403,3872,1021,4983,1866,6133,4264,5729,5259,773,4051,5092,3946,1719,3516,1471,1741,4391,3952,5649,3703,5780,3211,1718,1104,2690,3179,5615,3045,3361,5582,5785,2874,6542,3813,5471,2200,4819,5770,3119,1027,5674,1941,1428,3925,841,5827,6104,4436,712,4793,6456,1610,4325,5559,4334,4560,1855,1431,4249,1797,2309,6564,6528,2317,3102,5147,6063,2385,6272,2863,6239,899,4561,1375,7125,875,2047,4484,6769,5077,701,1504,4305,997,6881,6853,1106,5931,7121,2056,5941,4343,4938,4052,1423,1474,4928,6929,1865,3375,3532,1017,2305,1876,6913,1166,2205,2876,5013,4565,6210,3985,2001,3283,5750,4590,2299,2176,5102,2349,1945,746,6648,2157,4554,4404,4999,885,3751,3995,6845,1420,6494,5591,6195,2134,3994,4567,4652,4442,4388,3106,6285,4478,3113,6452,1943,5924,6050,4920,800,5838,4294,1380,1102,4318,6689,2266,2466,2435,4556,4742,2154,5592,3643,6247,1157,2059,857,5138,3033,5221,2775,4267,4144,4994,1769,4843,4904,5809,4632,6159,4764,1194,3129,2822,3914,6905,4643,4169,4380,6056,742,716,4458,3282,3926,809,4566,2831,1347,3953,5641,1564,4425,2178,2700,2359,6027,3350,3118,2117,3861,5453,1558,6696,6049,1746,5040,3818,5622,6916,1336,6081,5067,4563,5010,3853,858,1593,3651,5367,7074,1889,5757,5570,4883,6545,4452,3036,3810,251,1581,2957,3767,2744,2638,4406,4143,3260,4738,3989,1754,5006,4815,3204,5942,4817,1806,5725,1115,1957,4010,1637,3316,845,4225,2045,3239,6094,5450,3675,6122,3899,2081,1346,5457,3071,4235,2565,6934,4424,1951,4214,6194,5748,6833,993,3627,3829,1550,4766,855,6120,5578,2614,2342,1099,4910,6051,1339,3422,4480,6219,2731,1461,956,4319,6946,1340,5862,4333,3115,3225,4741,5159,965,2079,3742,1521,6670,4965,2578,4363,5808,772,3656,1476,1098,6041,4389,2172,1824,2216,7085,4860,3436,5369,4376,6682,6669,6898,5123,960,2198,3440,253,2444,6093,2647,5376,3966,945,2361,4157,5718,4848,6855,904,560,1565,3308,6090,3183,4482,1062,1541,2533,1011,5675,1802,5636,6595,727,1529,1355,2376,4721,3360,2207,2068,7126,5184,2720,5812,2191,1597,5781,3877,3827,7063,2420,3580,7299,6044,4576,3819,6206,6054,6768,1514,2433,3153,1462,4832,4440,2055,5998,5121,6865,5948,2719,3673,4285,3291,6016,2364,3686,6153,4847,6484,2054,5951,4649,5708,6461,637,843,6033,2310,6570,6907,861,2039,5460,4509,4233,1942,3836,5157,5277,619,1023,2536,1415,2295,2241,2089,6060,6065,3267,5997,5155,6742,5642,37,1405,4707,6471,2735,5504,4298,4696,6608,1483,1726,1386,3146,1626,1410,2728,2959,4580,3243,4309,6708,5929,3089,2649,1622,5870,6910,4290,3956,1403,3798,4866,5788,3894,946,5934,1086,3743,5495,5720,3682,1859,3642,1456,3127,673,3369,2301,4888,5791,5650,3461,4095,1473,3735,6208,1169,5244,3570,1076,5255,4586,3012,5624,4746,3112,6244,4141,1120,5363,2628,4895,3341,6666,3152,1097,2128,4914,1771,7076,3289,3478,4796,3635,768,2188,6251,2961,6131,1070,3464,6499,3351,6944,6215,1613,6126,5824,1643,5912,3585,6882,3823,7257,6238,6614,4958,1953,3653,7101,2093,1542,4675,6790,3073,2053,957,6635,5864,1938,2754,977,5563,4807,3288,3575,700,6700,4540,4505,5776,2570,4028,2422,3661,4648,3806,4172,4149,4770,2169,5235,2625,6598,6838,2718,4518,4273,1523,3892,3131,4929,5007,4710,3302,4409,693,1475,4224,3042,5051,6773,6171,6134,6057,3377,4671,6692,6637,3492,2470,6538,1950,6140,3126,6532,4199,3654,984,4980,2441,5728,5311,3293,1073,1348,4374,4462,4027,1241,4018,1371,1452,3658,1810,2689,6685,1785,891,7088,3434,3900,2569,4173,2369,4613,6086,6264,6097,4460,5740,5183,6762,3026,6624,2246,1407,3882,4401,6202,5603,4997,5646,4626,4574,3630,1387,4526,4882,986,4193,2880,6446,6119,3732,5321,4286,5380,3997,4976,5825,2003,2314,4853,5026,5284,2308,254,4708,6046,6856,4089,6774,6130,6920,2421,2408,2399,1159,2534,3090,2179,5826,1886,1472,3869,6525,7057,1748,5140,3241,2358,3037,5462,4395,2833,1598,5488,4909,782,5954,6629,736,1603,4799,4322,4422,1732,6782,6023,2634,6750,6477,3484,3885,3666,4956,4278,4021,725,5099,4499,4434,3854,3754,2858,3915,7051,7095,6245,4837,1704,2320,1458,706,5575,6512,3224,4447,1605,3195,2125,4065,6147,4833,3374,929,3053,5456,2243,5879,5190,6730,2724,2467,4982,2177,2675,1003,3737,1505,5920,3205,7097,5073,1095,4602,6537,6113,3803,6504,6161,3023,5492,2869,4841,6105,4687,5481,4503,3518,4423,6136,3237,4466,4352,4601,5209,6168,3860,5112,3738,1839,5843,2269,5283,3793,5325,6466,4701,5677,4237,4592,7103,4097,4504,3676,4118,5395,5150,2736,4229,3820,4692,4456,1944,4836,781,3074,2577,1110,4899,4454,2337,4698,6197,4297,6011,5632,776,4115,4473,872,1781,3292,1870,4751,6657,6690,5033,3640,5865,5029,4230,4582,1026,5195,2530,5360,2817,5483,3677,1645,4775,5069,5080,4750,3380,648,3908,6110,1935,3960,5915,5082,4184,6717,7043,4513,3988,803,4332,1649,1000,3014,868,6495,3479,840,1629,2161,4023,3472,4344,5382,6950,4625,7082,3233,1150,3047,5952,2388,3923,3574,6139,3546,4398,902,1350,6243,5278,889,5391,3889,1534,761,6567,3264,1775,4217,3136,3911,4437,2197,5135,1931,686,3421,2293,7092,3158,5640,2387,3723,4912,1624,3490,6066,2201,3943,6653,2298,763,6800,1341,2916,6568,3160,4164,6012,4656,4106,979,1087,2166,5810,3714,6465,5475,1552,1809,6560,3194,4222,5489,3753,3971,1468,5696,3867,6617,5926,4897,4268,5016,1731,6270,3717,6727,6155,5019,3097,3382,1607,3255,6469,6522,4673,6880,5655,5853,1553,1525,4455,2069,3076,2760,4209,4156,6903,5709,1374,6777,5038,4162,6634,2740,4894,4148,4491,5714,1482,2290,6932,5191,2238,3063,6596,4313,4693,2875,1111,6026,5797,4800,3234,2285,3538,5828,4004,4647,4181,4275,4630,6681,6772,2116,3212,6523,5202,6269,1706,2561,3357,3466,6686,4418,6015,1209,2164,4070,3740,6687,4790,5842,4642,1575,6246,4248,5932,7050,3169,2704,5742,4351,898,5222,2297,3133,3503,5946,1510,900,4250,1751,6924,6445,1455,6006,1749,6566,4198,6007,7078,3476,5145,1786,4623,3773,3473,4506,4129,4120,4884,2389,2519,7081,2650,7059,1091,3707,5928,1061,6256,4190,5749,5755,4183,5682,3494,2547,2686,2778,3929,6481,6795,2411,6470,1492,4620,1579,1750,3756,5111,2802,948,3758,2779,5001,5768,6925,1747,5799,1804,2265,2527,4539,2196,876,5511,2960,2436,4271,6464,6018,3093,5707,10,1930,4453,4892,1831,2168,4192,5606,2761,7000,3167,4754,3075,2319,5772,4413,4054,3378,3708,5213,5732,1753,3779,4047,6603,2386,3778,623,1745,6908,4851,4546,4803,5146,4934,4295,6101,1644,3240,1463,4429,5637,4985,5272,5242,5648,4414,4575,4548,2338,6459,4953,2791,6936,1816,5120,2380,2636,2333,3368,1807,3262,5486,4253,6189,4618,6030,4314,4000,850,5442,5441,1069,2531,988,1934,4444,4678,1477,5083,3650,6227,4242,6552,6174,4597,1673,6221,6633,6941,3079,2708,4622,2084,4366,6184,4293,6724,3667,4426,4871,4302,4872,5374,2648,4365,4679,5764,2414,5098,3678,2864,5730,3111,3370,745,6173,6698,2835,4595,2328,2557,4468,5860,4932,5855,3584,1349,4091,3837,5840,4315,6091,4737,6601,2633,3078,7120,4776,5017,5834,5231,6024,842,7128,2323,6169,1412,844,3776,3831,5927,2183,4197,890,2812,4898,3506,5601,1743,4978,5451,2635,5377,4463,5392,3921,5789,5218,3358,2573,1573,5194,3698,2331,5043,4464,849,962,5478,3691,3912,4816,7077,5796,5735,1335,3730,7002,4408,4170,7132,3101,4828,3566,6831,6754,6166,4358,6771,5132,5832,4788,1805,4244,6435,1841,3130,1093,2575,4748,6662,4598,5596,5449,738,3025,3815,2787,1596,4593,4279,5585,4783,6713,3278,4905,1176,5090,1960,4917,4877,3147,1449,4034,5610,2300,5722,4603,4320,5027,5761,1480,6919,2515,3919,1757,3202,679,6631,4046,5734,4411,6704,4306,6486,5458,3896,5011,1116,4349,6229,2356,3977,4471,985,2545,3142,7062,7068,4810,5756,3648,2632,4255,6615,1948,4879,2856,2334,1028,884,6162,3807,6211,1877,2432,1594,5223,3777,5994,3165,3838,1448,6543,3910,5164,6677,1710,6468,6619,3372,1795,6053,5643,5048,2576,2627,6235,5573,6835,3510,6914,5611,1470,1334,4604,3750,5028,3141,7067,6752,4900,6627,5940,3246,4238,1057,4949,3164,6942,2571,4178,2684,2860,1761,4312,3197,3975,1479,1493,3858,3149,6846,3787,5268,5852,6200,4369,3346,992,3441,5452,2165,5857,3805,4925,4523,4573,5783,2567,2674,5959,1674,6792,5565,2322,877,2473,3766,5312,5076,4514,4728,6141,3950,6644,4326,4907,2330,1008,4335,2182,6646,4535,3733,3987,3138,6117,1584,5066,6533,2701,5375,6723,4537,4067,3266,6868,4825,3934,1457,2810,3797,5753,4519,6088,4036,5110,5680,3646,2123,4988,6547,6252,7329,7064,7117,6277,1352,2666,3221,6483,4346,4092,5829,2247,2060,5784,1569,6911,3539,1445,3185,5228,1343,4631,4992,4357,4733,6515,4492,5568,5170,5849,4053,2572,6163,6872,2654,3817,7047,4394,1729,6801,4270,6429,1059,3067,3213,2395,1874,4528,3334,3907,4724,2341,5820,5878,4881,4014,6157,5265,4716,2043,5104,4390,4532,6240,6036,4864,4651,4259,4664,1619,2078,3011,1518,3339,3309,4179,5267,4820,4086,3937,5609,6895,5911,6796,1425,4136,1880,4079,4769,2348,4963,4381,1447,1872,6949,6087,4266,4475,694,4971,4906,2244,6022,1566,3873,6709,3180,6885,27,4919,5280,1060,7099,7070,6755,4340,6816,249,5581,4886,4611,1703,6059,2406,4718,4653,607,4336,4785,3301,897,926,3338,4487,3124,3579,4995,3177,3583,3059,4427,4362,6947,6894,2631,580,3028,7108,2859,3116,6300,1172,2560,2866,2083,4009,4612,4989,2391,1739,4684,4744,3214,4734,5778,5746,2073,4641,1659,1516,869,5490,4549,5476,1778,1882,4485,4571,1549,5819,5814,6839,5037,5229,3487,2306,4386,4665,5317,1007,1683,2643,4017,1614,4986,593,4705,1338,7131,4607,6236,2873,3305,4501,6216,4251,3236,1551,5660,1672,4845,5738,5777,5372,1351,4680,3,4715,723,3582,1511,6952,2180,6209,6201,5712,4634,5947,6558,1356,5385,6008,3878,5869,1408,3983,6442,5143,4813,4150,6454,1770,3041,5266,2687,6922,1833,4538,4801,3017,3897,3450,1867,1555,7133,4712,2517,4545,4659,5257,4931,784,3509,2665,3744,6009,762,6746,2327,2142,4952,6280,3437,4370,3724,5142,1830,3373,4541,6457,3832,4256,5711,5638,954,2163,5097,4570,3029,2121,6652,2120,3280,5567,2155,4213,5444,3217,7058,6020,5186,5207,4441,4019,4033,4063,2757,6190,5439,5107,5455,4060,1811,935,1881,4646,966,3193,1484,5501,4103,1025,1054,2368,568,1487,4161,7006,5252,5326,3533,5472,3022,4101,4955,4041,3684,4445,3830,4397,2818,689,4081,1024,4354,5389,4694,3560,4200,4720,3931,3561,3331,2100,4497,4842,3660,5068,2722,6458,6017,4139,5256,2335,1494,4644,5166,3886,4838,6179,5604,5281,6939,1709,3030,3891,1501,6793,5096,6052,3690,2351,5754,5667,1171,7065,6448,3729,6262,4124,4378,1591,5269,775,6997,4016,5937,7055,4547,3481,4153,4488,2629,6055,4681,2546,1774,4112,4951,4342,998,4954,867,802,6892,4762,4668,5626,3159,839,1158,4878,2877,4428,6930,2671,6661,3172,4107,4998,4013,2371,5246,5786,5210,2637,976,5634,5480,5074,4792,1460,5572,5390,5867,6767,6827,5193,2431,3644,4655,1489,2537,1513,4941,2150,1191,4822,2313,3903,4056,4531,4219,2550,6193,6474,5822,3445,3657,3034,4474,6089,2443,5716,3098,5651,1887,5105,5274,6909,6488,4516,7105,6170,3674,2440,2340,4328,3839,3435,5958,3864,3227,4415,2677,2474,5724,6725,4521,6182,4261,6137,1557,7100,4201,6660,1829,5002,1932,2780,4823,4420,4583,6028,3755,4530,939,4119,5803,5473,6716,6954,4477,1838,5805,4926,5792,2430,3711,1638,634,7060,1711,6259,6802,4923,5801,6045,6753,3317,2816,6851,5241,6616,4591,6544,769,6659,4371,3825,5237,4392,2239,3128,4704,4377,6829,4568,5510,1344,4039,5706,6187,5094,4353,3156,5629,4258,6527,4510,4984,3680,4802,4137,4522,3578,1606,2721,5817,1404,1864,5503,3371,4875,6152,5484,4555,1189,1517,4282,5165,5025,5134,6778,3367,4329,4032,1153,4533,1832,6241,4145,6991,4167,5053,3920,3168,4151,6476,3976,4269,6600,5583,5763,1744,3332,2316,5152,3069,4479,1752,4062,4968,6612,798,6783,7084,6129,3716,5059,2914,5497,4636,1240,6100,4911,1658,5639,4885,4936,6037,2793,6475,799,6931,5469,5262,5466,3870,3930,3222,4360,4470,4494,3916,6521,587,1620,6176,6776,3122,4116,572,4940,3517,1883,4831,7069,4001,3489,3704,5371,3789,2106,4292,5498,3970,4927,870,2774,2786,1577,4024,2000,3189,2365,6854,5151,3868,3238,4044,3972,6563,6228,983,4002,3235,4431,2373,6918,6747,3628,2002,6611,4405,2624,4812,2409,5275,5384,4117,5253,3928,1108,3019,4316,2174,4180,6062,1094,616,1947,4111,3652,934,2815,2072,2304,4254,3091,3688,4966,2289,3963,1723,1430,6917,4469,1586,4605,2801,3986,2696,4465,5064,3959,1772,1849,2294,3254,744,5217,5168,1376,4550,6902,5000,6123,1382,3035,6004,4188,1936,3695,1509,1015,6832,2790,6467,3135,6680,6951,6080,990,6820,5172,1627,4272,1583,1737,4753,2554,5717,2403,4808,1444,4915,22,5084,4948,5627,5482,1065,5054,866,4609,1006,4780,4858,5088,5474,2739,3883,4818,6609,3303,2167,3876,5580,6509,26,4490,5752,743,5366,3641,3084,5447,4633,3629,6128,3498,5169,7122,4719,5127,3488,3749,6283,4245,7118,5549,3794,6993,3248,6699,4862,2324,6121,6858,3184,863,2477,5254,1635,4059,4942,1602,4736,2291,5313,6703,4525,6164,4146,3901,3249,3446,3865,6263,1072,2667,3790,1787,3471,4339,6125,3161,3687,4706,7056,947,4964,3085,6658,6668,1652,6683,6084,4722,3556,5467,1485,2678,7096,2415,4210,4347,5045,6498,4859,1777,4416,3442,1893,3881,4939,4020,1079,5052,5794,801,1676,2344,1616,6108,4889,4711,5113,6745,1450,2868,3924,6014,5361,2006,2066,3151,5859,6897,3229,5058,1634,6785,1834,6726,7004,4232,6639,4947,4098,4163,6462,1486,6514,3259,4536,5858,3932,5095,5782,5811,2799,5996,3231,4902,3796,7003,4324,5506,5454,5433,7052,4779,4996,887,4551,1631,4809,3502,4663,4283,4749,4969,6031,4042,3964,2318,6671,1766,994,3462,1928,5584,5220,4529,5935,6005,4616,3771,7098,2471,4930,6029,3721,6817,3499,4175,6003,5087,3121,4331,6058,2132,5731,6650,4806,1096,4960,2653,2085,6900,2419,1730,4588,3748,6672,2,3096,4467,4220,6597,2353,4767,6893,4615,1409,4432,3961,4171,4310,4760,3968,3879,6837,1879,2355,1828,5189,6915,3544,3710,1625,4236,5091,3150,6642,5251,2825,1427,2521,1794,4798,2377,3770,4240,4944,4289,5276,3980,5239,764,4787,1801,2832,3949,1651,3788,3154,6628,7009,1888,7075,3993,4869,6220,6736,5167,4839,2151,6040,4829,1190,4260,4672,6095,1563,6151,6744,6948,6630,6267,6520,2384,5815,4913,4284,924,881,4752,4552,1776,1161,5938,3549,3965,1799,5468,3562,6766,5818,3480,4855,5205,1502,1734,5035,3109,666,6431,6940,1049,2242,1895,4610,5203,2410,1451,5795,1010,7083,3564,2249,6625,4765,533,4206,5158,4026,6788,4288,3917,4187,3645,4076,3192,2867,4241,5508,6039,6840,7106,4072,3990,4158,3261,6935,2286,4935,4159,3343,3769,3016,3348,3991,6705,4945,2071,938,4029,1641,3663,3631,860,5600,6811,1763,3226,4761,2782,6728,2702,940,1199,4662,5654,4638,783,552,3978,3904,4834,6711,6960,1687,5919,5656,1796,2263,5807,786,5316,2468,936,914,5320,2360,5362,4507,1195,4068,5672,3719,4396,4337,4725,2688,2040,4890,949,5187,4781,3215,1998,6640,2523,3841,1615,4472,3219,6992,4502,882,2707,1047,4182,5652,6737,2478,2346,1808,4870,2357,4856,4957,6455,3913,4993,2705,5030,4569,1733,5713,2776,3542,3783,5496,5463,748,3299,2416,6085,3077,3689,5758,2147,4578,4544,4768,4515,6884,1871,6679,3948,6784,2255,6844,5446,4791,5668,6447,4635,4127,4186,4489,3110,4830,4876,5131,4194,1152,3242,2528,5560,3866,4579,6000,4154,6638,5950,2792,6450,5602,2074,4789,1677,2202,6010,3540,3785,4061,5681,5005,1791,4132,4109,252,5174,6879,2862,4049,2670,3862,3880,4918,973,5078,4430,3103,1187,3945,1488,4276,4979,981,4134,4731,3080,4212,5500,4697,3746,4367,6852,5759,4031,4126,1854,5258,258,6599,6546,4207,6048,2312,3105,1623,5479,3781,4814,2549,3483,865,4786,4265,3337,4686,638,2962,3981,2332,4341,3038,928,3313,2672,3379,856,1051,1422,3366,1527,3340,3888,659,4585,1378,4128,3951,7116,2555,4257,2195,4104,822,3573,3493,3941,5171,1188,4350,1519,1560,999,4517,691,6479,1686,5846,2640,6735,5196,879,4827,4784,1714,5773,6729,5055,5318,4674,2321,2090,7042,2329,4577,3485,3354,4703,5612,4348,4826,6183,3475,4038,5464,6738,4096,5034,3362,6506,2261,2788,5100,4667,4439,6870,3634,2204,6953,3694,7001,1587,6503,823,4794,1075,4281,6112,5918,734,2152,21,3335,7296,4410,4495,5130,6278,3163,5182,4373,4451,6453,6500,2326,2781,5319,5047,3669,5070,2245,1728,6107,5219,3175,28,1126,6076,3996,3107,6722,5666,6489,6937,3715,3935,6478,5628,6814,6440,4774,2479,5021,4231,3957,4782,4227,23,3501,3384,3979,4435,3223,749,2185,2655,2476,4122,1798,4661,1611,5106,5509,5379,2259,3701,6284,3433,6643,3190,4005,6733,5993,6883,7066,5101,1707,5841,2811,4743,1793,1875,5551,5779,4873,5192,4916,2339,4007,5386,5445,2382,4893,5378,4543,1720,2350,4121,3162,2439,4572,4071,4359,6265,3094,3906,609,4085,2367,4226,4216,4387,4967,1185,1589,3024,1850,2190,4640,6697,2568,4176,5214,2706,4857,3792,3545,941,4393,4628,6473,5216,1357,4030,6535,4520,5733}'::integer[]))
4. 1.059 2.161 ↑ 1.0 5,929 1

Hash (cost=130.53..130.53 rows=5,953 width=8) (actual time=2.160..2.161 rows=5,929 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 296kB
5. 1.102 1.102 ↑ 1.0 5,929 1

Seq Scan on zone_enforced (cost=0.00..130.53 rows=5,953 width=8) (actual time=0.009..1.102 rows=5,929 loops=1)

Planning time : 6.087 ms
Execution time : 78.805 ms