explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FUEO

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 1.141 ↓ 8.0 8 1

Sort (cost=139.33..139.33 rows=1 width=1,777) (actual time=1.139..1.141 rows=8 loops=1)

  • Sort Key: "candidateWorkExperiences"."isCurrentWorkplace" DESC NULLS LAST, "candidateWorkExperiences"."toDate" DESC NULLS LAST, "candidateWorkExperiences"."fromDate" DESC NULLS LAST
  • Sort Method: quicksort Memory: 35kB
2. 0.041 1.093 ↓ 8.0 8 1

Nested Loop (cost=42.97..139.32 rows=1 width=1,777) (actual time=0.341..1.093 rows=8 loops=1)

3. 0.008 1.020 ↓ 8.0 8 1

Nested Loop Left Join (cost=42.55..130.86 rows=1 width=1,709) (actual time=0.317..1.020 rows=8 loops=1)

4. 0.007 1.004 ↓ 8.0 8 1

Nested Loop Left Join (cost=42.13..130.25 rows=1 width=1,681) (actual time=0.312..1.004 rows=8 loops=1)

5. 0.008 0.989 ↓ 8.0 8 1

Nested Loop Left Join (cost=41.71..126.35 rows=1 width=1,663) (actual time=0.307..0.989 rows=8 loops=1)

6. 0.008 0.973 ↓ 8.0 8 1

Nested Loop Left Join (cost=41.29..125.74 rows=1 width=1,635) (actual time=0.303..0.973 rows=8 loops=1)

7. 0.007 0.957 ↓ 8.0 8 1

Nested Loop Left Join (cost=40.87..121.84 rows=1 width=1,617) (actual time=0.296..0.957 rows=8 loops=1)

8. 0.008 0.942 ↓ 8.0 8 1

Nested Loop Left Join (cost=40.44..121.24 rows=1 width=1,589) (actual time=0.291..0.942 rows=8 loops=1)

9. 0.011 0.926 ↓ 8.0 8 1

Nested Loop Left Join (cost=40.02..117.34 rows=1 width=1,571) (actual time=0.286..0.926 rows=8 loops=1)

10. 0.010 0.907 ↓ 8.0 8 1

Nested Loop Left Join (cost=39.60..116.73 rows=1 width=1,543) (actual time=0.277..0.907 rows=8 loops=1)

11. 0.007 0.889 ↓ 8.0 8 1

Nested Loop Left Join (cost=39.18..112.83 rows=1 width=1,525) (actual time=0.269..0.889 rows=8 loops=1)

12. 0.009 0.874 ↓ 8.0 8 1

Nested Loop Left Join (cost=38.76..112.22 rows=1 width=1,497) (actual time=0.264..0.874 rows=8 loops=1)

13. 0.008 0.857 ↓ 8.0 8 1

Nested Loop Left Join (cost=38.34..108.32 rows=1 width=1,479) (actual time=0.258..0.857 rows=8 loops=1)

14. 0.008 0.841 ↓ 8.0 8 1

Nested Loop Left Join (cost=37.92..107.71 rows=1 width=1,451) (actual time=0.251..0.841 rows=8 loops=1)

15. 0.007 0.825 ↓ 8.0 8 1

Nested Loop Left Join (cost=37.50..103.81 rows=1 width=1,433) (actual time=0.245..0.825 rows=8 loops=1)

16. 0.007 0.810 ↓ 8.0 8 1

Nested Loop Left Join (cost=37.07..103.20 rows=1 width=1,405) (actual time=0.241..0.810 rows=8 loops=1)

17. 0.007 0.795 ↓ 8.0 8 1

Nested Loop Left Join (cost=36.65..99.30 rows=1 width=1,387) (actual time=0.236..0.795 rows=8 loops=1)

18. 0.007 0.780 ↓ 8.0 8 1

Nested Loop Left Join (cost=36.23..98.69 rows=1 width=1,359) (actual time=0.231..0.780 rows=8 loops=1)

19. 0.007 0.765 ↓ 8.0 8 1

Nested Loop Left Join (cost=35.81..94.79 rows=1 width=1,341) (actual time=0.226..0.765 rows=8 loops=1)

20. 0.010 0.750 ↓ 8.0 8 1

Nested Loop Left Join (cost=35.39..94.18 rows=1 width=1,313) (actual time=0.221..0.750 rows=8 loops=1)

21. 0.007 0.732 ↓ 8.0 8 1

Nested Loop Left Join (cost=34.97..90.28 rows=1 width=1,295) (actual time=0.214..0.732 rows=8 loops=1)

22. 0.007 0.717 ↓ 8.0 8 1

Nested Loop Left Join (cost=34.55..89.67 rows=1 width=1,267) (actual time=0.210..0.717 rows=8 loops=1)

23. 0.012 0.702 ↓ 8.0 8 1

Nested Loop Left Join (cost=34.13..85.77 rows=1 width=1,249) (actual time=0.205..0.702 rows=8 loops=1)

24. 0.011 0.674 ↓ 8.0 8 1

Nested Loop Left Join (cost=33.84..77.46 rows=1 width=1,176) (actual time=0.195..0.674 rows=8 loops=1)

25. 0.012 0.631 ↓ 8.0 8 1

Nested Loop Left Join (cost=33.42..72.01 rows=1 width=1,152) (actual time=0.187..0.631 rows=8 loops=1)

26. 0.010 0.603 ↓ 8.0 8 1

Nested Loop Left Join (cost=33.14..64.37 rows=1 width=1,145) (actual time=0.182..0.603 rows=8 loops=1)

27. 0.012 0.561 ↓ 8.0 8 1

Nested Loop Left Join (cost=32.71..63.54 rows=1 width=1,121) (actual time=0.176..0.561 rows=8 loops=1)

28. 0.017 0.525 ↓ 8.0 8 1

Nested Loop (cost=32.30..59.11 rows=1 width=1,117) (actual time=0.169..0.525 rows=8 loops=1)

29. 0.011 0.476 ↓ 8.0 8 1

Nested Loop (cost=31.87..58.50 rows=1 width=1,093) (actual time=0.160..0.476 rows=8 loops=1)

30. 0.013 0.441 ↓ 8.0 8 1

Nested Loop (cost=31.45..50.06 rows=1 width=1,059) (actual time=0.153..0.441 rows=8 loops=1)

31. 0.015 0.396 ↓ 8.0 8 1

Nested Loop (cost=31.03..49.45 rows=1 width=1,035) (actual time=0.145..0.396 rows=8 loops=1)

32. 0.007 0.341 ↓ 8.0 8 1

Nested Loop (cost=30.61..48.84 rows=1 width=1,011) (actual time=0.134..0.341 rows=8 loops=1)

33. 0.010 0.302 ↓ 8.0 8 1

Nested Loop (cost=30.19..44.40 rows=1 width=1,007) (actual time=0.123..0.302 rows=8 loops=1)

34. 0.023 0.252 ↓ 8.0 8 1

Merge Join (cost=29.77..35.97 rows=1 width=840) (actual time=0.112..0.252 rows=8 loops=1)

  • Merge Cond: ("desiredPositionLov".id = "candidateWorkExperiences"."desiredPositionId")
35. 0.060 0.186 ↑ 1.0 48 1

Merge Join (cost=3.35..22.46 rows=50 width=42) (actual time=0.064..0.186 rows=48 loops=1)

  • Merge Cond: ("desiredPositionLov".id = "positionCategoryPosition"."positionId")
36. 0.073 0.073 ↑ 1,668.7 135 1

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "desiredPositionLov" (cost=0.42..48,738.82 rows=225,275 width=34) (actual time=0.010..0.073 rows=135 loops=1)

37. 0.034 0.053 ↑ 1.0 48 1

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

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

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

39. 0.027 0.043 ↓ 1.3 8 1

Sort (cost=26.42..26.44 rows=6 width=798) (actual time=0.040..0.043 rows=8 loops=1)

  • Sort Key: "candidateWorkExperiences"."desiredPositionId
  • Sort Method: quicksort Memory: 33kB
40. 0.016 0.016 ↓ 1.3 8 1

Index Scan using "IDX_CANDIDATEWORKEXPERIENCES_CANDIDATEID" on "candidateWorkExperiences" (cost=0.42..26.35 rows=6 width=798) (actual time=0.011..0.016 rows=8 loops=1)

  • Index Cond: ("candidateId" = 117,693)
41. 0.040 0.040 ↑ 1.0 1 8

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=8)

  • Index Cond: (id = "candidateWorkExperiences"."companyId")
42. 0.032 0.032 ↑ 1.0 1 8

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

  • Index Cond: (id = "candidateWorkExperiences"."titleId")
  • Heap Fetches: 1
43. 0.040 0.040 ↑ 1.0 1 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "titleLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=8)

  • Index Cond: ("fkId" = "titleLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 2
44. 0.032 0.032 ↑ 1.0 1 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "desiredPositionLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=8)

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

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "positionCategoryLov" (cost=0.42..8.44 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=8)

  • Index Cond: (id = "positionCategoryPosition"."positionCategoryId")
46. 0.032 0.032 ↑ 1.0 1 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "positionCategoryLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperiences"."cityId")
  • Heap Fetches: 0
48. 0.032 0.032 ↑ 1.0 1 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "cityLang" (cost=0.42..0.82 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=8)

  • Index Cond: ("fkId" = city.id)
  • Filter: (("tableName")::text = 'cities'::text)
  • Rows Removed by Filter: 0
49. 0.016 0.016 ↑ 1.0 1 8

Index Scan using "PK_09ab30ca0975c02656483265f4f" on states state (cost=0.28..7.63 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=8)

  • Index Cond: (id = "candidateWorkExperiences"."stateId")
50. 0.032 0.032 ↑ 1.0 1 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "stateLang" (cost=0.42..5.45 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=8)

  • Index Cond: ("fkId" = state.id)
  • Filter: (("tableName")::text = 'states'::text)
  • Rows Removed by Filter: 2
51. 0.016 0.016 ↓ 0.0 0 8

Index Scan using "IDX_CANDIDATEWORKEXPERIENCEDETAILS_CANDIDATEWORKEXPERIENCEID" on "candidateWorkExperienceDetails" "candidateWorkExperienceDetail" (cost=0.29..8.30 rows=1 width=77) (actual time=0.002..0.002 rows=0 loops=8)

  • Index Cond: ("candidateWorkExperienceId" = "candidateWorkExperiences".id)
52. 0.008 0.008 ↓ 0.0 0 8

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."averageDealSize")
53. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "averageDealSizeLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."averageDealCycle")
55. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "averageDealCycleLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."annualQuota")
57. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "annualQuotaLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."netNewBusiness")
59. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "netNewBusinessLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."customerSize")
61. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "customerSizeLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."soldIntoLevel")
63. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "soldIntoLevelLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."bookOfBusiness")
65. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "bookOfBusinessLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."targetCustomerSize")
67. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "targetCustomerSizeLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."monthlyQualifiedMeetingsQuota")
69. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "monthlyQualifiedMeetingsQuotaLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

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

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

  • Index Cond: (id = "candidateWorkExperienceDetail"."annualPipelineQuota")
71. 0.008 0.008 ↓ 0.0 0 8

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "annualPipelineQuotaLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=8)

  • Index Cond: ("fkId" = "annualPipelineQuotaLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
72. 0.032 0.032 ↑ 1.0 1 8

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

  • Index Cond: (id = 117,693)
Planning time : 46.298 ms
Execution time : 5.961 ms