explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M8wY : Optimization for: Optimization for: Optimization for: Optimization for: plan #ONPT; plan #ApaB; plan #taM4; plan #s0cZ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.008 14.756 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.94..282.47 rows=1 width=23,833) (actual time=14.748..14.756 rows=1 loops=1)

2. 0.006 14.746 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.80..282.29 rows=1 width=23,519) (actual time=14.739..14.746 rows=1 loops=1)

3. 0.007 14.738 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.51..281.63 rows=1 width=23,357) (actual time=14.731..14.738 rows=1 loops=1)

4. 0.007 14.729 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.09..279.74 rows=1 width=23,192) (actual time=14.722..14.729 rows=1 loops=1)

5. 0.008 14.720 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.80..278.60 rows=1 width=21,788) (actual time=14.713..14.720 rows=1 loops=1)

6. 0.006 14.709 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.51..278.08 rows=1 width=20,774) (actual time=14.702..14.709 rows=1 loops=1)

7. 0.010 14.700 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.37..277.91 rows=1 width=20,472) (actual time=14.693..14.700 rows=1 loops=1)

8. 0.018 14.687 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.08..277.53 rows=1 width=19,458) (actual time=14.680..14.687 rows=1 loops=1)

9. 0.021 14.663 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.79..276.87 rows=1 width=19,296) (actual time=14.656..14.663 rows=1 loops=1)

10. 0.007 14.638 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.51..276.31 rows=1 width=15,499) (actual time=14.631..14.638 rows=1 loops=1)

11. 0.006 14.629 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.37..276.14 rows=1 width=14,811) (actual time=14.623..14.629 rows=1 loops=1)

12. 0.010 14.620 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.95..274.00 rows=1 width=14,097) (actual time=14.614..14.620 rows=1 loops=1)

13. 0.006 14.601 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.66..265.69 rows=1 width=13,813) (actual time=14.595..14.601 rows=1 loops=1)

  • Join Filter: (applicatio0_.id = invoiceent27_.position_candidate_id)
14. 0.007 8.152 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.66..63.41 rows=1 width=13,789) (actual time=8.145..8.152 rows=1 loops=1)

  • Join Filter: (applicatio0_.id = interview26_.position_candidate_id)
15. 0.007 8.044 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.38..55.10 rows=1 width=13,747) (actual time=8.039..8.044 rows=1 loops=1)

  • Join Filter: (positionca24_.company_response_id = companyres25_.id)
  • Rows Removed by Join Filter: 5
16. 0.005 7.680 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.38..53.98 rows=1 width=13,743) (actual time=7.674..7.680 rows=1 loops=1)

  • Join Filter: (applicatio0_.id = positionca24_.position_candidate_id)
17. 0.007 7.130 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.38..52.85 rows=1 width=13,699) (actual time=7.124..7.130 rows=1 loops=1)

18. 0.008 7.113 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.24..49.58 rows=1 width=13,397) (actual time=7.108..7.113 rows=1 loops=1)

  • Join Filter: (applicatio0_.sub_status_id = substatuse22_.id)
  • Rows Removed by Join Filter: 26
19. 0.006 6.668 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.24..48.00 rows=1 width=12,845) (actual time=6.663..6.668 rows=1 loops=1)

20. 0.007 6.612 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.11..47.84 rows=1 width=12,835) (actual time=6.607..6.612 rows=1 loops=1)

21. 0.008 5.324 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.69..47.18 rows=1 width=12,552) (actual time=5.319..5.324 rows=1 loops=1)

22. 0.006 5.300 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.55..47.01 rows=1 width=12,250) (actual time=5.296..5.300 rows=1 loops=1)

  • Join Filter: (positionen16_.id = screenings18_.position_description_id)
  • Rows Removed by Join Filter: 4
23. 0.008 4.801 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.55..45.92 rows=1 width=10,682) (actual time=4.797..4.801 rows=1 loops=1)

24. 0.007 4.778 ↑ 1.0 1 1

Nested Loop (cost=4.40..45.76 rows=1 width=10,380) (actual time=4.774..4.778 rows=1 loops=1)

25. 0.007 3.380 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.11..37.45 rows=1 width=9,371) (actual time=3.376..3.380 rows=1 loops=1)

26. 0.007 3.309 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.97..29.22 rows=1 width=9,069) (actual time=3.305..3.309 rows=1 loops=1)

27. 0.007 2.929 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.82..21.00 rows=1 width=8,767) (actual time=2.925..2.929 rows=1 loops=1)

28. 0.005 2.914 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.68..20.81 rows=1 width=8,465) (actual time=2.910..2.914 rows=1 loops=1)

29. 0.004 2.170 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.53..20.65 rows=1 width=8,435) (actual time=2.166..2.170 rows=1 loops=1)

30. 0.003 2.164 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.11..19.94 rows=1 width=8,270) (actual time=2.161..2.164 rows=1 loops=1)

31. 0.003 2.159 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.97..19.77 rows=1 width=7,968) (actual time=2.156..2.159 rows=1 loops=1)

32. 0.003 2.154 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.55..19.04 rows=1 width=7,803) (actual time=2.152..2.154 rows=1 loops=1)

33. 0.002 2.145 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.40..18.88 rows=1 width=7,501) (actual time=2.143..2.145 rows=1 loops=1)

34. 0.006 2.142 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.11..18.50 rows=1 width=6,097) (actual time=2.139..2.142 rows=1 loops=1)

35. 0.005 2.132 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.97..18.33 rows=1 width=5,795) (actual time=2.129..2.132 rows=1 loops=1)

36. 0.004 1.086 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.55..17.77 rows=1 width=5,630) (actual time=1.084..1.086 rows=1 loops=1)

37. 0.002 1.079 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.40..17.60 rows=1 width=5,328) (actual time=1.077..1.079 rows=1 loops=1)

38. 0.005 1.076 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..17.04 rows=1 width=5,163) (actual time=1.074..1.076 rows=1 loops=1)

39. 0.013 1.065 ↑ 1.0 1 1

Nested Loop (cost=0.84..16.87 rows=1 width=5,107) (actual time=1.063..1.065 rows=1 loops=1)

40. 0.384 0.384 ↑ 1.0 1 1

Index Scan using position_candidate_pkey on position_candidate applicatio0_ (cost=0.42..8.44 rows=1 width=714) (actual time=0.382..0.384 rows=1 loops=1)

  • Index Cond: (id = 170,150)
41. 0.668 0.668 ↑ 1.0 1 1

Index Scan using candidate_pkey on candidate candidatee1_ (cost=0.42..8.44 rows=1 width=4,393) (actual time=0.668..0.668 rows=1 loops=1)

  • Index Cond: (id = applicatio0_.candidate_id)
42. 0.006 0.006 ↑ 1.0 1 1

Index Scan using candidate_source_pkey on candidate_source candidates2_ (cost=0.14..0.16 rows=1 width=56) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (candidatee1_.candidate_source_id = id)
43. 0.001 0.001 ↓ 0.0 0 1

Index Scan using common_location_pkey on common_location locationen3_ (cost=0.42..0.57 rows=1 width=165) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (candidatee1_.company_location_id = id)
44. 0.003 0.003 ↑ 1.0 1 1

Index Scan using client_account_pkey on user_account useraccoun4_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (candidatee1_.user_account_id = id)
45. 1.041 1.041 ↑ 1.0 1 1

Index Scan using common_location_pkey on common_location locationen5_ (cost=0.42..0.57 rows=1 width=165) (actual time=1.041..1.041 rows=1 loops=1)

  • Index Cond: (candidatee1_.current_location_id = id)
46. 0.004 0.004 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun6_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (candidatee1_.deleted_by_user_id = id)
47. 0.001 0.001 ↓ 0.0 0 1

Index Scan using contact__pkey on contact contactent7_ (cost=0.29..0.38 rows=1 width=1,404) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (candidatee1_.contact_id = id)
48. 0.006 0.006 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun8_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (contactent7_.user_account_id = id)
49. 0.002 0.002 ↓ 0.0 0 1

Index Scan using common_location_pkey on common_location locationen9_ (cost=0.42..0.73 rows=1 width=165) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (contactent7_.current_location_id = id)
50. 0.002 0.002 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun10_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (candidatee1_.note_by = id)
51. 0.002 0.002 ↓ 0.0 0 1

Index Scan using common_location_pkey on common_location locationen11_ (cost=0.42..0.57 rows=1 width=165) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (candidatee1_.personal_location_id = id)
52. 0.739 0.739 ↑ 1.0 1 1

Index Scan using "PK_code" on language languageen12_ (cost=0.14..0.16 rows=1 width=30) (actual time=0.739..0.739 rows=1 loops=1)

  • Index Cond: ((candidatee1_.language)::text = (code)::text)
53. 0.008 0.008 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun13_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (candidatee1_.source_contact_id = id)
54. 0.373 0.373 ↑ 1.0 1 1

Index Scan using client_account_pkey on user_account useraccoun14_ (cost=0.14..8.16 rows=1 width=302) (actual time=0.373..0.373 rows=1 loops=1)

  • Index Cond: (applicatio0_.created_by = id)
55. 0.064 0.064 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun15_ (cost=0.14..8.16 rows=1 width=302) (actual time=0.064..0.064 rows=0 loops=1)

  • Index Cond: (applicatio0_.made_by = id)
56. 1.391 1.391 ↑ 1.0 1 1

Index Scan using position_description_pkey on position_description positionen16_ (cost=0.29..8.31 rows=1 width=1,009) (actual time=1.391..1.391 rows=1 loops=1)

  • Index Cond: (id = applicatio0_.position_description_id)
57. 0.015 0.015 ↑ 1.0 1 1

Index Scan using client_account_pkey on user_account useraccoun17_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (positionen16_.creator_account_id = id)
58. 0.493 0.493 ↑ 1.0 4 1

Seq Scan on position_description_screening_question screenings18_ (cost=0.00..1.04 rows=4 width=1,568) (actual time=0.492..0.493 rows=4 loops=1)

59. 0.016 0.016 ↑ 1.0 1 1

Index Scan using client_account_pkey on user_account useraccoun19_ (cost=0.14..0.16 rows=1 width=302) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (positionen16_.updated_by = id)
60. 1.281 1.281 ↑ 1.0 1 1

Index Scan using compensation_position_id__uidx on compensation compensati20_ (cost=0.42..0.67 rows=1 width=283) (actual time=1.281..1.281 rows=1 loops=1)

  • Index Cond: (positionen16_.id = position_id)
61. 0.050 0.050 ↓ 0.0 0 1

Index Scan using compensation_fee_model_compensation_id__fkey on compensation_fee_model compensati21_ (cost=0.13..0.15 rows=1 width=10) (actual time=0.050..0.050 rows=0 loops=1)

  • Index Cond: (compensati20_.id = compensation_id)
62. 0.437 0.437 ↑ 1.0 26 1

Seq Scan on sub_status substatuse22_ (cost=0.00..1.26 rows=26 width=552) (actual time=0.435..0.437 rows=26 loops=1)

63. 0.010 0.010 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun23_ (cost=0.14..3.24 rows=1 width=302) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (substatuse22_.creator_id = id)
64. 0.545 0.545 ↓ 0.0 0 1

Seq Scan on position_candidate_company_response positionca24_ (cost=0.00..1.13 rows=1 width=44) (actual time=0.545..0.545 rows=0 loops=1)

  • Filter: (position_candidate_id = 170,150)
  • Rows Removed by Filter: 10
65. 0.357 0.357 ↑ 1.0 5 1

Seq Scan on company_response companyres25_ (cost=0.00..1.05 rows=5 width=4) (actual time=0.356..0.357 rows=5 loops=1)

66. 0.101 0.101 ↓ 0.0 0 1

Index Scan using interview_position_candidate_id on interview interview26_ (cost=0.28..8.30 rows=1 width=42) (actual time=0.101..0.101 rows=0 loops=1)

  • Index Cond: (position_candidate_id = 170,150)
67. 6.443 6.443 ↓ 0.0 0 1

Seq Scan on invoice invoiceent27_ (cost=0.00..202.28 rows=1 width=24) (actual time=6.443..6.443 rows=0 loops=1)

  • Filter: (position_candidate_id = 170,150)
  • Rows Removed by Filter: 9,542
68. 0.009 0.009 ↓ 0.0 0 1

Index Scan using offer_pkey on offer offerentit28_ (cost=0.29..8.30 rows=1 width=284) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (invoiceent27_.offer_id = id)
69. 0.003 0.003 ↓ 0.0 0 1

Index Scan using position_candidate_pkey on position_candidate applicatio29_ (cost=0.42..2.14 rows=1 width=714) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (offerentit28_.position_candidate_id = id)
70. 0.002 0.002 ↓ 0.0 0 1

Index Scan using offer_fee_model__offer_id__fkey on offer_fee_model offerfeemo30_ (cost=0.14..0.16 rows=1 width=688) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (offerentit28_.id = offer_id)
71. 0.004 0.004 ↓ 0.0 0 1

Index Scan using offer_personal_info__offer__fkey on offer_personal_info offerperso31_ (cost=0.29..0.56 rows=1 width=3,797) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (offerentit28_.id = offer_id)
72. 0.006 0.006 ↓ 0.0 0 1

Index Scan using company_location__pkey on company_location companyloc32_ (cost=0.29..0.66 rows=1 width=162) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (offerperso31_.client_billing_location_id = id)
73. 0.003 0.003 ↓ 0.0 0 1

Index Scan using company__pkey on company companyent33_ (cost=0.29..0.38 rows=1 width=1,014) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (companyloc32_.company_id = id)
74. 0.003 0.003 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun34_ (cost=0.14..0.17 rows=1 width=302) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (companyent33_.user_account_id = id)
75. 0.003 0.003 ↓ 0.0 0 1

Index Scan using company__pkey on company companyent35_ (cost=0.29..0.52 rows=1 width=1,014) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (offerperso31_.client_company_id = id)
76. 0.002 0.002 ↓ 0.0 0 1

Index Scan using contact__pkey on contact contactent36_ (cost=0.29..1.15 rows=1 width=1,404) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (offerperso31_.client_contact_id = id)
77. 0.002 0.002 ↓ 0.0 0 1

Index Scan using common_location_pkey on common_location locationen37_ (cost=0.42..1.89 rows=1 width=165) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (offerperso31_.current_location_id = id)
78. 0.002 0.002 ↓ 0.0 0 1

Index Scan using company_location__pkey on company_location companyloc38_ (cost=0.29..0.66 rows=1 width=162) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (offerperso31_.job_site_location_id = id)
79. 0.002 0.002 ↓ 0.0 0 1

Index Scan using client_account_pkey on user_account useraccoun39_ (cost=0.14..0.17 rows=1 width=302) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (offerperso31_.offer_letter_signatory_user_id = id)
Planning time : 271.284 ms
Execution time : 20.380 ms