explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pAKA

Settings
# exclusive inclusive rows x rows loops node
1. 224.720 711.833 ↓ 1.2 311,345 1

Gather Merge (cost=33,236.99..63,508.73 rows=259,454 width=44) (actual time=481.370..711.833 rows=311,345 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 298.344 487.113 ↑ 1.2 103,782 3 / 3

Sort (cost=32,236.96..32,561.28 rows=129,727 width=44) (actual time=438.431..487.113 rows=103,782 loops=3)

  • Sort Key: product_product.default_code, (COALESCE(product_product__product_tmpl_id__name.value, (product_product__product_tmpl_id.name)::text)), product_product.id
  • Sort Method: external merge Disk: 3640kB
  • Worker 0: Sort Method: external merge Disk: 3784kB
  • Worker 1: Sort Method: external merge Disk: 3648kB
3. 25.824 188.769 ↑ 1.2 103,782 3 / 3

Hash Left Join (cost=11,728.31..18,880.77 rows=129,727 width=44) (actual time=106.192..188.769 rows=103,782 loops=3)

  • Hash Cond: (product_product__product_tmpl_id.id = product_product__product_tmpl_id__name.res_id)
4. 85.236 161.191 ↑ 1.2 103,782 3 / 3

Parallel Hash Left Join (cost=11,692.15..18,504.08 rows=129,727 width=29) (actual time=104.430..161.191 rows=103,782 loops=3)

  • Hash Cond: (product_product.product_tmpl_id = product_product__product_tmpl_id.id)
5. 23.677 23.677 ↑ 1.2 103,782 3 / 3

Parallel Seq Scan on product_product (cost=0.00..4,442.40 rows=129,727 width=16) (actual time=0.017..23.677 rows=103,782 loops=3)

  • Filter: active
  • Rows Removed by Filter: 10
6. 29.186 52.278 ↑ 1.2 103,792 3 / 3

Parallel Hash (cost=9,309.40..9,309.40 rows=129,740 width=17) (actual time=52.278..52.278 rows=103,792 loops=3)

  • Buckets: 131072 Batches: 8 Memory Usage: 3104kB
7. 23.092 23.092 ↑ 1.2 103,792 3 / 3

Parallel Seq Scan on product_template product_product__product_tmpl_id (cost=0.00..9,309.40 rows=129,740 width=17) (actual time=0.011..23.092 rows=103,792 loops=3)

8. 0.446 1.754 ↓ 62.1 2,112 3 / 3

Hash (cost=35.74..35.74 rows=34 width=38) (actual time=1.754..1.754 rows=2,112 loops=3)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 186kB
9. 1.308 1.308 ↓ 62.1 2,112 3 / 3

Index Scan using ir_translation_unique on ir_translation product_product__product_tmpl_id__name (cost=0.42..35.74 rows=34 width=38) (actual time=0.041..1.308 rows=2,112 loops=3)

  • Index Cond: (((type)::text = 'model'::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
Planning time : 0.657 ms
Execution time : 732.295 ms