#	exclusive	inclusive	rows x	rows	loops	node
1.	0.192	2,386.051	↑ 1.0	10	1	→ Merge Left Join (cost=461,664.32..469,179.99 rows=10 width=657) (actual time=2,092.969..2,386.051 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_9.res_id) Planning time: 5.393 ms Execution time: 2402.932 ms
2.	0.033	1,279.688	↑ 1.0	10	1	→ Merge Left Join (cost=244,593.82..248,399.16 rows=10 width=1,572) (actual time=1,130.927..1,279.688 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_8.res_id)
3.	0.007	1,277.994	↑ 1.0	10	1	→ Merge Left Join (cost=241,066.65..244,857.65 rows=10 width=1,503) (actual time=1,129.342..1,277.994 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_7.res_id)
4.	0.005	1,276.768	↑ 1.0	10	1	→ Merge Left Join (cost=237,539.48..241,316.13 rows=10 width=1,434) (actual time=1,128.120..1,276.768 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_6.res_id)
5.	0.005	1,275.578	↑ 1.0	10	1	→ Merge Left Join (cost=234,012.30..237,774.62 rows=10 width=1,365) (actual time=1,126.934..1,275.578 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_5.res_id)
6.	0.004	1,274.362	↑ 1.0	10	1	→ Merge Left Join (cost=230,485.13..234,233.11 rows=10 width=1,296) (actual time=1,125.721..1,274.362 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_4.res_id)
7.	0.005	1,273.181	↑ 1.0	10	1	→ Merge Left Join (cost=226,957.96..230,691.59 rows=10 width=1,227) (actual time=1,124.543..1,273.181 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_3.res_id)
8.	0.006	1,271.971	↑ 1.0	10	1	→ Merge Left Join (cost=223,430.79..227,150.08 rows=10 width=1,158) (actual time=1,123.336..1,271.971 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_2.res_id)
9.	0.006	1,270.749	↑ 1.0	10	1	→ Merge Left Join (cost=219,903.62..223,608.56 rows=10 width=1,089) (actual time=1,122.118..1,270.749 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation_1.res_id)
10.	0.028	1,269.439	↑ 1.0	10	1	→ Merge Left Join (cost=216,376.45..220,067.05 rows=10 width=1,020) (actual time=1,120.812..1,269.439 rows=10 loops=1) Merge Cond: (product_template.id = ir_translation.res_id)
11.	0.019	0.059	↑ 1.0	10	1	→ Sort (cost=69.28..69.31 rows=10 width=951) (actual time=0.057..0.059 rows=10 loops=1) Sort Key: product_template.id Sort Method: quicksort Memory: 30kB
12.	0.022	0.040	↑ 1.0	10	1	→ Bitmap Heap Scan on product_template (cost=34.90..69.12 rows=10 width=951) (actual time=0.026..0.040 rows=10 loops=1) Recheck Cond: (id = ANY ('{44501,2114,2182,2184,2157,2189,2100,2263,2171,2172}'::integer[])) Heap Blocks: exact=7
13.	0.018	0.018	↑ 1.0	10	1	→ Bitmap Index Scan on product_template_pkey (cost=0.00..34.90 rows=10 width=0) (actual time=0.018..0.018 rows=10 loops=1) Index Cond: (id = ANY ('{44501,2114,2182,2184,2157,2189,2100,2263,2171,2172}'::integer[]))
14.	41.028	1,269.352	↑ 12.8	185	1	→ Unique (cost=216,307.17..219,968.03 rows=2,371 width=77) (actual time=1,120.746..1,269.352 rows=185 loops=1)
15.	897.583	1,228.324	↓ 1.0	750,579	1	→ Sort (cost=216,307.17..218,137.60 rows=732,173 width=77) (actual time=1,120.745..1,228.324 rows=750,579 loops=1) Sort Key: ir_translation.res_id, ir_translation.id DESC Sort Method: external merge Disk: 90208kB
16.	330.741	330.741	↓ 1.0	750,717	1	→ Seq Scan on ir_translation (cost=0.00..79,914.84 rows=732,173 width=77) (actual time=5.924..330.741 rows=750,717 loops=1) Filter: ((value <> ''::text) AND ((name)::text = 'product.template,description_sale'::text) AND ((lang)::text = 'es_MX'::text)) Rows Removed by Filter: 929845
17.	0.000	1.304	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.304..1.304 rows=0 loops=1)
18.	0.009	1.304	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.303..1.304 rows=0 loops=1) Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC Sort Method: quicksort Memory: 25kB
19.	0.792	1.295	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_1 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.295..1.295 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5113 Heap Blocks: exact=333
20.	0.503	0.503	↓ 5.3	5,113	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.503..0.503 rows=5,113 loops=1) Index Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text))
21.	0.000	1.216	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.216..1.216 rows=0 loops=1)
22.	0.004	1.216	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.216..1.216 rows=0 loops=1) Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC Sort Method: quicksort Memory: 25kB
23.	0.749	1.212	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_2 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.212..1.212 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5093 Heap Blocks: exact=336
24.	0.463	0.463	↓ 5.3	5,093	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.463..0.463 rows=5,093 loops=1) Index Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text))
25.	0.000	1.205	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.205..1.205 rows=0 loops=1)
26.	0.004	1.205	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.204..1.205 rows=0 loops=1) Sort Key: ir_translation_3.res_id, ir_translation_3.id DESC Sort Method: quicksort Memory: 25kB
27.	0.740	1.201	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_3 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.201..1.201 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5113 Heap Blocks: exact=338
28.	0.461	0.461	↓ 5.3	5,113	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.461..0.461 rows=5,113 loops=1) Index Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text))
29.	0.001	1.177	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.177..1.177 rows=0 loops=1)
30.	0.002	1.176	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.176..1.176 rows=0 loops=1) Sort Key: ir_translation_4.res_id, ir_translation_4.id DESC Sort Method: quicksort Memory: 25kB
31.	0.718	1.174	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_4 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.174..1.174 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5093 Heap Blocks: exact=338
32.	0.456	0.456	↓ 5.3	5,093	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.456..0.456 rows=5,093 loops=1) Index Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text))
33.	0.000	1.211	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.211..1.211 rows=0 loops=1)
34.	0.003	1.211	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.211..1.211 rows=0 loops=1) Sort Key: ir_translation_5.res_id, ir_translation_5.id DESC Sort Method: quicksort Memory: 25kB
35.	0.731	1.208	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_5 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.208..1.208 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5113 Heap Blocks: exact=350
36.	0.477	0.477	↓ 5.3	5,113	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.477..0.477 rows=5,113 loops=1) Index Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text))
37.	0.001	1.185	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.185..1.185 rows=0 loops=1)
38.	0.003	1.184	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.184..1.184 rows=0 loops=1) Sort Key: ir_translation_6.res_id, ir_translation_6.id DESC Sort Method: quicksort Memory: 25kB
39.	0.725	1.181	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_6 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.181..1.181 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5093 Heap Blocks: exact=347
40.	0.456	0.456	↓ 5.3	5,093	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.456..0.456 rows=5,093 loops=1) Index Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text))
41.	0.000	1.219	↓ 0.0	0	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.219..1.219 rows=0 loops=1)
42.	0.003	1.219	↓ 0.0	0	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.219..1.219 rows=0 loops=1) Sort Key: ir_translation_7.res_id, ir_translation_7.id DESC Sort Method: quicksort Memory: 25kB
43.	0.730	1.216	↓ 0.0	0	1	→ Bitmap Heap Scan on ir_translation ir_translation_7 (cost=38.30..3,481.20 rows=932 width=77) (actual time=1.216..1.216 rows=0 loops=1) Recheck Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5113 Heap Blocks: exact=350
44.	0.486	0.486	↓ 5.3	5,113	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.486..0.486 rows=5,113 loops=1) Index Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text))
45.	0.057	1.661	↑ 1.5	519	1	→ Unique (cost=3,527.17..3,531.83 rows=771 width=77) (actual time=1.583..1.661 rows=519 loops=1)
46.	0.154	1.604	↑ 1.8	519	1	→ Sort (cost=3,527.17..3,529.50 rows=932 width=77) (actual time=1.583..1.604 rows=519 loops=1) Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC Sort Method: quicksort Memory: 278kB
47.	0.894	1.450	↑ 1.8	520	1	→ Bitmap Heap Scan on ir_translation ir_translation_8 (cost=38.30..3,481.20 rows=932 width=77) (actual time=0.595..1.450 rows=520 loops=1) Recheck Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text)) Filter: (value <> ''::text) Rows Removed by Filter: 5075 Heap Blocks: exact=413
48.	0.556	0.556	↓ 5.8	5,595	1	→ Bitmap Index Scan on ir_translation_langvalue_index (cost=0.00..38.07 rows=964 width=0) (actual time=0.556..0.556 rows=5,595 loops=1) Index Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text))
49.	39.810	1,106.171	↓ 1.3	3,198	1	→ Unique (cost=217,070.50..220,751.12 rows=2,371 width=77) (actual time=962.031..1,106.171 rows=3,198 loops=1)
50.	755.654	1,066.361	↓ 1.0	757,686	1	→ Sort (cost=217,070.50..218,910.81 rows=736,123 width=77) (actual time=962.030..1,066.361 rows=757,686 loops=1) Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC Sort Method: external merge Disk: 46072kB
51.	310.707	310.707	↓ 1.0	758,004	1	→ Seq Scan on ir_translation ir_translation_9 (cost=0.00..79,914.84 rows=736,123 width=77) (actual time=0.012..310.707 rows=758,004 loops=1) Filter: ((value <> ''::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'es_MX'::text)) Rows Removed by Filter: 922558

Merge Left Join  (cost=461664.32..469179.99 rows=10 width=657) (actual time=2092.969..2386.051 rows=10 loops=1)
   Merge Cond: (product_template.id = ir_translation_9.res_id)
   ->  Merge Left Join  (cost=244593.82..248399.16 rows=10 width=1572) (actual time=1130.927..1279.688 rows=10 loops=1)
         Merge Cond: (product_template.id = ir_translation_8.res_id)
         ->  Merge Left Join  (cost=241066.65..244857.65 rows=10 width=1503) (actual time=1129.342..1277.994 rows=10 loops=1)
               Merge Cond: (product_template.id = ir_translation_7.res_id)
               ->  Merge Left Join  (cost=237539.48..241316.13 rows=10 width=1434) (actual time=1128.120..1276.768 rows=10 loops=1)
                     Merge Cond: (product_template.id = ir_translation_6.res_id)
                     ->  Merge Left Join  (cost=234012.30..237774.62 rows=10 width=1365) (actual time=1126.934..1275.578 rows=10 loops=1)
                           Merge Cond: (product_template.id = ir_translation_5.res_id)
                           ->  Merge Left Join  (cost=230485.13..234233.11 rows=10 width=1296) (actual time=1125.721..1274.362 rows=10 loops=1)
                                 Merge Cond: (product_template.id = ir_translation_4.res_id)
                                 ->  Merge Left Join  (cost=226957.96..230691.59 rows=10 width=1227) (actual time=1124.543..1273.181 rows=10 loops=1)
                                       Merge Cond: (product_template.id = ir_translation_3.res_id)
                                       ->  Merge Left Join  (cost=223430.79..227150.08 rows=10 width=1158) (actual time=1123.336..1271.971 rows=10 loops=1)
                                             Merge Cond: (product_template.id = ir_translation_2.res_id)
                                             ->  Merge Left Join  (cost=219903.62..223608.56 rows=10 width=1089) (actual time=1122.118..1270.749 rows=10 loops=1)
                                                   Merge Cond: (product_template.id = ir_translation_1.res_id)
                                                   ->  Merge Left Join  (cost=216376.45..220067.05 rows=10 width=1020) (actual time=1120.812..1269.439 rows=10 loops=1)
                                                         Merge Cond: (product_template.id = ir_translation.res_id)
                                                         ->  Sort  (cost=69.28..69.31 rows=10 width=951) (actual time=0.057..0.059 rows=10 loops=1)
                                                               Sort Key: product_template.id
                                                               Sort Method: quicksort  Memory: 30kB
                                                               ->  Bitmap Heap Scan on product_template  (cost=34.90..69.12 rows=10 width=951) (actual time=0.026..0.040 rows=10 loops=1)
                                                                     Recheck Cond: (id = ANY ('{44501,2114,2182,2184,2157,2189,2100,2263,2171,2172}'::integer[]))
                                                                     Heap Blocks: exact=7
                                                                     ->  Bitmap Index Scan on product_template_pkey  (cost=0.00..34.90 rows=10 width=0) (actual time=0.018..0.018 rows=10 loops=1)
                                                                           Index Cond: (id = ANY ('{44501,2114,2182,2184,2157,2189,2100,2263,2171,2172}'::integer[]))
                                                         ->  Unique  (cost=216307.17..219968.03 rows=2371 width=77) (actual time=1120.746..1269.352 rows=185 loops=1)
                                                               ->  Sort  (cost=216307.17..218137.60 rows=732173 width=77) (actual time=1120.745..1228.324 rows=750579 loops=1)
                                                                     Sort Key: ir_translation.res_id, ir_translation.id DESC
                                                                     Sort Method: external merge  Disk: 90208kB
                                                                     ->  Seq Scan on ir_translation  (cost=0.00..79914.84 rows=732173 width=77) (actual time=5.924..330.741 rows=750717 loops=1)
                                                                           Filter: ((value <> ''::text) AND ((name)::text = 'product.template,description_sale'::text) AND ((lang)::text = 'es_MX'::text))
                                                                           Rows Removed by Filter: 929845
                                                   ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.304..1.304 rows=0 loops=1)
                                                         ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.303..1.304 rows=0 loops=1)
                                                               Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC
                                                               Sort Method: quicksort  Memory: 25kB
                                                               ->  Bitmap Heap Scan on ir_translation ir_translation_1  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.295..1.295 rows=0 loops=1)
                                                                     Recheck Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text))
                                                                     Filter: (value <> ''::text)
                                                                     Rows Removed by Filter: 5113
                                                                     Heap Blocks: exact=333
                                                                     ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.503..0.503 rows=5113 loops=1)
                                                                           Index Cond: (((name)::text = 'product.template,description_purchase'::text) AND ((lang)::text = 'es_MX'::text))
                                             ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.216..1.216 rows=0 loops=1)
                                                   ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.216..1.216 rows=0 loops=1)
                                                         Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
                                                         Sort Method: quicksort  Memory: 25kB
                                                         ->  Bitmap Heap Scan on ir_translation ir_translation_2  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.212..1.212 rows=0 loops=1)
                                                               Recheck Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text))
                                                               Filter: (value <> ''::text)
                                                               Rows Removed by Filter: 5093
                                                               Heap Blocks: exact=336
                                                               ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.463..0.463 rows=5093 loops=1)
                                                                     Index Cond: (((name)::text = 'product.template,website_meta_description'::text) AND ((lang)::text = 'es_MX'::text))
                                       ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.205..1.205 rows=0 loops=1)
                                             ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.204..1.205 rows=0 loops=1)
                                                   Sort Key: ir_translation_3.res_id, ir_translation_3.id DESC
                                                   Sort Method: quicksort  Memory: 25kB
                                                   ->  Bitmap Heap Scan on ir_translation ir_translation_3  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.201..1.201 rows=0 loops=1)
                                                         Recheck Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text))
                                                         Filter: (value <> ''::text)
                                                         Rows Removed by Filter: 5113
                                                         Heap Blocks: exact=338
                                                         ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.461..0.461 rows=5113 loops=1)
                                                               Index Cond: (((name)::text = 'product.template,description_picking'::text) AND ((lang)::text = 'es_MX'::text))
                                 ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.177..1.177 rows=0 loops=1)
                                       ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.176..1.176 rows=0 loops=1)
                                             Sort Key: ir_translation_4.res_id, ir_translation_4.id DESC
                                             Sort Method: quicksort  Memory: 25kB
                                             ->  Bitmap Heap Scan on ir_translation ir_translation_4  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.174..1.174 rows=0 loops=1)
                                                   Recheck Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text))
                                                   Filter: (value <> ''::text)
                                                   Rows Removed by Filter: 5093
                                                   Heap Blocks: exact=338
                                                   ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.456..0.456 rows=5093 loops=1)
                                                         Index Cond: (((name)::text = 'product.template,website_meta_title'::text) AND ((lang)::text = 'es_MX'::text))
                           ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.211..1.211 rows=0 loops=1)
                                 ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.211..1.211 rows=0 loops=1)
                                       Sort Key: ir_translation_5.res_id, ir_translation_5.id DESC
                                       Sort Method: quicksort  Memory: 25kB
                                       ->  Bitmap Heap Scan on ir_translation ir_translation_5  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.208..1.208 rows=0 loops=1)
                                             Recheck Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text))
                                             Filter: (value <> ''::text)
                                             Rows Removed by Filter: 5113
                                             Heap Blocks: exact=350
                                             ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.477..0.477 rows=5113 loops=1)
                                                   Index Cond: (((name)::text = 'product.template,description_pickingout'::text) AND ((lang)::text = 'es_MX'::text))
                     ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.185..1.185 rows=0 loops=1)
                           ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.184..1.184 rows=0 loops=1)
                                 Sort Key: ir_translation_6.res_id, ir_translation_6.id DESC
                                 Sort Method: quicksort  Memory: 25kB
                                 ->  Bitmap Heap Scan on ir_translation ir_translation_6  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.181..1.181 rows=0 loops=1)
                                       Recheck Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text))
                                       Filter: (value <> ''::text)
                                       Rows Removed by Filter: 5093
                                       Heap Blocks: exact=347
                                       ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.456..0.456 rows=5093 loops=1)
                                             Index Cond: (((name)::text = 'product.template,website_meta_keywords'::text) AND ((lang)::text = 'es_MX'::text))
               ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.219..1.219 rows=0 loops=1)
                     ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.219..1.219 rows=0 loops=1)
                           Sort Key: ir_translation_7.res_id, ir_translation_7.id DESC
                           Sort Method: quicksort  Memory: 25kB
                           ->  Bitmap Heap Scan on ir_translation ir_translation_7  (cost=38.30..3481.20 rows=932 width=77) (actual time=1.216..1.216 rows=0 loops=1)
                                 Recheck Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text))
                                 Filter: (value <> ''::text)
                                 Rows Removed by Filter: 5113
                                 Heap Blocks: exact=350
                                 ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.486..0.486 rows=5113 loops=1)
                                       Index Cond: (((name)::text = 'product.template,description_pickingin'::text) AND ((lang)::text = 'es_MX'::text))
         ->  Unique  (cost=3527.17..3531.83 rows=771 width=77) (actual time=1.583..1.661 rows=519 loops=1)
               ->  Sort  (cost=3527.17..3529.50 rows=932 width=77) (actual time=1.583..1.604 rows=519 loops=1)
                     Sort Key: ir_translation_8.res_id, ir_translation_8.id DESC
                     Sort Method: quicksort  Memory: 278kB
                     ->  Bitmap Heap Scan on ir_translation ir_translation_8  (cost=38.30..3481.20 rows=932 width=77) (actual time=0.595..1.450 rows=520 loops=1)
                           Recheck Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text))
                           Filter: (value <> ''::text)
                           Rows Removed by Filter: 5075
                           Heap Blocks: exact=413
                           ->  Bitmap Index Scan on ir_translation_langvalue_index  (cost=0.00..38.07 rows=964 width=0) (actual time=0.556..0.556 rows=5595 loops=1)
                                 Index Cond: (((name)::text = 'product.template,description'::text) AND ((lang)::text = 'es_MX'::text))
   ->  Unique  (cost=217070.50..220751.12 rows=2371 width=77) (actual time=962.031..1106.171 rows=3198 loops=1)
         ->  Sort  (cost=217070.50..218910.81 rows=736123 width=77) (actual time=962.030..1066.361 rows=757686 loops=1)
               Sort Key: ir_translation_9.res_id, ir_translation_9.id DESC
               Sort Method: external merge  Disk: 46072kB
               ->  Seq Scan on ir_translation ir_translation_9  (cost=0.00..79914.84 rows=736123 width=77) (actual time=0.012..310.707 rows=758004 loops=1)
                     Filter: ((value <> ''::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'es_MX'::text))
                     Rows Removed by Filter: 922558
 Planning time: 5.393 ms
 Execution time: 2402.932 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	9	6.101 ms	0.3 %
Bitmap Index Scan	9	3.876 ms	0.2 %
Merge Left Join	10	0.291 ms	0.0 %
Seq Scan	2	641.448 ms	26.9 %
Sort	11	1,653.438 ms	69.3 %
Unique	10	80.897 ms	3.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
ir_translation	10	647.527 ms	27.1 %
Bitmap Heap Scan	8	6.079 ms	0.9 %
Seq Scan	2	641.448 ms	99.1 %
product_template	1	0.022 ms	0.0 %
Bitmap Heap Scan	1	0.022 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A2ih : Optimization for: Optimization for: plan #5EaB; plan #tQ5z

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats