explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nbil

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 185.047 ↓ 0.0 0 1

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

2. 0.360 185.006 ↑ 579.3 216 1

Sort (cost=498,269.44..498,582.24 rows=125,120 width=582) (actual time=184.949..185.006 rows=216 loops=1)

  • Sort Key: date DESC, "createdAt" DESC
  • Sort Method: quicksort Memory: 238kB
3. 0.454 184.646 ↑ 579.3 216 1

WindowAgg (cost=5,439.03..492,034.84 rows=125,120 width=582) (actual time=184.516..184.646 rows=216 loops=1)

4. 66.915 184.192 ↑ 579.3 216 1

Bitmap Heap Scan on reviews (cost=5,439.03..490,470.84 rows=125,120 width=582) (actual time=117.323..184.192 rows=216 loops=1)

  • Recheck Cond: ("uniqueHash" = ANY (\'{facebook:STEPFISH81,yelp.com:fish-fish-fish-tacoma-2,yelp.com:leader-printing-madison,maps.google.com:9306739144754004242,maps.google.com:9220190076471065394,yelp.com:subway-norcross-11,maps.google.com:14493435099745602556,yelp.com:quantus-restaurant-and-bar-london,maps.google.com:14560683426550240644,maps.google.com:9861505675389175053,maps.google.com:883432009268876690,maps.google.com:15056709709060829097,maps.google.com:15208077980953495431,facebook:renee.moore.1217,facebook:mtonibc,yelp.com:nazareth-house-stoughton,facebook:prs3xyrican1,facebook:aldo.guimaraes.58,maps.google.com:3229732175153414867,maps.google.com:9473417906665308012,maps.google.com:13804086517004354596,facebook:jenconkle,yelp.com:whitehall-diner-whitehall,yelp.com:sokol-group-nanuet,yelp.com:dollar-tree-oceanside,yelp.com:linas-mexican-restaurant-omaha-2,maps.google.com:4102117792460950988,maps.google.com:3031156459476024385,facebook:adri.gonzalez.1232,facebook:eric.hurwitz.7,yelp.com:your-wine-and-spirit-shoppe-woodstock,maps.google.com:18265908142660568995,maps.google.com:3562838841714627145,maps.google.com:7157514970954241905,maps.google.com:13085606531013534211,facebook:jennifer.s.reid.1,facebook:mothsnoise,yelp.com:sidneysmassage-springfield,maps.google.com:10712856950854502010,facebook:pages-168999903110376,maps.google.com:17132669632287909969,maps.google.com:439271488431116137,maps.google.com:2890008698847601907,maps.google.com:1296314788622730111,maps.google.com:4838496879655587620,maps.google.com:7590747849635111838,maps.google.com:14068079910911133828,maps.google.com:1692594734013440819,maps.google.com:231553867135201732,maps.google.com:12105015928779894487,facebook:sara.sutter.165,maps.google.com:2317328800612029738,maps.google.com:1037253313573064661,facebook:nancyjo.divesteaweinstein,facebook:azucenalinda.lemusalvizures,maps.google.com:12620611064611214998,maps.google.com:9357815336292809059,maps.google.com:9550563794183895837,yelp.com:mark-h-hadfield-orthovirginia-midlothian-2,maps.google.com:15761061251977517401,maps.google.com:8577519580833410682,maps.google.com:8828858308292304287,facebook:UniqueOptique,maps.google.com:18441242505767221386,maps.google.com:16617113052190492374,maps.google.com:3227106668598349670,maps.google.com:17960805609799443651,maps.google.com:9639968555857429778,maps.google.com:15894399745203464464,facebook:beth.c.quinn.5,facebook:oncelovedtoysmtl,maps.google.com:11366725248093156070,facebook:martha.gronowski,facebook:beaver.fishery,facebook:lynne.m.breton,maps.google.com:7123740764227792194,yelp.com:america-1st-business-and-financial-center-miami,maps.google.com:17506681532922957555,maps.google.com:3244582045228128074,maps.google.com:559280389612645975,facebook:bettie.boggs,maps.google.com:7170183692562013850,maps.google.com:6677356988793446932,maps.google.com:14989563162451678698,facebook:lisa.w.peters.9,maps.google.com:18199240800737515232,facebook:pages-454026681703140,facebook:marie.allen.967,maps.google.com:4458121354259228240,maps.google.com:14632612020338098892,maps.google.com:3511346205553366440,maps.google.com:13803281686320657384,maps.google.com:10697245161440621660,yelp.com:once-is-not-enough-boutique-temiskaming-shores,maps.google.com:7636892148614540848,maps.google.com:13521614880531707757,facebook:aaron.remy.16,maps.google.com:17028615049347349842,maps.google.com:4344586890871850772,yelp.com:thyme-for-health-monroe}\'::text[]))
  • Heap Blocks: exact=152
5. 117.277 117.277 ↑ 579.3 216 1

Bitmap Index Scan on review_uh_date_index (cost=0.00..5,407.75 rows=125,120 width=0) (actual time=117.277..117.277 rows=216 loops=1)

  • Index Cond: ("uniqueHash" = ANY (\'{facebook:STEPFISH81,yelp.com:fish-fish-fish-tacoma-2,yelp.com:leader-printing-madison,maps.google.com:9306739144754004242,maps.google.com:9220190076471065394,yelp.com:subway-norcross-11,maps.google.com:14493435099745602556,yelp.com:quantus-restaurant-and-bar-london,maps.google.com:14560683426550240644,maps.google.com:9861505675389175053,maps.google.com:883432009268876690,maps.google.com:15056709709060829097,maps.google.com:15208077980953495431,facebook:renee.moore.1217,facebook:mtonibc,yelp.com:nazareth-house-stoughton,facebook:prs3xyrican1,facebook:aldo.guimaraes.58,maps.google.com:3229732175153414867,maps.google.com:9473417906665308012,maps.google.com:13804086517004354596,facebook:jenconkle,yelp.com:whitehall-diner-whitehall,yelp.com:sokol-group-nanuet,yelp.com:dollar-tree-oceanside,yelp.com:linas-mexican-restaurant-omaha-2,maps.google.com:4102117792460950988,maps.google.com:3031156459476024385,facebook:adri.gonzalez.1232,facebook:eric.hurwitz.7,yelp.com:your-wine-and-spirit-shoppe-woodstock,maps.google.com:18265908142660568995,maps.google.com:3562838841714627145,maps.google.com:7157514970954241905,maps.google.com:13085606531013534211,facebook:jennifer.s.reid.1,facebook:mothsnoise,yelp.com:sidneysmassage-springfield,maps.google.com:10712856950854502010,facebook:pages-168999903110376,maps.google.com:17132669632287909969,maps.google.com:439271488431116137,maps.google.com:2890008698847601907,maps.google.com:1296314788622730111,maps.google.com:4838496879655587620,maps.google.com:7590747849635111838,maps.google.com:14068079910911133828,maps.google.com:1692594734013440819,maps.google.com:231553867135201732,maps.google.com:12105015928779894487,facebook:sara.sutter.165,maps.google.com:2317328800612029738,maps.google.com:1037253313573064661,facebook:nancyjo.divesteaweinstein,facebook:azucenalinda.lemusalvizures,maps.google.com:12620611064611214998,maps.google.com:9357815336292809059,maps.google.com:9550563794183895837,yelp.com:mark-h-hadfield-orthovirginia-midlothian-2,maps.google.com:15761061251977517401,maps.google.com:8577519580833410682,maps.google.com:8828858308292304287,facebook:UniqueOptique,maps.google.com:18441242505767221386,maps.google.com:16617113052190492374,maps.google.com:3227106668598349670,maps.google.com:17960805609799443651,maps.google.com:9639968555857429778,maps.google.com:15894399745203464464,facebook:beth.c.quinn.5,facebook:oncelovedtoysmtl,maps.google.com:11366725248093156070,facebook:martha.gronowski,facebook:beaver.fishery,facebook:lynne.m.breton,maps.google.com:7123740764227792194,yelp.com:america-1st-business-and-financial-center-miami,maps.google.com:17506681532922957555,maps.google.com:3244582045228128074,maps.google.com:559280389612645975,facebook:bettie.boggs,maps.google.com:7170183692562013850,maps.google.com:6677356988793446932,maps.google.com:14989563162451678698,facebook:lisa.w.peters.9,maps.google.com:18199240800737515232,facebook:pages-454026681703140,facebook:marie.allen.967,maps.google.com:4458121354259228240,maps.google.com:14632612020338098892,maps.google.com:3511346205553366440,maps.google.com:13803281686320657384,maps.google.com:10697245161440621660,yelp.com:once-is-not-enough-boutique-temiskaming-shores,maps.google.com:7636892148614540848,maps.google.com:13521614880531707757,facebook:aaron.remy.16,maps.google.com:17028615049347349842,maps.google.com:4344586890871850772,yelp.com:thyme-for-health-monroe}\'::text[]))
Planning time : 2.561 ms
Execution time : 185.555 ms