explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H4BQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 114.359 ↓ 117.5 235 1

Nested Loop (cost=9,795.32..10,869.67 rows=2 width=641) (actual time=79.164..114.359 rows=235 loops=1)

2. 0.000 114.085 ↓ 117.5 235 1

Nested Loop Semi Join (cost=9,795.32..10,869.11 rows=2 width=133) (actual time=79.161..114.085 rows=235 loops=1)

3. 2.959 112.167 ↓ 34.9 384 1

Hash Semi Join (cost=9,795.32..10,768.62 rows=11 width=157) (actual time=79.138..112.167 rows=384 loops=1)

  • Hash Cond: (article0_.id = article22_.id)
4. 2.643 107.717 ↓ 4.1 18,255 1

Hash Left Join (cost=8,208.33..9,169.86 rows=4,434 width=141) (actual time=76.317..107.717 rows=18,255 loops=1)

  • Hash Cond: (articleweb7_.promowebtext_id = promowebte10_.id)
5. 4.866 105.074 ↓ 4.1 18,255 1

Hash Left Join (cost=8,174.93..9,119.83 rows=4,434 width=93) (actual time=76.313..105.074 rows=18,255 loops=1)

  • Hash Cond: (article0_.id = rentoption6_.article_id)
6. 3.982 98.971 ↓ 4.1 18,255 1

Hash Left Join (cost=7,996.20..8,899.02 rows=4,434 width=73) (actual time=75.071..98.971 rows=18,255 loops=1)

  • Hash Cond: (articlegro2_.group_id = articlegro3_.id)
7. 17.456 93.368 ↓ 4.1 18,255 1

Hash Right Join (cost=7,700.97..8,498.48 rows=4,434 width=73) (actual time=73.444..93.368 rows=18,255 loops=1)

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

9. 3.974 73.426 ↓ 4.1 18,255 1

Hash (cost=7,645.54..7,645.54 rows=4,434 width=66) (actual time=73.426..73.426 rows=18,255 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1748kB
10. 14.594 69.452 ↓ 4.1 18,255 1

Hash Join (cost=5,855.40..7,645.54 rows=4,434 width=66) (actual time=48.751..69.452 rows=18,255 loops=1)

  • Hash Cond: (articleweb7_.id = article0_.websettings_id)
11. 6.119 6.119 ↓ 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..6.119 rows=39,378 loops=1)

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

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

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

Hash Join (cost=3,930.01..5,757.65 rows=7,820 width=66) (actual time=26.886..44.472 rows=18,612 loops=1)

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

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

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

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

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

Seq Scan on article article0_ (cost=0.00..3,566.70 rows=29,065 width=48) (actual time=0.003..21.103 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.906 1.621 ↓ 1.0 8,994 1

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

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

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

19. 0.679 1.237 ↑ 1.0 5,099 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 279kB
20. 0.558 0.558 ↑ 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.558 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.115 1.491 ↓ 4.3 768 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
24. 0.057 1.376 ↓ 4.3 768 1

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

25. 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.004..0.004 rows=1 loops=1)

  • Index Cond: (id = 42474675)
  • Heap Fetches: 1
26. 0.431 1.315 ↓ 4.3 768 1

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

27. 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.006..0.116 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..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
29. 0.149 1.920 ↑ 1.0 1 384

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

30. 0.000 1.536 ↑ 1.0 1 384

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

31. 0.768 0.768 ↑ 1.0 1 384

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

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

Index Only Scan using article_articlewebtag_pkey on article_articlewebtag webtags17_ (cost=0.00..0.40 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: 235
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: 235
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=524) (actual time=0.001..0.001 rows=1 loops=235)

  • Index Cond: (id = article0_.warehouse_id)