explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iBnw

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.525 ↓ 17.5 35 1

Nested Loop Left Join (cost=24.62..677.91 rows=2 width=309) (actual time=0.131..0.525 rows=35 loops=1)

2. 0.041 0.496 ↓ 17.5 35 1

Nested Loop Left Join (cost=24.34..677.29 rows=2 width=240) (actual time=0.127..0.496 rows=35 loops=1)

3. 0.012 0.155 ↓ 25.0 25 1

Nested Loop Left Join (cost=5.06..56.32 rows=1 width=195) (actual time=0.050..0.155 rows=25 loops=1)

  • Join Filter: (rez.id = rezdetayek.id)
4. 0.012 0.093 ↓ 25.0 25 1

Nested Loop Left Join (cost=4.77..48.00 rows=1 width=143) (actual time=0.040..0.093 rows=25 loops=1)

  • Join Filter: (geceleme.rezid = rez.id)
5. 0.015 0.015 ↑ 1.0 1 1

Index Scan using "PK_public.rez" on rez (cost=0.29..8.30 rows=1 width=66) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (id = 2893068)
6. 0.053 0.066 ↓ 2.8 25 1

Bitmap Heap Scan on geceleme (cost=4.49..39.59 rows=9 width=77) (actual time=0.021..0.066 rows=25 loops=1)

  • Recheck Cond: (rezid = 2893068)
  • Heap Blocks: exact=15
7. 0.013 0.013 ↓ 2.8 25 1

Bitmap Index Scan on "geceleme_GecelemeRezId" (cost=0.00..4.49 rows=9 width=0) (actual time=0.013..0.013 rows=25 loops=1)

  • Index Cond: (rezid = 2893068)
8. 0.050 0.050 ↑ 1.0 1 25

Index Scan using "rezdetayek_IX_id" on rezdetayek (cost=0.29..8.30 rows=1 width=52) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (id = 2893068)
9. 0.050 0.300 ↑ 885.0 1 25

Bitmap Heap Scan on hesayr (cost=19.28..612.12 rows=885 width=45) (actual time=0.012..0.012 rows=1 loops=25)

  • Recheck Cond: (gecelemeid = geceleme.id)
  • Heap Blocks: exact=10
10. 0.250 0.250 ↑ 885.0 1 25

Bitmap Index Scan on "hesayr_IX_gecelemeid" (cost=0.00..19.06 rows=885 width=0) (actual time=0.010..0.010 rows=1 loops=25)

  • Index Cond: (gecelemeid = geceleme.id)
11. 0.000 0.000 ↓ 0.0 0 35

Index Scan using "PK_public.konumhamfiyat" on konumhamfiyat (cost=0.29..0.31 rows=1 width=69) (actual time=0.000..0.000 rows=0 loops=35)

  • Index Cond: (id = hesayr.konumhamfiyatid)
Planning time : 0.910 ms
Execution time : 0.647 ms