explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1cMW

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,010.832 ↑ 1.0 1 1

Aggregate (cost=12,230.05..12,230.06 rows=1 width=8) (actual time=2,010.832..2,010.832 rows=1 loops=1)

2. 0.025 2,010.829 ↑ 54.0 7 1

Unique (cost=12,187.52..12,225.32 rows=378 width=1,791) (actual time=2,010.805..2,010.829 rows=7 loops=1)

3. 0.068 2,010.804 ↑ 54.0 7 1

Sort (cost=12,187.52..12,188.47 rows=378 width=1,791) (actual time=2,010.804..2,010.804 rows=7 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: 39kB
4. 32.214 2,010.736 ↑ 54.0 7 1

GroupAggregate (cost=2.01..12,171.34 rows=378 width=1,791) (actual time=461.576..2,010.736 rows=7 loops=1)

  • Group Key: "chefclub-recipes_recipe".id
5. 305.876 1,978.522 ↓ 1,332.7 503,744 1

Nested Loop Left Join (cost=2.01..12,165.67 rows=378 width=1,787) (actual time=267.622..1,978.522 rows=503,744 loops=1)

  • Filter: ((upper(("chefclub-recipes_recipe".title)::text) ~~ '%A%'::text) OR (upper(("chefclub-recipes_recipe".chefclub_video_id)::text) ~~ '%A%'::text) OR (upper(("chefclub-recipes_recipe".uuid)::text) ~~ '%A%'::text) OR (upper("chefclub-recipes_recipe".nas_video_url) ~~ '%A%'::text) OR (upper(("chefclub-recipes_recipe".video_url)::text) ~~ '%A%'::text) OR (upper(("chefclub-recipes_recipe".marketing_description)::text) ~~ '%A%'::text) OR (upper((t8.description)::text) ~~ '%A%'::text) OR (upper(t9.description) ~~ '%A%'::text))
6. 16.594 1,577.798 ↓ 1,317.3 47,424 1

Nested Loop Left Join (cost=1.72..12,113.71 rows=36 width=1,999) (actual time=267.616..1,577.798 rows=47,424 loops=1)

7. 422.167 1,549.348 ↓ 1,185.6 11,856 1

Nested Loop Left Join (cost=1.43..12,104.78 rows=10 width=1,787) (actual time=267.612..1,549.348 rows=11,856 loops=1)

  • Join Filter: ("chefclub-recipes_recipe".id = "chefclub-books_book_recipes".recipe_id)
  • Rows Removed by Join Filter: 6876480
8. 39.185 913.773 ↓ 1,185.6 11,856 1

Nested Loop Left Join (cost=1.43..12,006.53 rows=10 width=1,783) (actual time=267.472..913.773 rows=11,856 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(("chefclub-recipes_recipeingredient".description)::text) ~~ '%POMMES%'::text) OR (upper("chefclub-recipes_recipestep".description) ~~ '%POMMES%'::text))
  • Rows Removed by Filter: 4800
9. 0.658 871.116 ↓ 4.4 1,736 1

Nested Loop Left Join (cost=1.14..11,442.17 rows=391 width=1,995) (actual time=267.464..871.116 rows=1,736 loops=1)

10. 849.414 870.022 ↓ 4.0 436 1

Merge Left Join (cost=0.85..11,345.74 rows=108 width=1,783) (actual time=267.458..870.022 rows=436 loops=1)

  • Merge Cond: ("chefclub-recipes_recipe".id = t6.recipe_id)
  • Filter: ((upper(("chefclub-recipes_recipe".title)::text) ~~ '%D''AMOUR%'::text) OR (upper(("chefclub-recipes_recipe".chefclub_video_id)::text) ~~ '%D''AMOUR%'::text) OR (upper(("chefclub-recipes_recipe".uuid)::text) ~~ '%D''AMOUR%'::text) OR (upper("chefclub-recipes_recipe".nas_video_url) ~~ '%D''AMOUR%'::text) OR (upper(("chefclub-recipes_recipe".video_url)::text) ~~ '%D''AMOUR%'::text) OR (upper(("chefclub-recipes_recipe".marketing_description)::text) ~~ '%D''AMOUR%'::text) OR (upper((t6.description)::text) ~~ '%D''AMOUR%'::text) OR (upper(t7.description) ~~ '%D''AMOUR%'::text))
  • Rows Removed by Filter: 142849
11. 4.678 9.881 ↓ 1.0 13,053 1

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

  • Merge Cond: ("chefclub-recipes_recipe".id = t7.recipe_id)
12. 3.164 3.164 ↑ 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.020..3.164 rows=3,567 loops=1)

13. 2.039 2.039 ↑ 1.0 12,956 1

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

14. 6.301 10.727 ↓ 3.9 143,259 1

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

15. 4.426 4.426 ↑ 1.0 37,047 1

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

16. 0.436 0.436 ↑ 1.0 4 436

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

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
17. 3.472 3.472 ↑ 1.0 10 1,736

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

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
18. 213.351 213.408 ↑ 1.0 580 11,856

Materialize (cost=0.00..12.70 rows=580 width=8) (actual time=0.000..0.018 rows=580 loops=11,856)

19. 0.057 0.057 ↑ 1.0 580 1

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

20. 11.856 11.856 ↑ 1.0 4 11,856

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=11,856)

  • Index Cond: ("chefclub-recipes_recipe".id = recipe_id)
21. 94.848 94.848 ↓ 1.1 11 47,424

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=47,424)

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