explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4Io

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=147,911.94..147,911.95 rows=1 width=4) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=31,161.46..145,928.99 rows=793,179 width=4) (actual time=.. rows= loops=)

  • Hash Cond: (votes.post = posts.id)
  • Join Filter: (votes.creation <= (posts.creation + '1 day'::interval))
3. 0.000 0.000 ↓ 0.0

Seq Scan on votes (cost=0.00..36,658.37 rows=2,379,537 width=12) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=15,834.65..15,834.65 rows=881,665 width=12) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on posts (cost=0.00..15,834.65 rows=881,665 width=12) (actual time=.. rows= loops=)