explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j1AY

Settings
# exclusive inclusive rows x rows loops node
1. 0.194 528.264 ↓ 424.0 424 1

Nested Loop Semi Join (cost=51,238.30..196,358.75 rows=1 width=714) (actual time=420.952..528.264 rows=424 loops=1)

  • Join Filter: (article22_.id = article19_.id)
2. 0.394 497.966 ↓ 84.8 424 1

Nested Loop Semi Join (cost=51,227.31..196,172.20 rows=5 width=746) (actual time=420.854..497.966 rows=424 loops=1)

3. 2.084 494.702 ↓ 23.9 574 1

Hash Semi Join (cost=51,227.31..195,756.89 rows=24 width=730) (actual time=418.021..494.702 rows=574 loops=1)

  • Hash Cond: (article0_.id = article22_.id)
4. 13.638 491.116 ↓ 2.4 22,368 1

Hash Left Join (cost=49,640.31..194,145.04 rows=9,369 width=714) (actual time=414.995..491.116 rows=22,368 loops=1)

  • Hash Cond: (article0_.id = omschrijvi11_.meertaligobject_id)
5. 2.984 445.718 ↓ 2.5 22,368 1

Hash Left Join (cost=39,747.81..183,529.14 rows=8,838 width=679) (actual time=383.202..445.718 rows=22,368 loops=1)

  • Hash Cond: (articleweb7_.promowebtext_id = promowebte10_.id)
6. 9.816 442.734 ↓ 2.5 22,368 1

Hash Join (cost=39,714.41..183,462.59 rows=8,838 width=631) (actual time=383.192..442.734 rows=22,368 loops=1)

  • Hash Cond: (article0_.warehouse_id = articletyp12_.id)
  • Join Filter: ((stockcache1_.availablestock > 0::numeric) OR (stockcache1_.sellablepreferredsupplierstock > 0::numeric) OR ((alternatives: SubPlan 1 or hashed SubPlan 2) AND (stockcache1_.physicalstock > 0::numeric)) OR ((articletyp12_.articletype)::text = 'BUNDLE'::text))
  • Rows Removed by Join Filter: 7077
7. 54.031 432.406 ↓ 1.8 29,445 1

Hash Right Join (cost=39,713.30..46,802.84 rows=16,481 width=123) (actual time=383.178..432.406 rows=29,445 loops=1)

  • Hash Cond: (values9_.multilingualtext_id = multilingu8_.id)
8. 13.986 19.337 ↓ 1.0 127,200 1

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

  • Recheck Cond: (language_id = 35)
9. 5.351 5.351 ↓ 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.351..5.351 rows=127,221 loops=1)

  • Index Cond: (language_id = 35)
10. 8.191 359.038 ↓ 1.8 29,445 1

Hash (cost=37,140.41..37,140.41 rows=16,481 width=112) (actual time=359.038..359.038 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 3419kB
11. 78.480 350.847 ↓ 1.8 29,445 1

Hash Right Join (cost=28,760.50..37,140.41 rows=16,481 width=112) (actual time=258.295..350.847 rows=29,445 loops=1)

  • Hash Cond: (multilingu8_.id = articleweb7_.title_id)
12. 15.559 15.559 ↓ 1.0 294,397 1

Seq Scan on multilingualtext multilingu8_ (cost=0.00..4,535.60 rows=294,360 width=8) (actual time=0.005..15.559 rows=294,397 loops=1)

13. 7.557 256.808 ↓ 1.8 29,445 1

Hash (cost=28,554.49..28,554.49 rows=16,481 width=112) (actual time=256.808..256.808 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 3419kB
14. 6.351 249.251 ↓ 1.8 29,445 1

Hash Left Join (cost=20,996.15..28,554.49 rows=16,481 width=112) (actual time=196.751..249.251 rows=29,445 loops=1)

  • Hash Cond: (article0_.id = rentoption6_.article_id)
15. 9.345 241.631 ↓ 1.8 29,445 1

Hash Right Join (cost=20,817.43..28,219.39 rows=16,481 width=92) (actual time=195.475..241.631 rows=29,445 loops=1)

  • Hash Cond: (articlegro3_.id = articlegro2_.group_id)
16. 23.827 104.558 ↓ 1.0 8,994 1

Hash Right Join (cost=11,090.67..18,148.05 rows=8,988 width=27) (actual time=67.743..104.558 rows=8,994 loops=1)

  • Hash Cond: (values5_.multilingualtext_id = multilingu4_.id)
17. 13.778 19.509 ↓ 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=6.196..19.509 rows=127,200 loops=1)

  • Recheck Cond: (language_id = 35)
18. 5.731 5.731 ↓ 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.731..5.731 rows=127,221 loops=1)

  • Index Cond: (language_id = 35)
19. 1.211 61.222 ↓ 1.0 8,994 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 352kB
20. 6.574 60.011 ↓ 1.0 8,994 1

Hash Left Join (cost=8,215.10..8,611.44 rows=8,988 width=16) (actual time=52.907..60.011 rows=8,994 loops=1)

  • Hash Cond: (articlegro3_.name_id = multilingu4_.id)
21. 0.580 0.580 ↓ 1.0 8,994 1

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

22. 30.167 52.857 ↓ 1.0 294,397 1

Hash (cost=4,535.60..4,535.60 rows=294,360 width=8) (actual time=52.857..52.857 rows=294,397 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 9200kB
23. 22.690 22.690 ↓ 1.0 294,397 1

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

24. 6.664 127.728 ↓ 1.8 29,445 1

Hash (cost=9,520.75..9,520.75 rows=16,481 width=73) (actual time=127.728..127.728 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2903kB
25. 28.168 121.064 ↓ 1.8 29,445 1

Hash Right Join (cost=7,470.96..9,520.75 rows=16,481 width=73) (actual time=88.560..121.064 rows=29,445 loops=1)

  • Hash Cond: (stockcache1_.article_id = article0_.id)
26. 4.354 4.354 ↑ 1.0 68,830 1

Seq Scan on articlestockcache stockcache1_ (cost=0.00..1,368.31 rows=68,931 width=18) (actual time=0.003..4.354 rows=68,830 loops=1)

27. 6.513 88.542 ↓ 1.8 29,445 1

Hash (cost=7,264.94..7,264.94 rows=16,481 width=63) (actual time=88.542..88.542 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2541kB
28. 20.704 82.029 ↓ 1.8 29,445 1

Hash Right Join (cost=6,293.32..7,264.94 rows=16,481 width=63) (actual time=58.882..82.029 rows=29,445 loops=1)

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

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

30. 5.609 58.874 ↓ 1.8 29,445 1

Hash (cost=6,087.31..6,087.31 rows=16,481 width=56) (actual time=58.874..58.874 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2173kB
31. 20.100 53.265 ↓ 1.8 29,445 1

Hash Join (cost=3,931.65..6,087.31 rows=16,481 width=56) (actual time=26.813..53.265 rows=29,445 loops=1)

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

Seq Scan on articlewebsettings articleweb7_ (cost=0.00..1,549.77 rows=39,207 width=24) (actual time=0.004..6.366 rows=39,378 loops=1)

  • Filter: online
  • Rows Removed by Filter: 29500
33. 5.958 26.799 ↓ 1.0 30,099 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 2217kB
34. 20.841 20.841 ↓ 1.0 30,271 1

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

  • Filter: (((status)::text = 'ARTICLE_ACTIVE'::text) OR ((status)::text = 'ARTICLE_NO_PURCHASE'::text))
  • Rows Removed by Filter: 38709
35. 0.705 1.269 ↑ 1.0 5,099 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 279kB
36. 0.564 0.564 ↑ 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.564 rows=5,099 loops=1)

37. 0.002 0.004 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=524) (actual time=0.004..0.004 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
38. 0.002 0.002 ↑ 1.0 5 1

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

39.          

SubPlan (forHash Join)

40. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_rentoption_article_id on rentoption rentoption14_ (cost=0.00..8.27 rows=1 width=0) (never executed)

  • Index Cond: (article_id = article0_.id)
  • Heap Fetches: 0
41. 0.508 0.508 ↑ 1.0 5,099 1

Seq Scan on rentoption rentoption14_ (cost=0.00..114.99 rows=5,099 width=8) (actual time=0.003..0.508 rows=5,099 loops=1)

42. 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
43. 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)

44. 12.790 31.760 ↑ 1.0 84,264 1

Hash (cost=8,833.26..8,833.26 rows=84,739 width=43) (actual time=31.760..31.760 rows=84,264 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 6507kB
45. 15.019 18.970 ↑ 1.0 84,264 1

Bitmap Heap Scan on objectomschrijving omschrijvi11_ (cost=1,965.03..8,833.26 rows=84,739 width=43) (actual time=4.452..18.970 rows=84,264 loops=1)

  • Recheck Cond: (taal_id = 35)
46. 3.951 3.951 ↑ 1.0 84,265 1

Bitmap Index Scan on uknqoxj51egadhqtcrlcv5ryge5 (cost=0.00..1,943.84 rows=84,739 width=0) (actual time=3.951..3.951 rows=84,265 loops=1)

  • Index Cond: (taal_id = 35)
47. 0.106 1.502 ↓ 4.3 768 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
48. 0.052 1.396 ↓ 4.3 768 1

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

49. 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: 1
50. 0.460 1.339 ↓ 4.3 768 1

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

51. 0.111 0.111 ↓ 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.006..0.111 rows=768 loops=1)

  • Index Cond: (webtags_id = 42474675)
52. 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
53. 0.150 2.870 ↑ 1.0 1 574

Nested Loop (cost=0.00..17.29 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=574)

54. 0.000 2.296 ↑ 1.0 1 574

Nested Loop (cost=0.00..9.02 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=574)

55. 1.148 1.148 ↑ 1.0 1 574

Index Only Scan using article_pkey on article article16_ (cost=0.00..4.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=574)

  • Index Cond: (id = article22_.id)
  • Heap Fetches: 574
56. 1.148 1.148 ↑ 1.0 1 574

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

  • Index Cond: ((article_id = article16_.id) AND (webtags_id = 42605544))
  • Heap Fetches: 424
57. 0.424 0.424 ↑ 1.0 1 424

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=424)

  • Index Cond: (id = 42605544)
  • Heap Fetches: 424
58. 1.696 30.104 ↑ 1.0 1 424

Nested Loop (cost=10.99..37.30 rows=1 width=16) (actual time=0.071..0.071 rows=1 loops=424)

  • Join Filter: (article16_.id = article19_.id)
59. 0.848 27.984 ↑ 1.0 1 424

Hash Join (cost=10.99..32.84 rows=1 width=8) (actual time=0.066..0.066 rows=1 loops=424)

  • Hash Cond: (articleweb21_.id = webtags20_.webtags_id)
60. 25.440 25.440 ↑ 1.1 28 424

Seq Scan on articlewebtag articleweb21_ (cost=0.00..21.72 rows=30 width=8) (actual time=0.003..0.060 rows=28 loops=424)

  • Filter: (id = ANY ('{42474611,42340979,42341129,42472612,42340997,42341009,42340913,42472676,42341213,42472564,42474006,42341057,42341135,42473671,42472580,42341075,42683956,42340937,42341153,42472628,42341219,42472724,42340967,42474845,42472644,42340985,42341063,42474675,42341045,42341021}'::bigint[]))
  • Rows Removed by Filter: 286
61. 0.424 1.696 ↓ 1.2 5 424

Hash (cost=10.94..10.94 rows=4 width=16) (actual time=0.004..0.004 rows=5 loops=424)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
62. 1.272 1.272 ↓ 1.2 5 424

Index Only Scan using article_articlewebtag_pkey on article_articlewebtag webtags20_ (cost=0.00..10.94 rows=4 width=16) (actual time=0.002..0.003 rows=5 loops=424)

  • Index Cond: (article_id = article16_.id)
  • Heap Fetches: 2233
63. 0.424 0.424 ↑ 1.0 1 424

Index Only Scan using article_pkey on article article19_ (cost=0.00..4.45 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=424)

  • Index Cond: (id = webtags20_.article_id)
  • Heap Fetches: 424