explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lhe3 : Optimization for: Optimization for: plan #Twh8; plan #SeWf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.046 0.895 ↑ 1.0 19 1

Hash Left Join (cost=476.32..536.27 rows=19 width=1,205) (actual time=0.616..0.895 rows=19 loops=1)

  • Hash Cond: (product_template.id = product_template__name.res_id)
2. 0.064 0.810 ↑ 1.0 19 1

Hash Left Join (cost=352.61..412.31 rows=19 width=1,699) (actual time=0.560..0.810 rows=19 loops=1)

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

Hash Left Join (cost=344.13..403.75 rows=19 width=1,655) (actual time=0.517..0.746 rows=19 loops=1)

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

Hash Left Join (cost=230.60..290.00 rows=19 width=1,611) (actual time=0.479..0.687 rows=19 loops=1)

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

Hash Left Join (cost=222.13..281.44 rows=19 width=1,567) (actual time=0.420..0.608 rows=19 loops=1)

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

Hash Left Join (cost=213.65..272.89 rows=19 width=1,523) (actual time=0.388..0.555 rows=19 loops=1)

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

Hash Left Join (cost=168.37..227.31 rows=19 width=1,479) (actual time=0.342..0.487 rows=19 loops=1)

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

Hash Left Join (cost=159.90..218.76 rows=19 width=1,435) (actual time=0.307..0.432 rows=19 loops=1)

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

Hash Left Join (cost=151.42..210.20 rows=19 width=1,391) (actual time=0.259..0.364 rows=19 loops=1)

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

Hash Left Join (cost=37.89..96.45 rows=19 width=1,347) (actual time=0.179..0.263 rows=19 loops=1)

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

Bitmap Heap Scan on product_template (cost=29.42..87.89 rows=19 width=1,303) (actual time=0.075..0.111 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.062 0.062 ↑ 1.0 19 1

Bitmap Index Scan on product_template_pkey (cost=0.00..29.41 rows=19 width=0) (actual time=0.062..0.062 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.084 ↓ 0.0 0 1

Hash (cost=8.46..8.46 rows=1 width=48) (actual time=0.084..0.084 rows=0 loops=1)

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

Subquery Scan on product_template__website_meta_description (cost=8.45..8.46 rows=1 width=48) (actual time=0.083..0.083 rows=0 loops=1)

15. 0.010 0.083 ↓ 0.0 0 1

Sort (cost=8.45..8.45 rows=1 width=52) (actual time=0.082..0.083 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation (cost=0.41..8.44 rows=1 width=52) (actual time=0.073..0.073 rows=0 loops=1)

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

Hash (cost=113.18..113.18 rows=28 width=48) (actual time=0.070..0.070 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
18. 0.001 0.070 ↓ 0.0 0 1

Subquery Scan on product_template__description_pickingout (cost=112.83..113.18 rows=28 width=48) (actual time=0.069..0.070 rows=0 loops=1)

19. 0.005 0.069 ↓ 0.0 0 1

Sort (cost=112.83..112.90 rows=28 width=52) (actual time=0.069..0.069 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_1 (cost=4.72..112.16 rows=28 width=52) (actual time=0.064..0.064 rows=0 loops=1)

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

Bitmap Index Scan on ir_translation_name_lang_index (cost=0.00..4.71 rows=30 width=0) (actual time=0.062..0.062 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'en_US'::text))
22. 0.000 0.039 ↓ 0.0 0 1

Hash (cost=8.46..8.46 rows=1 width=48) (actual time=0.039..0.039 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
23. 0.000 0.039 ↓ 0.0 0 1

Subquery Scan on product_template__description_pickingin (cost=8.45..8.46 rows=1 width=48) (actual time=0.039..0.039 rows=0 loops=1)

24. 0.005 0.039 ↓ 0.0 0 1

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

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_2 (cost=0.41..8.44 rows=1 width=52) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
26. 0.000 0.027 ↓ 0.0 0 1

Hash (cost=8.46..8.46 rows=1 width=48) (actual time=0.027..0.027 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
27. 0.001 0.027 ↓ 0.0 0 1

Subquery Scan on product_template__website_meta_title (cost=8.45..8.46 rows=1 width=48) (actual time=0.027..0.027 rows=0 loops=1)

28. 0.004 0.026 ↓ 0.0 0 1

Sort (cost=8.45..8.45 rows=1 width=52) (actual time=0.026..0.026 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_3 (cost=0.41..8.44 rows=1 width=52) (actual time=0.022..0.022 rows=0 loops=1)

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

Hash (cost=45.15..45.15 rows=10 width=48) (actual time=0.039..0.039 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
31. 0.001 0.039 ↓ 0.0 0 1

Subquery Scan on product_template__description (cost=45.03..45.15 rows=10 width=48) (actual time=0.039..0.039 rows=0 loops=1)

32. 0.003 0.038 ↓ 0.0 0 1

Sort (cost=45.03..45.05 rows=10 width=52) (actual time=0.038..0.038 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_4 (cost=0.41..44.86 rows=10 width=52) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
34. 0.001 0.025 ↓ 0.0 0 1

Hash (cost=8.46..8.46 rows=1 width=48) (actual time=0.025..0.025 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
35. 0.000 0.024 ↓ 0.0 0 1

Subquery Scan on product_template__website_meta_keywords (cost=8.45..8.46 rows=1 width=48) (actual time=0.024..0.024 rows=0 loops=1)

36. 0.004 0.024 ↓ 0.0 0 1

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

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_5 (cost=0.41..8.44 rows=1 width=52) (actual time=0.020..0.020 rows=0 loops=1)

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

Hash (cost=8.46..8.46 rows=1 width=48) (actual time=0.052..0.052 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
39. 0.001 0.052 ↓ 0.0 0 1

Subquery Scan on product_template__description_purchase (cost=8.45..8.46 rows=1 width=48) (actual time=0.052..0.052 rows=0 loops=1)

40. 0.003 0.051 ↓ 0.0 0 1

Sort (cost=8.45..8.45 rows=1 width=52) (actual time=0.051..0.051 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_6 (cost=0.41..8.44 rows=1 width=52) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
42. 0.001 0.031 ↓ 0.0 0 1

Hash (cost=113.18..113.18 rows=28 width=48) (actual time=0.031..0.031 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
43. 0.000 0.030 ↓ 0.0 0 1

Subquery Scan on product_template__description_sale (cost=112.83..113.18 rows=28 width=48) (actual time=0.030..0.030 rows=0 loops=1)

44. 0.004 0.030 ↓ 0.0 0 1

Sort (cost=112.83..112.90 rows=28 width=52) (actual time=0.030..0.030 rows=0 loops=1)

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

Bitmap Heap Scan on ir_translation ir_translation_7 (cost=4.72..112.16 rows=28 width=52) (actual time=0.026..0.026 rows=0 loops=1)

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

Bitmap Index Scan on ir_translation_name_lang_index (cost=0.00..4.71 rows=30 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_sale'::text) AND ((lang)::text = 'en_US'::text))
47. 0.001 0.036 ↓ 0.0 0 1

Hash (cost=8.46..8.46 rows=1 width=48) (actual time=0.036..0.036 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
48. 0.000 0.035 ↓ 0.0 0 1

Subquery Scan on product_template__description_picking (cost=8.45..8.46 rows=1 width=48) (actual time=0.035..0.035 rows=0 loops=1)

49. 0.004 0.035 ↓ 0.0 0 1

Sort (cost=8.45..8.45 rows=1 width=52) (actual time=0.035..0.035 rows=0 loops=1)

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

Index Scan using ir_translation_name_lang_index on ir_translation ir_translation_8 (cost=0.41..8.44 rows=1 width=52) (actual time=0.030..0.031 rows=0 loops=1)

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

Hash (cost=123.34..123.34 rows=30 width=48) (actual time=0.045..0.045 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
52. 0.001 0.045 ↓ 0.0 0 1

Subquery Scan on product_template__name (cost=122.96..123.34 rows=30 width=48) (actual time=0.045..0.045 rows=0 loops=1)

53. 0.004 0.044 ↓ 0.0 0 1

Sort (cost=122.96..123.04 rows=30 width=52) (actual time=0.044..0.044 rows=0 loops=1)

  • Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
  • Sort Method: quicksort Memory: 25kB
54. 0.001 0.040 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_9 (cost=4.75..122.23 rows=30 width=52) (actual time=0.040..0.040 rows=0 loops=1)

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

Bitmap Index Scan on ir_translation_name_lang_index (cost=0.00..4.75 rows=33 width=0) (actual time=0.039..0.039 rows=0 loops=1)

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