explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ibj

options
# exclusive inclusive rows x rows loops node
1. 125.764 6542.338 ↓ 5.5 3103 1
→

Unique (cost=38091.20..38184.92 rows=568 width=846) (actual time=6386.212..6542.338 rows=3103 loops=1)

2. 3758.925 6416.574 ↓ 42.1 23932 1
→

Sort (cost=38091.20..38092.62 rows=568 width=846) (actual time=6386.206..6416.574 rows=23932 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 2657.649 ↓ 42.1 23932 1
→

Hash Join (cost=15352.89..38065.21 rows=568 width=846) (actual time=1043.111..2657.649 rows=23932 loops=1)

  • Hash Cond: (catalog_productcategory_site_category.sitecategory_id = catalog_sitecategory_site.sitecategory_id)
4. 333.843 2519.088 ↓ 34.5 65237 1
→

Nested Loop (cost=15314.77..38004.85 rows=1892 width=854) (actual time=1041.629..2519.088 rows=65237 loops=1)

5. 454.680 1663.349 ↓ 29.4 65237 1
→

Hash Join (cost=15314.77..23740.37 rows=2222 width=383) (actual time=1041.509..1663.349 rows=65237 loops=1)

  • Hash Cond: (catalog_productprice.product_id = catalog_product.id)
6. 168.481 181.768 ↓ 2.7 69971 1
→

Bitmap Heap Scan on catalog_productprice (cost=555.65..8796.05 rows=26078 width=4) (actual time=14.543..181.768 rows=69971 loops=1)

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

Bitmap Index Scan on catalog_productprice_currency_site (cost=0.00..549.13 rows=26080 width=0) (actual time=13.287..13.287 rows=69971 loops=1)

  • Index Cond: (((currency)::text = 'CZK'::text) AND (site_id = 2))
8. 234.705 1026.901 ↓ 10.9 65237 1
→

Hash (cost=14684.53..14684.53 rows=5967 width=379) (actual time=1026.901..1026.901 rows=65237 loops=1)

9. 245.089 792.196 ↓ 10.9 65237 1
→

Hash Join (cost=10794.10..14684.53 rows=5967 width=379) (actual time=459.141..792.196 rows=65237 loops=1)

  • Hash Cond: (catalog_productsize.product_id = catalog_product.id)
10. 88.444 94.588 ↑ 1.0 47479 1
→

Bitmap Heap Scan on catalog_productsize (cost=912.06..4379.16 rows=48488 width=4) (actual time=6.544..94.588 rows=47479 loops=1)

  • Recheck Cond: (count >= 1)
11. 6.144 6.144 ↑ 1.0 47489 1
→

Bitmap Index Scan on catalog_productsize_count_ix (cost=0.00..899.93 rows=48488 width=0) (actual time=6.144..6.144 rows=47489 loops=1)

  • Index Cond: (count >= 1)
12. 57.375 452.519 ↓ 1.9 16055 1
→

Hash (cost=9774.29..9774.29 rows=8620 width=375) (actual time=452.519..452.519 rows=16055 loops=1)

13. 59.543 395.144 ↓ 1.9 16055 1
→

Hash Join (cost=2033.75..9774.29 rows=8620 width=375) (actual time=276.878..395.144 rows=16055 loops=1)

  • Hash Cond: (catalog_product.id = catalog_product_productcategory.product_id)
14. 76.980 76.980 ↑ 1.0 19554 1
→

Seq Scan on catalog_product (cost=0.00..7433.44 rows=19636 width=363) (actual time=18.143..76.980 rows=19554 loops=1)

  • Filter: onweb
15. 41.378 258.621 ↑ 1.1 28474 1
→

Hash (cost=1649.41..1649.41 rows=30747 width=12) (actual time=258.621..258.621 rows=28474 loops=1)

16. 124.930 217.243 ↑ 1.1 28474 1
→

Hash Join (cost=60.46..1649.41 rows=30747 width=12) (actual time=4.838..217.243 rows=28474 loops=1)

  • Hash Cond: (catalog_product_productcategory.productcategory_id = catalog_productcategory.id)
17. 87.713 87.713 ↑ 1.0 68307 1
→

Seq Scan on catalog_product_productcategory (cost=0.00..1053.07 rows=68307 width=8) (actual time=0.048..87.713 rows=68307 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 1019 1
→

Seq Scan on catalog_productcategory_site_category (cost=0.00..16.19 rows=1019 width=8) (actual time=0.025..1.309 rows=1019 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 65237
→

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=65237)

  • 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)