explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NBVO

Settings
# exclusive inclusive rows x rows loops node
1. 0.110 204.844 ↑ 1.0 4 1

Merge Left Join (cost=58,934.05..59,309.75 rows=4 width=657) (actual time=204.818..204.844 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_9.res_id)
  • Planning time: 16.479 ms
  • Execution time: 206.179 ms
2. 0.018 204.726 ↑ 1.0 4 1

Merge Left Join (cost=58,897.27..59,272.79 rows=4 width=1,599) (actual time=204.703..204.726 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_8.res_id)
3. 0.016 204.708 ↑ 1.0 4 1

Merge Left Join (cost=58,860.49..59,235.84 rows=4 width=1,527) (actual time=204.686..204.708 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_7.res_id)
4. 0.013 204.692 ↑ 1.0 4 1

Merge Left Join (cost=58,823.71..59,198.88 rows=4 width=1,455) (actual time=204.671..204.692 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_6.res_id)
5. 0.010 204.679 ↑ 1.0 4 1

Merge Left Join (cost=58,786.93..59,161.92 rows=4 width=1,383) (actual time=204.659..204.679 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_5.res_id)
6. 0.003 204.669 ↑ 1.0 4 1

Merge Left Join (cost=58,750.15..59,124.97 rows=4 width=1,311) (actual time=204.650..204.669 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_4.res_id)
7. 0.004 204.657 ↑ 1.0 4 1

Merge Left Join (cost=58,713.37..59,088.01 rows=4 width=1,239) (actual time=204.639..204.657 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_3.res_id)
8. 0.004 204.624 ↑ 1.0 4 1

Merge Left Join (cost=58,676.60..59,051.05 rows=4 width=1,167) (actual time=204.608..204.624 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_2.res_id)
9. 0.002 0.093 ↑ 1.0 4 1

Merge Left Join (cost=73.84..105.48 rows=4 width=1,095) (actual time=0.078..0.093 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation_1.res_id)
10. 0.008 0.074 ↑ 1.0 4 1

Merge Left Join (cost=37.06..68.53 rows=4 width=1,023) (actual time=0.061..0.074 rows=4 loops=1)

  • Merge Cond: (product_template.id = ir_translation.res_id)
11. 0.038 0.038 ↑ 1.0 4 1

Index Scan using product_template_pkey on product_template (cost=0.28..31.57 rows=4 width=951) (actual time=0.029..0.038 rows=4 loops=1)

  • Index Cond: (id = ANY ('{2258,2104,2105,2103}'::integer[]))
12. 0.001 0.028 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.028..0.028 rows=0 loops=1)

13. 0.008 0.027 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.027..0.027 rows=0 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 25kB
14. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ir_translation_name_lang_index on ir_translation (cost=0.42..36.64 rows=9 width=80) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
15. 0.000 0.017 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.017..0.017 rows=0 loops=1)

16. 0.005 0.017 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.017..0.017 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_1 (cost=0.42..36.64 rows=9 width=80) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
18. 0.001 204.527 ↑ 6,246.0 1 1

Unique (cost=58,602.75..58,867.44 rows=6,246 width=80) (actual time=204.527..204.527 rows=1 loops=1)

19. 68.174 204.526 ↑ 52,938.0 1 1

Sort (cost=58,602.75..58,735.10 rows=52,938 width=80) (actual time=204.526..204.526 rows=1 loops=1)

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: external merge Disk: 5832kB
20. 136.352 136.352 ↑ 1.0 52,234 1

Seq Scan on ir_translation ir_translation_2 (cost=0.00..52,093.74 rows=52,938 width=80) (actual time=48.573..136.352 rows=52,234 loops=1)

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

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.029..0.029 rows=0 loops=1)

22. 0.008 0.029 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.029..0.029 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_3 (cost=0.42..36.64 rows=9 width=80) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
24. 0.000 0.009 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.009..0.009 rows=0 loops=1)

25. 0.001 0.009 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.009..0.009 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_4 (cost=0.42..36.64 rows=9 width=80) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
27. 0.000 0.008 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.008..0.008 rows=0 loops=1)

28. 0.001 0.007 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_5 (cost=0.42..36.64 rows=9 width=80) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
30. 0.001 0.011 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.011..0.011 rows=0 loops=1)

31. 0.002 0.010 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.010..0.010 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_6 (cost=0.42..36.64 rows=9 width=80) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
33. 0.000 0.013 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.013..0.013 rows=0 loops=1)

34. 0.004 0.013 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.013..0.013 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_7 (cost=0.42..36.64 rows=9 width=80) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
36. 0.001 0.016 ↓ 0.0 0 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.016..0.016 rows=0 loops=1)

37. 0.003 0.015 ↓ 0.0 0 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.015..0.015 rows=0 loops=1)

  • Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC
  • Sort Method: quicksort Memory: 25kB
38. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_8 (cost=0.42..36.64 rows=9 width=80) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text))
  • Filter: (value <> ''::text)
39. 0.001 0.111 ↑ 3.0 3 1

Unique (cost=36.78..36.82 rows=9 width=80) (actual time=0.110..0.111 rows=3 loops=1)

40. 0.016 0.110 ↑ 3.0 3 1

Sort (cost=36.78..36.80 rows=9 width=80) (actual time=0.110..0.110 rows=3 loops=1)

  • Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
  • Sort Method: quicksort Memory: 28kB
41. 0.094 0.094 ↓ 3.3 30 1

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_9 (cost=0.42..36.64 rows=9 width=80) (actual time=0.012..0.094 rows=30 loops=1)

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