explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1r2Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 373.225 ↓ 0.0 0 1

Limit (cost=789,621.98..789,622.23 rows=100 width=582) (actual time=373.225..373.225 rows=0 loops=1)

2. 0.400 373.200 ↑ 984.9 137 1

Sort (cost=789,620.98..789,958.32 rows=134,935 width=582) (actual time=373.163..373.200 rows=137 loops=1)

  • Sort Key: rs.date DESC, rs."createdAt" DESC
  • Sort Method: quicksort Memory: 120kB
3. 80.571 372.800 ↑ 984.9 137 1

Hash Join (cost=3,977.39..782,897.32 rows=134,935 width=582) (actual time=119.140..372.800 rows=137 loops=1)

  • Hash Cond: (rs."uniqueHash" = ru."uniqueHash")
4. 177.375 177.375 ↑ 2.5 84,434 1

Index Scan using review_date_index on reviews rs (cost=0.57..744,893.25 rows=209,840 width=582) (actual time=0.017..177.375 rows=84,434 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))
5. 65.111 114.854 ↑ 1.1 100,000 1

Hash (cost=1,880.92..1,880.92 rows=108,392 width=32) (actual time=114.854..114.854 rows=100,000 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3719kB
6. 49.743 49.743 ↑ 1.1 100,000 1

Seq Scan on reviews_unique_hash_join ru (cost=0.00..1,880.92 rows=108,392 width=32) (actual time=0.026..49.743 rows=100,000 loops=1)

Planning time : 1.874 ms
Execution time : 373.297 ms