explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OcuJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.308 826.572 ↓ 41.0 41 1

Sort (cost=435.67..435.67 rows=1 width=1,760) (actual time=826.564..826.572 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.550 826.264 ↓ 41.0 41 1

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

3. 0.136 5.550 ↓ 41.0 41 1

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

4. 0.135 5.414 ↓ 41.0 41 1

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

5. 0.124 5.279 ↓ 41.0 41 1

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

6. 0.118 5.155 ↓ 41.0 41 1

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

7. 0.118 5.037 ↓ 41.0 41 1

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

8. 0.120 4.919 ↓ 41.0 41 1

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

9. 0.126 4.799 ↓ 41.0 41 1

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

10. 0.086 4.673 ↓ 41.0 41 1

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

11. 0.115 4.546 ↓ 41.0 41 1

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

12. 0.121 4.431 ↓ 41.0 41 1

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

13. 0.120 4.310 ↓ 41.0 41 1

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

14. 0.117 4.190 ↓ 41.0 41 1

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

15. 0.115 4.073 ↓ 41.0 41 1

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

16. 0.078 3.958 ↓ 41.0 41 1

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

17. 0.135 3.839 ↓ 41.0 41 1

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

18. 0.091 3.704 ↓ 41.0 41 1

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

19. 0.119 3.572 ↓ 41.0 41 1

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

20. 0.077 3.453 ↓ 41.0 41 1

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

21. 0.132 3.335 ↓ 41.0 41 1

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

22. 0.093 3.203 ↓ 41.0 41 1

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

23. 0.113 3.069 ↓ 41.0 41 1

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

24. 0.091 2.833 ↓ 41.0 41 1

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

25. 0.097 2.660 ↓ 41.0 41 1

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

26. 0.101 2.481 ↓ 41.0 41 1

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

27. 0.109 2.175 ↓ 41.0 41 1

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

28. 0.087 1.943 ↓ 41.0 41 1

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

29. 0.090 1.651 ↓ 41.0 41 1

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

30. 0.097 1.397 ↓ 41.0 41 1

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

31. 0.117 1.013 ↓ 41.0 41 1

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

32. 0.155 0.773 ↓ 41.0 41 1

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

33. 0.118 0.413 ↓ 41.0 41 1

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

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

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

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

36. 0.029 0.049 ↑ 1.0 48 1

Sort (cost=2.91..3.04 rows=50 width=8) (actual time=0.038..0.049 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.007..0.020 rows=50 loops=1)

38. 0.070 0.103 ↑ 1.8 41 1

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

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

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

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

Index Scan using "PK_6b031fcd0863e3f6b44230163f9" on organizations "companyOrganization" (cost=0.42..8.44 rows=1 width=167) (actual time=0.005..0.005 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.082 0.082 ↓ 0.0 0 41

Index Scan using "PK_09ab30ca0975c02656483265f4f" on states state (cost=0.28..2.68 rows=1 width=7) (actual time=0.002..0.002 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.000..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.000..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.000 0.000 ↓ 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.000 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.000 0.000 ↓ 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.000 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.000 0.000 ↓ 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.000 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 = 110795)
71.          

SubPlan (for Nested Loop)

72. 0.164 819.877 ↑ 1.0 1 41

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

73. 0.126 819.713 ↑ 301,722.0 1 41

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

74. 0.205 819.467 ↑ 1.0 1 41

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

75. 818.934 818.934 ↑ 1.0 1 41

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

  • Filter: (("fkId" = "candidateWorkExperiences"."titleId") AND (("tableName")::text = 'listOfValues'::text))
  • Rows Removed by Filter: 202610
76. 0.328 0.328 ↑ 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.008 rows=1 loops=41)

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

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

Planning time : 14.277 ms
Execution time : 827.153 ms