explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W7yl

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 804.614 ↑ 1.0 10 1

Limit (cost=109,157.01..109,157.04 rows=10 width=896) (actual time=804.610..804.614 rows=10 loops=1)

2. 61.362 804.611 ↑ 7,641.9 10 1

Sort (cost=109,157.01..109,348.06 rows=76,419 width=896) (actual time=804.608..804.611 rows=10 loops=1)

  • Sort Key: (random())
  • Sort Method: top-N heapsort Memory: 29kB
3. 743.249 743.249 ↓ 1.0 77,288 1

Seq Scan on eateries (cost=0.00..107,505.63 rows=76,419 width=896) (actual time=0.024..743.249 rows=77,288 loops=1)

  • Filter: (id <> ALL ('{3294,3295,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3871,3872,3873,3874,3875,3876,3877,3878,3879,3880,3881,3882,3883,3884,3885,3886,3887,3888,3889,3890,3891,3893,3894,3895,3896,3898,3899,3900,3901,3902,3903,3904,3905,3906,3907,3908,3909,1501,1502,1503,3308,3309,3310,3311,3312,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,1637,1638,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,3447,3448,3449,3450,3451,3453,3454,3455,3456,3457,3458,3459,3460,3461,3462,3463,3464,3465,3466,3467,3468,3469,3470,3471,3472,3473,3474,3475,3476,3477,3478,3479,3480,3481,3482,3483,3484,3485,3486,3487,3488,3489,3490,3491,3492,3493,3494,3495,3496,3497,3498,3499,3500,3503,3505,3506,3507,3508,3501,3509,3510,3511,3512,3513,3514,3515,3516,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3538,3539,1773,1774,3540,3541,3542,3543,3544,3545,3546,3547,3548,3549,3550,3551,3552,3553,3554,3555,3556,3557,3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3599,3600,3601,3910,3911,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3924,3925,3926,3927,3928,3929,3930,3931,3932,3933,3934,3936,3937,3938,3939,3940,3941,3942,3943,3944,3945,3946,3947,3948,3949,3950,3951,3952,3953,3954,3955,3956,3957,3958,3959,1909,1911,1912,1913,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3633,3634,3635,3636,3637,3638,3639,2045,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2071,2075,2077,2079,2080,2081,2082,2083,3640,3641,3644,3646,3647,3649,3650,3652,3653,3655,3656,3657,3658,3659,3660,3661,3662,3663,3665,3666,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3683,3684,3685,3686,3687,3688,3689,3690,3691,3692,3693,3694,3695,3696,3697,3698,3699,3700,3701,3702,3703,3704,3705,3706,3707,3708,3709,3710,3711,3712,3713,3714,3715,3716,3717,3718,10,11,15,16,17,18,19,20,21,22,26,27,28,30,31,32,33,34,36,37,38,39,40,41,42,43,44,46,47,49,50,51,52,53,54,55,56,57,58,61,62,64,65,66,67,68,69,70,73,74,76,77,78,80,82,83,84,85,86,88,89,90,91,92,93,94,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,113,114,115,116,117,118,120,121,122,124,125,127,128,129,131,133,136,138,152,154,155,156,159,160,162,165,166,167,35,168,171,172,173,174,175,176,177,178,179,180,181,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,201,202,204,206,208,209,210,211,212,214,215,216,217,218,222,223,224,225,226,228,231,233,234,235,236,241,242,243,245,246,247,248,249,250,251,252,254,255,256,257,258,259,260,261,262,263,264,265,267,269,270,271,219,276,282,239,284,286,287,288,289,291,292,169,238,253,293,294,295,296,298,299,300,302,305,306,307,311,312,313,314,315,316,317,318,321,322,325,326,327,328,329,330,331,332,333,336,337,338,339,340,323,343,344,345,346,347,348,349,350,351,352,353,354,355,356,297,387,359,360,361,362,364,365,373,367,368,369,370,371,372,374,375,376,378,379,380,381,382,383,384,385,388,389,390,392,393,394,395,396,397,391,399,400,402,403,404,405,406,407,408,410,430,431,433,434,438,443,446,447,448,449,450,451,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,479,480,481,482,485,486,487,488,489,490,491,493,494,495,496,497,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,532,533,535,536,537,538,539,540,541,542,543,544,545,546,547,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,639,640,641,642,643,644,645,646,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,666,667,668,669,670,671,672,673,674,675}'::integer[]))
  • Rows Removed by Filter: 783
Planning time : 1.187 ms
Execution time : 804.675 ms