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=287,472.95..287,472.97 rows=1 width=4) (actual time=.. rows= loops=)

2.          

Initplan (forAggregate)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=133,612.15..133,612.16 rows=1 width=4) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=30,300.46..127,663.31 rows=2,379,537 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..36,658.37 rows=2,379,537 width=8) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=31,161.46..151,877.84 rows=793,179 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..36,658.37 rows=2,379,537 width=12) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

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

11. 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=)