explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xuti

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.312 834.284 ↓ 41.0 41 1

Sort (cost=435.67..435.67 rows=1 width=1,760) (actual time=834.276..834.284 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.570 833.972 ↓ 41.0 41 1

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

3. 0.144 5.940 ↓ 41.0 41 1

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

4. 0.099 5.796 ↓ 41.0 41 1

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

5. 0.148 5.656 ↓ 41.0 41 1

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

6. 0.083 5.508 ↓ 41.0 41 1

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

7. 0.144 5.384 ↓ 41.0 41 1

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

8. 0.099 5.240 ↓ 41.0 41 1

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

9. 0.139 5.100 ↓ 41.0 41 1

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

10. 0.091 4.961 ↓ 41.0 41 1

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

11. 0.136 4.829 ↓ 41.0 41 1

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

12. 0.121 4.693 ↓ 41.0 41 1

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

13. 0.124 4.572 ↓ 41.0 41 1

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

14. 0.127 4.448 ↓ 41.0 41 1

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

15. 0.125 4.321 ↓ 41.0 41 1

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

16. 0.089 4.196 ↓ 41.0 41 1

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

17. 0.138 4.066 ↓ 41.0 41 1

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

18. 0.092 3.928 ↓ 41.0 41 1

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

19. 0.134 3.795 ↓ 41.0 41 1

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

20. 0.090 3.661 ↓ 41.0 41 1

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

21. 0.139 3.530 ↓ 41.0 41 1

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

22. 0.101 3.391 ↓ 41.0 41 1

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

23. 0.126 3.249 ↓ 41.0 41 1

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

24. 0.095 3.000 ↓ 41.0 41 1

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

25. 0.152 2.823 ↓ 41.0 41 1

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

26. 0.098 2.630 ↓ 41.0 41 1

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

27. 0.128 2.327 ↓ 41.0 41 1

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

28. 0.097 2.076 ↓ 41.0 41 1

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

29. 0.106 1.774 ↓ 41.0 41 1

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

30. 0.138 1.504 ↓ 41.0 41 1

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

31. 0.128 1.079 ↓ 41.0 41 1

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

32. 0.130 0.828 ↓ 41.0 41 1

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

33. 0.119 0.452 ↓ 41.0 41 1

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

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

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

  • Merge Cond: ("desiredPositionLov".id = "positionCategoryPosition"."positionId")
35. 0.081 0.081 ↑ 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.009..0.081 rows=135 loops=1)

36. 0.048 0.069 ↑ 1.0 48 1

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

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

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

38. 0.084 0.119 ↑ 1.8 41 1

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

  • Sort Key: "candidateWorkExperiences"."desiredPositionId
  • Sort Method: quicksort Memory: 71kB
39. 0.035 0.035 ↑ 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.035 rows=41 loops=1)

  • Index Cond: ("candidateId" = 110,795)
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.006..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.000 0.000 ↓ 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.000 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.000 0.000 ↓ 0.0 0 41

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "soldIntoLevelLov" (cost=0.42..4.50 rows=1 width=22) (actual time=0.000..0.000 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.001..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.000..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.000..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.287 0.287 ↑ 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.007 rows=1 loops=41)

  • Index Cond: (id = 110,795)
71.          

SubPlan (for Nested Loop)

72. 0.164 827.175 ↑ 1.0 1 41

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

73. 0.127 827.011 ↑ 301,722.0 1 41

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

74. 0.164 826.724 ↑ 1.0 1 41

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

75. 826.191 826.191 ↑ 1.0 1 41

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

  • Filter: (("fkId" = "candidateWorkExperiences"."titleId") AND (("tableName")::text = 'listOfValues'::text))
  • Rows Removed by Filter: 202,610
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 : 14.743 ms
Execution time : 834.898 ms