explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a6Uhf

Settings
# exclusive inclusive rows x rows loops node
1. 0.197 619.134 ↓ 9.2 4,233 1

Limit (cost=131,626.08..142,115.01 rows=459 width=212) (actual time=535.733..619.134 rows=4,233 loops=1)

2. 5.100 618.937 ↓ 9.2 4,233 1

Hash Semi Join (cost=131,626.08..142,115.01 rows=459 width=212) (actual time=535.733..618.937 rows=4,233 loops=1)

  • Hash Cond: (article16_.id = article19_.id)
3. 8.773 567.625 ↓ 5.7 11,350 1

Hash Semi Join (cost=123,209.73..133,683.00 rows=1,983 width=228) (actual time=489.517..567.625 rows=11,350 loops=1)

  • Hash Cond: (article0_.id = article16_.id)
4. 41.891 534.537 ↓ 2.5 22,368 1

Hash Right Join (cost=116,950.97..127,358.19 rows=9,071 width=212) (actual time=465.194..534.537 rows=22,368 loops=1)

  • Hash Cond: (omschrijvi11_.meertaligobject_id = article0_.id)
5. 29.320 29.320 ↓ 1.0 84,264 1

Seq Scan on objectomschrijving omschrijvi11_ (cost=0.00..9,686.75 rows=83,966 width=43) (actual time=0.006..29.320 rows=84,264 loops=1)

  • Filter: (taal_id = 35)
  • Rows Removed by Filter: 225956
6. 6.722 463.326 ↓ 2.5 22,368 1

Hash (cost=116,838.87..116,838.87 rows=8,968 width=177) (actual time=463.326..463.326 rows=22,368 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2541kB
7. 3.274 456.604 ↓ 2.5 22,368 1

Hash Left Join (cost=109,750.56..116,838.87 rows=8,968 width=177) (actual time=413.654..456.604 rows=22,368 loops=1)

  • Hash Cond: (articleweb7_.promowebtext_id = promowebte10_.id)
8. 49.532 453.329 ↓ 2.5 22,368 1

Hash Right Join (cost=109,717.16..116,771.83 rows=8,968 width=129) (actual time=413.601..453.329 rows=22,368 loops=1)

  • Hash Cond: (values9_.multilingualtext_id = multilingu8_.id)
9. 13.923 19.396 ↓ 1.0 127,200 1

Bitmap Heap Scan on multilingualtextvalue values9_ (cost=2,365.64..8,908.99 rows=126,108 width=28) (actual time=5.971..19.396 rows=127,200 loops=1)

  • Recheck Cond: (language_id = 35)
10. 5.473 5.473 ↓ 1.0 127,200 1

Bitmap Index Scan on idx_multilingualtextvalue_language_id (cost=0.00..2,334.11 rows=126,108 width=0) (actual time=5.473..5.473 rows=127,200 loops=1)

  • Index Cond: (language_id = 35)
11. 7.412 384.401 ↓ 2.5 22,368 1

Hash (cost=107,239.42..107,239.42 rows=8,968 width=117) (actual time=384.401..384.401 rows=22,368 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2782kB
12. 112.101 376.989 ↓ 2.5 22,368 1

Hash Right Join (cost=100,405.79..107,239.42 rows=8,968 width=117) (actual time=251.289..376.989 rows=22,368 loops=1)

  • Hash Cond: (multilingu8_.id = articleweb7_.title_id)
13. 15.279 15.279 ↑ 1.0 294,397 1

Seq Scan on multilingualtext multilingu8_ (cost=0.00..4,535.97 rows=294,397 width=8) (actual time=0.004..15.279 rows=294,397 loops=1)

14. 6.027 249.609 ↓ 2.5 22,368 1

Hash (cost=100,293.69..100,293.69 rows=8,968 width=117) (actual time=249.609..249.609 rows=22,368 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2782kB
15. 9.392 243.582 ↓ 2.5 22,368 1

Hash Join (cost=21,011.57..100,293.69 rows=8,968 width=117) (actual time=182.672..243.582 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
16. 5.931 233.699 ↓ 1.8 29,445 1

Hash Left Join (cost=21,010.46..28,570.81 rows=16,711 width=113) (actual time=181.370..233.699 rows=29,445 loops=1)

  • Hash Cond: (article0_.id = rentoption6_.article_id)
17. 9.493 226.532 ↓ 1.8 29,445 1

Hash Right Join (cost=20,831.73..28,233.51 rows=16,711 width=93) (actual time=180.128..226.532 rows=29,445 loops=1)

  • Hash Cond: (articlegro3_.id = articlegro2_.group_id)
18. 23.887 102.270 ↑ 1.0 8,994 1

Hash Right Join (cost=11,090.54..18,145.33 rows=8,994 width=28) (actual time=65.355..102.270 rows=8,994 loops=1)

  • Hash Cond: (values5_.multilingualtext_id = multilingu4_.id)
19. 13.801 19.314 ↓ 1.0 127,200 1

Bitmap Heap Scan on multilingualtextvalue values5_ (cost=2,365.64..8,908.99 rows=126,108 width=28) (actual time=5.980..19.314 rows=127,200 loops=1)

  • Recheck Cond: (language_id = 35)
20. 5.513 5.513 ↓ 1.0 127,200 1

Bitmap Index Scan on idx_multilingualtextvalue_language_id (cost=0.00..2,334.11 rows=126,108 width=0) (actual time=5.513..5.513 rows=127,200 loops=1)

  • Index Cond: (language_id = 35)
21. 1.152 59.069 ↑ 1.0 8,994 1

Hash (cost=8,612.48..8,612.48 rows=8,994 width=16) (actual time=59.069..59.069 rows=8,994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 352kB
22. 6.280 57.917 ↑ 1.0 8,994 1

Hash Left Join (cost=8,215.93..8,612.48 rows=8,994 width=16) (actual time=51.217..57.917 rows=8,994 loops=1)

  • Hash Cond: (articlegro3_.name_id = multilingu4_.id)
23. 0.466 0.466 ↑ 1.0 8,994 1

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

24. 29.911 51.171 ↑ 1.0 294,397 1

Hash (cost=4,535.97..4,535.97 rows=294,397 width=8) (actual time=51.171..51.171 rows=294,397 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 9200kB
25. 21.260 21.260 ↑ 1.0 294,397 1

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

26. 6.548 114.769 ↓ 1.8 29,445 1

Hash (cost=9,532.30..9,532.30 rows=16,711 width=73) (actual time=114.769..114.769 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2903kB
27. 26.868 108.221 ↓ 1.8 29,445 1

Hash Right Join (cost=7,482.03..9,532.30 rows=16,711 width=73) (actual time=77.799..108.221 rows=29,445 loops=1)

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

Seq Scan on articlestockcache stockcache1_ (cost=0.00..1,367.30 rows=68,830 width=18) (actual time=0.004..3.572 rows=68,830 loops=1)

29. 5.655 77.781 ↓ 1.8 29,445 1

Hash (cost=7,273.14..7,273.14 rows=16,711 width=63) (actual time=77.781..77.781 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2541kB
30. 12.950 72.126 ↓ 1.8 29,445 1

Hash Right Join (cost=6,302.43..7,273.14 rows=16,711 width=63) (actual time=57.357..72.126 rows=29,445 loops=1)

  • Hash Cond: (articlegro2_.id = article0_.groupmember_id)
31. 1.853 1.853 ↑ 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.853 rows=37,061 loops=1)

32. 6.272 57.323 ↓ 1.8 29,445 1

Hash (cost=6,093.55..6,093.55 rows=16,711 width=56) (actual time=57.323..57.323 rows=29,445 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2173kB
33. 18.701 51.051 ↓ 1.8 29,445 1

Hash Join (cost=3,933.45..6,093.55 rows=16,711 width=56) (actual time=25.029..51.051 rows=29,445 loops=1)

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

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

  • Filter: online
  • Rows Removed by Filter: 29500
35. 5.687 25.016 ↓ 1.0 30,099 1

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

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

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

  • Filter: (((status)::text = 'ARTICLE_ACTIVE'::text) OR ((status)::text = 'ARTICLE_NO_PURCHASE'::text))
  • Rows Removed by Filter: 38709
37. 0.694 1.236 ↑ 1.0 5,099 1

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

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

39. 0.001 0.004 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
40. 0.003 0.003 ↑ 1.0 5 1

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

41.          

SubPlan (forHash Join)

42. 0.000 0.000 ↓ 0.0 0

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

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

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

44. 0.000 0.001 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
45. 0.001 0.001 ↓ 0.0 0 1

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

46. 1.880 24.315 ↑ 1.0 14,888 1

Hash (cost=6,070.22..6,070.22 rows=15,083 width=16) (actual time=24.315..24.315 rows=14,888 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 582kB
47. 0.995 22.435 ↑ 1.0 14,888 1

Nested Loop (cost=4,369.21..6,070.22 rows=15,083 width=16) (actual time=14.659..22.435 rows=14,888 loops=1)

48. 0.007 0.007 ↑ 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.005..0.007 rows=1 loops=1)

  • Index Cond: (id = 42605544)
  • Heap Fetches: 0
49. 5.843 21.433 ↑ 1.0 14,888 1

Hash Join (cost=4,369.21..5,911.12 rows=15,083 width=24) (actual time=14.643..21.433 rows=14,888 loops=1)

  • Hash Cond: (webtags17_.article_id = article16_.id)
50. 0.974 1.554 ↑ 1.0 14,888 1

Bitmap Heap Scan on article_articlewebtag webtags17_ (cost=285.16..1,487.70 rows=15,083 width=16) (actual time=0.593..1.554 rows=14,888 loops=1)

  • Recheck Cond: (webtags_id = 42605544)
51. 0.580 0.580 ↑ 1.0 14,888 1

Bitmap Index Scan on article_articlewebtag_webtags_id_index (cost=0.00..281.39 rows=15,083 width=0) (actual time=0.580..0.580 rows=14,888 loops=1)

  • Index Cond: (webtags_id = 42605544)
52. 7.037 14.036 ↑ 1.0 68,980 1

Hash (cost=3,221.80..3,221.80 rows=68,980 width=8) (actual time=14.036..14.036 rows=68,980 loops=1)

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

Seq Scan on article article16_ (cost=0.00..3,221.80 rows=68,980 width=8) (actual time=0.001..6.999 rows=68,980 loops=1)

54. 2.200 46.212 ↓ 1.1 17,159 1

Hash (cost=8,216.66..8,216.66 rows=15,975 width=16) (actual time=46.212..46.212 rows=17,159 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 671kB
55. 7.286 44.012 ↓ 1.1 17,159 1

Hash Join (cost=4,106.15..8,216.66 rows=15,975 width=16) (actual time=15.066..44.012 rows=17,159 loops=1)

  • Hash Cond: (webtags20_.article_id = article19_.id)
56. 12.887 21.792 ↓ 1.1 17,159 1

Hash Join (cost=22.09..3,773.17 rows=15,975 width=8) (actual time=0.119..21.792 rows=17,159 loops=1)

  • Hash Cond: (webtags20_.webtags_id = articleweb21_.id)
57. 8.796 8.796 ↑ 1.0 187,442 1

Seq Scan on article_articlewebtag webtags20_ (cost=0.00..2,888.42 rows=187,442 width=16) (actual time=0.004..8.796 rows=187,442 loops=1)

58. 0.008 0.109 ↑ 1.0 30 1

Hash (cost=21.72..21.72 rows=30 width=8) (actual time=0.109..0.109 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
59. 0.101 0.101 ↑ 1.0 30 1

Seq Scan on articlewebtag articleweb21_ (cost=0.00..21.72 rows=30 width=8) (actual time=0.007..0.101 rows=30 loops=1)

  • 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: 322
60. 7.373 14.934 ↑ 1.0 68,980 1

Hash (cost=3,221.80..3,221.80 rows=68,980 width=8) (actual time=14.934..14.934 rows=68,980 loops=1)

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

Seq Scan on article article19_ (cost=0.00..3,221.80 rows=68,980 width=8) (actual time=0.001..7.561 rows=68,980 loops=1)