explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tQ5z : Optimization for: plan #5EaB

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.183 2,384.623 ↑ 1.0 10 1

Merge Left Join (cost=460,601.45..468,117.12 rows=10 width=657) (actual time=2,088.216..2,384.623 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_9.res_id)
  • Planning time: 2.186 ms
  • Execution time: 2401.985 ms
2. 0.033 1,253.012 ↑ 1.0 10 1

Merge Left Join (cost=243,530.94..247,336.29 rows=10 width=1,572) (actual time=1,108.274..1,253.012 rows=10 loops=1)

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

Merge Left Join (cost=240,136.63..243,927.63 rows=10 width=1,503) (actual time=1,106.872..1,251.499 rows=10 loops=1)

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

Merge Left Join (cost=236,742.32..240,518.98 rows=10 width=1,434) (actual time=1,105.820..1,250.444 rows=10 loops=1)

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

Merge Left Join (cost=233,348.01..237,110.32 rows=10 width=1,365) (actual time=1,104.721..1,249.341 rows=10 loops=1)

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

Merge Left Join (cost=229,953.70..233,701.67 rows=10 width=1,296) (actual time=1,103.412..1,248.029 rows=10 loops=1)

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

Merge Left Join (cost=226,559.38..230,293.01 rows=10 width=1,227) (actual time=1,102.322..1,246.935 rows=10 loops=1)

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

Merge Left Join (cost=223,165.07..226,884.36 rows=10 width=1,158) (actual time=1,101.190..1,245.800 rows=10 loops=1)

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

Merge Left Join (cost=219,770.76..223,475.70 rows=10 width=1,089) (actual time=1,100.035..1,244.641 rows=10 loops=1)

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

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

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

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

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

Bitmap Heap Scan on product_template (cost=34.90..69.12 rows=10 width=951) (actual time=0.019..0.030 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.014 0.014 ↑ 1.0 10 1

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

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

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

15. 881.854 1,203.560 ↓ 1.0 750,579 1

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

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

Seq Scan on ir_translation (cost=0.00..79,914.84 rows=732,173 width=77) (actual time=4.511..321.706 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.160 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.160..1.160 rows=0 loops=1)

18. 0.009 1.160 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.159..1.160 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_1 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.151..1.151 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_purchase'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5113
20. 0.000 1.153 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.153..1.153 rows=0 loops=1)

21. 0.008 1.153 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.153..1.153 rows=0 loops=1)

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
22. 1.145 1.145 ↓ 0.0 0 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_2 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.145..1.145 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_description'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5093
23. 0.000 1.131 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.131..1.131 rows=0 loops=1)

24. 0.003 1.131 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.131..1.131 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_3 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.128..1.128 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_picking'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5113
26. 0.000 1.089 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.089..1.089 rows=0 loops=1)

27. 0.002 1.089 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.089..1.089 rows=0 loops=1)

  • Sort Key: ir_translation_4.res_id, ir_translation_4.id DESC
  • Sort Method: quicksort Memory: 25kB
28. 1.087 1.087 ↓ 0.0 0 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_4 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.087..1.087 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_title'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5093
29. 0.000 1.307 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.307..1.307 rows=0 loops=1)

30. 0.003 1.307 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.307..1.307 rows=0 loops=1)

  • Sort Key: ir_translation_5.res_id, ir_translation_5.id DESC
  • Sort Method: quicksort Memory: 25kB
31. 1.304 1.304 ↓ 0.0 0 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_5 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.304..1.304 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_pickingout'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5113
32. 0.000 1.098 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.098..1.098 rows=0 loops=1)

33. 0.003 1.098 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.098..1.098 rows=0 loops=1)

  • Sort Key: ir_translation_6.res_id, ir_translation_6.id DESC
  • Sort Method: quicksort Memory: 25kB
34. 1.095 1.095 ↓ 0.0 0 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_6 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.095..1.095 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_keywords'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5093
35. 0.000 1.050 ↓ 0.0 0 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.050..1.050 rows=0 loops=1)

36. 0.002 1.050 ↓ 0.0 0 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.050..1.050 rows=0 loops=1)

  • Sort Key: ir_translation_7.res_id, ir_translation_7.id DESC
  • Sort Method: quicksort Memory: 25kB
37. 1.048 1.048 ↓ 0.0 0 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_7 (cost=0.43..3,348.34 rows=932 width=77) (actual time=1.048..1.048 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_pickingin'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5113
38. 0.059 1.480 ↑ 1.5 519 1

Unique (cost=3,394.31..3,398.97 rows=771 width=77) (actual time=1.400..1.480 rows=519 loops=1)

39. 0.153 1.421 ↑ 1.8 519 1

Sort (cost=3,394.31..3,396.64 rows=932 width=77) (actual time=1.399..1.421 rows=519 loops=1)

  • Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC
  • Sort Method: quicksort Memory: 278kB
40. 1.268 1.268 ↑ 1.8 520 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_8 (cost=0.43..3,348.34 rows=932 width=77) (actual time=0.019..1.268 rows=520 loops=1)

  • Index Cond: ((name)::text = 'product.template,description'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'es_MX'::text))
  • Rows Removed by Filter: 5075
41. 40.463 1,131.428 ↓ 1.3 3,198 1

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

42. 777.485 1,090.965 ↓ 1.0 757,686 1

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

  • Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
  • Sort Method: external merge Disk: 46072kB
43. 313.480 313.480 ↓ 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.010..313.480 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