explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8syd : Optimization for: plan #VwTL

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 34.448 ↑ 1.6 5 1

Merge Right Join (cost=26,127.94..26,166.11 rows=8 width=1,183) (actual time=34.422..34.448 rows=5 loops=1)

  • Merge Cond: (ir_translation.res_id = product_public_category.id)
2. 0.000 13.949 ↓ 2.2 3,386 1

Gather Merge (cost=8,705.71..8,888.19 rows=1,564 width=25) (actual time=11.513..13.949 rows=3,386 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.314 28.149 ↓ 1.6 1,224 3

Sort (cost=7,705.69..7,707.64 rows=782 width=25) (actual time=9.312..9.383 rows=1,224 loops=3)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 213kB
4. 26.835 26.835 ↓ 1.7 1,306 3

Parallel Seq Scan on ir_translation (cost=0.00..7,668.11 rows=782 width=25) (actual time=5.665..8.945 rows=1,306 loops=3)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.public.category,name'::text) AND ((lang)::text = 'fi_FI'::text))
  • Rows Removed by Filter: 45779
5. 0.010 21.819 ↑ 1.0 5 1

Materialize (cost=17,337.36..17,367.16 rows=5 width=1,300) (actual time=21.797..21.819 rows=5 loops=1)

6. 0.009 21.809 ↑ 1.0 5 1

Merge Left Join (cost=17,337.36..17,367.15 rows=5 width=1,300) (actual time=21.790..21.809 rows=5 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation_2.res_id)
7. 0.009 11.657 ↑ 1.0 5 1

Merge Left Join (cost=8,668.82..8,698.57 rows=5 width=1,283) (actual time=11.639..11.657 rows=5 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation_1.res_id)
8. 0.027 0.027 ↑ 1.0 5 1

Index Scan using product_public_category_pkey on product_public_category (cost=0.28..30.00 rows=5 width=1,266) (actual time=0.012..0.027 rows=5 loops=1)

  • Index Cond: (id = ANY ('{6539,6535,6536,6537,6538}'::integer[]))
9. 0.000 11.621 ↓ 6.5 39 1

Materialize (cost=8,668.15..8,668.93 rows=6 width=21) (actual time=11.592..11.621 rows=39 loops=1)

10. 0.000 11.651 ↓ 6.5 39 1

Gather Merge (cost=8,668.15..8,668.85 rows=6 width=25) (actual time=11.589..11.651 rows=39 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
11. 0.129 28.491 ↓ 4.3 13 3

Sort (cost=7,668.13..7,668.14 rows=3 width=25) (actual time=9.496..9.497 rows=13 loops=3)

  • Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC
  • Sort Method: quicksort Memory: 25kB
12. 28.362 28.362 ↓ 4.3 13 3

Parallel Seq Scan on ir_translation ir_translation_1 (cost=0.00..7,668.11 rows=3 width=25) (actual time=3.795..9.454 rows=13 loops=3)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.public.category,website_meta_description'::text) AND ((lang)::text = 'fi_FI'::text))
  • Rows Removed by Filter: 47072
13. 0.000 10.143 ↑ 1.5 4 1

Materialize (cost=8,668.15..8,668.93 rows=6 width=21) (actual time=10.139..10.143 rows=4 loops=1)

14. 0.000 10.161 ↑ 1.5 4 1

Gather Merge (cost=8,668.15..8,668.85 rows=6 width=25) (actual time=10.135..10.161 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
15. 0.099 22.782 ↑ 3.0 1 3

Sort (cost=7,668.13..7,668.14 rows=3 width=25) (actual time=7.594..7.594 rows=1 loops=3)

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
16. 22.683 22.683 ↑ 3.0 1 3

Parallel Seq Scan on ir_translation ir_translation_2 (cost=0.00..7,668.11 rows=3 width=25) (actual time=6.839..7.561 rows=1 loops=3)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.public.category,website_meta_keywords'::text) AND ((lang)::text = 'fi_FI'::text))
  • Rows Removed by Filter: 47084
Planning time : 0.378 ms
Execution time : 36.097 ms