#	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)

explain analyze SELECT * FROM "core_film" INNER JOIN "core_object" ON ("core_film"."parent_id" = "core_object"."id") LEFT OUTER JOIN "filmbasket_basketitem" ON ("core_film"."parent_id" = "filmbasket_basketitem"."film_id" and "filmbasket_basketitem"."user_id" = 3) LEFT OUTER JOIN "core_rating" ON ("core_film"."parent_id" = "core_rating"."parent_id" and "core_rating"."user_id" = 3) WHERE ("filmbasket_basketitem"."wishlist" IS NULL) AND ( ("core_rating"."type"=1 AND "core_rating"."rating" IS NULL) OR "core_rating"."user_id" IS NULL) AND "core_rating"."last_displayed" IS NULL ORDER BY "core_film"."popularity" DESC LIMIT 10 
                                                                                 QUERY PLAN                                                                                  
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=37.44..1349.68 rows=10 width=223) (actual time=4545.760..5988.377 rows=10 loops=1)
   ->  Nested Loop  (cost=37.44..402107.67 rows=3064 width=223) (actual time=4545.756..5988.341 rows=10 loops=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)))
               ->  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)
                     ->  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)
                     ->  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))
               ->  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))
                     ->  BitmapAnd  (cost=37.44..37.44 rows=1 width=0) (actual time=4.525..4.525 rows=0 loops=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)
                           ->  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)
         ->  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)
 Total runtime: 5988.580 ms
(19 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	82.752 ms	1.4 %
Bitmap Index Scan	2	5590.932 ms	93.4 %
BitmapAnd	1	259.893 ms	4.3 %
Index Scan	2	17.650 ms	0.3 %
Index Scan Backward	1	6.236 ms	0.1 %
Limit	1	0.036 ms	0.0 %
Nested Loop	1	0.102 ms	0.0 %
Nested Loop Left Join	2	30.776 ms	0.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
core_film	1	6.236 ms	0.1 %
Index Scan Backward	1	6.236 ms	100.0 %
core_object	1	0.160 ms	0.0 %
Index Scan	1	0.160 ms	100.0 %
core_rating	1	82.752 ms	1.4 %
Bitmap Heap Scan	1	82.752 ms	100.0 %
filmbasket_basketitem	1	17.490 ms	0.3 %
Index Scan	1	17.490 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Cf

Colorize:

Columns visibility:

Per node type stats

Per table stats