explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5EaB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,229.118 9,188.482 ↑ 1.0 10 1

Merge Left Join (cost=461,477.02..468,987.85 rows=10 width=657) (actual time=8,879.741..9,188.482 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_9.res_id)
2. 2.144 7,957.973 ↑ 1.0 10 1

Merge Left Join (cost=244,516.61..248,319.47 rows=10 width=1,572) (actual time=7,794.219..7,957.973 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_8.res_id)
3. 1.398 7,955.829 ↑ 1.0 10 1

Merge Left Join (cost=240,985.37..244,773.90 rows=10 width=1,503) (actual time=7,792.198..7,955.829 rows=10 loops=1)

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

Merge Left Join (cost=237,454.13..241,228.34 rows=10 width=1,434) (actual time=7,790.805..7,954.431 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_6.res_id)
5. 0.006 7,953.023 ↑ 1.0 10 1

Merge Left Join (cost=233,922.89..237,682.78 rows=10 width=1,365) (actual time=7,789.400..7,953.023 rows=10 loops=1)

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

Merge Left Join (cost=230,391.65..234,137.21 rows=10 width=1,296) (actual time=7,787.988..7,951.607 rows=10 loops=1)

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

Merge Left Join (cost=226,860.41..230,591.65 rows=10 width=1,227) (actual time=7,786.640..7,950.257 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_3.res_id)
8. 0.004 7,948.875 ↑ 1.0 10 1

Merge Left Join (cost=223,329.17..227,046.08 rows=10 width=1,158) (actual time=7,785.262..7,948.875 rows=10 loops=1)

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

Merge Left Join (cost=219,797.93..223,500.52 rows=10 width=1,089) (actual time=7,783.843..7,947.453 rows=10 loops=1)

  • Merge Cond: (product_template.id = ir_translation_1.res_id)
10. 0.030 7,946.016 ↑ 1.0 10 1

Merge Left Join (cost=216,266.69..219,954.95 rows=10 width=1,020) (actual time=7,782.410..7,946.016 rows=10 loops=1)

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

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

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

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

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

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

Unique (cost=216,197.41..219,855.93 rows=2,371 width=77) (actual time=7,782.328..7,945.912 rows=185 loops=1)

15. 2,004.751 7,902.416 ↓ 1.0 750,579 1

Sort (cost=216,197.41..218,026.67 rows=731,705 width=77) (actual time=7,782.327..7,902.416 rows=750,579 loops=1)

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

Seq Scan on ir_translation (cost=0.00..79,896.04 rows=731,705 width=77) (actual time=81.387..5,897.665 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.001 1.431 ↓ 0.0 0 1

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.430..1.431 rows=0 loops=1)

18. 0.009 1.430 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.430..1.430 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_1 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.421..1.421 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.532 0.532 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.532..0.532 rows=5,113 loops=1)

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

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.417..1.418 rows=0 loops=1)

22. 0.004 1.417 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.417..1.417 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_2 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.413..1.413 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.547 0.547 ↓ 5.3 5,093 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.547..0.547 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.376 ↓ 0.0 0 1

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.376..1.376 rows=0 loops=1)

26. 0.008 1.376 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.376..1.376 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_3 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.368..1.368 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.499 0.499 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.499..0.499 rows=5,113 loops=1)

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

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.346..1.346 rows=0 loops=1)

30. 0.005 1.345 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.345..1.345 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_4 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.340..1.340 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.468 0.468 ↓ 5.3 5,093 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.468..0.468 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.410 ↓ 0.0 0 1

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.410..1.410 rows=0 loops=1)

34. 0.006 1.410 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.410..1.410 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_5 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.404..1.404 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.500 0.500 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.500..0.500 rows=5,113 loops=1)

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

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.403..1.403 rows=0 loops=1)

38. 0.004 1.403 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.403..1.403 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_6 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.399..1.399 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.518 0.518 ↓ 5.3 5,093 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.518..0.518 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.391 ↓ 0.0 0 1

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=1.391..1.391 rows=0 loops=1)

42. 0.004 1.391 ↓ 0.0 0 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=1.391..1.391 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_7 (cost=42.43..3,485.33 rows=931 width=77) (actual time=1.387..1.387 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.497 0.497 ↓ 5.3 5,113 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.497..0.497 rows=5,113 loops=1)

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

Unique (cost=3,531.24..3,535.89 rows=770 width=77) (actual time=2.018..2.107 rows=519 loops=1)

46. 0.289 2.041 ↑ 1.8 519 1

Sort (cost=3,531.24..3,533.57 rows=931 width=77) (actual time=2.017..2.041 rows=519 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_8 (cost=42.43..3,485.33 rows=931 width=77) (actual time=0.634..1.752 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.584 0.584 ↓ 5.8 5,595 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..42.19 rows=964 width=0) (actual time=0.584..0.584 rows=5,595 loops=1)

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

Unique (cost=216,960.41..220,638.67 rows=2,371 width=77) (actual time=1,085.512..1,230.312 rows=3,198 loops=1)

50. 841.840 1,191.511 ↓ 1.0 757,686 1

Sort (cost=216,960.41..218,799.54 rows=735,652 width=77) (actual time=1,085.511..1,191.511 rows=757,686 loops=1)

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

Seq Scan on ir_translation ir_translation_9 (cost=0.00..79,896.04 rows=735,652 width=77) (actual time=0.025..349.671 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