explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DJ9N : number 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 0.423 ↑ 1.5 68 1

Limit (cost=20,291.65..20,291.90 rows=100 width=582) (actual time=0.379..0.423 rows=68 loops=1)

2. 0.102 0.399 ↑ 64.2 78 1

Sort (cost=20,291.62..20,304.13 rows=5,005 width=582) (actual time=0.374..0.399 rows=78 loops=1)

  • Sort Key: date DESC, "createdAt" DESC
  • Sort Method: quicksort Memory: 112kB
3. 0.113 0.297 ↑ 64.2 78 1

WindowAgg (cost=0.70..20,096.89 rows=5,005 width=582) (actual time=0.253..0.297 rows=78 loops=1)

4. 0.184 0.184 ↑ 64.2 78 1

Index Scan using review_uh_date_index on reviews (cost=0.70..20,034.33 rows=5,005 width=582) (actual time=0.071..0.184 rows=78 loops=1)

  • Index Cond: ("uniqueHash" = ANY ('{maps.google.com:15193891601016590978,yelp.com:to-the-point-bar-and-grill-jacksons-point,yelp.com:hobo-piez-windsor,yelp.com:c-and-o-canal-washington}'::text[]))
Planning time : 0.219 ms
Execution time : 0.487 ms