explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NovP

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.809 ↑ 1.0 1 1

Nested Loop Left Join (cost=435.02..443.45 rows=1 width=2,343) (actual time=0.804..0.809 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_14.res_id)
2. 0.004 0.779 ↑ 1.0 1 1

Nested Loop Left Join (cost=384.41..392.81 rows=1 width=3,510) (actual time=0.775..0.779 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_13.res_id)
3. 0.005 0.761 ↑ 1.0 1 1

Nested Loop Left Join (cost=333.81..342.18 rows=1 width=3,456) (actual time=0.757..0.761 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_12.res_id)
4. 0.006 0.702 ↑ 1.0 1 1

Nested Loop Left Join (cost=320.54..328.89 rows=1 width=3,402) (actual time=0.698..0.702 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_11.res_id)
5. 0.029 0.570 ↑ 1.0 1 1

Nested Loop Left Join (cost=301.17..309.49 rows=1 width=3,348) (actual time=0.566..0.570 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_10.res_id)
6. 0.004 0.446 ↑ 1.0 1 1

Nested Loop Left Join (cost=282.30..290.59 rows=1 width=3,294) (actual time=0.442..0.446 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_9.res_id)
7. 0.004 0.425 ↑ 1.0 1 1

Nested Loop Left Join (cost=231.69..239.96 rows=1 width=3,240) (actual time=0.421..0.425 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_8.res_id)
8. 0.004 0.406 ↑ 1.0 1 1

Nested Loop Left Join (cost=181.09..189.33 rows=1 width=3,186) (actual time=0.403..0.406 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_7.res_id)
9. 0.004 0.388 ↑ 1.0 1 1

Nested Loop Left Join (cost=130.48..138.69 rows=1 width=3,132) (actual time=0.385..0.388 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_6.res_id)
10. 0.005 0.364 ↑ 1.0 1 1

Nested Loop Left Join (cost=79.88..88.06 rows=1 width=3,078) (actual time=0.362..0.364 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_5.res_id)
11. 0.004 0.316 ↑ 1.0 1 1

Nested Loop Left Join (cost=66.61..74.77 rows=1 width=3,024) (actual time=0.314..0.316 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_4.res_id)
12. 0.004 0.273 ↑ 1.0 1 1

Nested Loop Left Join (cost=53.35..61.47 rows=1 width=2,970) (actual time=0.271..0.273 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_3.res_id)
13. 0.005 0.224 ↑ 1.0 1 1

Nested Loop Left Join (cost=40.08..48.18 rows=1 width=2,916) (actual time=0.222..0.224 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_2.res_id)
14. 0.005 0.173 ↑ 1.0 1 1

Nested Loop Left Join (cost=26.82..34.89 rows=1 width=2,862) (actual time=0.171..0.173 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation_1.res_id)
15. 0.011 0.121 ↑ 1.0 1 1

Nested Loop Left Join (cost=13.55..21.60 rows=1 width=2,808) (actual time=0.120..0.121 rows=1 loops=1)

  • Join Filter: (product_template.id = ir_translation.res_id)
16. 0.034 0.034 ↑ 1.0 1 1

Index Scan using product_template_pkey on product_template (cost=0.29..8.30 rows=1 width=2,754) (actual time=0.033..0.034 rows=1 loops=1)

  • Index Cond: (id = 11256)
17. 0.000 0.076 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.076..0.076 rows=0 loops=1)

18. 0.014 0.076 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.075..0.076 rows=0 loops=1)

  • Sort Key: ir_translation.id DESC
  • Sort Method: quicksort Memory: 25kB
19. 0.008 0.062 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation (cost=9.24..13.26 rows=1 width=62) (actual time=0.062..0.062 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'lv_LV'::text) AND (res_id = 11256))
  • Filter: (value <> ''::text)
20. 0.002 0.054 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.054..0.054 rows=0 loops=1)

21. 0.045 0.045 ↓ 1.3 8 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.045..0.045 rows=8 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'lv_LV'::text))
22. 0.007 0.007 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.007..0.007 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
23. 0.000 0.047 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.047..0.047 rows=0 loops=1)

24. 0.009 0.047 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.047..0.047 rows=0 loops=1)

  • Sort Key: ir_translation_1.id DESC
  • Sort Method: quicksort Memory: 25kB
25. 0.001 0.038 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_1 (cost=9.24..13.26 rows=1 width=62) (actual time=0.038..0.038 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'lv_LV'::text) AND (res_id = 11256))
  • Filter: (value <> ''::text)
26. 0.002 0.037 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.037..0.037 rows=0 loops=1)

27. 0.032 0.032 ↓ 1.3 8 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.032..0.032 rows=8 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'lv_LV'::text))
28. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
29. 0.000 0.046 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.046..0.046 rows=0 loops=1)

30. 0.006 0.046 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.046..0.046 rows=0 loops=1)

  • Sort Key: ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
31. 0.004 0.040 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_2 (cost=9.24..13.26 rows=1 width=62) (actual time=0.040..0.040 rows=0 loops=1)

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

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.036..0.036 rows=0 loops=1)

33. 0.032 0.032 ↑ 1.2 5 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.032..0.032 rows=5 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'lv_LV'::text))
34. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
35. 0.000 0.045 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.045..0.045 rows=0 loops=1)

36. 0.008 0.045 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.045..0.045 rows=0 loops=1)

  • Sort Key: ir_translation_3.id DESC
  • Sort Method: quicksort Memory: 25kB
37. 0.001 0.037 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_3 (cost=9.24..13.26 rows=1 width=62) (actual time=0.037..0.037 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'lv_LV'::text) AND (res_id = 11256))
  • Filter: (value <> ''::text)
38. 0.002 0.036 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.036..0.036 rows=0 loops=1)

39. 0.031 0.031 ↓ 1.3 8 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.031..0.031 rows=8 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'lv_LV'::text))
40. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
41. 0.001 0.039 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.039..0.039 rows=0 loops=1)

42. 0.008 0.038 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.038..0.038 rows=0 loops=1)

  • Sort Key: ir_translation_4.id DESC
  • Sort Method: quicksort Memory: 25kB
  • -> Bitmap Heap Scan on ir_translation ir_translation_4 (cost=9.24..13.26 rows=1 width=62) (actual time=0.032..0.032 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'lv_LV'::text) AND (res_id = 11256))
  • Filter: (value <> ''::text)
43. 0.004 0.030 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • -> Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2
44. 0.026 0.026 ↑ 1.2 5 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.026..0.026 rows=5 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'lv_LV'::text))
  • Index Cond: (res_id = 11256)
45. 0.000 0.043 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.043..0.043 rows=0 loops=1)

46. 0.007 0.043 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.043..0.043 rows=0 loops=1)

  • Sort Key: ir_translation_5.id DESC
  • Sort Method: quicksort Memory: 25kB
47. 0.001 0.036 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_5 (cost=9.24..13.26 rows=1 width=62) (actual time=0.036..0.036 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'lv_LV'::text) AND (res_id = 11256))
  • Filter: (value <> ''::text)
48. 0.002 0.035 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.035..0.035 rows=0 loops=1)

49. 0.030 0.030 ↑ 1.2 5 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.030..0.030 rows=5 loops=1)

  • Index Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'lv_LV'::text))
50. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
51. 0.001 0.020 ↓ 0.0 0 1

Unique (cost=50.61..50.61 rows=1 width=62) (actual time=0.019..0.020 rows=0 loops=1)

52. 0.006 0.019 ↓ 0.0 0 1

Sort (cost=50.61..50.61 rows=1 width=62) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: ir_translation_6.id DESC
  • Sort Method: quicksort Memory: 25kB
53. 0.010 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_6 (cost=4.51..50.60 rows=1 width=62) (actual time=0.012..0.013 rows=0 loops=1)

  • Recheck Cond: (res_id = 11256)
  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,ElxNosaukums'::text) AND ((lang)::text = 'lv_LV'::text))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
54. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
55. 0.001 0.014 ↓ 0.0 0 1

Unique (cost=50.61..50.61 rows=1 width=62) (actual time=0.014..0.014 rows=0 loops=1)

56. 0.006 0.013 ↓ 0.0 0 1

Sort (cost=50.61..50.61 rows=1 width=62) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: ir_translation_7.id DESC
  • Sort Method: quicksort Memory: 25kB
57. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_7 (cost=4.51..50.60 rows=1 width=62) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (res_id = 11256)
  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,ElxNosaukumsKentaura'::text) AND ((lang)::text = 'lv_LV'::text))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
58. 0.004 0.004 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.004..0.004 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
59. 0.001 0.015 ↓ 0.0 0 1

Unique (cost=50.61..50.61 rows=1 width=62) (actual time=0.015..0.015 rows=0 loops=1)

60. 0.007 0.014 ↓ 0.0 0 1

Sort (cost=50.61..50.61 rows=1 width=62) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: ir_translation_8.id DESC
  • Sort Method: quicksort Memory: 25kB
61. 0.002 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_8 (cost=4.51..50.60 rows=1 width=62) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (res_id = 11256)
  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,ElxNosaukumsRupnicas'::text) AND ((lang)::text = 'lv_LV'::text))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
62. 0.005 0.005 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.005..0.005 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
63. 0.001 0.017 ↓ 0.0 0 1

Unique (cost=50.61..50.61 rows=1 width=62) (actual time=0.017..0.017 rows=0 loops=1)

64. 0.010 0.016 ↓ 0.0 0 1

Sort (cost=50.61..50.61 rows=1 width=62) (actual time=0.016..0.016 rows=0 loops=1)

  • Sort Key: ir_translation_9.id DESC
  • Sort Method: quicksort Memory: 25kB
65. 0.003 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_9 (cost=4.51..50.60 rows=1 width=62) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (res_id = 11256)
  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,ElxAprakstsIss'::text) AND ((lang)::text = 'lv_LV'::text))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
66. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
67. 0.001 0.095 ↓ 0.0 0 1

Unique (cost=18.87..18.87 rows=1 width=62) (actual time=0.095..0.095 rows=0 loops=1)

68. 0.007 0.094 ↓ 0.0 0 1

Sort (cost=18.87..18.87 rows=1 width=62) (actual time=0.094..0.094 rows=0 loops=1)

  • Sort Key: ir_translation_10.id DESC
  • Sort Method: quicksort Memory: 25kB
69. 0.000 0.087 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_10 (cost=14.84..18.86 rows=1 width=62) (actual time=0.087..0.087 rows=0 loops=1)

  • Recheck Cond: ((res_id = 11256) AND ((name)::text = 'product.template,ElxApraksts'::text) AND ((lang)::text = 'lv_LV'::text))
  • Filter: (value <> ''::text)
70. 0.003 0.087 ↓ 0.0 0 1

BitmapAnd (cost=14.84..14.84 rows=1 width=0) (actual time=0.086..0.087 rows=0 loops=1)

71. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
72. 0.081 0.081 ↓ 1.5 248 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..10.08 rows=166 width=0) (actual time=0.081..0.081 rows=248 loops=1)

  • Index Cond: (((name)::text = 'product.template,ElxApraksts'::text) AND ((lang)::text = 'lv_LV'::text))
73. 0.000 0.126 ↑ 1.0 1 1

Unique (cost=19.38..19.38 rows=1 width=62) (actual time=0.126..0.126 rows=1 loops=1)

74. 0.020 0.126 ↑ 1.0 1 1

Sort (cost=19.38..19.38 rows=1 width=62) (actual time=0.126..0.126 rows=1 loops=1)

  • Sort Key: ir_translation_11.id DESC
  • Sort Method: quicksort Memory: 25kB
75. 0.005 0.106 ↑ 1.0 1 1

Bitmap Heap Scan on ir_translation ir_translation_11 (cost=15.35..19.37 rows=1 width=62) (actual time=0.106..0.106 rows=1 loops=1)

  • Recheck Cond: ((res_id = 11256) AND ((name)::text = 'product.template,description'::text) AND ((lang)::text = 'lv_LV'::text))
  • Filter: (value <> ''::text)
  • Heap Blocks: exact=1
76. 0.001 0.101 ↓ 0.0 0 1

BitmapAnd (cost=15.35..15.35 rows=1 width=0) (actual time=0.101..0.101 rows=0 loops=1)

77. 0.005 0.005 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.005..0.005 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
78. 0.095 0.095 ↓ 1.4 314 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..10.59 rows=217 width=0) (actual time=0.095..0.095 rows=314 loops=1)

  • Index Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'lv_LV'::text))
79. 0.000 0.054 ↓ 0.0 0 1

Unique (cost=13.27..13.27 rows=1 width=62) (actual time=0.054..0.054 rows=0 loops=1)

80. 0.010 0.054 ↓ 0.0 0 1

Sort (cost=13.27..13.27 rows=1 width=62) (actual time=0.054..0.054 rows=0 loops=1)

  • Sort Key: ir_translation_12.id DESC
  • Sort Method: quicksort Memory: 25kB
81. 0.003 0.044 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_12 (cost=9.24..13.26 rows=1 width=62) (actual time=0.044..0.044 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'lv_LV'::text) AND (res_id = 11256))
  • Filter: (value <> ''::text)
82. 0.002 0.041 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=0.041..0.041 rows=0 loops=1)

83. 0.036 0.036 ↓ 1.3 8 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..4.48 rows=6 width=0) (actual time=0.036..0.036 rows=8 loops=1)

  • Index Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'lv_LV'::text))
84. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
85. 0.000 0.014 ↓ 0.0 0 1

Unique (cost=50.61..50.61 rows=1 width=62) (actual time=0.014..0.014 rows=0 loops=1)

86. 0.008 0.014 ↓ 0.0 0 1

Sort (cost=50.61..50.61 rows=1 width=62) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: ir_translation_13.id DESC
  • Sort Method: quicksort Memory: 25kB
87. 0.003 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on ir_translation ir_translation_13 (cost=4.51..50.60 rows=1 width=62) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (res_id = 11256)
  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,ElxSearch'::text) AND ((lang)::text = 'lv_LV'::text))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
88. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
89. 0.004 0.021 ↑ 1.0 1 1

Unique (cost=50.61..50.61 rows=1 width=62) (actual time=0.021..0.021 rows=1 loops=1)

90. 0.010 0.017 ↑ 1.0 1 1

Sort (cost=50.61..50.61 rows=1 width=62) (actual time=0.017..0.017 rows=1 loops=1)

  • Sort Key: ir_translation_14.id DESC
  • Sort Method: quicksort Memory: 25kB
91. 0.004 0.007 ↑ 1.0 1 1

Bitmap Heap Scan on ir_translation ir_translation_14 (cost=4.51..50.60 rows=1 width=62) (actual time=0.007..0.007 rows=1 loops=1)

  • Recheck Cond: (res_id = 11256)
  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'lv_LV'::text))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=1
92. 0.003 0.003 ↑ 6.0 2 1

Bitmap Index Scan on ir_translation_res_id_index (cost=0.00..4.51 rows=12 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (res_id = 11256)
Planning time : 14.798 ms
Execution time : 2.026 ms