explain.depesz.com

A tool for finding a real cause for slow queries.

Result: XN6

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

2.          

Initplan (forAggregate)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=133612.15..133612.16 rows=1 width=4) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=30300.46..127663.31 rows=2379537 width=4) (actual time=.. rows= loops=)

  • Hash Cond: (public.votes.post = public.posts.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on votes (cost=0.00..36658.37 rows=2379537 width=8) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=31161.46..151877.84 rows=793179 width=4) (actual time=.. rows= loops=)

  • Hash Cond: (public.votes.post = public.posts.id)
  • Join Filter: (public.votes.creation > ((public.posts.creation + '1 day'::interval))::date)
9. 0.000 0.000 ↓ 0.0

Seq Scan on votes (cost=0.00..36658.37 rows=2379537 width=12) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

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

11. 0.000 0.000 ↓ 0.0

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