#	exclusive	inclusive	rows x	rows	loops	node
1.	0.048	39.428	↓ 2.6	66	1	→ Nested Loop (cost=831.98..1045.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	2211	1	→ Nested Loop (cost=0.00..337.82 rows=20 width=4) (actual time=0.098..15.741 rows=2211 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	2211	→ 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=2211) 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)

              QUERY PLAN                                                                                          
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=831.98..1045.99 rows=25 width=694) (actual time=38.855..39.428 rows=66 loops=1)
   ->  HashAggregate  (cost=831.98..832.23 rows=25 width=8) (actual time=38.838..38.852 rows=66 loops=1)
         ->  Nested Loop  (cost=0.00..831.92 rows=25 width=8) (actual time=0.155..38.654 rows=204 loops=1)
               ->  Nested Loop  (cost=0.00..624.37 rows=25 width=4) (actual time=0.146..35.117 rows=449 loops=1)
                     ->  Nested Loop  (cost=0.00..337.82 rows=20 width=4) (actual time=0.098..15.741 rows=2211 loops=1)
                           ->  Nested Loop  (cost=0.00..162.81 rows=14 width=8) (actual time=0.064..1.571 rows=72 loops=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)
                                 ->  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)
                           ->  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)
                     ->  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=2211)
                           Index Cond: ((contact_id = facebook_friends.id) AND ((contact_type)::text = 'FacebookFriend'::text))
               ->  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)
   ->  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)
 Total runtime: 39.713 ms
(19 rows)

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	0.198 ms	0.5 %
Index Scan	6	36.062 ms	91.5 %
Nested Loop	5	3.168 ms	8.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
candidates	3	4.679 ms	11.9 %
Index Scan	3	4.679 ms	100.0 %
employments	1	0.447 ms	1.1 %
Index Scan	1	0.447 ms	100.0 %
facebook_friends	1	13.248 ms	33.6 %
Index Scan	1	13.248 ms	100.0 %
relationships	1	17.688 ms	44.9 %
Index Scan	1	17.688 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: DArw

Colorize:

Columns visibility:

Per node type stats

Per table stats