explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Twh8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.011 3.801 ↑ 1.0 19 1

Merge Right Join (cost=6,484.27..6,486.62 rows=19 width=1,205) (actual time=3.709..3.801 rows=19 loops=1)

  • Merge Cond: (ir_translation.res_id = product_template.id)
2. 0.007 1.189 ↓ 0.0 0 1

Sort (cost=1,577.06..1,577.13 rows=30 width=52) (actual time=1.189..1.189 rows=0 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.955 1.182 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation (cost=103.79..1,576.32 rows=30 width=52) (actual time=1.182..1.182 rows=0 loops=1)

  • Recheck Cond: ((name)::text = 'product.template,name'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 3186
  • Heap Blocks: exact=201
4. 0.227 0.227 ↓ 1.0 3,186 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..103.79 rows=3,116 width=0) (actual time=0.227..0.227 rows=3,186 loops=1)

  • Index Cond: ((name)::text = 'product.template,name'::text)
5. 0.028 2.601 ↑ 1.0 19 1

Materialize (cost=4,907.20..4,909.06 rows=19 width=1,699) (actual time=2.517..2.601 rows=19 loops=1)

6. 0.007 2.573 ↑ 1.0 19 1

Merge Left Join (cost=4,907.20..4,909.01 rows=19 width=1,699) (actual time=2.510..2.573 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_9.res_id)
7. 0.008 2.528 ↑ 1.0 19 1

Merge Left Join (cost=4,865.28..4,867.02 rows=19 width=1,655) (actual time=2.471..2.528 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_8.res_id)
8. 0.006 1.602 ↑ 1.0 19 1

Merge Left Join (cost=3,298.42..3,299.62 rows=19 width=1,611) (actual time=1.551..1.602 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_7.res_id)
9. 0.006 1.564 ↑ 1.0 19 1

Merge Left Join (cost=3,256.51..3,257.63 rows=19 width=1,567) (actual time=1.519..1.564 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_6.res_id)
10. 0.455 1.531 ↑ 1.0 19 1

Merge Left Join (cost=3,214.59..3,215.64 rows=19 width=1,523) (actual time=1.492..1.531 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_5.res_id)
11. 0.032 1.035 ↑ 1.0 19 1

Merge Left Join (cost=1,780.38..1,781.19 rows=19 width=1,479) (actual time=1.002..1.035 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_4.res_id)
12. 0.047 1.003 ↑ 1.0 19 1

Merge Left Join (cost=1,738.46..1,739.20 rows=19 width=1,435) (actual time=0.976..1.003 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_3.res_id)
13. 0.006 0.956 ↑ 1.0 19 1

Merge Left Join (cost=1,696.55..1,697.20 rows=19 width=1,391) (actual time=0.935..0.956 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_2.res_id)
14. 0.018 0.185 ↑ 1.0 19 1

Merge Left Join (cost=130.21..130.34 rows=19 width=1,347) (actual time=0.169..0.185 rows=19 loops=1)

  • Merge Cond: (product_template.id = ir_translation_1.res_id)
15. 0.041 0.135 ↑ 1.0 19 1

Sort (cost=88.30..88.34 rows=19 width=1,303) (actual time=0.133..0.135 rows=19 loops=1)

  • Sort Key: product_template.id
  • Sort Method: quicksort Memory: 46kB
16. 0.069 0.094 ↑ 1.0 19 1

Bitmap Heap Scan on product_template (cost=29.42..87.89 rows=19 width=1,303) (actual time=0.029..0.094 rows=19 loops=1)

  • Recheck Cond: (id = ANY ('{16243,16198,16199,16200,16207,16208,16209,16242,16213,16214,16215,16216,16217,16218,16219,16220,16221,16210,16223}'::integer[]))
  • Heap Blocks: exact=10
17. 0.025 0.025 ↑ 1.0 19 1

Bitmap Index Scan on product_template_pkey (cost=0.00..29.41 rows=19 width=0) (actual time=0.024..0.025 rows=19 loops=1)

  • Index Cond: (id = ANY ('{16243,16198,16199,16200,16207,16208,16209,16242,16213,16214,16215,16216,16217,16218,16219,16220,16221,16210,16223}'::integer[]))
18. 0.002 0.032 ↓ 0.0 0 1

Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.032..0.032 rows=0 loops=1)

19. 0.009 0.030 ↓ 0.0 0 1

Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.030..0.030 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_1 (cost=0.41..41.91 rows=1 width=52) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_description'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 10
21. 0.004 0.765 ↓ 0.0 0 1

Materialize (cost=1,566.32..1,566.74 rows=28 width=48) (actual time=0.765..0.765 rows=0 loops=1)

22. 0.006 0.761 ↓ 0.0 0 1

Sort (cost=1,566.32..1,566.39 rows=28 width=52) (actual time=0.761..0.761 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_2 (cost=97.79..1,565.65 rows=28 width=52) (actual time=0.755..0.755 rows=0 loops=1)

  • Recheck Cond: ((name)::text = 'product.template,description_pickingout'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 2790
  • Heap Blocks: exact=132
24. 0.177 0.177 ↑ 1.0 2,790 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..97.78 rows=2,849 width=0) (actual time=0.177..0.177 rows=2,790 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_pickingout'::text)
25. 0.000 0.041 ↓ 0.0 0 1

Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.040..0.041 rows=0 loops=1)

26. 0.009 0.038 ↓ 0.0 0 1

Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.038..0.038 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_3 (cost=0.41..41.91 rows=1 width=52) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_pickingin'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 24
28. 0.003 0.025 ↓ 0.0 0 1

Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.025..0.025 rows=0 loops=1)

29. 0.004 0.022 ↓ 0.0 0 1

Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.022..0.022 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_4 (cost=0.41..41.91 rows=1 width=52) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_title'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 10
31. 0.002 0.489 ↓ 0.0 0 1

Materialize (cost=1,434.21..1,434.36 rows=10 width=48) (actual time=0.489..0.489 rows=0 loops=1)

32. 0.004 0.487 ↓ 0.0 0 1

Sort (cost=1,434.21..1,434.24 rows=10 width=52) (actual time=0.487..0.487 rows=0 loops=1)

  • Sort Key: ir_translation_5.res_id, ir_translation_5.id DESC
  • Sort Method: quicksort Memory: 25kB
33. 0.407 0.483 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_5 (cost=36.37..1,434.05 rows=10 width=52) (actual time=0.483..0.483 rows=0 loops=1)

  • Recheck Cond: ((name)::text = 'product.template,description'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 1049
  • Heap Blocks: exact=173
34. 0.076 0.076 ↑ 1.0 1,049 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..36.37 rows=1,060 width=0) (actual time=0.076..0.076 rows=1,049 loops=1)

  • Index Cond: ((name)::text = 'product.template,description'::text)
35. 0.003 0.027 ↓ 0.0 0 1

Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.027..0.027 rows=0 loops=1)

36. 0.006 0.024 ↓ 0.0 0 1

Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.024..0.024 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_6 (cost=0.41..41.91 rows=1 width=52) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_keywords'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 10
38. 0.003 0.032 ↓ 0.0 0 1

Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.031..0.032 rows=0 loops=1)

39. 0.004 0.029 ↓ 0.0 0 1

Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.029..0.029 rows=0 loops=1)

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

Index Scan using ir_translation_name_index on ir_translation ir_translation_7 (cost=0.41..41.91 rows=1 width=52) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_purchase'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 24
41. 0.002 0.918 ↓ 0.0 0 1

Materialize (cost=1,566.85..1,567.27 rows=28 width=48) (actual time=0.918..0.918 rows=0 loops=1)

42. 0.004 0.916 ↓ 0.0 0 1

Sort (cost=1,566.85..1,566.92 rows=28 width=52) (actual time=0.916..0.916 rows=0 loops=1)

  • Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC
  • Sort Method: quicksort Memory: 25kB
43. 0.723 0.912 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_8 (cost=97.95..1,566.17 rows=28 width=52) (actual time=0.911..0.912 rows=0 loops=1)

  • Recheck Cond: ((name)::text = 'product.template,description_sale'::text)
  • Filter: ((value <> ''::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 2834
  • Heap Blocks: exact=165
44. 0.189 0.189 ↑ 1.0 2,834 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..97.94 rows=2,870 width=0) (actual time=0.189..0.189 rows=2,834 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_sale'::text)
45. 0.004 0.038 ↓ 0.0 0 1

Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.038..0.038 rows=0 loops=1)

46. 0.005 0.034 ↓ 0.0 0 1

Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.034..0.034 rows=0 loops=1)

  • Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
  • Sort Method: quicksort Memory: 25kB
47. 0.029 0.029 ↓ 0.0 0 1

Index Scan using ir_translation_name_index on ir_translation ir_translation_9 (cost=0.41..41.91 rows=1 width=52) (actual time=0.028..0.029 rows=0 loops=1)

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