explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SeWf : Optimization for: plan #Twh8

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 1.628 ↑ 1.0 19 1

Hash Left Join (cost=929.69..989.64 rows=19 width=1,205) (actual time=1.527..1.628 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__name.res_id)
  • Planning time: 6.607 ms
  • Execution time: 2.125 ms
2. 0.016 1.359 ↑ 1.0 19 1

Hash Left Join (cost=693.45..753.15 rows=19 width=1,699) (actual time=1.269..1.359 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__description_picking.res_id)
3. 0.014 1.268 ↑ 1.0 19 1

Hash Left Join (cost=671.42..731.04 rows=19 width=1,655) (actual time=1.185..1.268 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__description_sale.res_id)
4. 0.016 0.977 ↑ 1.0 19 1

Hash Left Join (cost=451.19..510.58 rows=19 width=1,611) (actual time=0.901..0.977 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__description_purchase.res_id)
5. 0.015 0.839 ↑ 1.0 19 1

Hash Left Join (cost=429.16..488.47 rows=19 width=1,567) (actual time=0.770..0.839 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__website_meta_keywords.res_id)
6. 0.012 0.730 ↑ 1.0 19 1

Hash Left Join (cost=407.13..466.36 rows=19 width=1,523) (actual time=0.669..0.730 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__description.res_id)
7. 0.013 0.581 ↑ 1.0 19 1

Hash Left Join (cost=315.58..374.52 rows=19 width=1,479) (actual time=0.527..0.581 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__website_meta_title.res_id)
8. 0.014 0.502 ↑ 1.0 19 1

Hash Left Join (cost=293.55..352.41 rows=19 width=1,435) (actual time=0.456..0.502 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__description_pickingin.res_id)
9. 0.013 0.415 ↑ 1.0 19 1

Hash Left Join (cost=271.53..330.30 rows=19 width=1,391) (actual time=0.375..0.415 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__description_pickingout.res_id)
10. 0.031 0.181 ↑ 1.0 19 1

Hash Left Join (cost=51.45..110.00 rows=19 width=1,347) (actual time=0.148..0.181 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__website_meta_description.res_id)
11. 0.019 0.047 ↑ 1.0 19 1

Bitmap Heap Scan on product_template (cost=29.42..87.89 rows=19 width=1,303) (actual time=0.033..0.047 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
12. 0.028 0.028 ↑ 1.0 19 1

Bitmap Index Scan on product_template_pkey (cost=0.00..29.41 rows=19 width=0) (actual time=0.028..0.028 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[]))
13. 0.001 0.103 ↓ 0.0 0 1

Hash (cost=22.02..22.02 rows=1 width=48) (actual time=0.103..0.103 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
14. 0.000 0.102 ↓ 0.0 0 1

Subquery Scan on product_template__website_meta_description (cost=22.00..22.02 rows=1 width=48) (actual time=0.102..0.102 rows=0 loops=1)

15. 0.008 0.102 ↓ 0.0 0 1

Sort (cost=22.00..22.01 rows=1 width=52) (actual time=0.102..0.102 rows=0 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 25kB
16. 0.003 0.094 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation (cost=17.97..21.99 rows=1 width=52) (actual time=0.094..0.094 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
17. 0.002 0.091 ↓ 0.0 0 1

BitmapAnd (cost=17.97..17.97 rows=1 width=0) (actual time=0.091..0.091 rows=0 loops=1)

18. 0.019 0.019 ↑ 1.1 10 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..4.50 rows=11 width=0) (actual time=0.019..0.019 rows=10 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_description'::text)
19. 0.070 0.070 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.070..0.070 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
20. 0.000 0.221 ↓ 0.0 0 1

Hash (cost=219.73..219.73 rows=28 width=48) (actual time=0.221..0.221 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
21. 0.000 0.221 ↓ 0.0 0 1

Subquery Scan on product_template__description_pickingout (cost=219.38..219.73 rows=28 width=48) (actual time=0.221..0.221 rows=0 loops=1)

22. 0.005 0.221 ↓ 0.0 0 1

Sort (cost=219.38..219.45 rows=28 width=52) (actual time=0.221..0.221 rows=0 loops=1)

  • Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC
  • Sort Method: quicksort Memory: 25kB
23. 0.001 0.216 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_1 (cost=111.27..218.71 rows=28 width=52) (actual time=0.216..0.216 rows=0 loops=1)

  • Recheck Cond: (((lang)::text = 'en_US'::text) AND ((name)::text = 'product.template,description_pickingout'::text))
  • Filter: (value <> ''::text)
24. 0.008 0.215 ↓ 0.0 0 1

BitmapAnd (cost=111.27..111.27 rows=30 width=0) (actual time=0.215..0.215 rows=0 loops=1)

25. 0.042 0.042 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.042..0.042 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
26. 0.165 0.165 ↑ 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.165..0.165 rows=2,790 loops=1)

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

Hash (cost=22.02..22.02 rows=1 width=48) (actual time=0.073..0.073 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
28. 0.000 0.073 ↓ 0.0 0 1

Subquery Scan on product_template__description_pickingin (cost=22.00..22.02 rows=1 width=48) (actual time=0.073..0.073 rows=0 loops=1)

29. 0.007 0.073 ↓ 0.0 0 1

Sort (cost=22.00..22.01 rows=1 width=52) (actual time=0.073..0.073 rows=0 loops=1)

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
30. 0.001 0.066 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_2 (cost=17.97..21.99 rows=1 width=52) (actual time=0.066..0.066 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
31. 0.002 0.065 ↓ 0.0 0 1

BitmapAnd (cost=17.97..17.97 rows=1 width=0) (actual time=0.065..0.065 rows=0 loops=1)

32. 0.021 0.021 ↓ 2.2 24 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..4.50 rows=11 width=0) (actual time=0.021..0.021 rows=24 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_pickingin'::text)
33. 0.042 0.042 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.042..0.042 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
34. 0.000 0.066 ↓ 0.0 0 1

Hash (cost=22.02..22.02 rows=1 width=48) (actual time=0.066..0.066 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
35. 0.001 0.066 ↓ 0.0 0 1

Subquery Scan on product_template__website_meta_title (cost=22.00..22.02 rows=1 width=48) (actual time=0.066..0.066 rows=0 loops=1)

36. 0.006 0.065 ↓ 0.0 0 1

Sort (cost=22.00..22.01 rows=1 width=52) (actual time=0.065..0.065 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_3 (cost=17.97..21.99 rows=1 width=52) (actual time=0.059..0.059 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
38. 0.001 0.057 ↓ 0.0 0 1

BitmapAnd (cost=17.97..17.97 rows=1 width=0) (actual time=0.057..0.057 rows=0 loops=1)

39. 0.015 0.015 ↑ 1.1 10 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..4.50 rows=11 width=0) (actual time=0.015..0.015 rows=10 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_title'::text)
40. 0.041 0.041 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.041..0.041 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
41. 0.001 0.137 ↓ 0.0 0 1

Hash (cost=91.42..91.42 rows=10 width=48) (actual time=0.137..0.137 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
42. 0.000 0.136 ↓ 0.0 0 1

Subquery Scan on product_template__description (cost=91.30..91.42 rows=10 width=48) (actual time=0.136..0.136 rows=0 loops=1)

43. 0.008 0.136 ↓ 0.0 0 1

Sort (cost=91.30..91.32 rows=10 width=52) (actual time=0.136..0.136 rows=0 loops=1)

  • Sort Key: ir_translation_4.res_id, ir_translation_4.id DESC
  • Sort Method: quicksort Memory: 25kB
44. 0.001 0.128 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_4 (cost=49.84..91.13 rows=10 width=52) (actual time=0.128..0.128 rows=0 loops=1)

  • Recheck Cond: (((lang)::text = 'en_US'::text) AND ((name)::text = 'product.template,description'::text))
  • Filter: (value <> ''::text)
45. 0.009 0.127 ↓ 0.0 0 1

BitmapAnd (cost=49.84..49.84 rows=11 width=0) (actual time=0.127..0.127 rows=0 loops=1)

46. 0.042 0.042 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.042..0.042 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
47. 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)
48. 0.000 0.094 ↓ 0.0 0 1

Hash (cost=22.02..22.02 rows=1 width=48) (actual time=0.094..0.094 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
49. 0.001 0.094 ↓ 0.0 0 1

Subquery Scan on product_template__website_meta_keywords (cost=22.00..22.02 rows=1 width=48) (actual time=0.094..0.094 rows=0 loops=1)

50. 0.007 0.093 ↓ 0.0 0 1

Sort (cost=22.00..22.01 rows=1 width=52) (actual time=0.093..0.093 rows=0 loops=1)

  • Sort Key: ir_translation_5.res_id, ir_translation_5.id DESC
  • Sort Method: quicksort Memory: 25kB
51. 0.001 0.086 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_5 (cost=17.97..21.99 rows=1 width=52) (actual time=0.086..0.086 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
52. 0.002 0.085 ↓ 0.0 0 1

BitmapAnd (cost=17.97..17.97 rows=1 width=0) (actual time=0.085..0.085 rows=0 loops=1)

53. 0.023 0.023 ↑ 1.1 10 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..4.50 rows=11 width=0) (actual time=0.023..0.023 rows=10 loops=1)

  • Index Cond: ((name)::text = 'product.template,website_meta_keywords'::text)
54. 0.060 0.060 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.060..0.060 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
55. 0.000 0.122 ↓ 0.0 0 1

Hash (cost=22.02..22.02 rows=1 width=48) (actual time=0.122..0.122 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
56. 0.001 0.122 ↓ 0.0 0 1

Subquery Scan on product_template__description_purchase (cost=22.00..22.02 rows=1 width=48) (actual time=0.122..0.122 rows=0 loops=1)

57. 0.010 0.121 ↓ 0.0 0 1

Sort (cost=22.00..22.01 rows=1 width=52) (actual time=0.121..0.121 rows=0 loops=1)

  • Sort Key: ir_translation_6.res_id, ir_translation_6.id DESC
  • Sort Method: quicksort Memory: 25kB
58. 0.003 0.111 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_6 (cost=17.97..21.99 rows=1 width=52) (actual time=0.111..0.111 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
59. 0.003 0.108 ↓ 0.0 0 1

BitmapAnd (cost=17.97..17.97 rows=1 width=0) (actual time=0.108..0.108 rows=0 loops=1)

60. 0.032 0.032 ↓ 2.2 24 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..4.50 rows=11 width=0) (actual time=0.032..0.032 rows=24 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_purchase'::text)
61. 0.073 0.073 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.073..0.073 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
62. 0.000 0.277 ↓ 0.0 0 1

Hash (cost=219.89..219.89 rows=28 width=48) (actual time=0.277..0.277 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
63. 0.000 0.277 ↓ 0.0 0 1

Subquery Scan on product_template__description_sale (cost=219.54..219.89 rows=28 width=48) (actual time=0.277..0.277 rows=0 loops=1)

64. 0.006 0.277 ↓ 0.0 0 1

Sort (cost=219.54..219.61 rows=28 width=52) (actual time=0.277..0.277 rows=0 loops=1)

  • Sort Key: ir_translation_7.res_id, ir_translation_7.id DESC
  • Sort Method: quicksort Memory: 25kB
65. 0.001 0.271 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_7 (cost=111.43..218.86 rows=28 width=52) (actual time=0.271..0.271 rows=0 loops=1)

  • Recheck Cond: (((lang)::text = 'en_US'::text) AND ((name)::text = 'product.template,description_sale'::text))
  • Filter: (value <> ''::text)
66. 0.009 0.270 ↓ 0.0 0 1

BitmapAnd (cost=111.43..111.43 rows=30 width=0) (actual time=0.270..0.270 rows=0 loops=1)

67. 0.073 0.073 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.073..0.073 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
68. 0.188 0.188 ↑ 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.188..0.188 rows=2,834 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_sale'::text)
69. 0.000 0.075 ↓ 0.0 0 1

Hash (cost=22.02..22.02 rows=1 width=48) (actual time=0.075..0.075 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
70. 0.000 0.075 ↓ 0.0 0 1

Subquery Scan on product_template__description_picking (cost=22.00..22.02 rows=1 width=48) (actual time=0.075..0.075 rows=0 loops=1)

71. 0.008 0.075 ↓ 0.0 0 1

Sort (cost=22.00..22.01 rows=1 width=52) (actual time=0.075..0.075 rows=0 loops=1)

  • Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC
  • Sort Method: quicksort Memory: 25kB
72. 0.001 0.067 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_8 (cost=17.97..21.99 rows=1 width=52) (actual time=0.067..0.067 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
73. 0.002 0.066 ↓ 0.0 0 1

BitmapAnd (cost=17.97..17.97 rows=1 width=0) (actual time=0.066..0.066 rows=0 loops=1)

74. 0.021 0.021 ↓ 2.2 24 1

Bitmap Index Scan on ir_translation_name_index (cost=0.00..4.50 rows=11 width=0) (actual time=0.021..0.021 rows=24 loops=1)

  • Index Cond: ((name)::text = 'product.template,description_picking'::text)
75. 0.043 0.043 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.043..0.043 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
76. 0.000 0.251 ↓ 0.0 0 1

Hash (cost=235.86..235.86 rows=30 width=48) (actual time=0.251..0.251 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
77. 0.000 0.251 ↓ 0.0 0 1

Subquery Scan on product_template__name (cost=235.49..235.86 rows=30 width=48) (actual time=0.251..0.251 rows=0 loops=1)

78. 0.005 0.251 ↓ 0.0 0 1

Sort (cost=235.49..235.56 rows=30 width=52) (actual time=0.251..0.251 rows=0 loops=1)

  • Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
  • Sort Method: quicksort Memory: 25kB
79. 0.002 0.246 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_9 (cost=117.28..234.75 rows=30 width=52) (actual time=0.246..0.246 rows=0 loops=1)

  • Recheck Cond: (((lang)::text = 'en_US'::text) AND ((name)::text = 'product.template,name'::text))
  • Filter: (value <> ''::text)
80. 0.011 0.244 ↓ 0.0 0 1

BitmapAnd (cost=117.28..117.28 rows=33 width=0) (actual time=0.244..0.244 rows=0 loops=1)

81. 0.042 0.042 ↓ 1.0 667 1

Bitmap Index Scan on ir_translation_lang_index (cost=0.00..13.22 rows=658 width=0) (actual time=0.041..0.042 rows=667 loops=1)

  • Index Cond: ((lang)::text = 'en_US'::text)
82. 0.191 0.191 ↓ 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.191..0.191 rows=3,186 loops=1)

  • Index Cond: ((name)::text = 'product.template,name'::text)