explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Km3w

Settings
# exclusive inclusive rows x rows loops node
1. 224.481 712.900 ↓ 1.2 311,345 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 305.675 488.419 ↑ 1.2 103,782 3 / 3

Sort (cost=32,236.96..32,561.28 rows=129,727 width=44) (actual time=438.157..488.419 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: 3664kB
  • Worker 0: Sort Method: external merge Disk: 3768kB
  • Worker 1: Sort Method: external merge Disk: 3640kB
3. 26.209 182.744 ↑ 1.2 103,782 3 / 3

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

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

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

  • Hash Cond: (product_product.product_tmpl_id = product_product__product_tmpl_id.id)
5. 18.773 18.773 ↑ 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.014..18.773 rows=103,782 loops=3)

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

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

  • Buckets: 131072 Batches: 8 Memory Usage: 3104kB
7. 22.647 22.647 ↑ 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.014..22.647 rows=103,792 loops=3)

8. 0.485 2.040 ↓ 62.1 2,112 3 / 3

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

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 186kB
9. 1.555 1.555 ↓ 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.072..1.555 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.936 ms
Execution time : 733.652 ms