explain.depesz.com

A tool for finding a real cause for slow queries.

Result: DN

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)