explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jmxv

Settings
# exclusive inclusive rows x rows loops node
1. 13.459 73,749.654 ↑ 1.9 1,122 1

Hash Left Join (cost=347.45..2,137,101.05 rows=2,131 width=760) (actual time=385.892..73,749.654 rows=1,122 loops=1)

  • Hash Cond: (c.candidate_source_id = cs.id)
2. 3.382 73,736.124 ↑ 1.9 1,122 1

Nested Loop Left Join (cost=345.78..2,136,984.84 rows=2,131 width=248) (actual time=385.547..73,736.124 rows=1,122 loops=1)

3. 2.847 73,722.644 ↑ 1.9 1,122 1

Nested Loop Left Join (cost=345.36..2,132,303.49 rows=2,131 width=232) (actual time=385.492..73,722.644 rows=1,122 loops=1)

4. 3.376 73,715.309 ↑ 1.9 1,122 1

Nested Loop Left Join (cost=345.22..2,131,935.79 rows=2,131 width=222) (actual time=385.429..73,715.309 rows=1,122 loops=1)

5. 3.689 73,707.445 ↑ 1.9 1,122 1

Hash Left Join (cost=345.07..2,131,560.73 rows=2,131 width=178) (actual time=385.374..73,707.445 rows=1,122 loops=1)

  • Hash Cond: (pd.id = position_description_functional_expertise.position_id)
6. 35,963.623 73,686.280 ↑ 2.1 1,030 1

Nested Loop Left Join (cost=2.95..2,131,170.02 rows=2,131 width=182) (actual time=367.685..73,686.280 rows=1,030 loops=1)

  • Join Filter: (cl.id = c.current_location_id)
  • Rows Removed by Join Filter: 111338880
7. 2.055 215.207 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=2.95..11,731.59 rows=1,039 width=193) (actual time=2.111..215.207 rows=1,030 loops=1)

8. 2.713 208.002 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=2.68..11,378.80 rows=1,039 width=183) (actual time=2.099..208.002 rows=1,030 loops=1)

9. 2.420 199.109 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=2.40..10,964.61 rows=1,039 width=175) (actual time=2.080..199.109 rows=1,030 loops=1)

10. 2.343 192.569 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=2.13..10,651.10 rows=1,039 width=169) (actual time=2.072..192.569 rows=1,030 loops=1)

11. 2.845 181.986 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=1.84..10,287.15 rows=1,039 width=141) (actual time=2.056..181.986 rows=1,030 loops=1)

12. 2.721 172.961 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=1.56..9,782.15 rows=1,039 width=113) (actual time=2.046..172.961 rows=1,030 loops=1)

13. 2.022 160.970 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=1.27..8,116.87 rows=1,039 width=85) (actual time=2.026..160.970 rows=1,030 loops=1)

14. 2.539 154.828 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=0.99..7,784.67 rows=1,039 width=83) (actual time=2.022..154.828 rows=1,030 loops=1)

15. 2.897 145.079 ↑ 1.0 1,030 1

Nested Loop Left Join (cost=0.71..7,384.59 rows=1,039 width=40) (actual time=2.006..145.079 rows=1,030 loops=1)

16. 132.912 132.912 ↑ 1.0 1,030 1

Index Scan using position_candidate__candidate_id__fkey on position_candidate pc (cost=0.42..5,950.71 rows=1,039 width=20) (actual time=1.983..132.912 rows=1,030 loops=1)

  • Filter: (status >= 300)
  • Rows Removed by Filter: 134920
17. 9.270 9.270 ↑ 1.0 1 1,030

Index Scan using position_description_pkey on position_description pd (cost=0.29..1.37 rows=1 width=20) (actual time=0.008..0.009 rows=1 loops=1,030)

  • Index Cond: (pc.position_description_id = id)
18. 7.210 7.210 ↑ 1.0 1 1,030

Index Scan using company__pkey on company com (cost=0.29..0.38 rows=1 width=51) (actual time=0.006..0.007 rows=1 loops=1,030)

  • Index Cond: (id = pd.company_id)
19. 4.120 4.120 ↓ 0.0 0 1,030

Index Scan using company_location__pkey on company_location cl (cost=0.28..0.31 rows=1 width=6) (actual time=0.004..0.004 rows=0 loops=1,030)

  • Index Cond: (pd.company_location_id = id)
20. 9.270 9.270 ↑ 1.0 1 1,030

Index Scan using candidate_pkey on candidate c (cost=0.29..1.59 rows=1 width=36) (actual time=0.008..0.009 rows=1 loops=1,030)

  • Index Cond: (id = pc.candidate_id)
21. 6.180 6.180 ↑ 1.0 1 1,030

Index Scan using offer_position_candidate_id__fkey on offer o (cost=0.28..0.48 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=1,030)

  • Index Cond: (position_candidate_id = pc.id)
22. 8.240 8.240 ↑ 1.0 1 1,030

Index Scan using compensation_position_id__uidx on compensation comp (cost=0.29..0.34 rows=1 width=32) (actual time=0.007..0.008 rows=1 loops=1,030)

  • Index Cond: (position_id = pd.id)
23. 4.120 4.120 ↓ 0.0 0 1,030

Index Scan using compensation_fee_model_compensation_id__fkey on compensation_fee_model cfm (cost=0.27..0.29 rows=1 width=14) (actual time=0.004..0.004 rows=0 loops=1,030)

  • Index Cond: (compensation_id = comp.id)
24. 6.180 6.180 ↑ 1.0 1 1,030

Index Scan using offer_personal_info_offer_id_unq on offer_personal_info opi (cost=0.28..0.39 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=1,030)

  • Index Cond: (offer_id = o.id)
25. 5.150 5.150 ↑ 1.0 1 1,030

Index Scan using offer_fee_model__offer_id__fkey on offer_fee_model ofm (cost=0.28..0.33 rows=1 width=14) (actual time=0.004..0.005 rows=1 loops=1,030)

  • Index Cond: (o.id = offer_id)
26. 37,423.427 37,507.450 ↓ 1.0 108,096 1,030

Materialize (cost=0.00..3,457.22 rows=107,748 width=1) (actual time=0.004..36.415 rows=108,096 loops=1,030)

27. 84.023 84.023 ↓ 1.0 108,096 1

Seq Scan on common_location coml (cost=0.00..2,497.48 rows=107,748 width=1) (actual time=0.011..84.023 rows=108,096 loops=1)

28. 8.125 17.476 ↓ 1.0 9,105 1

Hash (cost=232.43..232.43 rows=8,775 width=8) (actual time=17.476..17.476 rows=9,105 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 484kB
29. 9.351 9.351 ↓ 1.0 9,105 1

Seq Scan on position_description_functional_expertise (cost=0.00..232.43 rows=8,775 width=8) (actual time=0.047..9.351 rows=9,105 loops=1)

  • Filter: (sub_functional_expertise_id IS NOT NULL)
  • Rows Removed by Filter: 6084
30. 4.488 4.488 ↑ 1.0 1 1,122

Index Scan using sub_functional_expertise_pkey on sub_functional_expertise sfe (cost=0.15..0.17 rows=1 width=48) (actual time=0.004..0.004 rows=1 loops=1,122)

  • Index Cond: (position_description_functional_expertise.sub_functional_expertise_id = id)
31. 4.488 4.488 ↓ 0.0 0 1,122

Index Scan using country_pkey on country cou (cost=0.14..0.16 rows=1 width=13) (actual time=0.004..0.004 rows=0 loops=1,122)

  • Index Cond: ((code)::text = (COALESCE(coml.country_code, ''::character varying))::text)
32. 10.098 10.098 ↑ 1.0 1 1,122

Index Scan using candidate_extension_candidate_id__pkey on candidate_extension ce (cost=0.41..2.19 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=1,122)

  • Index Cond: (candidate_id = pc.candidate_id)
33. 0.040 0.071 ↓ 1.0 31 1

Hash (cost=1.30..1.30 rows=30 width=520) (actual time=0.071..0.071 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
34. 0.031 0.031 ↓ 1.0 31 1

Seq Scan on candidate_source cs (cost=0.00..1.30 rows=30 width=520) (actual time=0.011..0.031 rows=31 loops=1)