#	exclusive	inclusive	rows x	rows	loops	node
1.	0.256	1,280.086	↑ 1.0	76	1	→ Merge Left Join (cost=218,000.82..221,716.33 rows=76 width=55) (actual time=1,108.800..1,280.086 rows=76 loops=1) Merge Cond: (product_product__product_tmpl_id.id = ir_translation.res_id)
2.	0.036	0.297	↑ 1.0	76	1	→ Sort (cost=660.58..660.77 rows=76 width=86) (actual time=0.290..0.297 rows=76 loops=1) Sort Key: product_product.product_tmpl_id Sort Method: quicksort Memory: 36kB
3.	0.038	0.261	↑ 1.0	76	1	→ Nested Loop (cost=0.57..658.21 rows=76 width=86) (actual time=0.035..0.261 rows=76 loops=1)
4.	0.147	0.147	↑ 1.0	76	1	→ Index Scan using product_product_pkey on product_product (cost=0.29..307.41 rows=76 width=23) (actual time=0.030..0.147 rows=76 loops=1) Index Cond: (id = ANY ('{18842,80384,77057,77570,18948,77061,80405,103193,121755,122396,107037,77086,76828,76827,107041,80671,103338,103215,103216,106802,106803,103218,81015,81016,20158,19007,81017,81018,19911,20294,20297,129662,109003,109002,18893,20298,17487,129663,109521,109522,20299,103124,76885,128086,19031,128087,18904,103003,77147,76892,121694,128094,77406,77405,128098,128227,77412,128228,128229,128230,20300,20296,18794,20295,77566,80373,77302,77303,77304,77305,18678,129659,129660,129661,103294,76799}'::integer[]))
5.	0.076	0.076	↑ 1.0	1	76	→ Index Scan using product_template_pkey on product_template product_product__product_tmpl_id (cost=0.28..4.62 rows=1 width=63) (actual time=0.001..0.001 rows=1 loops=76) Index Cond: (id = product_product.product_tmpl_id)
6.	49.863	1,279.533	↓ 1.4	3,205	1	→ Unique (cost=217,340.24..221,025.38 rows=2,371 width=77) (actual time=1,108.062..1,279.533 rows=3,205 loops=1)
7.	887.611	1,229.670	↓ 1.0	757,820	1	→ Sort (cost=217,340.24..219,182.81 rows=737,027 width=77) (actual time=1,108.061..1,229.670 rows=757,820 loops=1) Sort Key: ir_translation.res_id, ir_translation.id DESC Sort Method: external merge Disk: 46104kB
8.	342.059	342.059	↓ 1.0	758,004	1	→ Seq Scan on ir_translation (cost=0.00..80,012.96 rows=737,027 width=77) (actual time=0.681..342.059 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: 866897

 Merge Left Join  (cost=218000.82..221716.33 rows=76 width=55) (actual time=1108.800..1280.086 rows=76 loops=1)
   Merge Cond: (product_product__product_tmpl_id.id = ir_translation.res_id)
   ->  Sort  (cost=660.58..660.77 rows=76 width=86) (actual time=0.290..0.297 rows=76 loops=1)
         Sort Key: product_product.product_tmpl_id
         Sort Method: quicksort  Memory: 36kB
         ->  Nested Loop  (cost=0.57..658.21 rows=76 width=86) (actual time=0.035..0.261 rows=76 loops=1)
               ->  Index Scan using product_product_pkey on product_product  (cost=0.29..307.41 rows=76 width=23) (actual time=0.030..0.147 rows=76 loops=1)
                     Index Cond: (id = ANY ('{18842,80384,77057,77570,18948,77061,80405,103193,121755,122396,107037,77086,76828,76827,107041,80671,103338,103215,103216,106802,106803,103218,81015,81016,20158,19007,81017,81018,19911,20294,20297,129662,109003,109002,18893,20298,17487,129663,109521,109522,20299,103124,76885,128086,19031,128087,18904,103003,77147,76892,121694,128094,77406,77405,128098,128227,77412,128228,128229,128230,20300,20296,18794,20295,77566,80373,77302,77303,77304,77305,18678,129659,129660,129661,103294,76799}'::integer[]))
               ->  Index Scan using product_template_pkey on product_template product_product__product_tmpl_id  (cost=0.28..4.62 rows=1 width=63) (actual time=0.001..0.001 rows=1 loops=76)
                     Index Cond: (id = product_product.product_tmpl_id)
   ->  Unique  (cost=217340.24..221025.38 rows=2371 width=77) (actual time=1108.062..1279.533 rows=3205 loops=1)
         ->  Sort  (cost=217340.24..219182.81 rows=737027 width=77) (actual time=1108.061..1229.670 rows=757820 loops=1)
               Sort Key: ir_translation.res_id, ir_translation.id DESC
               Sort Method: external merge  Disk: 46104kB
               ->  Seq Scan on ir_translation  (cost=0.00..80012.96 rows=737027 width=77) (actual time=0.681..342.059 rows=758004 loops=1)
                     Filter: ((value <> ''::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'es_MX'::text))
                     Rows Removed by Filter: 866897
 Planning time: 0.783 ms
 Execution time: 1286.344 ms
(19 rows)

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.223 ms	0.0 %
Merge Left Join	1	0.256 ms	0.0 %
Nested Loop	1	0.038 ms	0.0 %
Seq Scan	1	342.059 ms	26.7 %
Sort	2	887.647 ms	69.3 %
Unique	1	49.863 ms	3.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
ir_translation	1	342.059 ms	26.7 %
Seq Scan	1	342.059 ms	100.0 %
product_product	1	0.147 ms	0.0 %
Index Scan	1	0.147 ms	100.0 %
product_template	1	0.076 ms	0.0 %
Index Scan	1	0.076 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BoA9

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats