#	rows x	node
1.	↓ 0.0	→ Aggregate (cost=147911.94..147911.95 rows=1 width=4) (actual time=.. rows= loops=)
2.	↓ 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.0	→ Seq Scan on votes (cost=0.00..36658.37 rows=2379537 width=12) (actual time=.. rows= loops=)
4.	↓ 0.0	→ Hash (cost=15834.65..15834.65 rows=881665 width=12) (actual time=.. rows= loops=)
5.	↓ 0.0	→ Seq Scan on posts (cost=0.00..15834.65 rows=881665 width=12) (actual time=.. rows= loops=)

Aggregate  (cost=147911.94..147911.95 rows=1 width=4)
   ->  Hash Join  (cost=31161.46..145928.99 rows=793179 width=4)
         Hash Cond: (votes.post = posts.id)
         Join Filter: (votes.creation <= (posts.creation + '1 day'::interval))
         ->  Seq Scan on votes  (cost=0.00..36658.37 rows=2379537 width=12)
         ->  Hash  (cost=15834.65..15834.65 rows=881665 width=12)
               ->  Seq Scan on posts  (cost=0.00..15834.65 rows=881665 width=12)
(7 rows)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.000 ms	0.0 %
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
posts	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
votes	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4Io

Colorize:

Columns visibility:

Per node type stats

Per table stats