explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 40yZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 21.966 ↑ 1.0 2 1

Merge Left Join (cost=6,776.95..6,781.60 rows=2 width=200) (actual time=21.949..21.966 rows=2 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation_3.res_id)
2. 0.008 16.248 ↑ 1.0 2 1

Merge Left Join (cost=5,082.78..5,087.40 rows=2 width=276) (actual time=16.232..16.248 rows=2 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation_2.res_id)
3. 0.006 10.997 ↑ 1.0 2 1

Merge Left Join (cost=3,388.62..3,393.19 rows=2 width=247) (actual time=10.981..10.997 rows=2 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation_1.res_id)
4. 0.009 5.307 ↑ 1.0 2 1

Merge Left Join (cost=1,694.45..1,698.99 rows=2 width=218) (actual time=5.292..5.307 rows=2 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation.res_id)
5. 0.057 0.057 ↑ 1.0 2 1

Index Scan using product_public_category_pkey on product_public_category (cost=0.28..4.78 rows=2 width=189) (actual time=0.044..0.057 rows=2 loops=1)

  • Index Cond: (id = ANY ('{557,558}'::integer[]))
6. 0.005 5.241 ↓ 0.0 0 1

Materialize (cost=1,694.17..1,694.19 rows=1 width=33) (actual time=5.241..5.241 rows=0 loops=1)

7. 0.011 5.236 ↓ 0.0 0 1

Sort (cost=1,694.17..1,694.18 rows=1 width=37) (actual time=5.236..5.236 rows=0 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 25kB
8. 5.225 5.225 ↓ 0.0 0 1

Index Scan using ir_translation_unique on ir_translation (cost=0.42..1,694.16 rows=1 width=37) (actual time=5.225..5.225 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.public.category,name'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
9. 0.013 5.684 ↓ 0.0 0 1

Materialize (cost=1,694.17..1,694.19 rows=1 width=33) (actual time=5.684..5.684 rows=0 loops=1)

10. 0.023 5.671 ↓ 0.0 0 1

Sort (cost=1,694.17..1,694.18 rows=1 width=37) (actual time=5.671..5.671 rows=0 loops=1)

  • Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC
  • Sort Method: quicksort Memory: 25kB
11. 5.648 5.648 ↓ 0.0 0 1

Index Scan using ir_translation_unique on ir_translation ir_translation_1 (cost=0.42..1,694.16 rows=1 width=37) (actual time=5.648..5.648 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.public.category,website_meta_description'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
12. 0.014 5.243 ↓ 0.0 0 1

Materialize (cost=1,694.17..1,694.19 rows=1 width=33) (actual time=5.242..5.243 rows=0 loops=1)

13. 0.023 5.229 ↓ 0.0 0 1

Sort (cost=1,694.17..1,694.18 rows=1 width=37) (actual time=5.229..5.229 rows=0 loops=1)

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
14. 5.206 5.206 ↓ 0.0 0 1

Index Scan using ir_translation_unique on ir_translation ir_translation_2 (cost=0.42..1,694.16 rows=1 width=37) (actual time=5.206..5.206 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.public.category,website_meta_keywords'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
15. 0.025 5.709 ↓ 0.0 0 1

Materialize (cost=1,694.17..1,694.19 rows=1 width=33) (actual time=5.709..5.709 rows=0 loops=1)

16. 0.027 5.684 ↓ 0.0 0 1

Sort (cost=1,694.17..1,694.18 rows=1 width=37) (actual time=5.684..5.684 rows=0 loops=1)

  • Sort Key: ir_translation_3.res_id, ir_translation_3.id DESC
  • Sort Method: quicksort Memory: 25kB
17. 5.657 5.657 ↓ 0.0 0 1

Index Scan using ir_translation_unique on ir_translation ir_translation_3 (cost=0.42..1,694.16 rows=1 width=37) (actual time=5.657..5.657 rows=0 loops=1)

  • Index Cond: (((name)::text = 'product.public.category,website_meta_title'::text) AND ((lang)::text = 'en_US'::text))
  • Filter: (value <> ''::text)
Planning time : 5.343 ms
Execution time : 23.050 ms