explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tWr

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 115.727 ↓ 117.5 235 1

Nested Loop (cost=9,796.85..10,870.96 rows=2 width=641) (actual time=82.130..115.727 rows=235 loops=1)

2. 0.001 115.433 ↓ 117.5 235 1

Nested Loop Semi Join (cost=9,796.85..10,870.40 rows=2 width=133) (actual time=82.127..115.433 rows=235 loops=1)

3. 1.611 113.512 ↓ 34.9 384 1

Hash Semi Join (cost=9,796.85..10,769.92 rows=11 width=157) (actual time=82.105..113.512 rows=384 loops=1)

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

Hash Left Join (cost=8,209.86..9,171.17 rows=4,429 width=141) (actual time=79.293..110.407 rows=18,255 loops=1)

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

Hash Left Join (cost=8,176.46..9,121.15 rows=4,429 width=93) (actual time=79.287..108.059 rows=18,255 loops=1)

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

Hash Left Join (cost=7,997.73..8,900.40 rows=4,429 width=73) (actual time=78.014..101.443 rows=18,255 loops=1)

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

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

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

9. 4.043 76.313 ↓ 4.1 18,255 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Buckets: 4096 Batches: 1 Memory Usage: 2226kB
16. 21.296 21.296 ↓ 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..21.296 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.937 1.672 ↓ 1.0 8,994 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 282kB
18. 0.735 0.735 ↓ 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.735 rows=8,994 loops=1)

19. 0.714 1.268 ↑ 1.0 5,099 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 279kB
20. 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.002..0.554 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.107 1.494 ↓ 4.3 768 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
24. 0.062 1.387 ↓ 4.3 768 1

Nested Loop (cost=0.00..1,584.77 rows=178 width=16) (actual time=0.014..1.387 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.004..0.005 rows=1 loops=1)

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

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

27. 0.112 0.112 ↓ 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.112 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)