explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Cf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.036 5988.377 ↑ 1.0 10 1

Limit (cost=37.44..1349.68 rows=10 width=223) (actual time=4545.760..5988.377 rows=10 loops=1)

2. 0.102 5988.341 ↑ 306.4 10 1

Nested Loop (cost=37.44..402107.67 rows=3064 width=223) (actual time=4545.756..5988.341 rows=10 loops=1)

3. 18.069 5988.079 ↑ 306.4 10 1

Nested Loop Left Join (cost=37.44..393367.55 rows=3064 width=197) (actual time=4545.734..5988.079 rows=10 loops=1)

  • Filter: ((core_rating.last_displayed IS NULL) AND (((core_rating.type = 1) AND (core_rating.rating IS NULL)) OR (core_rating.user_id IS NULL)))
4. 12.707 36.433 ↑ 6.4 1293 1

Nested Loop Left Join (cost=0.00..48519.23 rows=8317 width=114) (actual time=0.040..36.433 rows=1293 loops=1)

  • Filter: (filmbasket_basketitem.wishlist IS NULL)
5. 6.236 6.236 ↑ 10.5 1590 1

Index Scan Backward using core_film_popularity on core_film (cost=0.00..14188.60 rows=16634 width=78) (actual time=0.019..6.236 rows=1590 loops=1)

6. 17.490 17.490 ↓ 0.0 0 1590

Index Scan using filmbasket_basketitem_ids on filmbasket_basketitem (cost=0.00..2.05 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=1590)

  • Index Cond: ((core_film.parent_id = filmbasket_basketitem.film_id) AND (filmbasket_basketitem.user_id = 3))
7. 82.752 5933.577 ↓ 2.0 2 1293

Bitmap Heap Scan on core_rating (cost=37.44..41.45 rows=1 width=83) (actual time=4.568..4.589 rows=2 loops=1293)

  • Recheck Cond: ((core_film.parent_id = core_rating.parent_id) AND (core_rating.user_id = 3))
8. 259.893 5850.825 ↓ 0.0 0 1293

BitmapAnd (cost=37.44..37.44 rows=1 width=0) (actual time=4.525..4.525 rows=0 loops=1293)

9. 408.588 408.588 ↓ 1.1 822 1293

Bitmap Index Scan on core_rating_parent_id (cost=0.00..8.98 rows=715 width=0) (actual time=0.316..0.316 rows=822 loops=1293)

  • Index Cond: (core_film.parent_id = core_rating.parent_id)
10. 5182.344 5182.344 ↓ 6.7 16209 1293

Bitmap Index Scan on core_rating_user_id (cost=0.00..27.60 rows=2431 width=0) (actual time=4.008..4.008 rows=16209 loops=1293)

  • Index Cond: (core_rating.user_id = 3)
11. 0.160 0.160 ↑ 1.0 1 10

Index Scan using core_object_pkey on core_object (cost=0.00..2.84 rows=1 width=26) (actual time=0.014..0.016 rows=1 loops=10)

  • Index Cond: (core_object.id = core_film.parent_id)