explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4noB

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.047 ↑ 1.0 1 1

Sort (cost=18.54..18.54 rows=1 width=68) (actual time=0.047..0.047 rows=1 loops=1)

  • Sort Key: "desiredPositionLang"."sortOrder
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.041 ↑ 1.0 1 1

Nested Loop (cost=2.10..18.53 rows=1 width=68) (actual time=0.036..0.041 rows=1 loops=1)

3. 0.000 0.035 ↑ 1.0 1 1

Nested Loop (cost=1.68..17.92 rows=1 width=44) (actual time=0.033..0.035 rows=1 loops=1)

4. 0.001 0.032 ↑ 1.0 1 1

Nested Loop (cost=1.26..13.48 rows=1 width=40) (actual time=0.030..0.032 rows=1 loops=1)

5. 0.001 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.84..12.87 rows=1 width=12) (actual time=0.024..0.025 rows=1 loops=1)

6. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "IDX_CANDIDATEDESIREDPOSITIONS_CANDIDATEID" on "candidateDesiredPositions" (cost=0.42..8.44 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ("candidateId" = 94827)
7. 0.016 0.016 ↑ 1.0 1 1

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

  • Index Cond: (id = "candidateDesiredPositions"."desiredPositionId")
  • Heap Fetches: 1
8. 0.006 0.006 ↑ 1.0 1 1

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" "desiredPositionLang" (cost=0.42..0.60 rows=1 width=36) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ("fkId" = "desiredPosition".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 2
9. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using "PK_aed005139bdf3ad7515d728bcd4" on "listOfValues" "positionCategory" (cost=0.42..4.44 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=1)

  • Index Cond: (id = "candidateDesiredPositions"."positionCategoryId")
  • Heap Fetches: 1
10. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: ("fkId" = "positionCategory".id)
  • Filter: (("tableName")::text = 'listOfValues'::text)
  • Rows Removed by Filter: 2
Planning time : 1.358 ms
Execution time : 0.091 ms