explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yBUA

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 20,318.615 ↑ 1.0 1 1

Aggregate (cost=16,275.38..16,275.39 rows=1 width=8) (actual time=20,318.615..20,318.615 rows=1 loops=1)

2. 0.025 20,318.613 ↑ 594.5 6 1

Unique (cost=15,874.09..16,230.79 rows=3,567 width=1,791) (actual time=20,318.589..20,318.613 rows=6 loops=1)

3. 0.075 20,318.588 ↑ 594.5 6 1

Sort (cost=15,874.09..15,883.01 rows=3,567 width=1,791) (actual time=20,318.588..20,318.588 rows=6 loops=1)

  • Sort Key: "chefclub-recipes_recipe".id, "chefclub-recipes_recipe".created, "chefclub-recipes_recipe".modified, "chefclub-recipes_recipe".uuid, "chefclub-recipes_recipe".chefclub_video_id, "chefclub-recipes_recipe".title, "chefclub-recipes_recipe".subtitle, "chefclub-recipes_recipe".description, "chefclub-recipes_recipe".published_date, "chefclub-recipes_recipe".language, "chefclub-recipes_recipe".vertical, "chefclub-recipes_recipe".video_id, "chefclub-recipes_recipe".pinterest_picture, "chefclub-recipes_recipe".pinterest_picture_thumbnail, "chefclub-recipes_recipe".result_picture, "chefclub-recipes_recipe".result_picture_thumbnail, "chefclub-recipes_recipe".marketing_description, "chefclub-recipes_recipe".web_cover, "chefclub-recipes_recipe".web_cover_hd, "chefclub-recipes_recipe".web_cover_thumbnail, "chefclub-recipes_recipe".video_preview, "chefclub-recipes_recipe".video_preview_thumbnail, "chefclub-recipes_recipe".video_preview_mini_b64, "chefclub-recipes_recipe".dominant_color, "chefclub-recipes_recipe".video_url, "chefclub-recipes_recipe".nas_video_url, "chefclub-recipes_recipe".primary_tags, "chefclub-recipes_recipe".access_mode, "chefclub-recipes_recipe".is_draft, "chefclub-recipes_recipe".is_vegan, "chefclub-recipes_recipe".is_vegetarian, "chefclub-recipes_recipe".duration_minutes, "chefclub-recipes_recipe".number_of_people, "chefclub-recipes_recipe".sticker, "chefclub-recipes_recipe".sticker_position, "chefclub-recipes_recipe".mobile_share_url, "chefclub-recipes_recipe".mobile_share_rev, "chefclub-recipes_recipe".mobile_share_info, (count("chefclub-books_book_recipes".book_id))
  • Sort Method: quicksort Memory: 37kB
4. 1,286.734 20,318.513 ↑ 594.5 6 1

GroupAggregate (cost=2.58..12,895.13 rows=3,567 width=1,791) (actual time=3,941.059..20,318.513 rows=6 loops=1)

  • Group Key: "chefclub-recipes_recipe".id
5. 12,751.561 19,031.779 ↓ 4,349.3 17,884,160 1

Nested Loop Left Join (cost=2.58..12,838.90 rows=4,112 width=1,787) (actual time=261.874..19,031.779 rows=17,884,160 loops=1)

  • Filter: ((upper(("chefclub-recipes_recipe".title)::text) ~~ '%D%'::text) OR (upper(("chefclub-recipes_recipe".chefclub_video_id)::text) ~~ '%D%'::text) OR (upper(("chefclub-recipes_recipe".uuid)::text) ~~ '%D%'::text) OR (upper("chefclub-recipes_recipe".nas_video_url) ~~ '%D%'::text) OR (upper(("chefclub-recipes_recipe".video_url)::text) ~~ '%D%'::text) OR (upper(("chefclub-recipes_recipe".marketing_description)::text) ~~ '%D%'::text) OR (upper((t10.description)::text) ~~ '%D%'::text) OR (upper(t11.description) ~~ '%D%'::text))
6. 576.627 2,931.738 ↓ 4,227.9 1,674,240 1

Nested Loop Left Join (cost=2.29..12,267.33 rows=396 width=1,999) (actual time=261.866..2,931.738 rows=1,674,240 loops=1)

7. 430.434 1,936.551 ↓ 3,840.0 418,560 1

Nested Loop Left Join (cost=2.01..12,170.00 rows=109 width=1,787) (actual time=261.862..1,936.551 rows=418,560 loops=1)

  • Filter: ((upper(("chefclub-recipes_recipe".title)::text) ~~ '%AUX%'::text) OR (upper(("chefclub-recipes_recipe".chefclub_video_id)::text) ~~ '%AUX%'::text) OR (upper(("chefclub-recipes_recipe".uuid)::text) ~~ '%AUX%'::text) OR (upper("chefclub-recipes_recipe".nas_video_url) ~~ '%AUX%'::text) OR (upper(("chefclub-recipes_recipe".video_url)::text) ~~ '%AUX%'::text) OR (upper(("chefclub-recipes_recipe".marketing_description)::text) ~~ '%AUX%'::text) OR (upper((t6.description)::text) ~~ '%AUX%'::text) OR (upper(t7.description) ~~ '%AUX%'::text))
8. 14.574 1,426.757 ↓ 1,044.2 39,680 1

Nested Loop Left Join (cost=1.72..12,115.15 rows=38 width=1,999) (actual time=261.855..1,426.757 rows=39,680 loops=1)

9. 356.750 1,402.263 ↓ 992.0 9,920 1

Nested Loop Left Join (cost=1.43..12,106.22 rows=10 width=1,787) (actual time=261.851..1,402.263 rows=9,920 loops=1)

  • Join Filter: ("chefclub-recipes_recipe".id = "chefclub-books_book_recipes".recipe_id)
  • Rows Removed by Join Filter: 5753600
10. 16.732 886.793 ↓ 992.0 9,920 1

Nested Loop Left Join (cost=1.43..12,007.97 rows=10 width=1,783) (actual time=261.712..886.793 rows=9,920 loops=1)

  • Filter: ((upper(("chefclub-recipes_recipe".title)::text) ~~ '%POMMES%'::text) OR (upper(("chefclub-recipes_recipe".chefclub_video_id)::text) ~~ '%POMMES%'::text) OR (upper(("chefclub-recipes_recipe".uuid)::text) ~~ '%POMMES%'::text) OR (upper("chefclub-recipes_recipe".nas_video_url) ~~ '%POMMES%'::text) OR (upper(("chefclub-recipes_recipe".video_url)::text) ~~ '%POMMES%'::text) OR (upper(("chefclub-recipes_recipe".marketing_description)::text) ~~ '%POMMES%'::text) OR (upper((t8.description)::text) ~~ '%POMMES%'::text) OR (upper(t9.description) ~~ '%POMMES%'::text))
  • Rows Removed by Filter: 1521
11. 0.524 867.907 ↓ 2.7 1,077 1

Nested Loop Left Join (cost=1.14..11,442.17 rows=392 width=1,995) (actual time=261.706..867.907 rows=1,077 loops=1)

12. 845.691 867.104 ↓ 2.6 279 1

Merge Left Join (cost=0.85..11,345.74 rows=108 width=1,783) (actual time=261.701..867.104 rows=279 loops=1)

  • Merge Cond: ("chefclub-recipes_recipe".id = "chefclub-recipes_recipeingredient".recipe_id)
  • Filter: ((upper(("chefclub-recipes_recipe".title)::text) ~~ '%011719\_TARTE%'::text) OR (upper(("chefclub-recipes_recipe".chefclub_video_id)::text) ~~ '%011719\_TARTE%'::text) OR (upper(("chefclub-recipes_recipe".uuid)::text) ~~ '%011719\_TARTE%'::text) OR (upper("chefclub-recipes_recipe".nas_video_url) ~~ '%011719\_TARTE%'::text) OR (upper(("chefclub-recipes_recipe".video_url)::text) ~~ '%011719\_TARTE%'::text) OR (upper(("chefclub-recipes_recipe".marketing_description)::text) ~~ '%011719\_TARTE%'::text) OR (upper(("chefclub-recipes_recipeingredient".description)::text) ~~ '%011719\_TARTE%'::text) OR (upper("chefclub-recipes_recipestep".description) ~~ '%011719\_TARTE%'::text))
  • Rows Removed by Filter: 143006
13. 4.667 10.378 ↓ 1.0 13,053 1

Merge Left Join (cost=0.57..1,963.53 rows=12,956 width=1,995) (actual time=0.009..10.378 rows=13,053 loops=1)

  • Merge Cond: ("chefclub-recipes_recipe".id = "chefclub-recipes_recipestep".recipe_id)
14. 3.619 3.619 ↑ 1.0 3,567 1

Index Scan using "chefclub-recipes_recipe_pkey" on "chefclub-recipes_recipe" (cost=0.28..1,023.23 rows=3,567 width=1,783) (actual time=0.004..3.619 rows=3,567 loops=1)

15. 2.092 2.092 ↑ 1.0 12,956 1

Index Scan using "chefclub-recipes_recipestep_recipe_id_94aa188d" on "chefclub-recipes_recipestep" (cost=0.29..769.43 rows=12,956 width=216) (actual time=0.004..2.092 rows=12,956 loops=1)

16. 6.476 11.035 ↓ 3.9 143,259 1

Materialize (cost=0.29..1,368.72 rows=37,047 width=20) (actual time=0.005..11.035 rows=143,259 loops=1)

17. 4.559 4.559 ↑ 1.0 37,047 1

Index Scan using "chefclub-recipes_recipeingredient_recipe_id_6649de48" on "chefclub-recipes_recipeingredient" (cost=0.29..1,276.10 rows=37,047 width=20) (actual time=0.003..4.559 rows=37,047 loops=1)

18. 0.279 0.279 ↑ 1.0 4 279

Index Scan using "chefclub-recipes_recipestep_recipe_id_94aa188d" on "chefclub-recipes_recipestep" t9 (cost=0.29..0.85 rows=4 width=216) (actual time=0.001..0.001 rows=4 loops=279)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
19. 2.154 2.154 ↓ 1.1 11 1,077

Index Scan using "chefclub-recipes_recipeingredient_recipe_id_6649de48" on "chefclub-recipes_recipeingredient" t8 (cost=0.29..0.89 rows=10 width=20) (actual time=0.001..0.002 rows=11 loops=1,077)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
20. 158.664 158.720 ↑ 1.0 580 9,920

Materialize (cost=0.00..12.70 rows=580 width=8) (actual time=0.000..0.016 rows=580 loops=9,920)

21. 0.056 0.056 ↑ 1.0 580 1

Seq Scan on "chefclub-books_book_recipes" (cost=0.00..9.80 rows=580 width=8) (actual time=0.006..0.056 rows=580 loops=1)

22. 9.920 9.920 ↑ 1.0 4 9,920

Index Scan using "chefclub-recipes_recipestep_recipe_id_94aa188d" on "chefclub-recipes_recipestep" t7 (cost=0.29..0.85 rows=4 width=216) (actual time=0.001..0.001 rows=4 loops=9,920)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
23. 79.360 79.360 ↓ 1.1 11 39,680

Index Scan using "chefclub-recipes_recipeingredient_recipe_id_6649de48" on "chefclub-recipes_recipeingredient" t6 (cost=0.29..0.89 rows=10 width=20) (actual time=0.001..0.002 rows=11 loops=39,680)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
24. 418.560 418.560 ↑ 1.0 4 418,560

Index Scan using "chefclub-recipes_recipestep_recipe_id_94aa188d" on "chefclub-recipes_recipestep" t11 (cost=0.29..0.85 rows=4 width=216) (actual time=0.001..0.001 rows=4 loops=418,560)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
25. 3,348.480 3,348.480 ↓ 1.1 11 1,674,240

Index Scan using "chefclub-recipes_recipeingredient_recipe_id_6649de48" on "chefclub-recipes_recipeingredient" t10 (cost=0.29..0.89 rows=10 width=20) (actual time=0.001..0.002 rows=11 loops=1,674,240)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)