explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TYUb

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.579 ↓ 17.5 35 1

Nested Loop Left Join (cost=25.04..686.35 rows=2 width=334) (actual time=0.137..0.579 rows=35 loops=1)

2. 0.052 0.553 ↓ 17.5 35 1

Nested Loop Left Join (cost=24.75..685.72 rows=2 width=265) (actual time=0.134..0.553 rows=35 loops=1)

3. 0.012 0.376 ↓ 25.0 25 1

Nested Loop Left Join (cost=5.47..64.75 rows=1 width=220) (actual time=0.121..0.376 rows=25 loops=1)

4. 0.011 0.214 ↓ 25.0 25 1

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

  • Join Filter: (rez.id = rezdetayek.id)
5. 0.014 0.153 ↓ 25.0 25 1

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

  • Join Filter: (geceleme.rezid = rez.id)
6. 0.040 0.040 ↑ 1.0 1 1

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

  • Index Cond: (id = 2893068)
7. 0.069 0.099 ↓ 2.8 25 1

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

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

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

  • Index Cond: (rezid = 2893068)
9. 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)
10. 0.150 0.150 ↑ 1.0 1 25

Index Scan using "gecelemedetayek_IX_id" on gecelemedetayek (cost=0.42..8.44 rows=1 width=25) (actual time=0.006..0.006 rows=1 loops=25)

  • Index Cond: (geceleme.id = id)
11. 0.025 0.125 ↑ 885.0 1 25

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

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

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

  • Index Cond: (gecelemeid = geceleme.id)
13. 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 : 1.578 ms
Execution time : 0.749 ms