explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EI9E

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 156,155.529 ↑ 2.6 39 1

Limit (cost=26,982,558.15..26,982,558.40 rows=100 width=582) (actual time=156,155.505..156,155.529 rows=39 loops=1)

2. 0.921 156,155.444 ↑ 280.1 439 1

Sort (cost=26,982,557.15..26,982,864.55 rows=122,959 width=582) (actual time=156,155.333..156,155.444 rows=439 loops=1)

  • Sort Key: date DESC, "createdAt" DESC
  • Sort Method: quicksort Memory: 273kB
3. 1.823 156,154.523 ↑ 280.1 439 1

WindowAgg (cost=0.57..26,976,430.24 rows=122,959 width=582) (actual time=156,154.321..156,154.523 rows=439 loops=1)

4. 156,152.700 156,152.700 ↑ 280.1 439 1

Index Scan using review_date_index on reviews (cost=0.57..26,974,893.25 rows=122,959 width=582) (actual time=869.398..156,152.700 rows=439 loops=1)

  • Index Cond: ((date >= \'2019-10-07 00:00:00\'::timestamp without time zone) AND (date <= \'2019-11-07 00:00:00\'::timestamp without time zone))
  • Filter: ("uniqueHash" = ANY (\'{facebook:justannied}\'::text[]))
  • Rows Removed by Filter: 83995
Planning time : 1,061.397 ms
Execution time : 156,155.605 ms