explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwC

Settings
# exclusive inclusive rows x rows loops node
1. 0.777 309.007 ↓ 78.3 235 1

Hash Semi Join (cost=26,202.95..36,642.78 rows=3 width=695) (actual time=238.783..309.007 rows=235 loops=1)

  • Hash Cond: (article16_.id = article22_.id)
2. 0.000 306.734 ↓ 7.3 7,323 1

Nested Loop Left Join (cost=24,615.96..35,053.11 rows=1,006 width=719) (actual time=235.245..306.734 rows=7,323 loops=1)

3. 5.137 292.797 ↓ 7.7 7,323 1

Nested Loop (cost=24,615.96..31,803.54 rows=949 width=684) (actual time=235.237..292.797 rows=7,323 loops=1)

  • Join Filter: (article0_.warehouse_id = articletyp12_.id)
  • Rows Removed by Join Filter: 29292
4. 1.018 287.660 ↓ 7.7 7,323 1

Hash Left Join (cost=24,615.96..31,731.30 rows=949 width=176) (actual time=235.233..287.660 rows=7,323 loops=1)

  • Hash Cond: (articleweb7_.promowebtext_id = promowebte10_.id)
5. 5.019 286.642 ↓ 7.7 7,323 1

Hash Semi Join (cost=24,582.56..31,694.33 rows=949 width=128) (actual time=235.228..286.642 rows=7,323 loops=1)

  • Hash Cond: (article0_.id = article16_.id)
6. 4.083 256.515 ↓ 4.1 18,255 1

Hash Left Join (cost=18,344.31..25,424.18 rows=4,429 width=112) (actual time=210.115..256.515 rows=18,255 loops=1)

  • Hash Cond: (article0_.id = rentoption6_.article_id)
7. 30.035 251.167 ↓ 4.1 18,255 1

Hash Right Join (cost=18,165.59..25,203.43 rows=4,429 width=92) (actual time=208.844..251.167 rows=18,255 loops=1)

  • Hash Cond: (values5_.multilingualtext_id = multilingu4_.id)
8. 13.036 18.397 ↓ 1.0 127,200 1

Bitmap Heap Scan on multilingualtextvalue values5_ (cost=2,366.87..8,912.21 rows=126,267 width=27) (actual time=5.829..18.397 rows=127,200 loops=1)

  • Recheck Cond: (language_id = 35)
9. 5.361 5.361 ↓ 1.0 127,221 1

Bitmap Index Scan on idx_multilingualtextvalue_language_id (cost=0.00..2,335.30 rows=126,267 width=0) (actual time=5.361..5.361 rows=127,221 loops=1)

  • Index Cond: (language_id = 35)
10. 4.361 202.735 ↓ 4.1 18,255 1

Hash (cost=15,743.35..15,743.35 rows=4,429 width=81) (actual time=202.735..202.735 rows=18,255 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1868kB
11. 61.458 198.374 ↓ 4.1 18,255 1

Hash Right Join (cost=8,955.76..15,743.35 rows=4,429 width=81) (actual time=121.760..198.374 rows=18,255 loops=1)

  • Hash Cond: (multilingu4_.id = articlegro3_.name_id)
12. 16.121 16.121 ↓ 1.0 294,397 1

Seq Scan on multilingualtext multilingu4_ (cost=0.00..4,535.60 rows=294,360 width=8) (actual time=0.007..16.121 rows=294,397 loops=1)

13. 4.715 120.795 ↓ 4.1 18,255 1

Hash (cost=8,900.40..8,900.40 rows=4,429 width=81) (actual time=120.795..120.795 rows=18,255 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1868kB
14. 4.409 116.080 ↓ 4.1 18,255 1

Hash Left Join (cost=7,997.73..8,900.40 rows=4,429 width=81) (actual time=93.825..116.080 rows=18,255 loops=1)

  • Hash Cond: (articlegro2_.group_id = articlegro3_.id)
15. 15.459 108.384 ↓ 4.1 18,255 1

Hash Right Join (cost=7,702.50..8,499.98 rows=4,429 width=73) (actual time=90.525..108.384 rows=18,255 loops=1)

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

Seq Scan on articlegroupmember articlegro2_ (cost=0.00..645.40 rows=37,140 width=23) (actual time=0.004..2.424 rows=37,061 loops=1)

17. 5.376 90.501 ↓ 4.1 18,255 1

Hash (cost=7,647.14..7,647.14 rows=4,429 width=66) (actual time=90.501..90.501 rows=18,255 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1748kB
18. 27.857 85.125 ↓ 4.1 18,255 1

Hash Join (cost=5,857.04..7,647.14 rows=4,429 width=66) (actual time=49.753..85.125 rows=18,255 loops=1)

  • Hash Cond: (articleweb7_.id = article0_.websettings_id)
19. 7.527 7.527 ↓ 1.0 39,378 1

Seq Scan on articlewebsettings articleweb7_ (cost=0.00..1,549.77 rows=39,207 width=16) (actual time=0.003..7.527 rows=39,378 loops=1)

  • Filter: online
  • Rows Removed by Filter: 29500
20. 4.445 49.741 ↓ 2.4 18,612 1

Hash (cost=5,759.29..5,759.29 rows=7,820 width=66) (actual time=49.741..49.741 rows=18,612 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1906kB
21. 10.489 45.296 ↓ 2.4 18,612 1

Hash Join (cost=3,931.65..5,759.29 rows=7,820 width=66) (actual time=25.721..45.296 rows=18,612 loops=1)

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

Seq Scan on articlestockcache stockcache1_ (cost=0.00..1,540.64 rows=18,560 width=18) (actual time=0.008..9.103 rows=18,661 loops=1)

  • Filter: (availablestock > 0::numeric)
  • Rows Removed by Filter: 50169
23. 5.576 25.704 ↓ 1.0 30,271 1

Hash (cost=3,567.92..3,567.92 rows=29,099 width=48) (actual time=25.704..25.704 rows=30,271 loops=1)

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

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

  • Filter: (((status)::text = 'ARTICLE_ACTIVE'::text) OR ((status)::text = 'ARTICLE_NO_PURCHASE'::text))
  • Rows Removed by Filter: 38709
25. 1.764 3.287 ↓ 1.0 8,994 1

Hash (cost=182.88..182.88 rows=8,988 width=16) (actual time=3.287..3.287 rows=8,994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 352kB
26. 1.523 1.523 ↓ 1.0 8,994 1

Seq Scan on articlegroup articlegro3_ (cost=0.00..182.88 rows=8,988 width=16) (actual time=0.003..1.523 rows=8,994 loops=1)

27. 0.711 1.265 ↑ 1.0 5,099 1

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

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

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

29. 1.971 25.108 ↓ 1.0 14,888 1

Hash (cost=6,053.22..6,053.22 rows=14,802 width=16) (actual time=25.108..25.108 rows=14,888 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 582kB
30. 1.075 23.137 ↓ 1.0 14,888 1

Nested Loop (cost=4,364.86..6,053.22 rows=14,802 width=16) (actual time=15.579..23.137 rows=14,888 loops=1)

31. 0.003 0.003 ↑ 1.0 1 1

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

  • Index Cond: (id = 42605544)
  • Heap Fetches: 1
32. 5.489 22.059 ↓ 1.0 14,888 1

Hash Join (cost=4,364.86..5,896.93 rows=14,802 width=24) (actual time=15.572..22.059 rows=14,888 loops=1)

  • Hash Cond: (webtags17_.article_id = article16_.id)
33. 1.024 1.648 ↓ 1.0 14,888 1

Bitmap Heap Scan on article_articlewebtag webtags17_ (cost=278.99..1,478.01 rows=14,802 width=16) (actual time=0.637..1.648 rows=14,888 loops=1)

  • Recheck Cond: (webtags_id = 42605544)
34. 0.624 0.624 ↓ 1.0 14,888 1

Bitmap Index Scan on article_articlewebtag_webtags_id_index (cost=0.00..275.29 rows=14,802 width=0) (actual time=0.624..0.624 rows=14,888 loops=1)

  • Index Cond: (webtags_id = 42605544)
35. 7.667 14.922 ↑ 1.0 68,980 1

Hash (cost=3,222.61..3,222.61 rows=69,061 width=8) (actual time=14.922..14.922 rows=68,980 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2156kB
36. 7.255 7.255 ↑ 1.0 68,980 1

Seq Scan on article article16_ (cost=0.00..3,222.61 rows=69,061 width=8) (actual time=0.002..7.255 rows=68,980 loops=1)

37. 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
38. 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)

39. 0.000 0.000 ↑ 1.0 5 7,323

Materialize (cost=0.00..1.08 rows=5 width=524) (actual time=0.000..0.000 rows=5 loops=7,323)

40. 0.001 0.001 ↑ 1.0 5 1

Seq Scan on articletypewarehouse articletyp12_ (cost=0.00..1.05 rows=5 width=524) (actual time=0.001..0.001 rows=5 loops=1)

41. 14.646 14.646 ↑ 1.0 1 7,323

Index Scan using uknqoxj51egadhqtcrlcv5ryge5 on objectomschrijving omschrijvi11_ (cost=0.00..3.41 rows=1 width=43) (actual time=0.002..0.002 rows=1 loops=7,323)

  • Index Cond: ((taal_id = 35) AND (article0_.id = meertaligobject_id))
42. 0.105 1.496 ↓ 4.3 768 1

Hash (cost=1,584.77..1,584.77 rows=178 width=16) (actual time=1.496..1.496 rows=768 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
43. 0.062 1.391 ↓ 4.3 768 1

Nested Loop (cost=0.00..1,584.77 rows=178 width=16) (actual time=0.013..1.391 rows=768 loops=1)

44. 0.004 0.004 ↑ 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.003..0.004 rows=1 loops=1)

  • Index Cond: (id = 42474675)
  • Heap Fetches: 1
45. 0.441 1.325 ↓ 4.3 768 1

Nested Loop (cost=0.00..1,574.72 rows=178 width=24) (actual time=0.009..1.325 rows=768 loops=1)

46. 0.116 0.116 ↓ 4.3 768 1

Index Scan using article_articlewebtag_webtags_id_index on article_articlewebtag webtags23_ (cost=0.00..347.52 rows=178 width=16) (actual time=0.005..0.116 rows=768 loops=1)

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

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

  • Index Cond: (id = webtags23_.article_id)
  • Heap Fetches: 768