explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mOqw : Optimization for: plan #xuti

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.322 872.022 ↓ 41.0 41 1

Sort (cost=435.67..435.67 rows=1 width=1,760) (actual time=872.014..872.022 rows=41 loops=1)

  • Sort Key: "candidateWorkExperiences"."isCurrentWorkplace" DESC NULLS LAST, "candidateWorkExperiences"."toDate" DESC NULLS LAST, "candidateWorkExperiences"."fromDate" DESC NULLS LAST
  • Sort Method: quicksort Memory: 95kB
2. 0.535 871.700 ↓ 41.0 41 1

Nested Loop (cost=295.22..435.66 rows=1 width=1,760) (actual time=12.106..871.700 rows=41 loops=1)

3. 0.135 5.860 ↓ 41.0 41 1

Nested Loop Left Join (cost=294.80..426.71 rows=1 width=1,664) (actual time=0.349..5.860 rows=41 loops=1)

4. 0.098 5.725 ↓ 41.0 41 1

Nested Loop Left Join (cost=294.38..424.34 rows=1 width=1,637) (actual time=0.347..5.725 rows=41 loops=1)

5. 0.139 5.586 ↓ 41.0 41 1

Nested Loop Left Join (cost=293.96..419.85 rows=1 width=1,619) (actual time=0.345..5.586 rows=41 loops=1)

6. 0.096 5.447 ↓ 41.0 41 1

Nested Loop Left Join (cost=293.53..417.48 rows=1 width=1,592) (actual time=0.343..5.447 rows=41 loops=1)

7. 0.135 5.310 ↓ 41.0 41 1

Nested Loop Left Join (cost=293.11..412.99 rows=1 width=1,574) (actual time=0.341..5.310 rows=41 loops=1)

8. 0.095 5.175 ↓ 41.0 41 1

Nested Loop Left Join (cost=292.69..410.62 rows=1 width=1,547) (actual time=0.338..5.175 rows=41 loops=1)

9. 0.122 5.039 ↓ 41.0 41 1

Nested Loop Left Join (cost=292.27..406.13 rows=1 width=1,529) (actual time=0.336..5.039 rows=41 loops=1)

10. 0.103 4.917 ↓ 41.0 41 1

Nested Loop Left Join (cost=291.85..403.76 rows=1 width=1,502) (actual time=0.334..4.917 rows=41 loops=1)

11. 0.137 4.773 ↓ 41.0 41 1

Nested Loop Left Join (cost=291.43..399.27 rows=1 width=1,484) (actual time=0.329..4.773 rows=41 loops=1)

12. 0.088 4.636 ↓ 41.0 41 1

Nested Loop Left Join (cost=291.01..396.90 rows=1 width=1,457) (actual time=0.326..4.636 rows=41 loops=1)

13. 0.123 4.507 ↓ 41.0 41 1

Nested Loop Left Join (cost=290.59..392.41 rows=1 width=1,439) (actual time=0.323..4.507 rows=41 loops=1)

14. 0.089 4.384 ↓ 41.0 41 1

Nested Loop Left Join (cost=290.16..390.04 rows=1 width=1,412) (actual time=0.321..4.384 rows=41 loops=1)

15. 0.121 4.254 ↓ 41.0 41 1

Nested Loop Left Join (cost=289.74..385.55 rows=1 width=1,394) (actual time=0.319..4.254 rows=41 loops=1)

16. 0.097 4.133 ↓ 41.0 41 1

Nested Loop Left Join (cost=289.32..383.18 rows=1 width=1,367) (actual time=0.316..4.133 rows=41 loops=1)

17. 0.130 3.995 ↓ 41.0 41 1

Nested Loop Left Join (cost=288.90..378.69 rows=1 width=1,349) (actual time=0.313..3.995 rows=41 loops=1)

18. 0.096 3.865 ↓ 41.0 41 1

Nested Loop Left Join (cost=288.48..376.32 rows=1 width=1,322) (actual time=0.311..3.865 rows=41 loops=1)

19. 0.133 3.728 ↓ 41.0 41 1

Nested Loop Left Join (cost=288.06..371.83 rows=1 width=1,304) (actual time=0.308..3.728 rows=41 loops=1)

20. 0.092 3.595 ↓ 41.0 41 1

Nested Loop Left Join (cost=287.64..369.46 rows=1 width=1,277) (actual time=0.305..3.595 rows=41 loops=1)

21. 0.138 3.462 ↓ 41.0 41 1

Nested Loop Left Join (cost=287.22..364.97 rows=1 width=1,259) (actual time=0.303..3.462 rows=41 loops=1)

22. 0.096 3.324 ↓ 41.0 41 1

Nested Loop Left Join (cost=286.79..362.60 rows=1 width=1,232) (actual time=0.301..3.324 rows=41 loops=1)

23. 0.126 3.187 ↓ 41.0 41 1

Nested Loop Left Join (cost=286.37..358.11 rows=1 width=1,214) (actual time=0.298..3.187 rows=41 loops=1)

24. 0.107 2.938 ↓ 41.0 41 1

Nested Loop Left Join (cost=286.09..352.98 rows=1 width=1,141) (actual time=0.293..2.938 rows=41 loops=1)

25. 0.136 2.749 ↓ 41.0 41 1

Nested Loop Left Join (cost=285.67..347.29 rows=1 width=1,118) (actual time=0.291..2.749 rows=41 loops=1)

26. 0.097 2.572 ↓ 41.0 41 1

Nested Loop Left Join (cost=285.38..344.61 rows=1 width=1,111) (actual time=0.288..2.572 rows=41 loops=1)

27. 0.121 2.270 ↓ 41.0 41 1

Nested Loop Left Join (cost=284.96..342.13 rows=1 width=1,088) (actual time=0.281..2.270 rows=41 loops=1)

28. 0.105 2.026 ↓ 41.0 41 1

Nested Loop (cost=284.54..337.80 rows=1 width=1,084) (actual time=0.275..2.026 rows=41 loops=1)

29. 0.104 1.716 ↓ 41.0 41 1

Nested Loop (cost=284.12..335.44 rows=1 width=1,061) (actual time=0.271..1.716 rows=41 loops=1)

30. 0.124 1.448 ↓ 41.0 41 1

Nested Loop (cost=283.70..327.00 rows=1 width=1,033) (actual time=0.266..1.448 rows=41 loops=1)

31. 0.119 1.037 ↓ 41.0 41 1

Nested Loop (cost=283.28..324.64 rows=1 width=1,010) (actual time=0.257..1.037 rows=41 loops=1)

32. 0.124 0.795 ↓ 41.0 41 1

Nested Loop (cost=282.86..320.20 rows=1 width=1,006) (actual time=0.249..0.795 rows=41 loops=1)

33. 0.121 0.425 ↓ 41.0 41 1

Merge Join (cost=282.44..311.76 rows=1 width=839) (actual time=0.240..0.425 rows=41 loops=1)

  • Merge Cond: ("desiredPositionLov".id = "candidateWorkExperiences"."desiredPositionId")
34. 0.064 0.197 ↑ 1.0 48 1

Merge Join (cost=3.33..88.33 rows=50 width=36) (actual time=0.061..0.197 rows=48 loops=1)

  • Merge Cond: ("desiredPositionLov".id = "positionCategoryPosition"."positionId")
35. 0.082 0.082 ↑ 1,583.6 135 1

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "desiredPositionLov" (cost=0.42..195,242.50 rows=213,782 width=28) (actual time=0.010..0.082 rows=135 loops=1)

36. 0.031 0.051 ↑ 1.0 48 1

Sort (cost=2.91..3.04 rows=50 width=8) (actual time=0.039..0.051 rows=48 loops=1)

  • Sort Key: "positionCategoryPosition"."positionId
  • Sort Method: quicksort Memory: 27kB
37. 0.020 0.020 ↑ 1.0 50 1

Seq Scan on "positionCategoryPositions" "positionCategoryPosition" (cost=0.00..1.50 rows=50 width=8) (actual time=0.008..0.020 rows=50 loops=1)

38. 0.071 0.107 ↑ 1.8 41 1

Sort (cost=279.11..279.29 rows=74 width=803) (actual time=0.074..0.107 rows=41 loops=1)

  • Sort Key: "candidateWorkExperiences"."desiredPositionId
  • Sort Method: quicksort Memory: 71kB
39. 0.036 0.036 ↑ 1.8 41 1

Index Scan using "IDX_CANDIDATEWORKEXPERIENCES_CANDIDATEID" on "candidateWorkExperiences" (cost=0.42..276.81 rows=74 width=803) (actual time=0.009..0.036 rows=41 loops=1)

  • Index Cond: ("candidateId" = 110795)
40. 0.246 0.246 ↑ 1.0 1 41

Index Scan using "PK_6b031fcd0863e3f6b44230163f9" on organizations "companyOrganization" (cost=0.42..8.44 rows=1 width=167) (actual time=0.006..0.006 rows=1 loops=41)

  • Index Cond: (id = "candidateWorkExperiences"."companyId")
41. 0.123 0.123 ↑ 1.0 1 41

Index Only Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "titleLov" (cost=0.42..4.44 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=41)

  • Index Cond: (id = "candidateWorkExperiences"."titleId")
  • Heap Fetches: 0
42. 0.287 0.287 ↑ 1.0 1 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "desiredPositionLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.005..0.007 rows=1 loops=41)

  • Index Cond: ("fkId" = "desiredPositionLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 2
43. 0.164 0.164 ↑ 1.0 1 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "positionCategoryLov" (cost=0.42..8.44 rows=1 width=28) (actual time=0.004..0.004 rows=1 loops=41)

  • Index Cond: (id = "positionCategoryPosition"."positionCategoryId")
44. 0.205 0.205 ↑ 1.0 1 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "positionCategoryLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.003..0.005 rows=1 loops=41)

  • Index Cond: ("fkId" = "positionCategoryLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 2
45. 0.123 0.123 ↑ 1.0 1 41

Index Only Scan using "PK_4762ffb6e5d198cfec5606bc11e" on cities city (cost=0.42..4.33 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=41)

  • Index Cond: (id = "candidateWorkExperiences"."cityId")
  • Heap Fetches: 0
46. 0.205 0.205 ↑ 1.0 1 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "cityLang" (cost=0.42..2.47 rows=1 width=31) (actual time=0.003..0.005 rows=1 loops=41)

  • Index Cond: ("fkId" = city.id)
  • Filter: (("tableName")::text = 'cities'::text)
  • Rows Removed by Filter: 1
47. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_09ab30ca0975c02656483265f4f" on states state (cost=0.28..2.68 rows=1 width=7) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperiences"."stateId")
48. 0.082 0.082 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "stateLang" (cost=0.42..5.69 rows=1 width=31) (actual time=0.001..0.002 rows=0 loops=41)

  • Index Cond: ("fkId" = state.id)
  • Filter: (("tableName")::text = 'states'::text)
  • Rows Removed by Filter: 0
49. 0.123 0.123 ↓ 0.0 0 41

Index Scan using "IDX_CANDIDATEWORKEXPERIENCEDETAILS_CANDIDATEWORKEXPERIENCEID" on "candidateWorkExperienceDetails" "candidateWorkExperienceDetail" (cost=0.29..5.11 rows=1 width=77) (actual time=0.003..0.003 rows=0 loops=41)

  • Index Cond: ("candidateWorkExperienceId" = "candidateWorkExperiences".id)
50. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "averageDealSizeLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."averageDealSize")
51. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "averageDealSizeLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "averageDealSizeLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
52. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "averageDealCycleLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."averageDealCycle")
53. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "averageDealCycleLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "averageDealCycleLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
54. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "annualQuotaLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."annualQuota")
55. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "annualQuotaLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "annualQuotaLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
56. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "netNewBusinessLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."netNewBusiness")
57. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "netNewBusinessLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "netNewBusinessLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
58. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "customerSizeLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.000..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."customerSize")
59. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "customerSizeLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "customerSizeLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
60. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "soldIntoLevelLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."soldIntoLevel")
61. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "soldIntoLevelLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "soldIntoLevelLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
62. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "bookOfBusinessLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."bookOfBusiness")
63. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "bookOfBusinessLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "bookOfBusinessLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
64. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "targetCustomerSizeLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.000..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."targetCustomerSize")
65. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "targetCustomerSizeLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "targetCustomerSizeLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
66. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "monthlyQualifiedMeetingsQuotaLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."monthlyQualifiedMeetingsQuota")
67. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "monthlyQualifiedMeetingsQuotaLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "monthlyQualifiedMeetingsQuotaLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
68. 0.041 0.041 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "annualPipelineQuotaLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=41)

  • Index Cond: (id = "candidateWorkExperienceDetail"."annualPipelineQuota")
69. 0.000 0.000 ↓ 0.0 0 41

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "annualPipelineQuotaLang" (cost=0.42..2.35 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=41)

  • Index Cond: ("fkId" = "annualPipelineQuotaLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
70. 0.328 0.328 ↑ 1.0 1 41

Index Scan using "PK_140681296bf033ab1eb95288abb" on candidates candidate (cost=0.42..8.44 rows=1 width=8) (actual time=0.006..0.008 rows=1 loops=41)

  • Index Cond: (id = 110795)
71.          

SubPlan (for Nested Loop)

72. 0.164 864.977 ↑ 1.0 1 41

Limit (cost=0.42..0.50 rows=1 width=27) (actual time=21.094..21.097 rows=1 loops=41)

73. 0.127 864.813 ↑ 301,722.0 1 41

Nested Loop (cost=0.42..23,108.72 rows=301,722 width=27) (actual time=21.093..21.093 rows=1 loops=41)

74. 0.164 864.526 ↑ 1.0 1 41

Nested Loop (cost=0.42..10,804.28 rows=1 width=27) (actual time=21.086..21.086 rows=1 loops=41)

75. 863.993 863.993 ↑ 1.0 1 41

Seq Scan on "languageData" (cost=0.00..10,795.83 rows=1 width=31) (actual time=20.561..21.073 rows=1 loops=41)

  • Filter: (("fkId" = "candidateWorkExperiences"."titleId") AND (("tableName")::text = 'listOfValues'::text))
  • Rows Removed by Filter: 202610
76. 0.369 0.369 ↑ 1.0 1 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "titleLov_1" (cost=0.42..8.44 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=41)

  • Index Cond: (id = "candidateWorkExperiences"."titleId")
  • Filter: (NOT "isInternal")
  • Rows Removed by Filter: 0
77. 0.160 0.160 ↑ 301,722.0 1 40

Seq Scan on "languageData" "LanguageData" (cost=0.00..9,287.22 rows=301,722 width=0) (actual time=0.004..0.004 rows=1 loops=40)

Planning time : 16.785 ms
Execution time : 872.628 ms