#	exclusive	inclusive	rows x	rows	loops	node
1.	0.003	497.889	↓ 10.0	10	1	→ Limit (cost=75,716.64..75,716.67 rows=1 width=17) (actual time=497.822..497.889 rows=10 loops=1)
2.	0.063	497.886	↓ 10.0	10	1	→ GroupAggregate (cost=75,716.64..75,716.67 rows=1 width=17) (actual time=497.821..497.886 rows=10 loops=1)
3.	0.825	497.823	↓ 362.0	362	1	→ Sort (cost=75,716.64..75,716.64 rows=1 width=17) (actual time=497.806..497.823 rows=362 loops=1) Sort Key: ((dashboard_app_namedattribute.value)::integer) Sort Method: quicksort Memory: 127kB
4.	1.688	496.998	↓ 1,677.0	1,677	1	→ Nested Loop (cost=11,565.64..75,716.63 rows=1 width=17) (actual time=480.796..496.998 rows=1,677 loops=1)
5.	0.096	488.602	↓ 1,677.0	1,677	1	→ Nested Loop (cost=11,565.64..75,708.05 rows=1 width=8) (actual time=480.763..488.602 rows=1,677 loops=1)
6.	0.442	485.152	↓ 1,677.0	1,677	1	→ Nested Loop (cost=11,565.64..75,707.73 rows=1 width=12) (actual time=480.748..485.152 rows=1,677 loops=1)
7.	0.236	481.356	↓ 1,677.0	1,677	1	→ Subquery Scan on ANY_subquery (cost=11,565.64..75,699.44 rows=1 width=4) (actual time=480.742..481.356 rows=1,677 loops=1)
8.	6.192	481.120	↓ 1,677.0	1,677	1	→ HashSetOp Intersect (cost=11,565.64..75,699.43 rows=1 width=4) (actual time=480.742..481.120 rows=1,677 loops=1)
9.	2.797	474.928	↓ 106.8	30,218	1	→ Append (cost=11,565.64..75,698.72 rows=283 width=4) (actual time=173.519..474.928 rows=30,218 loops=1)
10.	0.218	217.516	↓ 1,677.0	1,677	1	→ Subquery Scan on SELECT 2 (cost=11,565.64..36,429.78 rows=1 width=4) (actual time=173.519..217.516 rows=1,677 loops=1)
11.	0.043	217.298	↓ 1,677.0	1,677	1	→ Nested Loop (cost=11,565.64..36,429.77 rows=1 width=4) (actual time=173.517..217.298 rows=1,677 loops=1)
12.	157.625	213.901	↓ 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=173.495..213.901 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))
13.	56.276	56.276	↑ 1.0	624,967	1	→ Bitmap Index Scan on dashboard_app_namedattribute_content_type_id (cost=0.00..11,565.64 rows=625,762 width=0) (actual time=56.276..56.276 rows=624,967 loops=1) Index Cond: (content_type_id = 23)
14.	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)
15.	3.629	254.615	↓ 101.2	28,541	1	→ Subquery Scan on SELECT 1 (cost=11,565.77..39,268.94 rows=282 width=4) (actual time=35.265..254.615 rows=28,541 loops=1)
16.	20.672	250.986	↓ 101.2	28,541	1	→ Nested Loop (cost=11,565.77..39,266.12 rows=282 width=4) (actual time=35.264..250.986 rows=28,541 loops=1)
17.	167.618	201.773	↓ 54.2	28,541	1	→ Bitmap Heap Scan on dashboard_app_namedattribute u1 (cost=11,565.77..36,421.61 rows=527 width=4) (actual time=35.246..201.773 rows=28,541 loops=1) Recheck Cond: (content_type_id = 23) Filter: ((name = 'target.device_type'::text) AND (value = 'panda'::text))
18.	34.155	34.155	↑ 1.0	624,967	1	→ Bitmap Index Scan on dashboard_app_namedattribute_content_type_id (cost=0.00..11,565.64 rows=625,762 width=0) (actual time=34.155..34.155 rows=624,967 loops=1) Index Cond: (content_type_id = 23)
19.	28.541	28.541	↑ 1.0	1	28,541	→ Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun u0 (cost=0.00..5.39 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=28,541) Index Cond: (id = u1.object_id)
20.	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 = "ANY_subquery".id)
21.	3.354	3.354	↑ 1.0	1	1,677	→ Index Scan using dashboard_app_bundle_pkey on dashboard_app_bundle (cost=0.00..0.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1,677) Index Cond: (id = dashboard_app_testrun.bundle_id) Filter: (bundle_stream_id = 6417)
22.	6.708	6.708	↑ 1.0	1	1,677	→ 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.004..0.004 rows=1 loops=1,677) Index Cond: ((object_id = dashboard_app_testrun.id) AND (name = 'android.build'::text)) Filter: (content_type_id = 23)

 Limit  (cost=75716.64..75716.67 rows=1 width=17) (actual time=497.822..497.889 rows=10 loops=1)
   ->  GroupAggregate  (cost=75716.64..75716.67 rows=1 width=17) (actual time=497.821..497.886 rows=10 loops=1)
         ->  Sort  (cost=75716.64..75716.64 rows=1 width=17) (actual time=497.806..497.823 rows=362 loops=1)
               Sort Key: ((dashboard_app_namedattribute.value)::integer)
               Sort Method: quicksort  Memory: 127kB
               ->  Nested Loop  (cost=11565.64..75716.63 rows=1 width=17) (actual time=480.796..496.998 rows=1677 loops=1)
                     ->  Nested Loop  (cost=11565.64..75708.05 rows=1 width=8) (actual time=480.763..488.602 rows=1677 loops=1)
                           ->  Nested Loop  (cost=11565.64..75707.73 rows=1 width=12) (actual time=480.748..485.152 rows=1677 loops=1)
                                 ->  Subquery Scan on "ANY_subquery"  (cost=11565.64..75699.44 rows=1 width=4) (actual time=480.742..481.356 rows=1677 loops=1)
                                       ->  HashSetOp Intersect  (cost=11565.64..75699.43 rows=1 width=4) (actual time=480.742..481.120 rows=1677 loops=1)
                                             ->  Append  (cost=11565.64..75698.72 rows=283 width=4) (actual time=173.519..474.928 rows=30218 loops=1)
                                                   ->  Subquery Scan on "*SELECT* 2"  (cost=11565.64..36429.78 rows=1 width=4) (actual time=173.519..217.516 rows=1677 loops=1)
                                                         ->  Nested Loop  (cost=11565.64..36429.77 rows=1 width=4) (actual time=173.517..217.298 rows=1677 loops=1)
                                                               ->  Bitmap Heap Scan on dashboard_app_namedattribute u1  (cost=11565.64..36421.48 rows=1 width=4) (actual time=173.495..213.901 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=56.276..56.276 rows=624967 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)
                                                   ->  Subquery Scan on "*SELECT* 1"  (cost=11565.77..39268.94 rows=282 width=4) (actual time=35.265..254.615 rows=28541 loops=1)
                                                         ->  Nested Loop  (cost=11565.77..39266.12 rows=282 width=4) (actual time=35.264..250.986 rows=28541 loops=1)
                                                               ->  Bitmap Heap Scan on dashboard_app_namedattribute u1  (cost=11565.77..36421.61 rows=527 width=4) (actual time=35.246..201.773 rows=28541 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.155..34.155 rows=624967 loops=1)
                                                                           Index Cond: (content_type_id = 23)
                                                               ->  Index Scan using dashboard_app_testrun_pkey on dashboard_app_testrun u0  (cost=0.00..5.39 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=28541)
                                                                     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 = "ANY_subquery".id)
                           ->  Index Scan using dashboard_app_bundle_pkey on dashboard_app_bundle  (cost=0.00..0.31 rows=1 width=4) (actual time=0.002..0.002 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.004..0.004 rows=1 loops=1677)
                           Index Cond: ((object_id = dashboard_app_testrun.id) AND (name = 'android.build'::text))
                           Filter: (content_type_id = 23)
 Total runtime: 497.990 ms
(38 rows)

Per node type stats

node type	count	sum of times	% of query
Append	1	2.797 ms	0.6 %
Bitmap Heap Scan	2	325.243 ms	65.3 %
Bitmap Index Scan	2	90.431 ms	18.2 %
GroupAggregate	1	0.063 ms	0.0 %
HashSetOp Intersect	1	6.192 ms	1.2 %
Index Scan	5	45.311 ms	9.1 %
Limit	1	0.003 ms	0.0 %
Nested Loop	5	22.941 ms	4.6 %
Sort	1	0.825 ms	0.2 %
Subquery Scan	3	4.083 ms	0.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dashboard_app_bundle	1	3.354 ms	0.7 %
Index Scan	1	3.354 ms	100.0 %
dashboard_app_namedattribute	3	331.951 ms	66.7 %
Bitmap Heap Scan	2	325.243 ms	98.0 %
Index Scan	1	6.708 ms	2.0 %
dashboard_app_testrun	3	35.249 ms	7.1 %
Index Scan	3	35.249 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5i9

Color mode:

Visible columns:

Per node type stats

Per table stats