#	exclusive	inclusive	rows x	rows	loops	node
1.	50.105	841.478	↓ 0.0	0	1	→ Merge Join (cost=125379.14..125775.12 rows=3311 width=29) (actual time=841.478..841.478 rows=0 loops=1) Merge Cond: (a.orderid = b.orderid) Total runtime: 842.134 ms
2.	161.744	774.475	↑ 3.4	16815	1	→ Sort (cost=109737.32..109881.89 rows=57828 width=23) (actual time=736.163..774.475 rows=16815 loops=1) Sort Key: a.orderid Sort Method: quicksort Memory: 1695kB
3.	587.698	612.731	↑ 3.4	16815	1	→ Bitmap Heap Scan on orderitemattribute a (cost=1286.88..105163.27 rows=57828 width=23) (actual time=41.536..612.731 rows=16815 loops=1) Recheck Cond: ((attributeid)::text = 'display-album'::text)
4.	25.033	25.033	↑ 3.4	16815	1	→ Bitmap Index Scan on (cost=0.00..1272.43 rows=57828 width=0) (actual time=25.033..25.033 rows=16815 loops=1) Index Cond: ((attributeid)::text = 'display-album'::text)
5.	8.418	16.898	↑ 13.3	1109	1	→ Sort (cost=15641.81..15678.73 rows=14769 width=14) (actual time=14.471..16.898 rows=1109 loops=1) Sort Key: b.orderid Sort Method: quicksort Memory: 76kB
6.	7.049	8.480	↑ 13.3	1114	1	→ Bitmap Heap Scan on orderitem b (cost=310.96..14619.03 rows=14769 width=14) (actual time=1.865..8.480 rows=1114 loops=1) Recheck Cond: ((productid)::text = 'ModernBook'::text)
7.	1.431	1.431	↑ 13.3	1114	1	→ Bitmap Index Scan on id_orderitem_productid (cost=0.00..307.27 rows=14769 width=0) (actual time=1.431..1.431 rows=1114 loops=1) Index Cond: ((productid)::text = 'ModernBook'::text)

Merge Join  (cost=125379.14..125775.12 rows=3311 width=29) (actual time=841.478..841.478 rows=0 loops=1)

   Merge Cond: (a.orderid = b.orderid)

   ->  Sort  (cost=109737.32..109881.89 rows=57828 width=23) (actual time=736.163..774.475 rows=16815 loops=1)

         Sort Key: a.orderid

         Sort Method:  quicksort  Memory: 1695kB

         ->  Bitmap Heap Scan on orderitemattribute a  (cost=1286.88..105163.27 rows=57828 width=23) (actual time=41.536..612.731 rows=16815 loops=1)

               Recheck Cond: ((attributeid)::text = 'display-album'::text)

               ->  Bitmap Index Scan on (cost=0.00..1272.43 rows=57828 width=0) (actual time=25.033..25.033 rows=16815 loops=1)

                     Index Cond: ((attributeid)::text = 'display-album'::text)

   ->  Sort  (cost=15641.81..15678.73 rows=14769 width=14) (actual time=14.471..16.898 rows=1109 loops=1)

         Sort Key: b.orderid

         Sort Method:  quicksort  Memory: 76kB

         ->  Bitmap Heap Scan on orderitem b  (cost=310.96..14619.03 rows=14769 width=14) (actual time=1.865..8.480 rows=1114 loops=1)

               Recheck Cond: ((productid)::text = 'ModernBook'::text)

               ->  Bitmap Index Scan on id_orderitem_productid  (cost=0.00..307.27 rows=14769 width=0) (actual time=1.431..1.431 rows=1114 loops=1)

                     Index Cond: ((productid)::text = 'ModernBook'::text)

 Total runtime: 842.134 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	2	594.747 ms	70.7 %
Bitmap Index Scan	1	1.431 ms	0.2 %
Bitmap Index Scan on	1	25.033 ms	3.0 %
Merge Join	1	50.105 ms	6.0 %
Sort	2	170.162 ms	20.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
orderitem	1	7.049 ms	0.8 %
Bitmap Heap Scan	1	7.049 ms	100.0 %
orderitemattribute	1	587.698 ms	69.8 %
Bitmap Heap Scan	1	587.698 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: DN

Colorize:

Columns visibility:

Per node type stats

Per table stats