explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aUS5

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.030 ↑ 1.0 1 1

Limit (cost=8.45..8.46 rows=1 width=73) (actual time=0.029..0.030 rows=1 loops=1)

2. 0.007 0.028 ↑ 1.0 1 1

Sort (cost=8.45..8.46 rows=1 width=73) (actual time=0.028..0.028 rows=1 loops=1)

  • Sort Key: "isPreferredResume" DESC, "createdAt" DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.021 0.021 ↑ 1.0 1 1

Index Scan using "IDX_CANDIDATEEXTERNALDATA_CANDIDATEID_TYPE" on "candidateExternalData" "CandidateExternalData" (cost=0.42..8.44 rows=1 width=73) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (("candidateId" = 119090) AND ((type)::text = 'resume'::text))
Planning time : 0.122 ms
Execution time : 0.050 ms