explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gpvf

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 0.431 ↓ 17.5 35 1

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

2. 0.053 0.407 ↓ 17.5 35 1

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

3. 0.030 0.279 ↓ 25.0 25 1

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

4. 0.008 0.149 ↓ 25.0 25 1

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

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

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

  • Join Filter: (geceleme.rezid = rez.id)
6. 0.016 0.016 ↑ 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.016 rows=1 loops=1)

  • Index Cond: (id = 2,893,068)
7. 0.045 0.063 ↓ 2.8 25 1

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

  • Recheck Cond: (rezid = 2,893,068)
  • Heap Blocks: exact=15
8. 0.018 0.018 ↓ 2.8 25 1

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

  • Index Cond: (rezid = 2,893,068)
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 = 2,893,068)
10. 0.100 0.100 ↑ 1.0 1 25

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

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

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

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

Bitmap Index Scan on "hesayr_IX_gecelemeid" (cost=0.00..19.06 rows=885 width=0) (actual time=0.002..0.002 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.233 ms
Execution time : 0.588 ms