explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7MR7

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

Merge Right Join (cost=34,801.04..34,839.71 rows=8 width=1,183) (actual time=87.191..87.219 rows=5 loops=1)

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

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.329 30.816 ↓ 1.6 1,238 3

Sort (cost=7,705.69..7,707.64 rows=782 width=25) (actual time=10.201..10.272 rows=1,238 loops=3)

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

Parallel Seq Scan on ir_translation (cost=0.00..7,668.11 rows=782 width=25) (actual time=6.341..9.829 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.005 64.579 ↑ 1.0 5 1

Materialize (cost=26,010.46..26,040.75 rows=5 width=1,317) (actual time=64.558..64.579 rows=5 loops=1)

6. 0.020 64.574 ↑ 1.0 5 1

Merge Left Join (cost=26,010.46..26,040.74 rows=5 width=1,317) (actual time=64.554..64.574 rows=5 loops=1)

  • Merge Cond: (product_public_category.id = ir_translation_3.res_id)
7. 0.010 36.361 ↑ 1.0 5 1

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

  • Merge Cond: (product_public_category.id = ir_translation_2.res_id)
8. 0.010 17.830 ↑ 1.0 5 1

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

  • Merge Cond: (product_public_category.id = ir_translation_1.res_id)
9. 0.026 0.026 ↑ 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.026 rows=5 loops=1)

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

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

11. 0.000 17.831 ↓ 6.5 39 1

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

  • Workers Planned: 2
  • Workers Launched: 2
12. 0.129 27.012 ↓ 4.3 13 3

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

  • Sort Key: ir_translation_1.res_id, ir_translation_1.id DESC
  • Sort Method: quicksort Memory: 27kB
13. 26.883 26.883 ↓ 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=2.935..8.961 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
14. 0.000 18.521 ↑ 1.5 4 1

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

15. 0.000 18.542 ↑ 1.5 4 1

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

  • Workers Planned: 2
  • Workers Launched: 1
16. 0.054 30.106 ↑ 1.5 2 2

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

  • Sort Key: ir_translation_2.res_id, ir_translation_2.id DESC
  • Sort Method: quicksort Memory: 25kB
17. 30.052 30.052 ↑ 1.5 2 2

Parallel Seq Scan on ir_translation ir_translation_2 (cost=0.00..7,668.11 rows=3 width=25) (actual time=13.195..15.026 rows=2 loops=2)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.public.category,website_meta_keywords'::text) AND ((lang)::text = 'fi_FI'::text))
  • Rows Removed by Filter: 70626
18. 0.000 28.193 ↑ 1.0 73 1

Materialize (cost=8,669.09..8,678.65 rows=74 width=21) (actual time=28.152..28.193 rows=73 loops=1)

19. 0.000 30.184 ↑ 1.0 73 1

Gather Merge (cost=8,669.09..8,677.73 rows=74 width=25) (actual time=28.145..30.184 rows=73 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
20. 0.201 42.288 ↓ 1.4 50 3

Sort (cost=7,669.07..7,669.16 rows=37 width=25) (actual time=14.093..14.096 rows=50 loops=3)

  • Sort Key: ir_translation_3.res_id, ir_translation_3.id DESC
  • Sort Method: quicksort Memory: 25kB
21. 42.087 42.087 ↓ 1.4 50 3

Parallel Seq Scan on ir_translation ir_translation_3 (cost=0.00..7,668.11 rows=37 width=25) (actual time=9.904..14.029 rows=50 loops=3)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.public.category,website_meta_title'::text) AND ((lang)::text = 'fi_FI'::text))
  • Rows Removed by Filter: 47035
Planning time : 0.808 ms
Execution time : 91.672 ms