explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ipfg

Settings
# exclusive inclusive rows x rows loops node
1. 64.462 105.441 ↑ 1.0 9,444 1

Sort (cost=6,068.35..6,091.96 rows=9,444 width=41) (actual time=104.846..105.441 rows=9,444 loops=1)

  • Sort Key: (COALESCE(product_template.website_published, false)) DESC, product_template.website_sequence DESC, (COALESCE(product_template__name.value, (product_template.name)::text))
  • Sort Method: quicksort Memory: 1396kB
2. 7.132 40.979 ↑ 1.0 9,444 1

Hash Left Join (cost=4,387.53..5,444.80 rows=9,444 width=41) (actual time=27.909..40.979 rows=9,444 loops=1)

  • Hash Cond: (product_template.id = product_template__name.res_id)
3. 6.027 6.027 ↑ 1.0 9,444 1

Seq Scan on product_template (cost=0.00..1,032.47 rows=9,444 width=44) (actual time=0.030..6.027 rows=9,444 loops=1)

  • Filter: active
  • Rows Removed by Filter: 403
4. 3.234 27.820 ↓ 1.8 9,235 1

Hash (cost=4,323.79..4,323.79 rows=5,099 width=58) (actual time=27.819..27.820 rows=9,235 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 803kB
5. 2.411 24.586 ↓ 1.8 9,235 1

Subquery Scan on product_template__name (cost=4,237.50..4,323.79 rows=5,099 width=58) (actual time=18.400..24.586 rows=9,235 loops=1)

6. 2.621 22.175 ↓ 1.8 9,235 1

Unique (cost=4,237.50..4,272.80 rows=5,099 width=62) (actual time=18.397..22.175 rows=9,235 loops=1)

7. 7.621 19.554 ↓ 1.3 9,235 1

Sort (cost=4,237.50..4,255.15 rows=7,060 width=62) (actual time=18.390..19.554 rows=9,235 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 1330kB
8. 9.017 11.933 ↓ 1.3 9,235 1

Bitmap Heap Scan on ir_translation (cost=302.54..3,786.17 rows=7,060 width=62) (actual time=3.295..11.933 rows=9,235 loops=1)

  • Recheck Cond: (((name)::text = 'product.template,name'::text) AND ((lang)::text = 'lv_LV'::text))
  • Filter: (value <> ''::text)
  • Heap Blocks: exact=1342
9. 2.916 2.916 ↓ 1.3 9,235 1

Bitmap Index Scan on ir_translation_ltn (cost=0.00..300.78 rows=7,236 width=0) (actual time=2.916..2.916 rows=9,235 loops=1)

  • Index Cond: (((name)::text = 'product.template,name'::text) AND ((lang)::text = 'lv_LV'::text))
Planning time : 1.815 ms
Execution time : 106.658 ms