explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HVv2

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.110 ↑ 1.0 2 1

Sort (cost=56.74..56.75 rows=2 width=459) (actual time=0.109..0.110 rows=2 loops=1)

  • Sort Key: "candidateEducation"."educationYear" DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
2. 0.011 0.095 ↑ 1.0 2 1

Nested Loop Left Join (cost=2.40..56.73 rows=2 width=459) (actual time=0.062..0.095 rows=2 loops=1)

3. 0.002 0.072 ↑ 1.0 2 1

Nested Loop (cost=1.97..55.51 rows=2 width=433) (actual time=0.049..0.072 rows=2 loops=1)

4. 0.001 0.056 ↑ 1.0 2 1

Nested Loop Left Join (cost=1.55..54.30 rows=2 width=409) (actual time=0.039..0.056 rows=2 loops=1)

5. 0.002 0.043 ↑ 1.0 2 1

Nested Loop (cost=1.13..45.42 rows=2 width=405) (actual time=0.032..0.043 rows=2 loops=1)

6. 0.003 0.033 ↑ 1.0 2 1

Nested Loop (cost=0.71..28.55 rows=2 width=354) (actual time=0.025..0.033 rows=2 loops=1)

7. 0.010 0.010 ↑ 1.0 2 1

Index Scan using "IDX_CANDIDATEEDUCATION_CANDIDATEID" on "candidateEducation" (cost=0.29..11.67 rows=2 width=186) (actual time=0.010..0.010 rows=2 loops=1)

  • Index Cond: ("candidateId" = 118808)
8. 0.020 0.020 ↑ 1.0 1 2

Index Scan using "PK_6b031fcd0863e3f6b44230163f9" on organizations "schoolOrganization" (cost=0.42..8.44 rows=1 width=172) (actual time=0.010..0.010 rows=1 loops=2)

  • Index Cond: (id = "candidateEducation"."schoolId")
9. 0.008 0.008 ↑ 1.0 1 2

Index Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "degreeLov" (cost=0.42..8.44 rows=1 width=51) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: (id = "candidateEducation"."degreeId")
10. 0.012 0.012 ↓ 0.0 0 2

Index Only Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "fieldOfStudyLov" (cost=0.42..4.44 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=2)

  • Index Cond: (id = "candidateEducation"."fieldOfStudyId")
  • Heap Fetches: 1
11. 0.014 0.014 ↑ 1.0 1 2

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "degreeLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.006..0.007 rows=1 loops=2)

  • Index Cond: ("fkId" = "degreeLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 2
12. 0.012 0.012 ↓ 0.0 0 2

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "fieldOfStudyLang" (cost=0.42..0.60 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=2)

  • Index Cond: ("fkId" = "fieldOfStudyLov".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 0
Planning time : 1.871 ms
Execution time : 0.218 ms