explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LfjQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 42.983 ↓ 2.5 35 1

Nested Loop Left Join (cost=40.97..4,156.62 rows=14 width=334) (actual time=13.411..42.983 rows=35 loops=1)

2. 0.016 42.954 ↓ 2.5 35 1

Nested Loop (cost=40.69..4,152.23 rows=14 width=265) (actual time=13.406..42.954 rows=35 loops=1)

3. 0.015 42.798 ↓ 2.5 35 1

Nested Loop (cost=40.27..4,034.14 rows=14 width=240) (actual time=13.382..42.798 rows=35 loops=1)

4. 0.003 0.026 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=118) (actual time=0.025..0.026 rows=1 loops=1)

  • Join Filter: (rez.id = rezdetayek.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.014..0.015 rows=1 loops=1)

  • Index Cond: (id = 2893068)
6. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (id = 2893068)
7. 10.661 42.757 ↓ 2.5 35 1

Hash Right Join (cost=39.70..4,017.38 rows=14 width=122) (actual time=13.355..42.757 rows=35 loops=1)

  • Hash Cond: (hesayr.gecelemeid = geceleme.id)
8. 32.034 32.034 ↑ 1.0 177,082 1

Seq Scan on hesayr (cost=0.00..3,512.82 rows=177,082 width=45) (actual time=0.007..32.034 rows=177,082 loops=1)

9. 0.010 0.062 ↓ 2.8 25 1

Hash (cost=39.59..39.59 rows=9 width=77) (actual time=0.062..0.062 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.039 0.052 ↓ 2.8 25 1

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

  • Recheck Cond: (rezid = 2893068)
  • Heap Blocks: exact=15
11. 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)
12. 0.140 0.140 ↑ 1.0 1 35

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=35)

  • Index Cond: (id = 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.134 ms
Execution time : 43.143 ms