explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xkDK

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 6,438.109 ↓ 10.0 10 1
→

Limit (cost=5,159.34..5,159.37 rows=1 width=17) (actual time=6,438.045..6,438.109 rows=10 loops=1)

2. 0.065 6,438.107 ↓ 10.0 10 1
→

GroupAggregate (cost=5,159.34..5,159.37 rows=1 width=17) (actual time=6,438.043..6,438.107 rows=10 loops=1)

3. 1.225 6,438.042 ↓ 362.0 362 1
→

Sort (cost=5,159.34..5,159.35 rows=1 width=17) (actual time=6,438.030..6,438.042 rows=362 loops=1)

  • Sort Key: ((dashboard_app_namedattribute.value)::integer)
  • Sort Method: quicksort Memory: 127kB
4. 1.593 6,436.817 ↓ 1,677.0 1,677 1
→

Nested Loop (cost=16.98..5,159.33 rows=1 width=17) (actual time=84.940..6,436.817 rows=1,677 loops=1)

5. 1.401 6,425.162 ↓ 1,677.0 1,677 1
→

Nested Loop (cost=16.98..5,150.76 rows=1 width=20) (actual time=84.915..6,425.162 rows=1,677 loops=1)

6. 2,910.886 6,417.053 ↓ 1,677.0 1,677 1
→

Nested Loop Semi Join (cost=16.98..5,145.33 rows=1 width=24) (actual time=84.901..6,417.053 rows=1,677 loops=1)

  • Join Filter: (dashboard_app_testrun.id = u0.id)
7. 0.467 16.330 ↓ 1,677.0 1,677 1
→

Nested Loop (cost=16.98..25.27 rows=1 width=16) (actual time=10.173..16.330 rows=1,677 loops=1)

8. 1.829 10.832 ↓ 1,677.0 1,677 1
→

HashAggregate (cost=16.98..16.99 rows=1 width=8) (actual time=10.170..10.832 rows=1,677 loops=1)

9. 2.090 9.003 ↓ 1,677.0 1,677 1
→

Nested Loop (cost=0.00..16.97 rows=1 width=8) (actual time=0.248..9.003 rows=1,677 loops=1)

10. 1.882 1.882 ↓ 1,677.0 1,677 1
→

Index Scan using foo on dashboard_app_namedattribute u1 (cost=0.00..8.68 rows=1 width=4) (actual time=0.229..1.882 rows=1,677 loops=1)

  • Index Cond: ((content_type_id = 23) AND (name = 'android.name'::text) AND (value = 'linaro-android_panda-ics-gcc47-tilt-stable-blob'::text))
11. 5.031 5.031 ↑ 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.003..0.003 rows=1 loops=1,677)

  • Index Cond: (id = u1.object_id)
12. 5.031 5.031 ↑ 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.003 rows=1 loops=1,677)

  • Index Cond: (id = u0.id)
13. 3,412.798 3,489.837 ↓ 88.1 24,831 1,677
→

Materialize (cost=0.00..5,115.83 rows=282 width=8) (actual time=0.002..2.081 rows=24,831 loops=1,677)

14. 18.407 77.039 ↓ 101.1 28,501 1
→

Nested Loop (cost=0.00..5,114.42 rows=282 width=8) (actual time=0.054..77.039 rows=28,501 loops=1)

15. 30.131 30.131 ↓ 54.1 28,501 1
→

Index Scan using foo on dashboard_app_namedattribute u1 (cost=0.00..1,773.90 rows=527 width=4) (actual time=0.043..30.131 rows=28,501 loops=1)

  • Index Cond: ((content_type_id = 23) AND (name = 'target.device_type'::text) AND (value = 'panda'::text))
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. 6.708 6.708 ↑ 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.004..0.004 rows=1 loops=1,677)

  • Index Cond: (id = dashboard_app_testrun.bundle_id)
  • Filter: (bundle_stream_id = 6417)
18. 10.062 10.062 ↑ 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.006..0.006 rows=1 loops=1,677)

  • Index Cond: ((object_id = dashboard_app_testrun.id) AND (name = 'android.build'::text))
  • Filter: (content_type_id = 23)