explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D3EX

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 45.249 ↓ 2.5 35 1

Nested Loop (cost=40.97..4,156.62 rows=14 width=334) (actual time=13.964..45.249 rows=35 loops=1)

2. 0.049 45.055 ↓ 2.5 35 1

Nested Loop Left Join (cost=40.56..4,038.53 rows=14 width=309) (actual time=13.928..45.055 rows=35 loops=1)

3. 0.015 45.006 ↓ 2.5 35 1

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

4. 0.003 0.035 ↑ 1.0 1 1

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

  • Join Filter: (rez.id = rezdetayek.id)
5. 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 = 2893068)
6. 0.016 0.016 ↑ 1.0 1 1

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

  • Index Cond: (id = 2893068)
7. 10.817 44.956 ↓ 2.5 35 1

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

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

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

9. 0.010 0.064 ↓ 2.8 25 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.040 0.054 ↓ 2.8 25 1

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

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

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

  • Index Cond: (rezid = 2893068)
12. 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)
13. 0.175 0.175 ↑ 1.0 1 35

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

  • Index Cond: (id = geceleme.id)
Planning time : 1.170 ms
Execution time : 45.401 ms