explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 903W

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 2.160 ↑ 1.0 1 1

Limit (cost=23.60..23.63 rows=1 width=142) (actual time=2.134..2.160 rows=1 loops=1)

  • Planning time: 3.367 ms
  • Execution time: 4.024 ms
2. 0.002 2.133 ↑ 1.0 1 1

Unique (cost=23.60..23.63 rows=1 width=142) (actual time=2.131..2.133 rows=1 loops=1)

3. 0.083 2.131 ↑ 1.0 1 1

Sort (cost=23.60..23.60 rows=1 width=142) (actual time=2.128..2.131 rows=1 loops=1)

  • Sort Key: teos_stajyerler.id DESC, teos_kimlik.tc_kimlik_numarasi, teos_kimlik.adi, teos_kimlik.soyadi, (pg_fnc_abc_gectigi_donem((teos_stajyerler.staj_donemi_id)::bigint)), teos_stajyerler.yonetmelik_id, teos_stajyerler.ilgili_veritabani_numarasi, (pg_fnc_versiyona_gore_cd_sayisi(teos_stajyerler.ilgili_veritabani_numarasi)), teos_stajyerler_ortak_ozel_durumlar.ozel_durum, (pg_fnc_egitim_durumu_getir(pg_fnc_egitim_turu_id_getir((teos_stajyerler.kimlik_id)::bigint)))
  • Sort Method: quicksort Memory: 25kB
4. 1.635 2.048 ↑ 1.0 1 1

Nested Loop (cost=1.26..23.59 rows=1 width=142) (actual time=2.029..2.048 rows=1 loops=1)

  • Join Filter: (teos_stajyerler.ozel_durumu_id = teos_stajyerler_ortak_ozel_durumlar.id)
5. 0.006 0.395 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.26..21.34 rows=1 width=54) (actual time=0.379..0.395 rows=1 loops=1)

  • Join Filter: (teos_kimlik_egitimler.kimlik_id = teos_kimlik.id)
6. 0.007 0.275 ↑ 1.0 1 1

Nested Loop (cost=0.84..16.89 rows=1 width=54) (actual time=0.265..0.275 rows=1 loops=1)

7. 0.132 0.132 ↑ 1.0 1 1

Index Scan using teos_kimlik_pkey on teos_kimlik (cost=0.42..8.44 rows=1 width=30) (actual time=0.128..0.132 rows=1 loops=1)

  • Index Cond: (id = 232095)
8. 0.136 0.136 ↑ 1.0 1 1

Index Scan using staj_basvuru on teos_stajyerler (cost=0.42..8.44 rows=1 width=24) (actual time=0.132..0.136 rows=1 loops=1)

  • Index Cond: (kimlik_id = 232095)
  • Filter: aktif
9. 0.114 0.114 ↑ 1.0 1 1

Index Only Scan using egitim_turu on teos_kimlik_egitimler (cost=0.42..4.44 rows=1 width=8) (actual time=0.109..0.114 rows=1 loops=1)

  • Index Cond: (kimlik_id = 232095)
  • Heap Fetches: 0
10. 0.018 0.018 ↑ 11.0 1 1

Seq Scan on teos_stajyerler_ortak_ozel_durumlar (cost=0.00..1.11 rows=11 width=36) (actual time=0.016..0.018 rows=1 loops=1)