explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ibj

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 125.764 6,542.338 ↓ 5.5 3,103 1

Unique (cost=38,091.20..38,184.92 rows=568 width=846) (actual time=6,386.212..6,542.338 rows=3,103 loops=1)

2. 3,758.925 6,416.574 ↓ 42.1 23,932 1

Sort (cost=38,091.20..38,092.62 rows=568 width=846) (actual time=6,386.206..6,416.574 rows=23,932 loops=1)

  • Sort Key: catalog_producti18n.list_order, catalog_producti18n.id, catalog_producti18n.marked_bad_at, catalog_producti18n.active, catalog_producti18n.name, catalog_producti18n.url, catalog_producti18n.description, catalog_producti18n.product_id, catalog_producti18n.added, catalog_producti18n.brand_id, catalog_producti18n.photo, catalog_producti18n.onweb, catalog_producti18n.needs_fulltext_update, catalog_producti18n.last_modified_fulltext, catalog_product.name, catalog_product.brand_id, catalog_product.photo, catalog_product.sizes, catalog_product.display, catalog_product.colour, catalog_product.added, catalog_product."totalViews", catalog_product.gender, catalog_product."hiddenSince", catalog_product.bargain, catalog_product.onstock, catalog_product.draft, catalog_product.onweb, catalog_product.plus, catalog_product.season, catalog_product."recentSale", catalog_product."recentInstore", catalog_product."notSoldSince", catalog_product.discount, catalog_product.onstockcnt, catalog_product."addedBy_id", catalog_product.watchdogs, catalog_product."missingPLU", catalog_product."applyDiscountTable", catalog_product."collectionID", catalog_product."catalogPrice", catalog_product.price, catalog_product.swf_3d_view, catalog_product.list_order, catalog_product.first_purchase, catalog_product.last_purchase, catalog_product."eshopsSoldQty", catalog_product."storeSoldQty", catalog_product."totalSoldQty", catalog_product."halfYearSoldQty", catalog_product."timeToWebPlacement", catalog_product.zbozi_cz_click, catalog_product.heureka_min_price, catalog_product.heureka_max_price, catalog_product.heureka_url, catalog_product.heureka_diff, catalog_product.ordered_in_last_14_days, catalog_product.ordered_in_last_7_days, catalog_product.ordered_in_last_1_days, catalog_product.last_price_change_time, catalog_product.pricewatch_min, catalog_product.pricewatch_diff, catalog_product.sold_sizes_cnt
  • Sort Method: quicksort Memory: 38567kB
3. 137.170 2,657.649 ↓ 42.1 23,932 1

Hash Join (cost=15,352.89..38,065.21 rows=568 width=846) (actual time=1,043.111..2,657.649 rows=23,932 loops=1)

  • Hash Cond: (catalog_productcategory_site_category.sitecategory_id = catalog_sitecategory_site.sitecategory_id)
4. 333.843 2,519.088 ↓ 34.5 65,237 1

Nested Loop (cost=15,314.77..38,004.85 rows=1,892 width=854) (actual time=1,041.629..2,519.088 rows=65,237 loops=1)

5. 454.680 1,663.349 ↓ 29.4 65,237 1

Hash Join (cost=15,314.77..23,740.37 rows=2,222 width=383) (actual time=1,041.509..1,663.349 rows=65,237 loops=1)

  • Hash Cond: (catalog_productprice.product_id = catalog_product.id)
6. 168.481 181.768 ↓ 2.7 69,971 1

Bitmap Heap Scan on catalog_productprice (cost=555.65..8,796.05 rows=26,078 width=4) (actual time=14.543..181.768 rows=69,971 loops=1)

  • Recheck Cond: (((currency)::text = 'CZK'::text) AND (site_id = 2))
  • Filter: (discount <= 10::double precision)
7. 13.287 13.287 ↓ 2.7 69,971 1

Bitmap Index Scan on catalog_productprice_currency_site (cost=0.00..549.13 rows=26,080 width=0) (actual time=13.287..13.287 rows=69,971 loops=1)

  • Index Cond: (((currency)::text = 'CZK'::text) AND (site_id = 2))
8. 234.705 1,026.901 ↓ 10.9 65,237 1

Hash (cost=14,684.53..14,684.53 rows=5,967 width=379) (actual time=1,026.901..1,026.901 rows=65,237 loops=1)

9. 245.089 792.196 ↓ 10.9 65,237 1

Hash Join (cost=10,794.10..14,684.53 rows=5,967 width=379) (actual time=459.141..792.196 rows=65,237 loops=1)

  • Hash Cond: (catalog_productsize.product_id = catalog_product.id)
10. 88.444 94.588 ↑ 1.0 47,479 1

Bitmap Heap Scan on catalog_productsize (cost=912.06..4,379.16 rows=48,488 width=4) (actual time=6.544..94.588 rows=47,479 loops=1)

  • Recheck Cond: (count >= 1)
11. 6.144 6.144 ↑ 1.0 47,489 1

Bitmap Index Scan on catalog_productsize_count_ix (cost=0.00..899.93 rows=48,488 width=0) (actual time=6.144..6.144 rows=47,489 loops=1)

  • Index Cond: (count >= 1)
12. 57.375 452.519 ↓ 1.9 16,055 1

Hash (cost=9,774.29..9,774.29 rows=8,620 width=375) (actual time=452.519..452.519 rows=16,055 loops=1)

13. 59.543 395.144 ↓ 1.9 16,055 1

Hash Join (cost=2,033.75..9,774.29 rows=8,620 width=375) (actual time=276.878..395.144 rows=16,055 loops=1)

  • Hash Cond: (catalog_product.id = catalog_product_productcategory.product_id)
14. 76.980 76.980 ↑ 1.0 19,554 1

Seq Scan on catalog_product (cost=0.00..7,433.44 rows=19,636 width=363) (actual time=18.143..76.980 rows=19,554 loops=1)

  • Filter: onweb
15. 41.378 258.621 ↑ 1.1 28,474 1

Hash (cost=1,649.41..1,649.41 rows=30,747 width=12) (actual time=258.621..258.621 rows=28,474 loops=1)

16. 124.930 217.243 ↑ 1.1 28,474 1

Hash Join (cost=60.46..1,649.41 rows=30,747 width=12) (actual time=4.838..217.243 rows=28,474 loops=1)

  • Hash Cond: (catalog_product_productcategory.productcategory_id = catalog_productcategory.id)
17. 87.713 87.713 ↑ 1.0 68,307 1

Seq Scan on catalog_product_productcategory (cost=0.00..1,053.07 rows=68,307 width=8) (actual time=0.048..87.713 rows=68,307 loops=1)

18. 0.138 4.600 ↑ 1.4 94 1

Hash (cost=58.84..58.84 rows=129 width=16) (actual time=4.600..4.600 rows=94 loops=1)

19. 0.561 4.462 ↑ 1.4 94 1

Hash Join (cost=50.22..58.84 rows=129 width=16) (actual time=3.819..4.462 rows=94 loops=1)

  • Hash Cond: (catalog_productcategory.id = catalog_productcategory_site_category.productcategory_id)
20. 0.429 0.429 ↑ 1.0 315 1

Seq Scan on catalog_productcategory (cost=0.00..6.15 rows=315 width=4) (actual time=0.027..0.429 rows=315 loops=1)

21. 0.135 3.472 ↑ 1.4 94 1

Hash (cost=48.61..48.61 rows=129 width=12) (actual time=3.472..3.472 rows=94 loops=1)

22. 1.466 3.337 ↑ 1.4 94 1

Hash Join (cost=27.31..48.61 rows=129 width=12) (actual time=0.675..3.337 rows=94 loops=1)

  • Hash Cond: (catalog_productcategory_site_category.sitecategory_id = catalog_sitecategory.id)
23. 1.309 1.309 ↑ 1.0 1,019 1

Seq Scan on catalog_productcategory_site_category (cost=0.00..16.19 rows=1,019 width=8) (actual time=0.025..1.309 rows=1,019 loops=1)

24. 0.136 0.562 ↑ 1.5 92 1

Hash (cost=25.56..25.56 rows=140 width=4) (actual time=0.562..0.562 rows=92 loops=1)

25. 0.426 0.426 ↑ 1.5 92 1

Seq Scan on catalog_sitecategory (cost=0.00..25.56 rows=140 width=4) (actual time=0.086..0.426 rows=92 loops=1)

  • Filter: ((dfs_left >= 572) AND (dfs_right <= 635))
26. 521.896 521.896 ↑ 1.0 1 65,237

Index Scan using t1 on catalog_producti18n (cost=0.00..6.41 rows=1 width=483) (actual time=0.006..0.008 rows=1 loops=65,237)

  • Index Cond: ((catalog_producti18n.product_id = catalog_product.id) AND ((catalog_producti18n.lang)::text = 'cs'::text) AND (catalog_producti18n.active = true))
  • Filter: catalog_producti18n.active
27. 0.491 1.391 ↑ 1.0 332 1

Hash (cost=33.97..33.97 rows=332 width=4) (actual time=1.391..1.391 rows=332 loops=1)

28. 0.790 0.900 ↑ 1.0 332 1

Bitmap Heap Scan on catalog_sitecategory_site (cost=10.82..33.97 rows=332 width=4) (actual time=0.145..0.900 rows=332 loops=1)

  • Recheck Cond: (site_id = 2)
29. 0.110 0.110 ↑ 1.0 332 1

Bitmap Index Scan on catalog_sitecategory_site_site_id (cost=0.00..10.74 rows=332 width=0) (actual time=0.110..0.110 rows=332 loops=1)

  • Index Cond: (site_id = 2)