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=147911.94..147911.95 rows=1 width=4) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=31161.46..145928.99 rows=793179 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..36658.37 rows=2379537 width=12) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=15834.65..15834.65 rows=881665 width=12) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on posts (cost=0.00..15834.65 rows=881665 width=12) (actual time=.. rows= loops=)