explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4bjs

Settings
# exclusive inclusive rows x rows loops node
1. 0.140 0.182 ↑ 1.0 1 1

Index Scan using pk_randiman_vrd_isemri_uretim on randiman_vrd_isemri_uretim rviu (cost=8.58..16.60 rows=1 width=42) (actual time=0.181..0.182 rows=1 loops=1)

  • Index Cond: (veri_vrd_isemri_uretim_id = $0)
2.          

Initplan (forIndex Scan)

3. 0.042 0.042 ↑ 1.0 1 1

Index Scan using pk_veri_vrd_isemri_uretim_personel on veri_vrd_isemri_uretim_personel (cost=0.28..8.29 rows=1 width=4) (actual time=0.040..0.042 rows=1 loops=1)

  • Index Cond: (veri_vrd_isemri_uretim_personel_id = 45007)
Planning time : 12.145 ms
Execution time : 0.244 ms