explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ybaW

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.023 ↓ 0.0 0 1

Sort (cost=20.24..20.24 rows=1 width=32) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: "desiredPositionLang"."sortOrder
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=1.68..20.23 rows=1 width=32) (actual time=0.018..0.018 rows=0 loops=1)

3. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=1.26..18.56 rows=1 width=26) (actual time=0.017..0.017 rows=0 loops=1)

4. 0.001 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.98..14.26 rows=1 width=22) (actual time=0.017..0.017 rows=0 loops=1)

5. 0.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.56..12.60 rows=1 width=12) (actual time=0.016..0.016 rows=0 loops=1)

6. 0.015 0.015 ↓ 0.0 0 1

Index Scan using "IDX_CANDIDATEDESIREDPOSITIONS_CANDIDATEID" on "candidateDesiredPositions" (cost=0.28..8.29 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ("candidateId" = 94827)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "desiredPosition" (cost=0.28..4.30 rows=1 width=4) (never executed)

  • Index Cond: (id = "candidateDesiredPositions"."desiredPositionId")
  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

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

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

Index Only Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "positionCategory" (cost=0.28..4.30 rows=1 width=4) (never executed)

  • Index Cond: (id = "candidateDesiredPositions"."positionCategoryId")
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ("fkId" = "positionCategory".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
Planning time : 1.339 ms
Execution time : 0.073 ms