explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Nip

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.093 ↓ 0.0 0 1

Sort (cost=191.34..191.34 rows=1 width=1,760) (actual time=0.093..0.093 rows=0 loops=1)

  • Sort Key: "candidateWorkExperiences"."isCurrentWorkplace" DESC NULLS LAST, "candidateWorkExperiences"."toDate" DESC NULLS LAST, "candidateWorkExperiences"."fromDate" DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.087 ↓ 0.0 0 1

Nested Loop (cost=42.97..191.33 rows=1 width=1,760) (actual time=0.087..0.087 rows=0 loops=1)

3. 0.001 0.087 ↓ 0.0 0 1

Nested Loop Left Join (cost=42.55..182.38 rows=1 width=1,664) (actual time=0.086..0.087 rows=0 loops=1)

4. 0.000 0.086 ↓ 0.0 0 1

Nested Loop Left Join (cost=42.13..180.01 rows=1 width=1,637) (actual time=0.086..0.086 rows=0 loops=1)

5. 0.001 0.086 ↓ 0.0 0 1

Nested Loop Left Join (cost=41.71..175.52 rows=1 width=1,619) (actual time=0.086..0.086 rows=0 loops=1)

6. 0.000 0.085 ↓ 0.0 0 1

Nested Loop Left Join (cost=41.29..173.15 rows=1 width=1,592) (actual time=0.085..0.085 rows=0 loops=1)

7. 0.000 0.085 ↓ 0.0 0 1

Nested Loop Left Join (cost=40.87..168.66 rows=1 width=1,574) (actual time=0.085..0.085 rows=0 loops=1)

8. 0.001 0.085 ↓ 0.0 0 1

Nested Loop Left Join (cost=40.45..166.29 rows=1 width=1,547) (actual time=0.084..0.085 rows=0 loops=1)

9. 0.000 0.084 ↓ 0.0 0 1

Nested Loop Left Join (cost=40.03..161.80 rows=1 width=1,529) (actual time=0.084..0.084 rows=0 loops=1)

10. 0.001 0.084 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.60..159.43 rows=1 width=1,502) (actual time=0.083..0.084 rows=0 loops=1)

11. 0.000 0.083 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.18..154.94 rows=1 width=1,484) (actual time=0.083..0.083 rows=0 loops=1)

12. 0.001 0.083 ↓ 0.0 0 1

Nested Loop Left Join (cost=38.76..152.57 rows=1 width=1,457) (actual time=0.083..0.083 rows=0 loops=1)

13. 0.000 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=38.34..148.08 rows=1 width=1,439) (actual time=0.082..0.082 rows=0 loops=1)

14. 0.000 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=37.92..145.71 rows=1 width=1,412) (actual time=0.082..0.082 rows=0 loops=1)

15. 0.001 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=37.50..141.22 rows=1 width=1,394) (actual time=0.081..0.082 rows=0 loops=1)

16. 0.000 0.081 ↓ 0.0 0 1

Nested Loop Left Join (cost=37.08..138.85 rows=1 width=1,367) (actual time=0.081..0.081 rows=0 loops=1)

17. 0.001 0.081 ↓ 0.0 0 1

Nested Loop Left Join (cost=36.66..134.36 rows=1 width=1,349) (actual time=0.081..0.081 rows=0 loops=1)

18. 0.000 0.080 ↓ 0.0 0 1

Nested Loop Left Join (cost=36.23..131.99 rows=1 width=1,322) (actual time=0.080..0.080 rows=0 loops=1)

19. 0.001 0.080 ↓ 0.0 0 1

Nested Loop Left Join (cost=35.81..127.50 rows=1 width=1,304) (actual time=0.080..0.080 rows=0 loops=1)

20. 0.000 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=35.39..125.13 rows=1 width=1,277) (actual time=0.079..0.079 rows=0 loops=1)

21. 0.000 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=34.97..120.64 rows=1 width=1,259) (actual time=0.079..0.079 rows=0 loops=1)

22. 0.001 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=34.55..118.27 rows=1 width=1,232) (actual time=0.079..0.079 rows=0 loops=1)

23. 0.000 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=34.13..113.78 rows=1 width=1,214) (actual time=0.078..0.078 rows=0 loops=1)

24. 0.001 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=33.84..105.46 rows=1 width=1,141) (actual time=0.078..0.078 rows=0 loops=1)

25. 0.000 0.077 ↓ 0.0 0 1

Nested Loop Left Join (cost=33.42..99.77 rows=1 width=1,118) (actual time=0.077..0.077 rows=0 loops=1)

26. 0.000 0.077 ↓ 0.0 0 1

Nested Loop Left Join (cost=33.14..92.13 rows=1 width=1,111) (actual time=0.077..0.077 rows=0 loops=1)

27. 0.001 0.077 ↓ 0.0 0 1

Nested Loop Left Join (cost=32.72..89.65 rows=1 width=1,088) (actual time=0.076..0.077 rows=0 loops=1)

28. 0.000 0.076 ↓ 0.0 0 1

Nested Loop (cost=32.30..85.22 rows=1 width=1,084) (actual time=0.076..0.076 rows=0 loops=1)

29. 0.001 0.076 ↓ 0.0 0 1

Nested Loop (cost=31.88..82.85 rows=1 width=1,061) (actual time=0.076..0.076 rows=0 loops=1)

30. 0.000 0.075 ↓ 0.0 0 1

Nested Loop (cost=31.46..74.42 rows=1 width=1,033) (actual time=0.075..0.075 rows=0 loops=1)

31. 0.000 0.075 ↓ 0.0 0 1

Nested Loop (cost=31.03..72.05 rows=1 width=1,010) (actual time=0.075..0.075 rows=0 loops=1)

32. 0.001 0.075 ↓ 0.0 0 1

Nested Loop (cost=30.61..67.61 rows=1 width=1,006) (actual time=0.074..0.075 rows=0 loops=1)

33. 0.001 0.074 ↓ 0.0 0 1

Merge Join (cost=30.19..59.18 rows=1 width=839) (actual time=0.074..0.074 rows=0 loops=1)

  • Merge Cond: ("desiredPositionLov".id = "candidateWorkExperiences"."desiredPositionId")
34. 0.005 0.061 ↑ 50.0 1 1

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

  • Merge Cond: ("desiredPositionLov".id = "positionCategoryPosition"."positionId")
35. 0.015 0.015 ↑ 17,815.2 12 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.015 rows=12 loops=1)

36. 0.021 0.041 ↑ 50.0 1 1

Sort (cost=2.91..3.04 rows=50 width=8) (actual time=0.041..0.041 rows=1 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.004 0.012 ↓ 0.0 0 1

Sort (cost=26.86..26.88 rows=6 width=803) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: "candidateWorkExperiences"."desiredPositionId
  • Sort Method: quicksort Memory: 25kB
39. 0.008 0.008 ↓ 0.0 0 1

Index Scan using "IDX_CANDIDATEWORKEXPERIENCES_CANDIDATEID" on "candidateWorkExperiences" (cost=0.42..26.79 rows=6 width=803) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ("candidateId" = 117,693)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_6b031fcd0863e3f6b44230163f9" on organizations "companyOrganization" (cost=0.42..8.44 rows=1 width=167) (never executed)

  • Index Cond: (id = "candidateWorkExperiences"."companyId")
41. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "titleLov" (cost=0.42..4.44 rows=1 width=4) (never executed)

  • Index Cond: (id = "candidateWorkExperiences"."titleId")
  • Heap Fetches: 0
42. 0.000 0.000 ↓ 0.0 0

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "desiredPositionLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

  • Index Cond: ("fkId" = "desiredPositionLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "positionCategoryLov" (cost=0.42..8.44 rows=1 width=28) (never executed)

  • Index Cond: (id = "positionCategoryPosition"."positionCategoryId")
44. 0.000 0.000 ↓ 0.0 0

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "positionCategoryLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

  • Index Cond: ("fkId" = "positionCategoryLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
45. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "PK_4762ffb6e5d198cfec5606bc11e" on cities city (cost=0.42..4.44 rows=1 width=4) (never executed)

  • Index Cond: (id = "candidateWorkExperiences"."cityId")
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "cityLang" (cost=0.42..2.47 rows=1 width=31) (never executed)

  • Index Cond: ("fkId" = city.id)
  • Filter: (("tableName")::text = 'cities'::text)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_09ab30ca0975c02656483265f4f" on states state (cost=0.28..7.63 rows=1 width=7) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "stateLang" (cost=0.42..5.69 rows=1 width=31) (never executed)

  • Index Cond: ("fkId" = state.id)
  • Filter: (("tableName")::text = 'states'::text)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using "IDX_CANDIDATEWORKEXPERIENCEDETAILS_CANDIDATEWORKEXPERIENCEID" on "candidateWorkExperienceDetails" "candidateWorkExperienceDetail" (cost=0.29..8.30 rows=1 width=77) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "averageDealSizeLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "averageDealSizeLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "averageDealCycleLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "averageDealCycleLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "annualQuotaLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "annualQuotaLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "netNewBusinessLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "netNewBusinessLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "customerSizeLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "customerSizeLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "soldIntoLevelLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "soldIntoLevelLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "bookOfBusinessLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "bookOfBusinessLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "targetCustomerSizeLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "targetCustomerSizeLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "monthlyQualifiedMeetingsQuotaLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "monthlyQualifiedMeetingsQuotaLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "annualPipelineQuotaLov" (cost=0.42..4.50 rows=1 width=22) (never executed)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "annualPipelineQuotaLang" (cost=0.42..2.35 rows=1 width=31) (never executed)

  • Index Cond: ("fkId" = "annualPipelineQuotaLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_140681296bf033ab1eb95288abb" on candidates candidate (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (id = 117,693)
71.          

SubPlan (for Nested Loop)

72. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.42..0.50 rows=1 width=27) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..23,108.72 rows=301,722 width=27) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..10,804.28 rows=1 width=27) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on "languageData" (cost=0.00..10,795.83 rows=1 width=31) (never executed)

  • Filter: (("fkId" = "candidateWorkExperiences"."titleId") AND (("tableName")::text = 'listOfValues'::text))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "titleLov_1" (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: (id = "candidateWorkExperiences"."titleId")
  • Filter: (NOT "isInternal")
77. 0.000 0.000 ↓ 0.0 0

Seq Scan on "languageData" "LanguageData" (cost=0.00..9,287.22 rows=301,722 width=0) (never executed)

Planning time : 14.056 ms
Execution time : 0.651 ms