explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U7Qd

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 53,357.951 ↑ 1.0 100 1

Limit (cost=9,482,954.60..9,482,954.85 rows=100 width=437) (actual time=53,357.889..53,357.951 rows=100 loops=1)

  • Execution time: 53439.433 ms' }
2. 1.139 53,357.911 ↑ 19,997.2 110 1

Sort (cost=9,482,954.57..9,488,453.81 rows=2,199,695 width=437) (actual time=53,357.883..53,357.911 rows=110 loops=1)

  • Sort Key: date DESC, "createdAt" DESC
  • Sort Method: top-N heapsort Memory: 95kB
3. 4.532 53,356.772 ↑ 1,451.0 1,516 1

WindowAgg (cost=0.69..9,397,371.48 rows=2,199,695 width=437) (actual time=53,355.890..53,356.772 rows=1,516 loops=1)

4. 53,352.240 53,352.240 ↑ 1,451.0 1,516 1

Index Scan using reviews_uh_date_index on reviews (cost=0.69..9,369,875.29 rows=2,199,695 width=437) (actual time=28.693..53,352.240 rows=1,516 loops=1)

  • Index Cond: (("uniqueHash" = ANY (\'{facebook:linda.dawe\'::timestamp without time zone))
Planning time : 103.729 ms