explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VIY8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 103.124 ↓ 117.5 235 1

Nested Loop (cost=9,131.41..10,205.53 rows=2 width=137) (actual time=80.057..103.124 rows=235 loops=1)

2. 0.258 102.909 ↓ 117.5 235 1

Nested Loop Semi Join (cost=9,131.41..10,204.97 rows=2 width=133) (actual time=80.053..102.909 rows=235 loops=1)

3. 1.259 101.499 ↓ 34.9 384 1

Hash Semi Join (cost=9,131.41..10,106.70 rows=11 width=157) (actual time=80.030..101.499 rows=384 loops=1)

  • Hash Cond: (article0_.id = article22_.id)
4. 2.113 98.875 ↓ 4.0 18,255 1

Hash Left Join (cost=8,215.95..9,179.28 rows=4,508 width=141) (actual time=77.350..98.875 rows=18,255 loops=1)

  • Hash Cond: (articleweb7_.promowebtext_id = promowebte10_.id)
5. 3.409 96.762 ↓ 4.0 18,255 1

Hash Left Join (cost=8,182.55..9,128.97 rows=4,508 width=93) (actual time=77.345..96.762 rows=18,255 loops=1)

  • Hash Cond: (article0_.id = rentoption6_.article_id)
6. 3.203 92.087 ↓ 4.0 18,255 1

Hash Left Join (cost=8,003.82..8,907.46 rows=4,508 width=73) (actual time=76.073..92.087 rows=18,255 loops=1)

  • Hash Cond: (articlegro2_.group_id = articlegro3_.id)
7. 10.960 87.169 ↓ 4.0 18,255 1

Hash Right Join (cost=7,708.45..8,505.03 rows=4,508 width=73) (actual time=74.348..87.169 rows=18,255 loops=1)

  • Hash Cond: (articlegro2_.id = article0_.groupmember_id)
8. 1.881 1.881 ↑ 1.0 37,061 1

Seq Scan on articlegroupmember articlegro2_ (cost=0.00..644.61 rows=37,061 width=23) (actual time=0.002..1.881 rows=37,061 loops=1)

9. 4.158 74.328 ↓ 4.0 18,255 1

Hash (cost=7,652.10..7,652.10 rows=4,508 width=66) (actual time=74.328..74.328 rows=18,255 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1748kB
10. 14.871 70.170 ↓ 4.0 18,255 1

Hash Join (cost=5,860.26..7,652.10 rows=4,508 width=66) (actual time=48.819..70.170 rows=18,255 loops=1)

  • Hash Cond: (articleweb7_.id = article0_.websettings_id)
11. 6.493 6.493 ↑ 1.0 39,378 1

Seq Scan on articlewebsettings articleweb7_ (cost=0.00..1,549.78 rows=39,396 width=16) (actual time=0.003..6.493 rows=39,378 loops=1)

  • Filter: online
  • Rows Removed by Filter: 29500
12. 4.423 48.806 ↓ 2.4 18,612 1

Hash (cost=5,761.33..5,761.33 rows=7,915 width=66) (actual time=48.806..48.806 rows=18,612 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1906kB
13. 8.668 44.383 ↓ 2.4 18,612 1

Hash Join (cost=3,933.45..5,761.33 rows=7,915 width=66) (actual time=26.651..44.383 rows=18,612 loops=1)

  • Hash Cond: (stockcache1_.article_id = article0_.id)
14. 9.082 9.082 ↓ 1.0 18,661 1

Seq Scan on articlestockcache stockcache1_ (cost=0.00..1,539.38 rows=18,609 width=18) (actual time=0.007..9.082 rows=18,661 loops=1)

  • Filter: (availablestock > 0::numeric)
  • Rows Removed by Filter: 50169
15. 5.796 26.633 ↓ 1.0 30,271 1

Hash (cost=3,566.70..3,566.70 rows=29,340 width=48) (actual time=26.633..26.633 rows=30,271 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 2226kB
16. 20.837 20.837 ↓ 1.0 30,271 1

Seq Scan on article article0_ (cost=0.00..3,566.70 rows=29,340 width=48) (actual time=0.003..20.837 rows=30,271 loops=1)

  • Filter: (((status)::text = 'ARTICLE_ACTIVE'::text) OR ((status)::text = 'ARTICLE_NO_PURCHASE'::text))
  • Rows Removed by Filter: 38709
17. 0.972 1.715 ↑ 1.0 8,994 1

Hash (cost=182.94..182.94 rows=8,994 width=8) (actual time=1.715..1.715 rows=8,994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 282kB
18. 0.743 0.743 ↑ 1.0 8,994 1

Seq Scan on articlegroup articlegro3_ (cost=0.00..182.94 rows=8,994 width=8) (actual time=0.002..0.743 rows=8,994 loops=1)

19. 0.697 1.266 ↑ 1.0 5,099 1

Hash (cost=114.99..114.99 rows=5,099 width=28) (actual time=1.266..1.266 rows=5,099 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 279kB
20. 0.569 0.569 ↑ 1.0 5,099 1

Seq Scan on rentoption rentoption6_ (cost=0.00..114.99 rows=5,099 width=28) (actual time=0.002..0.569 rows=5,099 loops=1)

21. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=20.40..20.40 rows=1,040 width=48) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
22. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on promowebtext promowebte10_ (cost=0.00..20.40 rows=1,040 width=48) (actual time=0.000..0.000 rows=0 loops=1)

23. 0.104 1.365 ↓ 4.4 768 1

Hash (cost=913.29..913.29 rows=174 width=16) (actual time=1.365..1.365 rows=768 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
24. 0.060 1.261 ↓ 4.4 768 1

Nested Loop (cost=0.00..913.29 rows=174 width=16) (actual time=0.017..1.261 rows=768 loops=1)

25. 0.005 0.005 ↑ 1.0 1 1

Index Only Scan using articlewebtag_pkey on articlewebtag articleweb24_ (cost=0.00..8.27 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = 42474675)
  • Heap Fetches: 0
26. 0.303 1.196 ↓ 4.4 768 1

Nested Loop (cost=0.00..903.29 rows=174 width=24) (actual time=0.011..1.196 rows=768 loops=1)

27. 0.125 0.125 ↓ 4.4 768 1

Index Scan using article_articlewebtag_webtags_id_index on article_articlewebtag webtags23_ (cost=0.00..353.24 rows=174 width=16) (actual time=0.008..0.125 rows=768 loops=1)

  • Index Cond: (webtags_id = 42474675)
28. 0.768 0.768 ↑ 1.0 1 768

Index Only Scan using article_pkey on article article22_ (cost=0.00..3.15 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=768)

  • Index Cond: (id = webtags23_.article_id)
  • Heap Fetches: 29
29. 0.000 1.152 ↑ 1.0 1 384

Nested Loop (cost=0.00..8.92 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=384)

30. 0.000 1.152 ↑ 1.0 1 384

Nested Loop (cost=0.00..0.65 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=384)

31. 0.384 0.384 ↑ 1.0 1 384

Index Only Scan using article_pkey on article article16_ (cost=0.00..0.29 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=384)

  • Index Cond: (id = article22_.id)
  • Heap Fetches: 19
32. 0.768 0.768 ↑ 1.0 1 384

Index Only Scan using article_articlewebtag_pkey on article_articlewebtag webtags17_ (cost=0.00..0.34 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=384)

  • Index Cond: ((article_id = article16_.id) AND (webtags_id = 42605544))
  • Heap Fetches: 0
33. 0.235 0.235 ↑ 1.0 1 235

Index Only Scan using articlewebtag_pkey on articlewebtag articleweb18_ (cost=0.00..8.27 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=235)

  • Index Cond: (id = 42605544)
  • Heap Fetches: 0
34. 0.235 0.235 ↑ 1.0 1 235

Index Scan using warehouse_pkey on articletypewarehouse articletyp12_ (cost=0.00..0.27 rows=1 width=20) (actual time=0.000..0.001 rows=1 loops=235)

  • Index Cond: (id = article0_.warehouse_id)