Result: wtQM

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
2286.696	9059.530	↓ 1.3	3942	1	→ HashAggregate (cost=73322.35..73373.49 rows=2922 width=12) (actual time=9051.956..9059.530 rows=3942 loops=1) Filter: (max(ph.reported_time) < '2012-02-01 04:50:13.912201'::timestamp without time zone)
4466.356	6772.834	↓ 1.0	1335684	1	→ Hash Join (cost=281.53..63666.72 rows=1287418 width=12) (actual time=17.532..6772.834 rows=1335684 loops=1) Hash Cond: (ph.item_id = importo_item.id)
2289.733	2289.733	↑ 1.0	1336109	1	→ Seq Scan on importo_pricehistory ph (cost=0.00..42148.53 rows=1337998 width=12) (actual time=0.766..2289.733 rows=1336109 loops=1) Filter: (region_id = 10000002)
6.967	16.745	↓ 1.2	4111	1	→ Hash (cost=237.30..237.30 rows=3538 width=4) (actual time=16.745..16.745 rows=4111 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 145kB
9.011	9.778	↓ 1.2	4111	1	→ Seq Scan on importo_item (cost=8.86..237.30 rows=3538 width=4) (actual time=1.621..9.778 rows=4111 loops=1) Filter: (NOT (hashed SubPlan 1))
					SubPlan (forSeq Scan)
0.767	0.767	↑ 1.0	469	1	→ Seq Scan on importo_marketgroupignore (cost=0.00..7.69 rows=469 width=4) (actual time=0.007..0.767 rows=469 loops=1)

                                                                   QUERY PLAN                                 
-------------------------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=73322.35..73373.49 rows=2922 width=12) (actual time=9051.956..9059.530 rows=3942 loops=1)
   Filter: (max(ph.reported_time) < '2012-02-01 04:50:13.912201'::timestamp without time zone)
   ->  Hash Join  (cost=281.53..63666.72 rows=1287418 width=12) (actual time=17.532..6772.834 rows=1335684 loops=1)
         Hash Cond: (ph.item_id = importo_item.id)
         ->  Seq Scan on importo_pricehistory ph  (cost=0.00..42148.53 rows=1337998 width=12) (actual time=0.766..2289.733 rows=1336109 loops=1)
               Filter: (region_id = 10000002)
         ->  Hash  (cost=237.30..237.30 rows=3538 width=4) (actual time=16.745..16.745 rows=4111 loops=1)
               Buckets: 1024  Batches: 1  Memory Usage: 145kB
               ->  Seq Scan on importo_item  (cost=8.86..237.30 rows=3538 width=4) (actual time=1.621..9.778 rows=4111 loops=1)
                     Filter: (NOT (hashed SubPlan 1))
                     SubPlan 1
                       ->  Seq Scan on importo_marketgroupignore  (cost=0.00..7.69 rows=469 width=4) (actual time=0.007..0.767 rows=469 loops=1)
 Total runtime: 9065.599 ms
(13 rows)

Per node type stats

node type	count	sum of times	% of query
Hash	1	6.967 ms	0.1 %
Hash Join	1	4466.356 ms	49.3 %
HashAggregate	1	2286.696 ms	25.2 %
Seq Scan	3	2299.511 ms	25.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
importo_item	1	9.011 ms	0.1 %
Seq Scan	1	9.011 ms	100.0 %
importo_marketgroupignore	1	0.767 ms	0.0 %
Seq Scan	1	0.767 ms	100.0 %
importo_pricehistory	1	2289.733 ms	25.3 %
Seq Scan	1	2289.733 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: wtQM

Colorize:

Columns visibility:

Per node type stats

Per table stats