explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NGKz

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 144,096.795 ↓ 0.0 0 1

Limit (cost=487,961,296.08..487,961,296.33 rows=100 width=582) (actual time=144,096.795..144,096.795 rows=0 loops=1)

2. 0.285 144,096.771 ↑ 546.0 135 1

Sort (cost=487,961,295.08..487,961,479.35 rows=73,707 width=582) (actual time=144,096.736..144,096.771 rows=135 loops=1)

  • Sort Key: date DESC, "createdAt" DESC
  • Sort Method: quicksort Memory: 118kB
3. 0.778 144,096.486 ↑ 546.0 135 1

WindowAgg (cost=0.70..487,957,622.34 rows=73,707 width=582) (actual time=144,096.412..144,096.486 rows=135 loops=1)

4. 144,095.708 144,095.708 ↑ 546.0 135 1

Index Scan using review_pkey on reviews (cost=0.70..487,956,701.00 rows=73,707 width=582) (actual time=3,192.387..144,095.708 rows=135 loops=1)

  • Index Cond: ("uniqueHash" = ANY (\'{facebook:FriendsofStaciBurk\') },
  • Filter: ((date >= \'2019-10-07 00:00:00\'::timestamp without time zone) AND (date <= \'2019-11-07 00:00:00\'::timestamp without time zone))
  • Rows Removed by Filter: 354369
Planning time : 1,056.210 ms
Execution time : 145,049.306 ms