#	exclusive	inclusive	rows x	rows	loops	node
1.	454.235	20315.857	↑ 1.6	905	1	→ HashAggregate (cost=1242.69..1316.29 rows=1472 width=8) (actual time=20314.659..20315.857 rows=905 loops=1)
2.	2782.738	19861.622	↓ 17.1	251028	1	→ Result (cost=0.00..1058.80 rows=14711 width=8) (actual time=94.471..19861.622 rows=251028 loops=1)
3.	466.885	17078.884	↓ 17.1	251028	1	→ Append (cost=0.00..507.14 rows=14711 width=8) (actual time=94.432..17078.884 rows=251028 loops=1)
4.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on accesses (cost=0.00..22.12 rows=323 width=8) (actual time=0.002..0.002 rows=0 loops=1) Filter: (unixtime >= 1335439860)
5.	16611.997	16611.997	↓ 17.4	251028	1	→ Index Scan using y12041_unixtime_idx on y12041_accesses accesses (cost=0.00..485.01 rows=14388 width=8) (actual time=94.427..16611.997 rows=251028 loops=1) Index Cond: (unixtime >= 1335439860)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=1242.69..1316.29 rows=1472 width=8) (actual time=20314.659..20315.857 rows=905 loops=1)
   ->  Result  (cost=0.00..1058.80 rows=14711 width=8) (actual time=94.471..19861.622 rows=251028 loops=1)
         ->  Append  (cost=0.00..507.14 rows=14711 width=8) (actual time=94.432..17078.884 rows=251028 loops=1)
               ->  Seq Scan on accesses  (cost=0.00..22.12 rows=323 width=8) (actual time=0.002..0.002 rows=0 loops=1)
                     Filter: (unixtime >= 1335439860)
               ->  Index Scan using y12041_unixtime_idx on y12041_accesses accesses  (cost=0.00..485.01 rows=14388 width=8) (actual time=94.427..16611.997 rows=251028 loops=1)
                     Index Cond: (unixtime >= 1335439860)
 Total runtime: 20316.769 ms
(8 rows)

Per node type stats

node type	count	sum of times	% of query
Append	1	466.885 ms	2.3 %
HashAggregate	1	454.235 ms	2.2 %
Index Scan	1	16611.997 ms	81.8 %
Result	1	2782.738 ms	13.7 %
Seq Scan	1	0.002 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
accesses	1	0.002 ms	0.0 %
Seq Scan	1	0.002 ms	100.0 %
y12041_accesses	1	16611.997 ms	81.8 %
Index Scan	1	16611.997 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: L73

Colorize:

Columns visibility:

Per node type stats

Per table stats