#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	6,793.156	↓ 10.0	10	1	→ Limit (cost=76,219.85..76,219.87 rows=1 width=17) (actual time=6,793.094..6,793.156 rows=10 loops=1)
2.	0.072	6,793.154	↓ 10.0	10	1	→ GroupAggregate (cost=76,219.85..76,219.87 rows=1 width=17) (actual time=6,793.093..6,793.154 rows=10 loops=1)
3.	1.326	6,793.082	↓ 362.0	362	1	→ Sort (cost=76,219.85..76,219.85 rows=1 width=17) (actual time=6,793.071..6,793.082 rows=362 loops=1) Sort Key: ((dashboard_app_namedattribute.value)::integer) Sort Method: quicksort Memory: 127kB
4.	11.090	6,791.756	↓ 1,677.0	1,677	1	→ Nested Loop (cost=47,995.55..76,219.84 rows=1 width=17) (actual time=425.800..6,791.756 rows=1,677 loops=1) -> Index Scan using dashboard_app_namedattribute_object_id_5df74633aa0eda4b_uniq on dashboard_app_namedattribute (cost=0.00..8.56 rows=1 width=17) (actual time=0.005..0.006 rows=1 lo
5.	2.019	6,780.666	↓ 1,677.0	1,677	1	→ Nested Loop (cost=47,995.55..76,211.26 rows=1 width=20) (actual time=425.756..6,780.666 rows=1,677 loops=1) Index Cond: ((object_id = dashboard_app_testrun.id) AND (name = 'android.build'::text)) Filter: (content_type_id = 23)
6.	2,918.443	6,773.616	↓ 1,677.0	1,677	1	→ Nested Loop Semi Join (cost=47,995.55..76,205.83 rows=1 width=24) (actual time=425.741..6,773.616 rows=1,677 loops=1) Join Filter: (dashboard_app_testrun.id = u0.id)
7.	1.628	204.344	↓ 1,677.0	1,677	1	→ Nested Loop (cost=36,429.77..36,438.07 rows=1 width=16) (actual time=198.694..204.344 rows=1,677 loops=1)
8.	1.393	199.362	↓ 1,677.0	1,677	1	→ HashAggregate (cost=36,429.77..36,429.78 rows=1 width=8) (actual time=198.690..199.362 rows=1,677 loops=1)
9.	0.085	197.969	↓ 1,677.0	1,677	1	→ Nested Loop (cost=11,565.64..36,429.77 rows=1 width=8) (actual time=154.222..197.969 rows=1,677 loops=1)
10.	194.530	194.530	↓ 1,677.0	1,677	1	→ Bitmap Heap Scan on dashboard_app_namedattribute u1 (cost=11,565.64..36,421.48 rows=1 width=4) (actual time=154.188..194.530 rows=1,677 loops=1) Recheck Cond: (content_type_id = 23) Filter: ((name = 'android.name'::text) AND (value = 'linaro-android_panda-ics-gcc47-tilt-stable-blob'::text)) -> Bitmap Index Scan on dashboard_app_namedattribute_content_type_id (cost=0.00..11565.64 rows=625762 width=0) (actual time=37.876..37.876 rows=62 Index Cond: (content_type_id = 23)
11.	3.354	3.354	↑ 1.0	1	1,677	→ Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun u0 (cost=0.00..8.28 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1,677) Index Cond: (id = u1.object_id)
12.	3.354	3.354	↑ 1.0	1	1,677	→ Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun (cost=0.00..8.28 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,677) Index Cond: (id = u0.id)
13.	3,404.086	3,650.829	↓ 88.1	24,831	1,677	→ Materialize (cost=11,565.77..39,763.53 rows=282 width=8) (actual time=0.023..2.177 rows=24,831 loops=1,677)
14.	21.544	246.743	↓ 101.1	28,501	1	→ Nested Loop (cost=11,565.77..39,762.12 rows=282 width=8) (actual time=35.393..246.743 rows=28,501 loops=1)
15.	196.698	196.698	↓ 54.1	28,501	1	→ Bitmap Heap Scan on dashboard_app_namedattribute u1 (cost=11,565.77..36,421.61 rows=527 width=4) (actual time=35.372..196.698 rows=28,501 loops=1) Recheck Cond: (content_type_id = 23) Filter: ((name = 'target.device_type'::text) AND (value = 'panda'::text)) -> Bitmap Index Scan on dashboard_app_namedattribute_content_type_id (cost=0.00..11565.64 rows=625762 width=0) (actual time=34.282..34.282 rows=624967 l Index Cond: (content_type_id = 23)
16.	28.501	28.501	↑ 1.0	1	28,501	→ Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun u0 (cost=0.00..6.33 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=28,501) Index Cond: (id = u1.object_id)
17.	5.031	5.031	↑ 1.0	1	1,677	→ Index Scan using dashboard_app_bundle_pkey on dashboard_app_bundle (cost=0.00..5.42 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,677) Index Cond: (id = dashboard_app_testrun.bundle_id) Filter: (bundle_stream_id = 6417)

                                                                                                        QUERY PLAN                                                                                           
              
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------
 Limit  (cost=76219.85..76219.87 rows=1 width=17) (actual time=6793.094..6793.156 rows=10 loops=1)
   ->  GroupAggregate  (cost=76219.85..76219.87 rows=1 width=17) (actual time=6793.093..6793.154 rows=10 loops=1)
         ->  Sort  (cost=76219.85..76219.85 rows=1 width=17) (actual time=6793.071..6793.082 rows=362 loops=1)
               Sort Key: ((dashboard_app_namedattribute.value)::integer)
               Sort Method: quicksort  Memory: 127kB
               ->  Nested Loop  (cost=47995.55..76219.84 rows=1 width=17) (actual time=425.800..6791.756 rows=1677 loops=1)
                     ->  Nested Loop  (cost=47995.55..76211.26 rows=1 width=20) (actual time=425.756..6780.666 rows=1677 loops=1)
                           ->  Nested Loop Semi Join  (cost=47995.55..76205.83 rows=1 width=24) (actual time=425.741..6773.616 rows=1677 loops=1)
                                 Join Filter: (dashboard_app_testrun.id = u0.id)
                                 ->  Nested Loop  (cost=36429.77..36438.07 rows=1 width=16) (actual time=198.694..204.344 rows=1677 loops=1)
                                       ->  HashAggregate  (cost=36429.77..36429.78 rows=1 width=8) (actual time=198.690..199.362 rows=1677 loops=1)
                                             ->  Nested Loop  (cost=11565.64..36429.77 rows=1 width=8) (actual time=154.222..197.969 rows=1677 loops=1)
                                                   ->  Bitmap Heap Scan on dashboard_app_namedattribute u1  (cost=11565.64..36421.48 rows=1 width=4) (actual time=154.188..194.530 rows=1677 loops=1)
                                                         Recheck Cond: (content_type_id = 23)
                                                         Filter: ((name = 'android.name'::text) AND (value = 'linaro-android_panda-ics-gcc47-tilt-stable-blob'::text))
                                                         ->  Bitmap Index Scan on dashboard_app_namedattribute_content_type_id  (cost=0.00..11565.64 rows=625762 width=0) (actual time=37.876..37.876 rows=62
4967 loops=1)
                                                               Index Cond: (content_type_id = 23)
                                                   ->  Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun u0  (cost=0.00..8.28 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1677)
                                                         Index Cond: (id = u1.object_id)
                                       ->  Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun  (cost=0.00..8.28 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1677)
                                             Index Cond: (id = u0.id)
                                 ->  Materialize  (cost=11565.77..39763.53 rows=282 width=8) (actual time=0.023..2.177 rows=24831 loops=1677)
                                       ->  Nested Loop  (cost=11565.77..39762.12 rows=282 width=8) (actual time=35.393..246.743 rows=28501 loops=1)
                                             ->  Bitmap Heap Scan on dashboard_app_namedattribute u1  (cost=11565.77..36421.61 rows=527 width=4) (actual time=35.372..196.698 rows=28501 loops=1)
                                                   Recheck Cond: (content_type_id = 23)
                                                   Filter: ((name = 'target.device_type'::text) AND (value = 'panda'::text))
                                                   ->  Bitmap Index Scan on dashboard_app_namedattribute_content_type_id  (cost=0.00..11565.64 rows=625762 width=0) (actual time=34.282..34.282 rows=624967 l
oops=1)
                                                         Index Cond: (content_type_id = 23)
                                             ->  Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun u0  (cost=0.00..6.33 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=28501)
                                                   Index Cond: (id = u1.object_id)
                           ->  Index Scan using dashboard_app_bundle_pkey on dashboard_app_bundle  (cost=0.00..5.42 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1677)
                                 Index Cond: (id = dashboard_app_testrun.bundle_id)
                                 Filter: (bundle_stream_id = 6417)
                     ->  Index Scan using dashboard_app_namedattribute_object_id_5df74633aa0eda4b_uniq on dashboard_app_namedattribute  (cost=0.00..8.56 rows=1 width=17) (actual time=0.005..0.006 rows=1 lo
ops=1677)
                           Index Cond: ((object_id = dashboard_app_testrun.id) AND (name = 'android.build'::text))
                           Filter: (content_type_id = 23)
 Total runtime: 6793.608 ms
(37 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	2	391.228 ms	5.8 %
GroupAggregate	1	0.072 ms	0.0 %
HashAggregate	1	1.393 ms	0.0 %
Index Scan	4	40.240 ms	0.6 %
Limit	1	0.002 ms	0.0 %
Materialize	1	3,404.086 ms	50.1 %
Nested Loop	5	36.366 ms	0.5 %
Nested Loop Semi Join	1	2,918.443 ms	43.0 %
Sort	1	1.326 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dashboard_app_bundle	1	5.031 ms	0.1 %
Index Scan	1	5.031 ms	100.0 %
dashboard_app_namedattribute	2	391.228 ms	5.8 %
Bitmap Heap Scan	2	391.228 ms	100.0 %
dashboard_app_testrun	3	35.209 ms	0.5 %
Index Scan	3	35.209 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xUB

Color mode:

Visible columns:

Per node type stats

Per table stats