explain.depesz.com

A tool for finding a real cause for slow queries.

Result: DArw

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.048 39.428 ↓ 2.6 66 1

Nested Loop (cost=831.98..1,045.99 rows=25 width=694) (actual time=38.855..39.428 rows=66 loops=1)

2. 0.198 38.852 ↓ 2.6 66 1

HashAggregate (cost=831.98..832.23 rows=25 width=8) (actual time=38.838..38.852 rows=66 loops=1)

3. 0.394 38.654 ↓ 8.2 204 1

Nested Loop (cost=0.00..831.92 rows=25 width=8) (actual time=0.155..38.654 rows=204 loops=1)

4. 1.688 35.117 ↓ 18.0 449 1

Nested Loop (cost=0.00..624.37 rows=25 width=4) (actual time=0.146..35.117 rows=449 loops=1)

5. 0.922 15.741 ↓ 110.5 2,211 1

Nested Loop (cost=0.00..337.82 rows=20 width=4) (actual time=0.098..15.741 rows=2,211 loops=1)

6. 0.116 1.571 ↓ 5.1 72 1

Nested Loop (cost=0.00..162.81 rows=14 width=8) (actual time=0.064..1.571 rows=72 loops=1)

7. 0.447 0.447 ↓ 5.1 72 1

Index Scan using index_employments_on_employer_id on employments (cost=0.00..43.10 rows=14 width=4) (actual time=0.047..0.447 rows=72 loops=1)

  • Index Cond: (employer_id = 2710)
8. 1.008 1.008 ↑ 1.0 1 72

Index Scan using candidates_pkey on candidates imported_friends (cost=0.00..8.54 rows=1 width=12) (actual time=0.013..0.014 rows=1 loops=72)

  • Index Cond: (id = employments.candidate_id)
9. 13.248 13.248 ↓ 15.5 31 72

Index Scan using index_facebook_friends_on_fb_id on facebook_friends (cost=0.00..12.48 rows=2 width=12) (actual time=0.015..0.184 rows=31 loops=72)

  • Index Cond: (fb_id = imported_friends.fb_id)
10. 17.688 17.688 ↓ 0.0 0 2,211

Index Scan using index_relationships_on_contact_id_and_contact_type on relationships (cost=0.00..14.29 rows=3 width=8) (actual time=0.008..0.008 rows=0 loops=2,211)

  • Index Cond: ((contact_id = facebook_friends.id) AND ((contact_type)::text = 'FacebookFriend'::text))
11. 3.143 3.143 ↓ 0.0 0 449

Index Scan using candidates_pkey on candidates subquery_candidates (cost=0.00..8.29 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=449)

  • Index Cond: (id = relationships.candidate_id)
12. 0.528 0.528 ↑ 1.0 1 66

Index Scan using candidates_pkey on candidates (cost=0.00..8.54 rows=1 width=694) (actual time=0.007..0.008 rows=1 loops=66)

  • Index Cond: (id = subquery_candidates.id)