explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zOmW

Settings
# exclusive inclusive rows x rows loops node
1. 0.555 202.558 ↑ 1.1 7 1

HashAggregate (cost=14,145.19..14,145.27 rows=8 width=16) (actual time=202.557..202.558 rows=7 loops=1)

2. 0.000 202.003 ↓ 137.6 3,165 1

Nested Loop Semi Join (cost=0.03..14,145.08 rows=23 width=16) (actual time=0.150..202.003 rows=3,165 loops=1)

  • Join Filter: (article9_.id = article6_.id)
3. 0.000 192.060 ↓ 32.5 3,380 1

Nested Loop Semi Join (cost=0.03..13,219.21 rows=104 width=40) (actual time=0.134..192.060 rows=3,380 loops=1)

  • Join Filter: (article0_.id = article9_.id)
4. 8.285 64.985 ↓ 16.6 8,602 1

Nested Loop Left Join (cost=0.00..9,317.30 rows=518 width=24) (actual time=0.092..64.985 rows=8,602 loops=1)

  • Filter: ((stockcache1_.availablestock > 0::numeric) OR (stockcache1_.sellablepreferredsupplierstock > 0::numeric) OR ((alternatives: SubPlan 1 or hashed SubPlan 2) AND (stockcache1_.physicalstock > 0::numeric)) OR ((articletyp5_.articletype)::text = 'BUNDLE'::text))
  • Rows Removed by Filter: 1690
5. 6.769 45.371 ↓ 10.7 10,292 1

Nested Loop (cost=0.00..4,791.39 rows=965 width=36) (actual time=0.085..45.371 rows=10,292 loops=1)

  • Join Filter: (article0_.warehouse_id = articletyp5_.id)
  • Rows Removed by Join Filter: 41168
6. 4.683 38.602 ↓ 10.7 10,292 1

Nested Loop (cost=0.00..4,717.95 rows=965 width=32) (actual time=0.078..38.602 rows=10,292 loops=1)

7. 9.018 23.617 ↓ 6.1 10,302 1

Nested Loop (cost=0.00..3,970.53 rows=1,695 width=40) (actual time=0.073..23.617 rows=10,302 loops=1)

8. 1.017 3.071 ↓ 2.7 11,528 1

Nested Loop (cost=0.00..2,476.34 rows=4,260 width=16) (actual time=0.052..3.071 rows=11,528 loops=1)

9. 0.062 0.062 ↑ 1.0 8 1

Seq Scan on articlewebtag articleweb3_ (cost=0.00..12.04 rows=8 width=8) (actual time=0.019..0.062 rows=8 loops=1)

  • Filter: (id = ANY ('{42387572,42387636,42387604,42774682,42774612,42387588,42387620,42774665}'::bigint[]))
  • Rows Removed by Filter: 344
10. 1.992 1.992 ↓ 2.0 1,441 8

Index Scan using article_articlewebtag_webtags_id_index on article_articlewebtag webtags2_ (cost=0.00..300.89 rows=715 width=16) (actual time=0.006..0.249 rows=1,441 loops=8)

  • Index Cond: (webtags_id = articleweb3_.id)
11. 11.528 11.528 ↑ 1.0 1 11,528

Index Scan using article_pkey on article article0_ (cost=0.00..0.34 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=11,528)

  • Index Cond: (id = webtags2_.article_id)
  • Filter: (((status)::text = 'ARTICLE_ACTIVE'::text) OR ((status)::text = 'ARTICLE_NO_PURCAHSE'::text))
  • Rows Removed by Filter: 0
12. 10.302 10.302 ↑ 1.0 1 10,302

Index Scan using articlewebsettings_pkey on articlewebsettings articleweb12_ (cost=0.00..0.43 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=10,302)

  • Index Cond: (id = article0_.websettings_id)
  • Filter: online
  • Rows Removed by Filter: 0
13. 0.000 0.000 ↑ 1.0 5 10,292

Materialize (cost=0.00..1.08 rows=5 width=20) (actual time=0.000..0.000 rows=5 loops=10,292)

14. 0.002 0.002 ↑ 1.0 5 1

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

15. 10.292 10.292 ↑ 1.0 1 10,292

Index Scan using unique_articlestockcache_article_id on articlestockcache stockcache1_ (cost=0.00..0.40 rows=1 width=18) (actual time=0.001..0.001 rows=1 loops=10,292)

  • Index Cond: (article0_.id = article_id)
16.          

SubPlan (forNested Loop Left Join)

17. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on rentoption rentoption4_ (cost=0.00..114.99 rows=5,099 width=8) (actual time=0.002..1.037 rows=5,099 loops=1)

19. 64.988 129.030 ↓ 0.0 0 8,602

Nested Loop (cost=0.03..7.52 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=8,602)

20. 8.602 25.806 ↓ 4.0 4 8,602

Nested Loop (cost=0.00..0.71 rows=1 width=24) (actual time=0.002..0.003 rows=4 loops=8,602)

  • Join Filter: (article9_.id = webtags10_.article_id)
21. 8.602 8.602 ↑ 1.0 1 8,602

Index Only Scan using article_pkey on article article9_ (cost=0.00..0.28 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=8,602)

  • Index Cond: (id = webtags2_.article_id)
  • Heap Fetches: 212
22. 8.602 8.602 ↑ 1.0 4 8,602

Index Only Scan using article_articlewebtag_pkey on article_articlewebtag webtags10_ (cost=0.00..0.37 rows=4 width=16) (actual time=0.001..0.001 rows=4 loops=8,602)

  • Index Cond: (article_id = webtags2_.article_id)
  • Heap Fetches: 0
23. 38.236 38.236 ↓ 0.0 0 38,236

Index Only Scan using articlewebtag_pkey on articlewebtag articleweb11_ (cost=0.03..6.80 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=38,236)

  • Index Cond: ((id = webtags10_.webtags_id) AND (id = ANY ('{42437503,42474405,42474707,42340955,42683560,42341117,42341099,42341033,42341207,42341237,42341105,42474469,42680143,42676849,42680175,42340991,42681544,42676865,42410760,42341183,42341015,42341123,42474421,42341069,42341231,42341243}'::bigint[])))
  • Heap Fetches: 1854
24. 3.380 10.140 ↑ 1.0 1 3,380

Nested Loop (cost=0.00..8.89 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3,380)

25. 0.000 6.760 ↑ 1.0 1 3,380

Nested Loop (cost=0.00..0.61 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=3,380)

  • Join Filter: (article6_.id = webtags7_.article_id)
26. 3.380 3.380 ↑ 1.0 1 3,380

Index Only Scan using article_pkey on article article6_ (cost=0.00..0.28 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=3,380)

  • Index Cond: (id = webtags10_.article_id)
  • Heap Fetches: 95
27. 3.380 3.380 ↑ 1.0 1 3,380

Index Only Scan using article_articlewebtag_pkey on article_articlewebtag webtags7_ (cost=0.00..0.32 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=3,380)

  • Index Cond: ((article_id = webtags10_.article_id) AND (webtags_id = 42605544))
  • Heap Fetches: 0
28. 0.000 0.000 ↑ 1.0 1 3,165

Index Only Scan using articlewebtag_pkey on articlewebtag articleweb8_ (cost=0.00..8.27 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=3,165)

  • Index Cond: (id = 42605544)
  • Heap Fetches: 0