explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A2ih : Optimization for: Optimization for: plan #5EaB; plan #tQ5z

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.192 2,386.051 ↑ 1.0 10 1

Merge Left Join (cost=461,664.32..469,179.99 rows=10 width=657) (actual time=2,092.969..2,386.051 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_9.res_id)
  • Planning time: 5.393 ms
  • Execution time: 2402.932 ms
2. 0.033 1,279.688 ↑ 1.0 10 1

Merge Left Join (cost=244,593.82..248,399.16 rows=10 width=1,572) (actual time=1,130.927..1,279.688 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_8.res_id)
3. 0.007 1,277.994 ↑ 1.0 10 1

Merge Left Join (cost=241,066.65..244,857.65 rows=10 width=1,503) (actual time=1,129.342..1,277.994 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_7.res_id)
4. 0.005 1,276.768 ↑ 1.0 10 1

Merge Left Join (cost=237,539.48..241,316.13 rows=10 width=1,434) (actual time=1,128.120..1,276.768 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_6.res_id)
5. 0.005 1,275.578 ↑ 1.0 10 1

Merge Left Join (cost=234,012.30..237,774.62 rows=10 width=1,365) (actual time=1,126.934..1,275.578 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_5.res_id)
6. 0.004 1,274.362 ↑ 1.0 10 1

Merge Left Join (cost=230,485.13..234,233.11 rows=10 width=1,296) (actual time=1,125.721..1,274.362 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_4.res_id)
7. 0.005 1,273.181 ↑ 1.0 10 1

Merge Left Join (cost=226,957.96..230,691.59 rows=10 width=1,227) (actual time=1,124.543..1,273.181 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_3.res_id)
8. 0.006 1,271.971 ↑ 1.0 10 1

Merge Left Join (cost=223,430.79..227,150.08 rows=10 width=1,158) (actual time=1,123.336..1,271.971 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_2.res_id)
9. 0.006 1,270.749 ↑ 1.0 10 1

Merge Left Join (cost=219,903.62..223,608.56 rows=10 width=1,089) (actual time=1,122.118..1,270.749 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_1.res_id)
10. 0.028 1,269.439 ↑ 1.0 10 1

Merge Left Join (cost=216,376.45..220,067.05 rows=10 width=1,020) (actual time=1,120.812..1,269.439 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation.res_id)
11. 0.019 0.059 ↑ 1.0 10 1

Sort (cost=69.28..69.31 rows=10 width=951) (actual time=0.057..0.059 rows=10 loops=1)

  • Sort Key: product_template.id
  • Sort Method: quicksort Memory: 30kB
12. 0.022 0.040 ↑ 1.0 10 1

Bitmap Heap Scan on product_template (cost=34.90..69.12 rows=10 width=951) (actual time=0.026..0.040 rows=10 loops=1)

  • Recheck Cond: (id = ANY ('{44501,2114,2182,2184,2157,2189,2100,2263,2171,2172}'::integer[]))
  • Heap Blocks: exact=7
13. 0.018 0.018 ↑ 1.0 10 1

Bitmap Index Scan on product_template_pkey (cost=0.00..34.90 rows=10 width=0) (actual time=0.018..0.018 rows=10 loops=1)

  • Index Cond: (id = ANY ('{44501,2114,2182,2184,2157,2189,2100,2263,2171,2172}'::integer[]))
14. 41.028 1,269.352 ↑ 12.8 185 1

Unique (cost=216,307.17..219,968.03 rows=2,371 width=77) (actual time=1,120.746..1,269.352 rows=185 loops=1)

15. 897.583 1,228.324 ↓ 1.0 750,579 1

Sort (cost=216,307.17..218,137.60 rows=732,173 width=77) (actual time=1,120.745..1,228.324 rows=750,579 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: external merge Disk: 90208kB
16. 330.741 330.741 ↓ 1.0 750,717 1

Seq Scan on ir_translation (cost=0.00..79,914.84 rows=732,173 width=77) (actual time=5.924..330.741 rows=750,717 loops=1)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,description_sale'::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 929845
17. 0.000 1.304 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.304..1.304 rows=0 loops=1)

18. 0.009 1.304 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.303..1.304 rows=0 loops=1)

  • Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC
  • Sort Method: quicksort Memory: 25kB
19. 0.792 1.295 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_1 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.295..1.295 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5113
  • Heap Blocks: exact=333
20. 0.503 0.503 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.503..0.503 rows=5,113 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text))
21. 0.000 1.216 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.216..1.216 rows=0 loops=1)

22. 0.004 1.216 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.216..1.216 rows=0 loops=1)

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
23. 0.749 1.212 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_2 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.212..1.212 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5093
  • Heap Blocks: exact=336
24. 0.463 0.463 ↓ 5.3 5,093 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.463..0.463 rows=5,093 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text))
25. 0.000 1.205 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.205..1.205 rows=0 loops=1)

26. 0.004 1.205 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.204..1.205 rows=0 loops=1)

  • Sort Key: ir_translation_3.res_id, ir_translation_3.id DESC
  • Sort Method: quicksort Memory: 25kB
27. 0.740 1.201 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_3 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.201..1.201 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5113
  • Heap Blocks: exact=338
28. 0.461 0.461 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.461..0.461 rows=5,113 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text))
29. 0.001 1.177 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.177..1.177 rows=0 loops=1)

30. 0.002 1.176 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.176..1.176 rows=0 loops=1)

  • Sort Key: ir_translation_4.res_id, ir_translation_4.id DESC
  • Sort Method: quicksort Memory: 25kB
31. 0.718 1.174 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_4 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.174..1.174 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5093
  • Heap Blocks: exact=338
32. 0.456 0.456 ↓ 5.3 5,093 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.456..0.456 rows=5,093 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text))
33. 0.000 1.211 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.211..1.211 rows=0 loops=1)

34. 0.003 1.211 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.211..1.211 rows=0 loops=1)

  • Sort Key: ir_translation_5.res_id, ir_translation_5.id DESC
  • Sort Method: quicksort Memory: 25kB
35. 0.731 1.208 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_5 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.208..1.208 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5113
  • Heap Blocks: exact=350
36. 0.477 0.477 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.477..0.477 rows=5,113 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text))
37. 0.001 1.185 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.185..1.185 rows=0 loops=1)

38. 0.003 1.184 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.184..1.184 rows=0 loops=1)

  • Sort Key: ir_translation_6.res_id, ir_translation_6.id DESC
  • Sort Method: quicksort Memory: 25kB
39. 0.725 1.181 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_6 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.181..1.181 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5093
  • Heap Blocks: exact=347
40. 0.456 0.456 ↓ 5.3 5,093 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.456..0.456 rows=5,093 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text))
41. 0.000 1.219 ↓ 0.0 0 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.219..1.219 rows=0 loops=1)

42. 0.003 1.219 ↓ 0.0 0 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.219..1.219 rows=0 loops=1)

  • Sort Key: ir_translation_7.res_id, ir_translation_7.id DESC
  • Sort Method: quicksort Memory: 25kB
43. 0.730 1.216 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_7 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.216..1.216 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5113
  • Heap Blocks: exact=350
44. 0.486 0.486 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.486..0.486 rows=5,113 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text))
45. 0.057 1.661 ↑ 1.5 519 1

Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.583..1.661 rows=519 loops=1)

46. 0.154 1.604 ↑ 1.8 519 1

Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.583..1.604 rows=519 loops=1)

  • Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC
  • Sort Method: quicksort Memory: 278kB
47. 0.894 1.450 ↑ 1.8 520 1

Bitmap Heap Scan on ir_translation ir_translation_8 (cost=38.30..3,481.20 rows=932 width=77) (actual time=0.595..1.450 rows=520 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
  • Rows Removed by Filter: 5075
  • Heap Blocks: exact=413
48. 0.556 0.556 ↓ 5.8 5,595 1

Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.556..0.556 rows=5,595 loops=1)

  • Index Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text))
49. 39.810 1,106.171 ↓ 1.3 3,198 1

Unique (cost=217,070.50..220,751.12 rows=2,371 width=77) (actual time=962.031..1,106.171 rows=3,198 loops=1)

50. 755.654 1,066.361 ↓ 1.0 757,686 1

Sort (cost=217,070.50..218,910.81 rows=736,123 width=77) (actual time=962.030..1,066.361 rows=757,686 loops=1)

  • Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
  • Sort Method: external merge Disk: 46072kB
51. 310.707 310.707 ↓ 1.0 758,004 1

Seq Scan on ir_translation ir_translation_9 (cost=0.00..79,914.84 rows=736,123 width=77) (actual time=0.012..310.707 rows=758,004 loops=1)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 922558