explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iYql

Settings
# exclusive inclusive rows x rows loops node
1. 8,202.923 8,888.679 ↓ 1.0 408,851 1

Sort (cost=65,306.07..66,328.02 rows=408,779 width=36) (actual time=8,836.072..8,888.679 rows=408,851 loops=1)

  • Sort Key: (COALESCE(ir_translation.value, (product_template.name)::text))
  • Sort Method: quicksort Memory: 42923kB
2. 135.744 685.756 ↓ 1.0 408,851 1

Hash Left Join (cost=2.51..27,205.90 rows=408,779 width=36) (actual time=0.149..685.756 rows=408,851 loops=1)

  • Hash Cond: (product_template.id = ir_translation.res_id)
3. 549.932 549.932 ↓ 1.0 408,851 1

Seq Scan on product_template (cost=0.00..26,130.34 rows=408,779 width=16) (actual time=0.031..549.932 rows=408,851 loops=1)

  • Filter: (active AND sale_ok AND ((event_ok IS NULL) OR (NOT event_ok)) AND ((website_id = 3) OR (website_id IS NULL)) AND ((company_id = 1) OR (company_id IS NULL)))
  • Rows Removed by Filter: 70505
4. 0.022 0.080 ↓ 0.0 0 1

Hash (cost=2.49..2.49 rows=1 width=30) (actual time=0.079..0.080 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.058 0.058 ↓ 0.0 0 1

Index Scan using ir_translation_unique on ir_translation (cost=0.27..2.49 rows=1 width=30) (actual time=0.058..0.058 rows=0 loops=1)

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