explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8yYH

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 339.176 ↓ 0.0 0 1

Limit (cost=506,270.44..506,270.69 rows=100 width=582) (actual time=339.176..339.176 rows=0 loops=1)

2. 0.584 339.114 ↑ 504.5 248 1

Sort (cost=506,269.44..506,582.24 rows=125,120 width=582) (actual time=339.026..339.114 rows=248 loops=1)

  • Sort Key: date DESC, "createdAt" DESC
  • Sort Method: quicksort Memory: 332kB
3. 0.795 338.530 ↑ 504.5 248 1

WindowAgg (cost=13,439.03..500,034.84 rows=125,120 width=582) (actual time=338.292..338.530 rows=248 loops=1)

4. 93.647 337.735 ↑ 504.5 248 1

Bitmap Heap Scan on reviews (cost=13,439.03..498,470.84 rows=125,120 width=582) (actual time=244.590..337.735 rows=248 loops=1)

  • Recheck Cond: ("uniqueHash" = ANY (\'{maps.google.com:13778658838474285935,yelp.com:swedlund-services-belle-plaine-2,maps.google.com:2889883004960226492,maps.google.com:15563209397620793018,facebook:Okeanosquebec,maps.google.com:10050631806459737911,yelp.com:quart-pat-insurance-agency-paradise-valley-2,facebook:ISIOphilippines,maps.google.com:4534890225832250839,facebook:gaboygerald,facebook:denise.mazzochi,maps.google.com:6607449688552743105,maps.google.com:10222954362887964327,maps.google.com:4092021208149089194,facebook:keisha.quiles,facebook:debbie.belk.5,maps.google.com:18001690374414469793,maps.google.com:4645919560241608468,yelp.com:clinton-family-hair-care-center-clinton,maps.google.com:7074952460868314038,maps.google.com:4213538193298152643,maps.google.com:3796349594252322634,maps.google.com:688740896833881708,maps.google.com:17252271604298785680,yelp.com:antietam-valley-animal-hospital-reading,maps.google.com:9187606058107653596,maps.google.com:62829505611591821,maps.google.com:11740017042529104064,yelp.com:chat-noir-books-new-liskeard,maps.google.com:17152213786194673076,maps.google.com:1250639476666664887,maps.google.com:11991719294991411735,facebook:lmbconstruction,maps.google.com:10368033856190979510,maps.google.com:406103350177930894,yelp.com:wind-n-willow-st-thomas,facebook:Snowyobject,facebook:jeff.gardner.9083,facebook:Hayden-Diamond-Bit-Industries-Ltd-216610645088494,maps.google.com:3919829154166453769,maps.google.com:13072517368232974699,maps.google.com:11886083617828198127,maps.google.com:232347810582625282,facebook:JustGetSchifty91,facebook:aarti.shah.581187,maps.google.com:17656049056961985197,maps.google.com:1778825089901957619,maps.google.com:12129434339575367376,maps.google.com:3586890658909003112,maps.google.com:11095885840845458372,maps.google.com:6859218850163763006,maps.google.com:13231906711286390831,yelp.com:marias-restaurant-braintree,facebook:marlo.thompsonswanson,maps.google.com:10640868426250837183,maps.google.com:10478499333318925433,yelp.com:union-central-life-insurance-scottsdale,facebook:albertodanielsalon,maps.google.com:1553160155531055626,maps.google.com:10415714804696923548,maps.google.com:4143759275504371108,maps.google.com:10225586940110903539,maps.google.com:14427566311155920125,maps.google.com:2320269973818299316,maps.google.com:16183589397250915854,facebook:misookshop,yelp.com:kuykendalls-collision-repair-sunnyvale,maps.google.com:16032902470774807233,facebook:Action-M%C3%A9nage-Plus-2045256562426337,maps.google.com:16908284124294809960,maps.google.com:2626701392555915560,maps.google.com:6491256323747556524,maps.google.com:14667207616888085075,yelp.com:newark-days-celebration-newark,yelp.com:marin-market-and-liquor-vallejo,maps.google.com:10495767593896078697,maps.google.com:1982885035333009851,facebook:seth.charleston,facebook:michelle.hartin.90,maps.google.com:3544080931853024708,maps.google.com:5663322207609905798,maps.google.com:9639390825459795085,maps.google.com:9929232866924503165,maps.google.com:4604194056496895099,maps.google.com:6271947444836480585,yelp.com:ark-animal-hospital-wyomissing,yelp.com:gymboree-schaumburg-2,facebook:stewartlandscaping,maps.google.com:6035202994669054595,yelp.com:lexington-eye-associates-arlington,yelp.com:granite-true-value-granite-falls,yelp.com:hop-in-foodstore-milledgeville,facebook:simon.weston.771,yelp.com:magnolia-plantation-and-gardens-charleston-2,yelp.com:handmade-on-main-algonquin,maps.google.com:11953893809100039449,facebook:pages-1630267033781173,maps.google.com:14379841834249582932,yelp.com:animal-emergency-service-of-berks-county-reading,yelp.com:krave-bistro-arnprior}\'::text[]))
  • Heap Blocks: exact=158
5. 244.088 244.088 ↑ 504.5 248 1

Bitmap Index Scan on review_pkey (cost=0.00..13,407.75 rows=125,120 width=0) (actual time=244.088..244.088 rows=248 loops=1)

  • Index Cond: ("uniqueHash" = ANY (\'{maps.google.com:13778658838474285935,yelp.com:swedlund-services-belle-plaine-2,maps.google.com:2889883004960226492,maps.google.com:15563209397620793018,facebook:Okeanosquebec,maps.google.com:10050631806459737911,yelp.com:quart-pat-insurance-agency-paradise-valley-2,facebook:ISIOphilippines,maps.google.com:4534890225832250839,facebook:gaboygerald,facebook:denise.mazzochi,maps.google.com:6607449688552743105,maps.google.com:10222954362887964327,maps.google.com:4092021208149089194,facebook:keisha.quiles,facebook:debbie.belk.5,maps.google.com:18001690374414469793,maps.google.com:4645919560241608468,yelp.com:clinton-family-hair-care-center-clinton,maps.google.com:7074952460868314038,maps.google.com:4213538193298152643,maps.google.com:3796349594252322634,maps.google.com:688740896833881708,maps.google.com:17252271604298785680,yelp.com:antietam-valley-animal-hospital-reading,maps.google.com:9187606058107653596,maps.google.com:62829505611591821,maps.google.com:11740017042529104064,yelp.com:chat-noir-books-new-liskeard,maps.google.com:17152213786194673076,maps.google.com:1250639476666664887,maps.google.com:11991719294991411735,facebook:lmbconstruction,maps.google.com:10368033856190979510,maps.google.com:406103350177930894,yelp.com:wind-n-willow-st-thomas,facebook:Snowyobject,facebook:jeff.gardner.9083,facebook:Hayden-Diamond-Bit-Industries-Ltd-216610645088494,maps.google.com:3919829154166453769,maps.google.com:13072517368232974699,maps.google.com:11886083617828198127,maps.google.com:232347810582625282,facebook:JustGetSchifty91,facebook:aarti.shah.581187,maps.google.com:17656049056961985197,maps.google.com:1778825089901957619,maps.google.com:12129434339575367376,maps.google.com:3586890658909003112,maps.google.com:11095885840845458372,maps.google.com:6859218850163763006,maps.google.com:13231906711286390831,yelp.com:marias-restaurant-braintree,facebook:marlo.thompsonswanson,maps.google.com:10640868426250837183,maps.google.com:10478499333318925433,yelp.com:union-central-life-insurance-scottsdale,facebook:albertodanielsalon,maps.google.com:1553160155531055626,maps.google.com:10415714804696923548,maps.google.com:4143759275504371108,maps.google.com:10225586940110903539,maps.google.com:14427566311155920125,maps.google.com:2320269973818299316,maps.google.com:16183589397250915854,facebook:misookshop,yelp.com:kuykendalls-collision-repair-sunnyvale,maps.google.com:16032902470774807233,facebook:Action-M%C3%A9nage-Plus-2045256562426337,maps.google.com:16908284124294809960,maps.google.com:2626701392555915560,maps.google.com:6491256323747556524,maps.google.com:14667207616888085075,yelp.com:newark-days-celebration-newark,yelp.com:marin-market-and-liquor-vallejo,maps.google.com:10495767593896078697,maps.google.com:1982885035333009851,facebook:seth.charleston,facebook:michelle.hartin.90,maps.google.com:3544080931853024708,maps.google.com:5663322207609905798,maps.google.com:9639390825459795085,maps.google.com:9929232866924503165,maps.google.com:4604194056496895099,maps.google.com:6271947444836480585,yelp.com:ark-animal-hospital-wyomissing,yelp.com:gymboree-schaumburg-2,facebook:stewartlandscaping,maps.google.com:6035202994669054595,yelp.com:lexington-eye-associates-arlington,yelp.com:granite-true-value-granite-falls,yelp.com:hop-in-foodstore-milledgeville,facebook:simon.weston.771,yelp.com:magnolia-plantation-and-gardens-charleston-2,yelp.com:handmade-on-main-algonquin,maps.google.com:11953893809100039449,facebook:pages-1630267033781173,maps.google.com:14379841834249582932,yelp.com:animal-emergency-service-of-berks-county-reading,yelp.com:krave-bistro-arnprior}\'::text[]))
Planning time : 12.732 ms
Execution time : 339.691 ms